if($_SERVER['REQUEST_METHOD'] == "GET"){
// Get post data`
$username = isset($_POST['username']) ? mysql_real_escape_string($_POST['username']) : "";
$password = isset($_POST['password']) ? mysql_real_escape_string($_POST['password']) : "";
//$status = 1;
// Here we set by default status In-active.
// Save data into database
//$resultarray = array();
$query = "select admin_user , admin_password from doc_admin where admin_user = '".$username."' and admin_password = '".$password."'";
$insert = mysql_query($query) or die (mysql_error());
if (mysql_num_rows($insert)>0)
{
while ($rs = mysql_fetch_assoc($insert))
{
$outp .= '{"id":"' . $rs["id"] . '",';
$outp .= '"admin_user":"' . $rs["admin_user"]. '",' ;
$outp .= '"admin_password":"' . base64_encode($rs["admin_password"]). '",' ;
$outp .= '"admin_status":"' . $rs["admin_status"] . '",';
$outp .= '"admin_data":"' . $rs["admin_data"] . '",';
$outp .= '"admin_calender":"' . $rs["admin_calender"] . '",';
$outp .= '"admin_suggestion":"' . $rs["admin_suggestion"] . '",';
$outp .= '"admin_agenda":"'. $rs["admin_agenda"] . '"}';
// array_push($resultarray,$result);
}
}
}
mysql_close($conn);
/* JSON Response */
header("Content-type: application/json");
echo json_encode($outp);
我想显示亲自登录的数据,但它显示空值,但如果它在数据库中获得空值,它以 JSON 格式显示结果。
<?php
if($_SERVER['REQUEST_METHOD'] == "GET"){
// Get post data`
$username = isset($_POST['username']) ? mysql_real_escape_string($_POST['username']) : "";
$password = isset($_POST['password']) ? mysql_real_escape_string($_POST['password']) : "";
//$status = 1;
// Here we set by default status In-active.
// Save data into database
//$resultarray = array();
$query = "select * from doc_admin where admin_user = '".$username."' and admin_password = '".$password."'";
$insert = mysql_query($query) or die (mysql_error());
if (mysql_num_rows($insert)>0)
{
$rs = mysql_fetch_assoc($insert);
$outp = json_encode($rs);
} else {
$outp = json_encode(array());
}
}
mysql_close($conn);
/* JSON Response */
header("Content-type: application/json");
echo json_encode($outp);
?>