source code of MES Data

来源：互联网发布：ubuntu17.10安装软件编辑：程序博客网时间：2024/05/02 02:15
<HTML><HEAD><TITLE>TELOGS</TITLE></HEAD><BODY><?php/* command line parameters:  wget "http://localhost/query.php?action=query&sn=123" -O get1.html */$act=$_GET["action"];/* http://localhost/query.php?action=query&sn=123  */if ($act == "query"){$serialnumber=$_GET["sn"];$con = mysql_connect("localhost","root","123456");if (!$con){die('Could not connect: ' . mysql_error());}mysql_select_db("test", $con);$sql = "SELECT * FROM testlogs where Serial_number='$serialnumber'";$result = mysql_query($sql);if (mysql_num_rows($result) != "0" ){while($row = mysql_fetch_array($result)){echo $row['Serial_number'] . "|" . $row['Mac_addr']."|". $row['OA_KEY']."\n";}}else{echo "No data of this serial number=".$serialnumber;}mysql_close($con);}?><?php/* http://localhost/query.php?action=add&sn=123&mac=eeee&oakey=123   */if ($act == "add"){$serialnumber=$_GET["sn"];$macaddr=$_GET["mac"];$oakey=$_GET["oakey"];$con = mysql_connect("localhost","root","123456");if (!$con){die('Could not connect: ' . mysql_error());}mysql_select_db("test", $con);$sql="INSERT INTO testlogs (Serial_number, Mac_addr, OA_KEY) values ('$serialnumber','$macaddr','$oakey')";if(mysql_query($sql)){echo "Add data Passed";}else{echo "Add data failed";}mysql_close($con);}?></BODY></HTML>
0 0