PHP 開發API介面 註冊,登入,查詢使用者資料
服務端
0) { exit(json_encode(1)); //返回1表示註冊失敗 } else { $addsql = "insert into `member` (username,password,email) values ('$username','$password','$email')"; mysql_query($addsql); exit(json_encode(0)); //返回0表示註冊成功 } break; //查詢使用者資訊 case"selectuserinfo"; $username = lib_replace_end_tag($_GET['username']); $sql = "select id,username,nickname,mobile from `member` where username='$username'"; $query = mysql_query($sql, $conn); $row = mysql_fetch_array($query); foreach ($row as $key => $v) { $res[$key] = urlencode($v); } exit(json_encode($res)); break; //會員登入 case"userlogin"; $username = lib_replace_end_tag($_GET['username']); $password2 = lib_replace_end_tag(trim($_GET['userpassword'])); $password = md5("$password2" . ALL_PS); $sqluser = "select id,username,password from `member` where username='" . $username . "' and password='" . $password . "'"; $queryuser = mysql_query($sqluser); $rowuser = mysql_fetch_array($queryuser); if ($rowuser && is_array($rowuser) && !empty($rowuser)) { if ($rowuser['username'] == $username && $rowuser['password'] == $password) { if ($rowuser['password'] == $password) { $res = urlencode("登入成功"); exit(json_encode($res)); } else { $res = urlencode("密碼錯誤"); exit(json_encode($res)); } } else { $res = urlencode("使用者名稱不存在"); exit(json_encode($res)); } } else { $res = urlencode("使用者名稱密碼錯誤"); exit(json_encode($res)); } /* * 0:表示登入成功,1:表示密碼錯誤,2:使用者名稱不存在,3:使用者名稱密碼錯誤 */ break; default: exit(json_encode(error));}?>
用戶端例子: