Click here to Skip to main content
14,981,532 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
<?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);
?>
Posted
Comments
Richard MacCutchan 27-Jun-18 5:12am
   
You have the balance from the database, what are you trying to do with it?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900