/*
* mysqli Library for connecting database
* Using a procedural style code
*/
Header (' Content-type:text/html;charset=utf-8 ');
Get database connection
$link = Mysqli_init ();
if (! $link) {
Exit (' Mysqli object creation failed ... ');
}
Creating a 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);
Handling return value Results
$arr = Array ();
if ($infos) {
while ($info = Mysqli_fetch_array ($infos, mysqli_num)) {
Array_push ($arr, $info);
}
Processing end gets the data collection to the purge
Mysqli_free_result ($infos);
}
Var_dump ($arr);
Close an open resource
Mysqli_close ($link);
Mysqli Database Connection