sourcecodeofMESData

< 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);
	}
 >