查询MYSQL数据库
时间:2008-07-11 来源: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);
?>
相关阅读 更多 +