sudo apt-get install php-mysql
dont forget to install it
This is for msqli php7 dudes like myself
function PlayerCount() {
Global $Srv_Host, $Srv_Username,$Srv_Password,$Srv_Database;
$mysqli = new mysqli($Srv_Host, $Srv_Username, $Srv_Password, $Srv_Database);
if ($mysqli -> connect_errno) {
echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
exit();
}
$count = 0;
if ($result = $mysqli -> query("SELECT COUNT(*) as total FROM `char` WHERE online = '1'")) {
$request_list_row = $result->fetch_row();
echo ' ',$request_list_row[0];
// Free result set
$result -> free_result();
} else {
echo 0;
}
$mysqli -> close();
}