<?php

// Suppressing warning:
// PHP Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50167 Library:50307
$mysqli = @new mysqli( "127.0.0.1", "root", "", "mysql");
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$result = mysqli_query( $mysqli, "SELECT VERSION()" );
print_r( mysqli_fetch_row( $result ) );

mysqli_query( $mysqli, "SET GLOBAL general_log = 1");
$result = mysqli_query( $mysqli, "SHOW GLOBAL VARIABLES LIKE 'general_log'" );
print_r( mysqli_fetch_row( $result ) );


if (!($stmti = $mysqli->prepare("SELECT * FROM mysql.user LIMIT ?"))) {
echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
}

$int = 1;
if (!$stmti->bind_param("i", $int)) {
echo "Binding parameters failed: (" . $stmti->errno . ") " . $stmti->error;
}

if (!$stmti->execute()) {
echo "Execute failed: (" . $stmti->errno . ") " . $stmti->error;
} else {
echo "Int Success\n";
}

if (!$stmti->execute()) {
echo "Execute failed: (" . $stmti->errno . ") " . $stmti->error;
} else {
echo "Int Success\n";
}

$stmti->free_result();
$stmti->close();

if (!($stmts = $mysqli->prepare("SELECT * FROM mysql.user LIMIT ?"))) {
echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
}

$str = '1';
if (!$stmts->bind_param("s", $str)) {
echo "Binding parameters failed: (" . $stmts->errno . ") " . $stmts->error;
}

if (!$stmts->execute()) {
echo "Execute failed: (" . $stmts->errno . ") " . $stmts->error;
} else {
echo "Str Success\n";
}

if (!$stmts->execute()) {
echo "Execute failed: (" . $stmts->errno . ") " . $stmts->error;
} else {
echo "Str Success\n";
}

$stmts->free_result();
$stmts->close();
?>