PHP 简单实现MySQL数据搜索、添加数据功能 以设备管理为例

测试截图：

数据库bzec ，表shebeidangan 列sb_name,sb_numandtype,sb_home,sb_usedate,sb_address,sb_updatetime,sb_remarks

html代码：

<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">
  <meta name="Generator" content="EditPlus®">
  <meta name="Author" content="">
  <meta name="Keywords" content="">
  <meta name="Description" content="">
  <title>设备档案</title>
 </head>
 <body>

<form method="post" action="s.php" name="search" /> 
<input name="search" type="text" value="" size="15" />  
<input type="submit" value="Search" /> 
</form>
<br/>
<hr/>

添加设备

<div>

 <form action="sb_add.php" method="post">
设备名称：<input type="text" name="sb_name" /><br/>
编码型号：<input type="text" name="sb_numandtype" /><br/>
生产厂家：<input type="text" name="sb_home" /><br/>
启用日期：<input type="text" name="sb_usedate" /><br/>
安装位置：<input type="text" name="sb_address" /><br/>
<!--更新日期：<input type="text" name="sb_updatetime" /><br/>-->
备注 ：<input type="text" name="sb_remarks" /><br/>

<br/>
<input type="submit" value="添加" />
</form>
</div>


 </body>
</html>

 

 s.php代码：

<?php
header("Content-Type:text/html;charset=utf-8");
$con = mysql_connect("localhost","root","110");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_query("set names 'utf8'",$con);
mysql_select_db("bzec", $con);

 $searchs = $_POST['search'];  //传递search框过来的值
 $searchs= trim($searchs);
if (!$searchs)
{
echo '搜索框不能为空.';
exit;
}
$result = mysql_query("SELECT * FROM shebeidangan where sb_name like '%$searchs%'");
if (mysql_num_rows($result) < 1) echo '没有数据';
  
while($row = mysql_fetch_array($result))
 {
  echo $row['sb_name'] ;
  echo "<br />";
  }
mysql_close($con);
?>

 

 sb_add.php 代码如下：

<?php
$con = mysql_connect("localhost","root","110");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_query("set names 'utf8'",$con);
mysql_select_db("bzec", $con);

$sb_name=$_POST['sb_name'];
$sb_numandtype=$_POST['sb_numandtype'];
$sb_home=$_POST['sb_home'];
$sb_usedate=$_POST['sb_usedate'];
$sb_address=$_POST['sb_address'];
//$sb_updatetime=$_POST['sb_updatetime'];
$sb_updatetime=date("Y-m-d G:i:s");
$sb_remarks=$_POST['sb_remarks'];


//$nikename= trim($nikename);

/*  
if (!$nikename || !$email) //判断是否为空
{
echo '不能为空';
exit;
}
*/

$sql="INSERT INTO shebeidangan (sb_name,sb_numandtype,sb_home,sb_usedate,sb_address,sb_updatetime,sb_remarks)
VALUES
('$sb_name','$sb_numandtype','$sb_home','$sb_usedate','$sb_address','$sb_updatetime','$sb_remarks')";
  
  
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "ADD OK";
  
mysql_close($con)
?>

 

posted @ 2015-06-23 18:33  TMD睡觉  阅读(3592)  评论(0)  编辑  收藏  举报