查询MYSQL数据库

wstczyl

html>
head>
/head>
body>
h3>Search/h3>
form action="search_result.php" method="POST">
Name:input type="test" size=25 name="ename" value="">br>br>
input type="submit" name="submit" value="Search">
/form>
/body>
/html>


?php
$link=mysql_connect("localhost","root","123");
if(! $link) echo "faild";
else echo "OK!";
mysql_select_db("ylzou",$link);
$ename=$_POST["ename"];
$q = "SELECT * FROM pc where ename='$ename'";
mysql_query("SET NAMES GB2312");
$rs = mysql_query($q,$link);
#if(! $rs) {die("Valid result!");}
echo "";
echo "NAMEPCNAME";
#while($row = mysql_fetch_object($rs)) echo "$row->ename$row->pcname";
while($row = mysql_fetch_row($rs)) echo"$row[0]$row[1]";
echo "";
mysql_close($link);
?>


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/31088/showart_1078448.html