PHP从数据循环中准备好的语句插入 [英] PHP prepared statement insert from a loop of data
本文介绍了PHP从数据循环中准备好的语句插入的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
关于为什么不更新我的数据的任何想法?他们在我编写预备陈述的方式上有根本性的错误吗?
Any ideas as to why my data isn't being updated? Is their something fundamentally wrong with how I'm writing my prepared statement?
表单:
while($log_dates = mysqli_fetch_assoc($q_log_dates_result)) {
echo "<tr>";
echo "<input type='hidden' name='data[][log_dates_ID]' value='" . $log_dates['log_dates_ID'] . "'/>";
echo "<td><input type='text' name='data[][week_date]' value='" . $log_dates['week_date'] . "' /></td>";
echo "<td><input type='text' name='data[][crew_chief]' value='" . $log_dates['crew_chief'] . "' readonly /></td>";
echo "<td><input type='text' name='data[][monday_crew]' value='". $log_dates["monday_crew"] ."'/></td>";
echo "</tr>";
} // end while loop
PHP:
if (isset($_POST['submit'])) {
$stmt = $connection->stmt_init();
if($stmt->prepare("UPDATE log_dates SET (week_date, crew_chief, monday_crew) VALUES (?, ?, ?) WHERE log_dates_ID = ?")) {
// Bind your variables to replace the ?s
$stmt->bind_param('sssi', $week_date, $crew_chief, $monday_crew, $log_dates_ID);
$returnedData = $_POST['data'];
for($i=0;$i<count($returnedData);$i+=4){
$log_dates_ID = $returnedData[$i]['log_dates_ID'];
$week_date = $returnedData[$i+1]['week_date'];
$crew_chief = $returnedData[$i+2]['crew_chief'];
$monday_crew = $returnedData[$i+3]['monday_crew'];
$stmt->execute();
}
// Close statement object
$stmt->close();
}
}
推荐答案
您的UPDATE语法不正确.应该是:
Your UPDATE syntax is not correct. It should be:
UPDATE log_dates
SET week_date = ?, crew_chief = ?, monday_crew = ?
WHERE log_dates_ID = ?
您正在尝试在UPDATE
语句中使用INSERT
语法.它们根本不相似.
You're trying to user INSERT
syntax in an UPDATE
statement. They're not similar at all.
这篇关于PHP从数据循环中准备好的语句插入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文