Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $connection = mysqli_connect("localhost", "SENSORED", "SENSORED", "SENSORED");
- $username = $_POST["username"];
- $password = $_POST["password"];
- $statement = mysqli_prepare($connection, "SELECT * FROM user WHERE username = ? AND password = ?");
- var_dump(mysqli_error($connection));
- mysqli_stmt_bind_param($statement, "ss", $username, $password);
- var_dump(mysqli_error($connection));
- mysqli_stmt_execute($statement);
- var_dump(mysqli_error($connection));
- mysqli_stmt_store_result($statement);
- var_dump(mysqli_error($connection));
- mysqli_stmt_bind_result($statement, $user_id, $name, $username, $email, $company_id, $phone, $password, $leaveTime, $sickTime, $rateOfPay);
- var_dump(mysqli_error($connection));
- $response = array();
- $response["success"] = false;
- while(mysqli_stmt_fetch($statement)){
- var_dump(mysqli_error($connection));
- $response["success"] = true;
- $response["user_id"] = $user_id;
- $response["name"] = $name;
- $response["username"] = $username;
- $response["email"] = $email;
- $response["company_id"] = $company_id;
- $response["phone"] = $phone;
- $response["password"] = $password;
- $response["leaveTime"] = $leaveTime;
- $response["sickTime"] = $sickTime;
- $response["rateOfPay"] = $rateOfPay;
- }
- echo json_encode($response);
- ?>
Add Comment
Please, Sign In to add comment