// 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(); |