正在组合要插入数据库的字段 - Combining fields to insert into database

Combining fields to insert into database

本文关键字：数据库字段插入组合 | 更新日期: 2023-09-27

我对此有问题。我正在努力使这些字段结合起来，一个有-一个没有插入数据库

$daters = $_POST['11']." ". $_POST['22']." ". $_POST['33']; 
$dater = $_POST['11']." - ". $_POST['22']." - ". $_POST['33'];

    <?php
                     //  if ('POST' === $_SERVER['REQUEST_METHOD'])
                     if (isset($_POST['submit2']))
{
$con = mysql_connect("localhost","rabbitju_rjziond","r4bb1t");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("rabbitju_rjreservation", $con);

$daters = $_POST['11']." ". $_POST['22']." ". $_POST['33']; 
$dater = $_POST['11']." - ". $_POST['22']." - ". $_POST['33'];

//Writes the to the server 
$sql = mysql_query("INSERT INTO `reservation__date` (`reservation_id`, `reservation_date`) 
VALUES
 ('daters', '$dates')") or die(mysql_error()); 
$query = mysql_query($sql);
if ($_SERVER['REQUEST_METHOD'] === 'POST')
{
echo "Succesfully added transaction. Updating table...";
echo "<META HTTP-EQUIV='"refresh'" CONTENT='"6'">";  
mysql_close($con);
}
}
?>

$sql = mysql_query("INSERT INTO `reservation__date` (`reservation_id`, `reservation_date`) VALUES ('$daters', '$dates')") or die(mysql_error());

在"daters"之前没有$

使用以下查询。您忘记为reservation_id值添加的$符号。

$sql = mysql_query("INSERT INTO `reservation__date` (`reservation_id`, `reservation_date`) VALUES ('".$daters."', '".$dates."')");