Saturday, 28 September 2013

insert multiple arrays to database

insert multiple arrays to database

I am creating a multiple choice quiz and I don't know how to insert
multiple arrays to database. Please help. Here is my code.
<?php
if(isset($_POST['btnCreate'])) {
$inQuestion = array($_POST['inQuestion']);
$inAnswer = array($_POST['inAnswer']);
$inA = array($_POST['inA']);
$inB = array($_POST['inB']);
$inC = array($_POST['inC']);
$inD = array($_POST['inD']);
$inLesson = $_POST['inLesson'];
$inQuizNo = $_POST['inQuizNo'];
$sql = "SELECT * FROM lessons WHERE title='$inLesson'";
$query = mysql_query ($sql);
$row = mysql_fetch_assoc($query);
$lessonID = $row['lessonID'];
foreach(array_combine($_POST['inQuestion'], $_POST['inAnswer']) as
$question => $answer) {
$sql = "INSERT INTO `test` (question, answer, A, B, C, D,
lessonID, quizNo) VALUES ('$question', '$answer', '$_POST[A]',
'$_POST[B]', '$_POST[C]', '$_POST[D]', '$lessonID',
$inQuizNo)";
$query = mysql_query( $sql );
}
}
?>

No comments:

Post a Comment