Abel1216 Posted July 10, 2020 Share Posted July 10, 2020 Am trying to get user input then compare it with the value in database then return an output in form of echo. It shows a blank page of whick i cant figure out the error. This is what i have tried so far. This is a file called t12.php <?php include 'db.php'; error_reporting(E_ALL | E_WARNING | E_NOTICE); ini_set('display_errors', TRUE); if (session_status() == PHP_SESSION_NONE) { session_start(); } if(!isset($_SESSION['login'])) { echo (" <script>location.href='../clogin/'</script>"); die(); if(isset($_POST['transfer'])) { $username = $_SESSION['login']; $transAmount = $_POST['transAmount']; $totalTrans = $transAmount + 30; $sql = "SELECT * FROM customer WHERE username = ?"; $stmt = $connection->prepare($sql); $stmt->bind_param('s', $username); $stmt->execute(); $result = $stmt->get_result(); $count = $result->num_rows; if($count == 1) { while ($row = $result->fetch_assoc()) { if($totalTrans > $row['transLimit']) { echo 'you have exceeded limit'; exit(); } else { echo"limit passed"; } }//while loop }//count }//submit }//session ?> The html form is this... <form action="t12.php" method="post"> <input type="number" name="transAmount" placeholder="Enter Amount"> </input><br> <button type="submit" name="transfer">Proceed</button></form> Have tried lot of stuffs but doesnt work out. I would appreciate if you can take your time to check for me and point out the errors. Also please be nice with your comments. Thanks in advance Quote Link to comment Share on other sites More sharing options...
Abel1216 Posted July 10, 2020 Author Share Posted July 10, 2020 I have found the issue. Thanks. Even if i had no answers. Much love😉 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.