我想执行4次查询以将数据插入表中。变量$answerformat
和$feedbackformat
具有固定值,但该值$answer
和$format
将发生变化。
这是我到目前为止所取得的成就:
$answer=array('<p>ali<p>','<p>ali<p>','<p>ali<p>','<p>ali<p>');
$answerformat=1;
$fraction=array('1.0000000','0.0000000','0.0000000','0.0000000');
$feedbackformat=1;
for($i=0;$i<=sizeof($answer);$i++){
}
您只需要将查询放入循环中即可。您是否尝试过阅读mysqli_*
或PDO?
让我们以mysqli_*
扩展为例。假设您还建立了用户权限,创建了数据库等,我们必须首先建立与数据库的连接:
$con = new mysqli("Host", "User", "Password", "Database"); /* REPLACE NECESSARY PARAMETERS INSIDE */
/* CHECK CONNECTION */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
然后,让我们继续循环并插入查询:
$answer = array('<p>ali<p>', '<p>ali<p>', '<p>ali<p>', '<p>ali<p>');
$answerformat = 1;
$fraction = array('1.0000000', '0.0000000', '0.0000000', '0.0000000');
$feedbackformat = 1;
for($i = 0; $i < sizeof($answer); $i++){
/* PREPARE YOUR INSERT QUERY BELOW; REPLACE NECESSARY TABLE NAME AND COLUMN NAME; */
$stmt = $con->prepare("INSERT INTO yourTable (Column1, Column2, Column3, Column4) VALUES (?, ?, ?, ?)");
$stmt->bind_param("ssss", $answer[$i], $answerformat, $fraction[$i], $feedbackformat); /* QUESTION MARKS IN YOUR INSERT QUERY WILL BE REPLACED WITH THESE FOUR VARIABLES; REPLACE OR REARRANGE PROPERLY THESE VARIABLES; s STANDS FOR STRINGS */
$stmt->execute(); /* EXECUTE QUERY */
$stmt->close(); /* CLOSE PREPARED STATEMENT */
}
必须删除=
您的循环,因为它将循环五(5)次而不是四(4)次。数组的索引始终以零(0)开头。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句