问题1:我有多行输入(动态生成),它将输入值存储在mysql数据库中。我有一个只获取一次值的输入字段,我希望这个值被重复地存储在表中。
问题2:如何使用用户输入作为第一个日期,将动态生成字段中的日期递增一天,并将递增的日期传递给我的数据库?
链接到代码
我的 insert.php
file:-
<?php
//insert.php
$connect = mysqli_connect("localhost", "root", "", "crondiet");
if(isset($_POST["break_name"]))
{
$date_entry = $_POST["date_entry"];
$cid_code = $_POST["cid_code"];
$break_name = $_POST["break_name"];
$mid_meal = $_POST["mid_meal"];
$lunch_name = $_POST["lunch_name"];
$evening_snacks = $_POST["evening_snacks"];
$dinner_name = $_POST["dinner_name"];
print_r($date_entry);
$query = '';
for($count = 0; $count<count($break_name); $count++)
{
$date_entry_clean = mysqli_real_escape_string($connect, $date_entry[$count]);
$cid_code_clean = mysqli_real_escape_string($connect, $cid_code[$count]);
$break_name_clean = mysqli_real_escape_string($connect, $break_name[$count]);
$mid_meal_clean = mysqli_real_escape_string($connect, $mid_meal[$count]);
$lunch_name_clean = mysqli_real_escape_string($connect, $lunch_name[$count]);
$evening_snacks_clean = mysqli_real_escape_string($connect, $evening_snacks[$count]);
$dinner_name_clean = mysqli_real_escape_string($connect, $dinner_name[$count]);
if($date_entry_clean != '' &&$cid_code_clean != '' && $break_name_clean != ''&& $mid_meal_clean != '' && $lunch_name_clean != ''&& $evening_snacks_clean != '' && $dinner_name_clean != '')
{
$query .= '
INSERT INTO dietwithmoremeals(date_entry,cid_code,break_name,mid_meal,lunch_name,evening_snacks,dinner_name)
VALUES("'.$date_entry_clean.'","'.$cid_code_clean.'","'.$break_name_clean.'","'.$mid_meal_clean.'", "'.$lunch_name_clean.'","'.$evening_snacks_clean.'", "'.$dinner_name_clean.'");
';
}
}
if($query != '')
{
if(mysqli_multi_query($connect, $query))
{
echo 'Item Data Inserted';
}
else
{
echo 'Error';
}
}
else
{
echo 'All Fields are Required';
}
}
?>
1条答案
按热度按时间uqjltbpv1#
在查询中,可以向插入的值添加一天: