/*
* mysqli function library for connecting to the database
* Using a procedural style encoding
*/
Header (' Content-type:text/html;charset=utf-8 ');
Get database connection
$link = Mysqli_init ();
if (! $link) {
exit (' Mysqli object creation failed ... ');
}
//Create MYSQLI Connection Database
if (!mysqli_real_connect ($link, ' localhost ', ' root ', ' ', ' pg39 ')) {
Die (' Connection error ' ('. Mysqli_connect_errno (). ‘) ‘ . Mysqli_connect_error ());
}
if (!mysqli_set_charset ($link, ' UTF8 ')) {
exit (' Set database query encoding set failed ... ');
}
$infos = Mysqli_query ($link, "SELECT * from Student", Mysqli_use_result);
//Process return value result
$arr = array ();
if ($infos) {
while ($info = Mysqli_fetch_array ($infos, Mysqli_num)) {
Array_push ($arr, $info);
}
//processing end gets the data collection to clear
Mysqli_free_result ($infos);
}
Var_dump ($arr);
//Close Open Resources
Mysqli_close ($link);
Mysqli Database Connection