Sample usage of pure PHP mysqli
<?php
function mysqliQuery($queryString, $hostName, $userName, $password, $dbName) {
$mysqlInstance = new mysqli($hostName, $userName, $password, $dbName); // create instance
if (!$mysqlInstance->set_charset("utf8")) { // set character coding
printf("Error loading character set utf8: %s\n", $mysqlInstance->error);
} else {
printf("Current character set: %s\n", $mysqlInstance->character_set_name());
}
if ($mysqlInstance->connect_error) { // connect
die('Connect Error: ' . $mysqlInstance->connect_error);
}
$escapedQueryString=$mysqlInstance->real_escape_string($queryString); // escape query string
$result = $mysqlInstance->query($escapedQueryString); // execute query
while($row = $result->fetch_assoc()) // get results
{
array_push($resultArray, $row); // organise them in an array
}
$result->free(); // release the result variable
$mysqlInstance->close(); // close database
return $resultArray;
}
?>