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

测试截图:

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

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)
?>
上一篇:yii框架详解 之 CWebApplication 运行流程分析


下一篇:android 播放视频时切换全屏隐藏状态栏