得到你需要制作一个与基于银行账户号码列中的所有数据数据库Select声明传递的银行帐号作为变量。然后将该语句存储为变量,并将其传递到数据库,该数据库将返回任何匹配项。如:
bank_no1
bank_no2
bank_no3
// make a connection to your MySQLi server using credentials
$conn = new mysqli($servername, $username, $password, $dbname);
// get the form data from the bank_name select
$bank_noX = $_POST["bank_name"];
// construct an SQL string passing in the bank number
$sql = "Select * FROM Accounts WHERE bank_name IS " . $bank_noX;
// query the SQL database using our established connection and store in $result
$result = $conn->query($sql);
?>
那么你的结果是银行数量在$result,您可以用$result->fetch_assoc()解析数据。例如,
while($row = $result->fetch_assoc()) {
printf("Bank ID: " . $row['bank_id'] . ", Hello " . $row['account_name']);
}
这是假设你有一个MySQLi数据库和一个到它的连接。