PHP database class [ติดต่อ + Query MySQL]

class database{
#create by songsaluang
public function query($sql , $countarr){
$Host = 'localhost'; #Host name
$UserName = 'root'; #User name
$PassWord = '1234'; #Password
$DataBase = 'Test'; #Database
$CharSet = 'SET NAMES TIS620'; #Character set

mysql_connect($Host , $UserName , $PassWord , $Database) or die (mysql_error());
mysql_select_db($DataBase) or die (mysql_error());
mysql_query($CharSet);
$strcheck = explode(' ',trim($sql));
$strcheck = strtolower(trim($strcheck[0]));
if ($strcheck == 'select'){
$query = mysql_query($sql);

if($countarr == 1){
return $countarr = mysql_num_rows($query);
}
return $query;

}else{
mysql_query($sql ) or die (mysql_error()); 
}
mysql_close();
}
}

#การเรียกใช้
$sql = "select * from TestName";                 #sql
$new = new database();                               #new class
$numarr = $new ->query($sql , 1);               #จำนวน row กรณีใช้คำสั้ง sql :: select
$arrslt = $new ->query($sql , '');                   #query sql

#fetch array
for ( $i = 1 ; $i <= $numarr ; $i++ ){
$allarr = mysql_fetch_array($arrslt);
echo $allarr[$i].'<br>';
}