一个简单php+mysql快递单号扫码记录网页

来源：互联网发布：手机京东秒杀抢购软件编辑：程序博客网时间：2024/04/28 00:29

快递一多，就会出现丢包的现象，快递说签收了，一天那么多，我又记不得签没签，就想着把到货的快递单号都记录下来，让我手工记那就算了，扫码枪现在又不贵，就买了一把 O(∩_∩)O~

提示：扫码抢是模仿键盘输入的，所以只需要安装驱动，然后随便打开个记事本就可以直接用了

页面代码：

<html> <head> <meta http-equiv="Content-Type" content="text/html;charset=UTF-8"> <title>快递运单录入</title> <style type="text/css">    body {        text-align:center;    }</style></head> <body><form method="post" name="yundanForm" onsubmit='lost()'> <input name="danhao" type="text" id="danhao"/><input type="submit" value="提交" name="submit"/>  <!--快递单号默认回车 都不用点提交--><input type="reset" value="重置" name="button"/> </form><?php @$danhao = $_POST['danhao'];  //获得传过来的输入值 //通过phpmyadmin建立一个数据库testphp,并建一个yundan表，里面添加两个字段'num','time'，num定义varchar(30),time定义timestamp并选择CURRENT_TIMESTAMP。别忘了设置访问此库的帐号密码。 // DBdefine('DB_DRIVER', 'mysql');define('DB_HOSTNAME', 'localhost');define('DB_USERNAME', 'testphp');define('DB_PASSWORD', 'phptest');define('DB_DATABASE', 'testphp'); $today = date("Y-m-d");  //今天日期 @$sqlselect = "select * from `yundan` where num='$danhao'";//把将要进行数据库操作的代码赋值给$sqlselect @$sqlinsert = "INSERT INTO `testphp`.`yundan` (`num`) VALUES ('$danhao')";$selecttoday = "select `num` from `yundan` where `time` LIKE '%$today%'";$counttoday = "select count(*) from `yundan` where `time` LIKE '%$today%'"; //统计当天的单量$conn  = mysql_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD);//建立mysql连接  $my_db = mysql_select_db(DB_DATABASE,$conn);//选择数据库   $selectnum = mysql_query($sqlselect); // 执行查询语句，并执行$sql操作 if(!empty($danhao)) {     if (mysql_num_rows($selectnum)) {  //判断重复           echo "<br>\n";        echo "<br>\n";  //这是换行空格        echo "<br>\n";        echo "运单：$danhao 请勿重复添加！";} else {        $insertnum = mysql_query($sqlinsert);        echo "<br>\n";        echo "<br>\n";        echo "<br>\n";        echo "运单：$danhao 已成功添加<br>\n";        }}//print_r($_POST) $totaltotal = mysql_fetch_array(mysql_query($counttoday));$yundannum = mysql_query($selecttoday); echo "<br>\n";echo "<br>\n";echo "<br>\n"; echo "今日统计: $totaltotal[0]件<br>\n"; while($echonum = mysql_fetch_array($yundannum)){  //循环输出单号    echo $echonum['num'];    echo "<br>\n";}mysql_close($conn); //关闭数据库连接?><script type="text/javascript"> document.getElementById ('danhao').focus(); //获得焦点function lost(){document.getElementById ('danhao').blur();  //失去焦点 防止扫快了填到一行上}</script></body> </html>

后续再完善查找、删除、修改等功能。

0 0