php mysql搜索功能,PHP 简单实现MySQL数据搜索、添加数据功能

数据库testdb ，表user 列email和nikename

html代码：

以下为数据库增加：...

nikename:

email:

search1.php代码：

$con = mysql_connect("localhost","root","root");

if (!$con)

{

die(‘Could not connect: ‘ . mysql_error());

}

mysql_select_db("testdb", $con);

$searchs = $_POST[‘search‘]; //传递search框过来的值

$searchs= trim($searchs);

if (!$searchs)

{

echo ‘搜索框不能为空.‘;

exit;

}

$result = mysql_query("SELECT * FROM user where nikename like ‘%$searchs%‘");

if (mysql_num_rows($result) < 1) echo ‘没有数据‘;

while($row = mysql_fetch_array($result))

{

echo $row[‘nikename‘] . " " . $row[‘email‘];

echo "
";

}

mysql_close($con);

?>

insert.php 代码如下：

$con = mysql_connect("localhost","root","root");

if (!$con)

{

die(‘Could not connect: ‘ . mysql_error());

}

mysql_select_db("testdb", $con);

$nikename=$_POST[‘nikename‘]; // create short variable names

$email=$_POST[‘email‘];

$nikename= trim($nikename);

if (!$nikename || !$email) //判断是否为空

{

echo ‘不能为空‘;

exit;

}

$sql="INSERT INTO user (nikename, email )

VALUES

(‘$nikename‘,‘$email‘)";

if (!mysql_query($sql,$con))

{

die(‘Error: ‘ . mysql_error());

}

echo "1 record added";

mysql_close($con)

?>

原文：http://www.cnblogs.com/tmdsleep/p/4596091.html