source code of MES Data
生活随笔
收集整理的這篇文章主要介紹了
source code of MES Data
小編覺得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
<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>
版權(quán)聲明:本文博主原創(chuàng)文章。博客,未經(jīng)同意不得轉(zhuǎn)載。
總結(jié)
以上是生活随笔為你收集整理的source code of MES Data的全部內(nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 二叉树的先序、中序、后序遍历等基本操作c
- 下一篇: MathType使用中的四个小技巧