Conexão com MariaDB usando PHP 7

// Connecting, selecting database
$mysqli = new mysqli('host', 'user', 'password', 'database');

// Check erros
if ( $mysqli->connect_errno ) echo $mysqli->connect_errno, ' ', $mysqli->connect_error;

// SQL query
$sql = 'SELECT Host, User, Password FROM user';

// Printing results
$result = $mysqli->query( $sql );

while ( $row = $result->fetch_assoc() ) echo $row['Host'], ' ', $row['User'], ' ', $row['Password'], "\n";

// Close Connection
$mysqli->close();

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s