這些是我的數(shù)據(jù)庫上的字段partamento intcodigocurso intdiurno intcontacto intpos_laboral intcontacto2 intproc_por int從昨天開始我一直在嘗試修復(fù)這個錯誤，但我無法弄清楚錯誤在哪里。**foreach ($diurno as $userId) { $data .= "(".$id.",".$grdid.",".$userId.",".$contacto.",".$pos_laboral.",".$contacto2.",".$idd.")"; } $data = rtrim($data, ','); $sql = "insert into cursosprogramas (departamento, codigocurso, diurno, contacto, pos_laboral, contacto2, proc_por) values (".$data.");"; echo $sql;錯誤插入cursosprogramas(department, codigocurso, daytime, contact, pos_laboral, contacto2, proc_por)values((100,120,7,646,5,363,2)(100,120,4,646,5,363,2));查詢失敗。
2 回答
揚帆大魚
TA貢獻1799條經(jīng)驗 獲得超9個贊
您在數(shù)據(jù)集之間缺少逗號，并且也不需要將它們?nèi)坷ㄆ饋?。您已?jīng)在使用rtrim()刪除最后一個逗號，但實際上并沒有在數(shù)據(jù)集的末尾添加逗號。
foreach ($diurno as $userId) {
? ??
? ? //add a comma at the end
? ? //note you can write variables directly into a string that is wrapped with double quotes
? ? $data .= "('$id', '$grdid', '$userId', '$contacto', '$pos_laboral', '$contacto2', '$idd'),";
}
//this gets rid of the very last comma in the string
$data = rtrim($data, ',');
//remove parenthesis around `$data`
$sql = "insert into cursosprogramas (departamento, codigocurso, diurno, contacto, pos_laboral, contacto2, proc_por) values {$data};";
echo $sql;
注意：Little Bobby表示這段代碼可能面臨 SQL 注入攻擊的風(fēng)險，具體取決于其中變量的$data創(chuàng)建方式。
牛魔王的故事
TA貢獻1830條經(jīng)驗 獲得超3個贊
您需要在值元組之間使用逗號。嘗試在第二行末尾加一個逗號，如下所示：
foreach ($diurno as $userId) {
$data .= "(".$id.",".$grdid.",".$userId.",".$contacto.",".$pos_laboral.",".$contacto2.",".$idd."),";
}
$data = rtrim($data, ',');
$sql = "insert into cursosprogramas (departamento, codigocurso, diurno, contacto, pos_laboral, contacto2, proc_por) values (".$data.");";
echo $sql;
- 2 回答
- 0 關(guān)注
- 191 瀏覽
添加回答
舉報
0/150
提交
取消