PHP+MYSQL查询数据库罗致系统很卡

    














$dbh = @mysql_connect("localhost:3306","root","123456");

 

 /* 定义变量dbh , mysql_connect()函数的意思是连接mysql数据库, "@"的意思是屏蔽报错 */

if(!$dbh){die("error");}

/* die()函数的意思是将括号里的字串送到浏览器并中断php程式 (script)。括号里的参数为欲送出的字串。 */

@mysql_select_db("data", $dbh);



mysql_query("SET NAMES data");







?>





















$wd=$_POST["wd"];

/* 选择mysql服务器里的一个数据库,这里选的数据库名为 ok */

$q = "(select * from tabal where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal1 where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal2 where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal3 where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal4 where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal5 where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal6 where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal7 where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal8 where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal9 where user like '$wd%' or email LIKE '$wd%')

union all

(select * from tabal10 where email LIKE '$wd%')

union all

(select * from tabal11  where user like '$wd%' or email LIKE '$wd%') LIMIT 0,20";



/* 定义变量q, "select * from abc"是一个sql语句,意思是读取表abc中的数据 */

?>











$rs = mysql_query($q, $dbh);


while($row = mysql_fetch_array($rs))


echo " ";


?>





$row[user]
 
$row[pass]
 
$row[email]








 


@mysql_close($dbh);