This is my code before I upload my .php and use it locally.
public function getUserByCardNo($cardno){
$stmt = $this->con->prepare("SELECT * FROM accounts WHERE cardno = ?");
$stmt->bind_param("s",$cardno);
$stmt->execute();
return $stmt->get_result()->fetch_assoc();
}
I uploaded my .php in a free hosting site. After running, I get the error: Call to undefined method mysqli_stmt::get_result()
After some digging, I found this answer: stackoverflow.com
They said that I needed to use BIND_RESULT & FETCH. But I don't know what to write inside the while($stmt->fetch()) block
So, I keep digging and found this: stackoverflow.com
and here is my code now:
public function getUserByCardNo($cardno){
$stmt = $this->con->prepare("SELECT id, name, cardno, pin, balance, status FROM accounts WHERE cardno = ?");
$stmt->bind_param("s",$cardno);
$stmt->execute();
$stmt->bind_result($id, $name, $cardno, $pin, $balance, $status);
$info = array();
while ($stmt->fetch()){
$tmp = array();
$tmp["id"] = $id;
$tmp["name"] = $name;
$tmp["cardno"] = $cardno;
$tmp["pin"] = $pin;
$tmp["balance"] = $balance;
$tmp["status"] = $status;
array_push($info, $tmp);
}
$stmt->close();
return $info;
}
That function is called by my userLogin.php
if($_SERVER['REQUEST_METHOD']=='POST'){
if(isset($_POST['cardno']) and isset($_POST['pin'])){
$db = new DbOperations();
if($db->userLogin($_POST['cardno'], $_POST['pin'])){
$user = $db->getUserByCardNo($_POST['cardno']);
$response['error'] = false;
$response['id'] = $user['id'];
$response['pin'] = $user['pin'];
$response['cardno'] = $user['cardno'];
$response['name'] = $user['name'];
$response['balance'] = $user['balance'];
$response['status'] = $user['status'];
}
else{
$response['error'] = true;
$response['message'] = "Invalid Card Number or Pin";
}
}
else{
$response['error'] = true;
$response['message'] = "Required fields are missing";
}
}
Because I need to store all the user's info.
But after using Postman, im getting this result.
{"error":false,"id":null,"pin":null,"cardno":null,"name":null,"balance":null,"status":null}
Everything it return is null.
