File: /home/suanchonac/domains/suanchon.ac.th/private_html/queen/include/mysql_func.php
<?
$host="localhost";
$username="suanchonac_queen";
$password="Oh040131";
$db="suanchonac_queen";
function connect(){
global $host,$username,$password,$db,$dblink;
$dblink=mysql_connect($host,$username,$password);
mysql_select_db($db) or die ("cann't select database");
mysql_query("SET NAMES UTF8");
}
function close(){
global $dblink;
mysql_close($dblink);
}
function query($sql_query){
global $db;
mysql_db_query($db,$sql_query);
}
function getList($sql_query){
$db_query=mysql_query($sql_query);
$num_rows=mysql_num_rows($db_query);
for($i=0;$i<$num_rows;$i++) {
$result[]=mysql_fetch_assoc($db_query);
}
return $result;
}
function getNumRow($sql_query){
$db_query=mysql_query($sql_query);
return mysql_num_rows($db_query);
}
?>