I have a table in mysql , called customer. it has id,name,number,password & balance with respective data's. i have an Android application which is connect with this database and login with number and password . If it is match then ask amount to detect from particular customer balance.the number and password is successfully verified but i need to detect some the amount from customer balance.how to do that.. below code is for verify the number and password
if my question is not clear. please let me know .. thanks in advance :)
What I have tried:
verify.php
$con = mysqli_connect("localhtost", "root","", "data");
$number = $_POST["number"];
$password = $_POST["password"];
$statement = mysqli_prepare($con, "SELECT * FROM customer WHERE number = ? AND password = ?");
mysqli_stmt_bind_param($statement, "ss", $number, $password);
mysqli_stmt_execute($statement);
mysqli_stmt_store_result($statement);
mysqli_stmt_bind_result($statement,$id,$name,$number,$password,$balance);
$response = array();
$response["success"] = false;
while(mysqli_stmt_fetch($statement)){
$response["success"] = true;
$response["id"] = $id;
$response["name"] = $name;
$response["number"] = $number;
$response["password"] = $password;
$response["balance"] = $balance;
}
echo json_encode($response);
?>
解决方案con = mysqli_connect("localhtost", "root","", "data");
number =
_POST["number"];