source code of MES Data

<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>

source code of MES Data的更多相关文章

Memcached source code analysis (threading model)--reference
Look under the start memcahced threading process memcached multi-threaded mainly by instantiating mu ...
Learning from the CakePHP source code - Part I
最近开始痛定思痛,研究cakephp的源码. 成长的路上从来没有捷径,没有小聪明. 只有傻傻的努力,你才能听到到成长的声音. 下面这篇文章虽然过时了,但是还是可以看到作者的精神,仿佛与作者隔着时空的交 ...
Source Code Review
1.berfore we talking abnout the Source Code review,here's what we want to know about the most popula ...
HashMap source code view（1）
前言 HashMap source code view 类注释 Hash table based implementation of the Map interface. This implement ...
How to compile and install Snort from source code on Ubuntu
http://www.tuicool.com/articles/v6j2Ab Snort is by far the most popular open-source network intrusio ...
CRC32 Source Code
/* The Quest Operating System * Copyright (C) 2005-2010 Richard West, Boston University * * This pro ...
attack source code
不废话,直接上代码, 先看截图use pictures;
Tree - AdaBoost with sklearn source code
In the previous post we addressed some issue of decision tree, including instability, lack of smooth ...
Tree - Decision Tree with sklearn source code
After talking about Information theory, now let's come to one of its application - Decision Tree! No ...

随机推荐

PL/SQL 将旧表的一些字段赋值给新的表中的字段的做法
INSERT INTO 新表(字段1,字段2,.......) SELECT 字段1,字段2,...... FROM 旧表
hdu 3018 Ant Trip 欧拉回路+并查集
Ant Trip Time Limit: 2000/1000 MS (Java/Others) Memory Limit: 32768/32768 K (Java/Others) Problem ...
JavaScript HTML DOM---遗漏知识再整理（向html添加/删除元素，改变内容和css）
1. HTML DOM 改变 HTML 内容:(HTML DOM 允许 JavaScript 改变 HTML 元素的内容.) (1)改变 HTML 输出流在 JavaScript 中,docume ...
Redis批量导入数据
首先准备数据文件格式为 SET Key0 Value0 SET Key1 Value1 ... SET KeyN ValueN 利用shell转换数据 #!/bin/bash while read ...
(转)php中&lowbar;&lowbar;autoload()方法详解
转之--http://www.php100.com/html/php/lei/2013/0905/5267.html PHP在魔术函数__autoload()方法出现以前,如果你要在一个程序文件中实例 ...
C&num;修改用户名
string strCmdText; strCmdText = "useraccount where name='" + 旧密码 + "' rename " + ...
IE控件cab包手动安装
一.XP系统第1步:先解压cab包,在解压的文件中找到*.inf文件,然后右击,选择安装,此时会把解压文件拷到C:Windows\System32文件夹下.第2步:注册拷到上述文件夹下的ocx文件. ...
Maven学习笔记2（坐标和依赖）
1.坐标 Maven坐标为各个构件建立了秩序,任何一个构件都必须明确自己的坐标,一个maven坐标是由一些元素确定的 <groupId>com.alivn.account</grou ...
struct初始化
C语言中struct初始化 • 普通结构体的初始化假设我们有如下的一段代码,其中已有Student结构体,要求实例化一个Student对象并将其初始化. #include <stdio.h&g ...
autofs文件自动挂载系统
为了自己使用方便,利用iso文件制作了自己的rhel6.4的yum源,每次都手动进行mount,十分不便后来在/etc/rc.local中写入了mount命令,方便多了. 时间一久,发现新的问题出现 ...