如何在另一个php文件上检索和确认表单输入

Question

我有以下表单输入，我正试图将这些输入数据发送到"php"；然后检索数据并添加一个确认或取消按钮，然后它可以添加到数据库

<form action="placebet.php" method="post">
<div id="box" class="boxlit">

<div class="box" data-id="0">Myanmar - Vietnam<br>Home [1]<div class="crtTotal">4.30</div>
<input type="hidden" name="kickoff[]" value="7/17/2022 10:00">
<input type="hidden" name="match[]" value="Myanmar - Vietnam">
<input type="hidden" name="result[]" value="Home [1]" readonly="">
<input type="hidden" name="value[]" value="4.30"></div>

<div class="box" data-id="4">Thailand - Philippines<br>Draw [2]<div class="crtTotal">3.20</div>
<input type="hidden" name="kickoff[]" value="7/17/2022 13:30">
<input type="hidden" name="match[]" value="Thailand - Philippines">
<input type="hidden" name="result[]" value="Draw [2]" readonly="">
<input type="hidden" name="value[]" value="3.20"></div>

<div class="box" data-id="11">Botswana - Cameroon<br>Away [3]<div class="crtTotal">1.35</div>
<input type="hidden" name="kickoff[]" value="7/17/2022 22:00">
<input type="hidden" name="match[]" value="Botswana - Cameroon">
<input type="hidden" name="result[]" value="Away [3]" readonly="">
<input type="hidden" name="value[]" value="1.35"></div></div><br>

<input type="hidden" name="account[]" value="0818054386" readonly="">

<input type="hidden" name="balance[]" value="20" readonly="">

<input type="hidden" id="todds" name="todds[]" value="18.58" readonly="">

<input type="hidden" id="inp" name="payout[]" value="92.90" readonly="">


<div>Total Odds: <b id="ct1">18.58</b></div><br>

<div>(N$)Stake: <input id="stake" type="number" name="stake[]" value="5"> NAD</div><br>

<div>Payout: N$ <b id="payout">92.90</b></div>

<input class="bet1" type="submit" name="submit" value="Bet">

</form>

Php代码在"；php"；

我不确定下面的代码是否正确，但我需要它来显示表单中的输入数据，并给我一个确认数据的选项(按钮(，然后它可以最终添加到数据库

<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "", "forms");
$dba = mysqli_connect("localhost","root","","login");

// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}

$error = false; //set the error status value
$error_msg = "";
$back = mysqli_real_escape_string($link, $_REQUEST['kickoff'][0]);
$total = count($back); // get the length of the match 
for($i=0;$i<$total;$i++){
// Escape user inputs for security
$kickoff =  mysqli_real_escape_string($link, $_REQUEST['kickoff'][$i]);
$match =  mysqli_real_escape_string($link, $_REQUEST['match'][$i]);
$selection = mysqli_real_escape_string($link, $_REQUEST['result'][$i]);
$odd =  mysqli_real_escape_string($link, $_REQUEST['value'][$i]);
$account =  mysqli_real_escape_string($link, $_REQUEST['account'][0]);
$stake = mysqli_real_escape_string($link, $_REQUEST['stake'][0]);
$payout = mysqli_real_escape_string($link, $_REQUEST['payout'][0]);
$todds = mysqli_real_escape_string($link, $_REQUEST['todds'][0]);
$accabal = mysqli_real_escape_string($link, $_REQUEST['balance'][0]);

//run sql query for every iteration
$charge = mysqli_query($dba, "UPDATE users SET balance = $accabal- $stake WHERE username='".$_SESSION['username']."'") ;
$_SESSION["balance"] =  $accabal- $stake ;

$date = date ('Ymd');
$create = mysqli_query($link,"CREATE TABLE R$date  LIKE receipts") ;
$insert = mysqli_query($link,"INSERT INTO `R$date`(`Match`, `Selection`, `Odd`,`Account`,`Stake Amount`,`Payout`,`Total Odds`) VALUES ('$match','$selection','$odd','$account','$stake','$payout','$todds')");

if(!$insert)
{
$error = true;
$error_msg = $error_msg.mysqli_error($link);            
}



//check your error status variable and show your output msg accordingly.
if($error){
echo "Error :".$error_msg;
}else{


header("location: index.php");
exit;
}

}
mysqli_close($db);
?>

Answer 1

您想要做的不是重定向到index.php，因为这样您就启动了一个新的请求，并且无法再指向placebet.php的请求数据。

您希望通过javascript ajax请求发送表单，然后对placebet.php的响应做出反应(https://www.w3schools.com/js/js_ajax_intro.asp)或者在placebet.php上生成自己的新输出，然后可以是一个确认页面或类似的页面。

例如

if($error){
echo "Error :".$error_msg;
}else{
echo "Data has been stored!";
}

在用>就像这里提到的https://www.thoughtco.com/php-with-html-2693952#:~：text=As%20you%20can%20see%2C%20you，re%20inthe%20PHP%20tags(。