1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 |
- <?php
- $uname = $_POST['uname'];
- $upass = $_POST['upass'];
- $action = $_POST['action'];
-
- $conn = mysql_connect("121.42.8.157","root","~cs3x@2022#123~","xcjkdba",13307);
- if(!$conn)
- {
- die("error");
- }
-
- $result = mysql_select_db("xcjkdba",$conn);
- if(!$result)
- {
- mysql_close($conn);
- die("error");
- }
-
- if($action == "login")
- {
-
- $sql = "select x, y, z from his_location_tadiao_result order by loc_time desc limit 100";
-
-
- $rs=mysql_query($sql);
- if(!$rs)
- {
- mysql_close($conn);
- die("error");
- }
- $recordCount=mysql_num_rows($rs);
- if($recordCount>0)
- {
- echo "success";
- }
- else
- {
- echo "error";
- }
- }
- else if($action == "regist")
- {
-
- $sql = "set names utf8";
-
- mysql_query($sql);
-
-
- $sql = "select *from t_user where uname='".$uname."'";
-
- $rs=mysql_query($sql);
- if(!$rs)
- {
- mysql_close($conn);
- die("error");
- }
-
- $recordCount = mysql_num_rows($rs);
- if($recordCount>0)
- {
- mysql_close($conn);
- die("exist");
- }else
- {
-
- $sql = "insert into t_user(uname,upass) values('".$uname."','".$upass."')";
-
- $rs=mysql_query($sql);
- if(!$rs)
- {
- mysql_close($conn);
- die("error");
- }
- else
- {
- echo "success";
- }
-
- }
-
-
- }
- else
- {
- echo "error!";
- }
-
- mysql_close($conn);
- ?>
|