现在要写php页面处理gms发送的请求了
命令行输入gedit打开文本编辑器gedit
暂且把处理登录的叫login.php吧,那喵代码如下了:
<?php
$name = $_POST['name'];
$password = $_POST['password'];
$con = mysql_connect("localhost", "root", "");
if ($con) echo "Connect to server successfully! ";
else die("Conncection fails...");
mysql_select_db("Data", $con);
$result = mysql_query("select * from User where name = '" . $name . "'");
$r = mysql_affected_rows();
if ($r == 1)
{
$row = mysql_fetch_array($result);
if ($row['password'] == $password) echo "Login successfully! ";
else echo "Wrong password! ";
}
else echo "No user with this name...";
mysql_close($con);
?>


$name = $_POST['name'];
$password = $_POST['password'];
这两句是php从gms发送的http请求中顺便post过来的数据,后面会说说
那么php获得这两个变量后,就可以进行愉快的处理了
先是连接数据库,判断数据库是否成功连接并输出信息,然后选择刚刚创建的名为Data的数据库,执行sql语句查询User表是否存在name,若存在判断密码对不对,处理,最后关掉连接。