search

Home  >  Article  >  Database  >  sourcecodeofMESData

sourcecodeofMESData

WBOY
WBOYOriginal
2016-06-07 16:04:441119browse

HTMLHEADTITLETELOGS/TITLE/HEADBODY?php/* command line parameters: wget http://localhost/query.php?action=querysn=123 -O get1.html */$act=$_GET[action];/* http://localhost/query.php?action=querysn=123 */if ($act == query){$serialnumber=$_GE

<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(&#39;Could not connect: &#39; . mysql_error());
		}

		mysql_select_db("test", $con);
		$sql = "SELECT * FROM testlogs where Serial_number=&#39;".$serialnumber."&#39;";
		$result = mysql_query($sql);
		if (mysql_num_rows($result) != "0" ){
			while($row = mysql_fetch_array($result))
			{
				echo $row[&#39;Serial_number&#39;] . "|" . $row[&#39;Mac_addr&#39;]."|". $row[&#39;OA_KEY&#39;]."\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(&#39;Could not connect: &#39; . mysql_error());
		}

		mysql_select_db("test", $con);
		$sql="INSERT INTO testlogs (Serial_number, Mac_addr, OA_KEY) values (&#39;".$serialnumber."&#39;,"."&#39;".$macaddr."&#39;,"."&#39;".$oakey."&#39;)";
		if(mysql_query($sql)){
			echo "Add data Passed";
		}else{
			echo "Add data failed";
		}
		mysql_close($con);
	}
?>
</BODY>
</HTML>

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MongoDB应用二三事Next article：数据库表的命名规范

Related articles

See more