Databases
StackOverflow2013
Postsdbo
POinsert multiple arrays to database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POinsert multiple arrays to database
    primarykey
    data
    text
    <p>I am creating a multiple choice quiz and I don't know how to insert multiple arrays to database. I can insert the first 2 arrays using array_combine but cannot on the 3rd, 4th, 5th, and 6th array. I can insert questions and answers but not the options A, B, C, and D.</p> <p>I'm trying to do something like</p> <p>foreach(array_combine($_POST['inQuestion'], $_POST['inAnswer'], $_POST['inA'], $_POST['inB'], $_POST['inC'], $_POST['inD']) as $question => $answer => $A => $B => $C => $D) {</p> <p>Please help. Here is my code.</p> <pre><code>&lt;?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 =&gt; $answer) { $sql = "INSERT INTO `test` (question, answer, A, B, C, D, lessonID, quizNo) VALUES ('$question', '$answer', '$A', '$B', '$C', '$D', '$lessonID', $inQuizNo)"; $query = mysql_query( $sql ); } } ?&gt; &lt;div class="panel panel-info"&gt; &lt;div class="panel-heading"&gt; &lt;h4&gt;Create Assessment - Multiple Choice&lt;/h4&gt; &lt;/div&gt; &lt;div class="panel-body"&gt; &lt;form method="post"&gt; &lt;br&gt; &lt;div&gt; &lt;div class="col-md-4"&gt; &lt;strong&gt;Lesson&lt;/strong&gt;&lt;br&gt; &lt;select class="form-control" name="inLesson"&gt; &lt;option&gt;&lt;/option&gt; &lt;option disabled&gt;&lt;/option&gt; &lt;?php $sql2 = "SELECT * FROM lessons WHERE courseID='$_GET[courseID]'"; $query2 = mysql_query ($sql2); while ($row2 = mysql_fetch_assoc($query2)) { ?&gt; &lt;option&gt;&lt;?php echo $row2['title']; ?&gt;&lt;/option&gt; &lt;?php } ?&gt; &lt;/select&gt; &lt;/div&gt; &lt;div class="col-md-4"&gt; &lt;strong&gt;Quiz No.&lt;/strong&gt;&lt;br&gt; &lt;input required type="number" class="form-control" name="inQuizNo" min="1" max="100"&gt; &lt;/div&gt; &lt;div class="col-md-4"&gt; &lt;div class="pull-right"&gt; &lt;br&gt; &lt;input type="button" value="Add" id="addButton" class="btn btn-info"&gt; &lt;input type="button" value="Remove" id="removeButton" class="btn btn-warning"&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt; &lt;div id='TextBoxesGroup'&gt; &lt;div id="TextBoxDiv1" class="form-group"&gt; &lt;h2&gt;&lt;span class="label label-primary"&gt;No. 1&lt;/span&gt;&lt;/h2&gt; &lt;br&gt;&lt;br&gt; &lt;div class="col-md-10"&gt; &lt;label&gt;Question&lt;/label&gt;&lt;input type='text' id='textbox1' name='inQuestion[]' class="form-control"&gt; &lt;/div&gt; &lt;div class="col-md-2"&gt; &lt;label&gt;Answer&lt;/label&gt;&lt;input type='text' id='textbox1' name='inAnswer[]' class="form-control"&gt; &lt;br&gt; &lt;/div&gt; &lt;div class="col-md-3"&gt; &lt;label&gt;A&lt;/label&gt;&lt;input type='text' id='textbox1' name='inA[]' class="form-control"&gt; &lt;/div&gt; &lt;div class="col-md-3"&gt; &lt;label&gt;B&lt;/label&gt;&lt;input type='text' id='textbox1' name='inB[]' class="form-control"&gt; &lt;/div&gt; &lt;div class="col-md-3"&gt; &lt;label&gt;C&lt;/label&gt;&lt;input type='text' id='textbox1' name='inC[]' class="form-control"&gt; &lt;/div&gt; &lt;div class="col-md-3"&gt; &lt;label&gt;D&lt;/label&gt;&lt;input type='text' id='textbox1' name='inD[]' class="form-control"&gt; &lt;br&gt;&lt;br&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;div class="col-md-12"&gt; &lt;button type="submit" name="btnCreate" class="btn btn-success pull-right"&gt;Create Quiz &lt;/div&gt; &lt;/form&gt; &lt;/div&gt; </code></pre> <p></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser2825914
    1. USuser2825914
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POinsert multiple arrays to database
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COgive your full code including html code. so that we understand what you want
      singulars
      1. POinsert multiple arrays to database
      1. USMd. Sahadat Hossain
    2. COwhat are the values types of these arrays ? and why do you have an array with one item in it?
      singulars
      1. POinsert multiple arrays to database
      1. USOthman
    3. COwould you mind giving us more information about what are you trying to reach ?
      singulars
      1. POinsert multiple arrays to database
      1. USOthman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload