<?php

$dbhost = "79.137.39.141";
$dbname = "altislife";
$dbuser = "root";
$dbpass = "Olbasoil123";

$db = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$sth = $db->prepare("SELECT * FROM players");
$sth->execute();

$result = $sth->fetchAll(PDO::FETCH_ASSOC);

$num = count($result);

echo $num;<?php
//username, password and db name
$username="root";$password="Olbasoil123";$database="altislife";
mysql_connect(79.137.39.141,$username,$password);

//connect to db
mysql_connect(79.137.39.141,$username,$password);

//select db
@mysql_select_db($database) or die( "Unable to select database");

//search
$query="SELECT * FROM players";$result=mysql_query($query);

/show resaults
$num=mysql_numrows($result);

?>