{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 爷、活的狠高调 的问题《Proceed Transaction if card number is found in the》','https://www.manongdao.com/q-1299849.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I am new here.
So, I am making a transaction page for our cashless RFID scanner system.
The system works by scanning the RFID card. Once scanned, the card number would appear and get searched in the database. The search feature already works but the problem now is, what are the codes needed to make it proceed once the card number is searched. Otherwise, the transaction will not proceed if the card number is not found in the system?
Screenshot of search page
Screenshot of code
<?php
if(isset($_POST['search']))
{
$card_number = $_POST['card_number'];
$connect = mysqli_connect("localhost", "root", "","transaction");
$query = "SELECT `card_number`, `first_name`, `last_name`, `department`,`address` FROM `accounts_list` WHERE `card_number` = $card_number LIMIT 1";
$result = mysqli_query($connect, $query);
if(mysqli_num_rows($result) > 0)
{
while ($row = mysqli_fetch_array($result))
{
$card_number = $row['card_number'];
$first_name = $row['first_name'];
$last_name = $row['last_name'];
$department = $row['department'];
$address = $row['address'];
}
}
else {
echo "Card Number not in the system";
$card_number = "";
$first_name = "";
$last_name = "";
$department = "";
$address = "";
}
mysqli_free_result($result);
mysqli_close($connect);
}
else{
$card_number = "";
$first_name = "";
$last_name = "";
$department = "";
$address = "";
}
?>
<!DOCTYPE html>
<html>
<head>
<title> PHP FIND DATA </title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<form action="searchsystem.php" method="post">
Card Number:<input type="text" name="card_number"><br><br>
First Name:<input type="text" name="first_name" readonly="readonly" value="<?php echo $first_name;?>"><br><br>
Last Name:<input type="text" name="last_name" readonly="readonly" value="<?php echo $last_name;?>"><br><br>
Addess:<input type="text" name="addess" readonly="readonly" value="<?php echo $address;?>"><br><br>
Department:<input type="text" name="department" readonly="readonly" value="<?php echo $department;?>"><br><br>
<input type="submit" name="search" value="Find">
</form>
</body>
<p><a href='/Transaction/home.php' title='Frank Tank Scripts'><font color='#000000'>Back</font></a></p>
</html>