<?php
header('Access-Control-Allow-Origin: *'); 
header('Content-type: application/json');
include'../admin/includes/connection.php';

if (isset($_GET['email'])){

    $email = $_GET['email'];
    $password = $_GET['password'];
    $query = "SELECT * FROM `public_users` WHERE email = '{$email}' AND password = '{$password}'";
    $res = mysqli_query($con, $query) or die(mysqli_error($con));
    if(mysqli_num_rows($res)>0){
       
        $respond['message']="login success";
        
    }
    else{
       
        $respond["message"]="login failed";
    }
    echo json_encode($respond);
    
   

}
else{
    
    $respond["message"]="login failed";
}


?>

I want to print message as well as login detail of user also from database ....like.....id name email password image etc....

please guide me...

CodePudding user response：

Please try this code: you have to loop over the $res variable, be aware to change the variable to your database variables

<?php
header('Access-Control-Allow-Origin: *');
header('Content-type: application/json');
include'../admin/includes/connection.php';

if (isset($_GET['email'])){

    $email = $_GET['email'];
    $password = $_GET['password'];
    $query = "SELECT * FROM `public_users` WHERE email = '{$email}' AND password = '{$password}'";
    $res = mysqli_query($con, $query) or die(mysqli_error($con));
    if(mysqli_num_rows($res)>0){
        $line = "login success";
        while($obj = $res->fetch_object()){
            $line.=$obj->uid;
            $line.=$obj->role;
            $line.=$obj->roleid;
        }

        $respond['message']=$line;

    }
    else{

        $respond["message"]="login failed";
    }
    echo json_encode($respond);



}
else{

    $respond["message"]="login failed";
}


?>

CodePudding user response：

Try the code:

<?php
header('Access-Control-Allow-Origin: *'); 
header('Content-type: application/json');
include'../admin/includes/connection.php';

if (isset($_GET['email'])){

    $email = $_GET['email'];
    $password = $_GET['password'];
    $query = "SELECT * FROM `public_users` WHERE email = '{$email}' AND password = '{$password}'";
    $res = mysqli_query($con, $query) or die(mysqli_error($con));
    if(mysqli_num_rows($res)>0){
        while($row = $res->fetch_assoc()) {
            $id = $row['id'];
            $email = $row['email'];
            $image = $row['image'];
          }
        
        $respond['id'] = $id;
        $respond['email'] = $email;
        $respond['image'] = $image;
        $respond['message'] = "login success";
        
    }
    else{
       
        $respond["message"]="login failed";
    }
    echo json_encode($respond);
    
   

}
else{
    
    $respond["message"]="login failed";
}


?>