//-- ------ #Db config ------ --$dbhost = 'localhost'; //数据库主机地址$dbuser = 'admin'; //mysql用户名$dbpass = 'admin'; //mysql密码$dbname = 'admin'; //mysql库名$dbcharset = 'gb2312'; //Charset//-- ------ #Connection ------ --$GLOBALS['Connection'] = mysql_connect($dbhost,$dbuser,$dbpass); if(mysql_error()!=''){ //Error //$this->getError1('',mysql_error(),'Database error','10005'); exit();}mysql_select_db($dbname);$tmpSTR=' SET NAMES '.$dbcharset;mysql_query($tmpSTR,$GLOBALS['Connection']);//-- ------ #Search ------ --$tmpSQL="SELECT username,yhzfmm FROM xly_yhzl WHERE username = \'zwj0936\' AND yhzfmm = \'870802\'; ";$tmpResult=mysql_query($tmpSQL);if(mysql_error()!=''){ //Error //$this->getError1('',mysql_error(),'Database error','10005'); exit();}$tmpDataCollection=array();$Coun0=0;while($tmpLine=mysql_fetch_array($tmpResult,MYSQL_ASSOC)){ $tmpDataCollection[$Coun0]=$tmpLine; $Coun0++;}//-- ------ #Print ------ --print_r($tmpDataCollection);
|