Conexão com MariaDB usando PHP 7

// Connecting, selecting database
$mysqli = new mysqli('192.168.100.188', '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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s