(php)为何搜索不行。

enjoylife 发布于 2010/11/02 17:40
阅读 195
收藏 0

查了半天,也没有找到错误。不知道为什么不能够搜索。

数据库是 testing.创建表代码

[code]

CREATE TABLE users (fname VARCHAR(30), lname VARCHAR(30), info BLOB); INSERT INTO users VALUES ( "Jim", "Jones", "In his spare time Jim enjoys biking, eating pizza, and classical music" ), ( "Peggy", "Smith", "Peggy is a water sports enthusiast who also enjoys making soap and selling cheese" ),( "Maggie", "Martin", "Maggie loves to cook itallian food including spagetti and pizza" ),( "Tex", "Moncom", "Tex is the owner and operator of The Pizza Palace, a local hang out joint" )

[/code]

 

the html code:

[code]

<h2>Search</h2> 

<form name="search" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> 

Seach for: <input type="text" name="find" /> in 

<Select NAME="field"> 

<Option VALUE="fname">First Name</option> 

<Option VALUE="lname">Last Name</option>

<Option VALUE="info">Profile</option> 

</Select> 

<input type="hidden" name="searching" value="yes" /> 

<input type="submit" name="search" value="Search" /> 

</form>

[/code]

搜索代码:

[code]

<?php

if ($searching =="yes") { 

echo "<h2>Results</h2><p>";

if ($find == "") { 

echo "<p>You forgot to enter a search term"; 

exit; 

mysql_connect("localhost", "root", "123") or die(mysql_error()); 

mysql_select_db("database_name") or die(mysql_error()); 

$find = strtoupper($find); 

$find = strip_tags($find); 

$find = trim ($find); 

$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'"); 

while($result = mysql_fetch_array( $data )) { 

echo $result['fname']; 

echo " "; 

echo $result['lname']; 

echo "<br>"; 

echo $result['info']; 

echo "<br>"; 

echo "<br>"; 

$anymatches=mysql_num_rows($data);

if ($anymatches == 0) { 

echo "Sorry, but we can not find an entry to match your query<br><br>"; 

echo "<b>Searched For:</b> " .$find; 

?> 

[/code]

加载中
0
该用户已被和谐
该用户已被和谐

$field  这个是什么东西。

$_POST

返回顶部
顶部