PHP Web服务。如何从数据库中获取数据？

Question

I am developing an adroid app and I faced some trouble about php web service.

I want to get user type information form database and according to the answer I will do some process in the background.

So in my authentication code there is a area like this to get usertype;

function getUserType(){
    $sql = "SELECT `usertype` FROM `login_test` WHERE username = '". $this->username2."'
     AND password = '".$this->password2."'";

    $result = mysqli_query($this->DB_CONNECTION, $sql);

    if(mysqli_num_rows($result)>0){
        return (?);
    }
}

and my in my login code the message will be send here;

if ($userStatus) {
// user existed
// So log him to main page
$json['success'] = 1;
$json['message'] = 'Access Granted';
$json['usertype'] = 'Client';


echo json_encode($json);

Here I dont know how to access a certain field called 'usertype' in my table (I am really new in php) and how to return the value that I got.

Any help will be apreciated

P.S = $userStatus returns ture.

Answer 1

You could try doing this:

$sql = "SELECT * FROM `login_test` WHERE username = '$this->username2' AND password = '$this->password2'";
$result = mysqli_query($this->DB_CONNECTION, $sql);
return $result->fetch_object()->userType;

While please do keep in mind to use prepared statements.