[Php]
<? Php
Define ("RelativePath ",".");
Include_once (RelativePath. "/DB_mysql.class.php"); # DB_mysql.class.php in my resources
$ Db_mysql = new DB_mysql (); www.2cto.com
$ Db_mysql-> set_values ("localhost ","***","***","***");
# Eg: "localhost", "root", "", "test"
# Eg: "localhost or remote IP Address", "root", "", "test"
$ Link = mysql_connect ($ db_mysql-> mysql_remote_db_host, $ db_mysql-> mysql_remote_db_username, $ db_mysql-> mysql_remote_db_password );
If (! $ Link ){
Die ("Not connectted:". mysql_error ($ link ));
}
$ Db_selected = mysql_select_db ($ db_mysql-> mysql_remote_db_name, $ link );
If (! $ Db_selected ){
Die ("Can't use". $ db_mysql-> mysql_remote_db_name. "". "error prompt:". "". mysql_error ($ db_selected ));
}
/*
Else {
Echo "selected successfully:". "". $ db_mysql-> mysql_remote_db_name;
}
*/
$ SQL = "select user_id, user_email from user_info limit 100 ";
$ Query = mysql_query ($ SQL, $ link );
If (! $ Query ){
Die (mysql_error ($ query ));
}
Else {
# $ Num_rows = mysql_num_rows ($ query );
# Echo $ num_rows;
Echo mysql_num_rows ($ query); # the result is 100
}
?>