Insert 2 array to mysql with PHP

Question

I have 2 form with array

 <form action="addschedule.php" method="post">
 <?php
      $n = 0;
      $c = 0;
      echo "<Select name='jam[]'>";
      do{
          if($c>10){$n="";}
          echo "<option>".$n.$c.":00</option>";
          echo "<option>".$n.$c.":30</option>";
          $c++;
         }while($c<24);
?>
<input type="text" name="nampro[]"></td>
<input type="submit" id="submit" class="btn btn-success" value="submit">
</form>
<input class="btn btn-primary" id="addrow" value="Add Row">

then it will looks like this

This is addschedule.php

<?php
include_once("connect.php");
    if(!empty($_POST['jam'])){
        foreach($_POST['jam'] as $jmt){
            echo $jmt."<br>";
            echo $_POST['nampro'];
        }
    }
?>

i want to insert that 'jam' and 'nampro' into mysql

$result=$mysqli->query('INSERT INTO SCHEDULE VALUES ('$jam','$nampro');

but how can i get 'nampro' Or anyone has a better way to do this ? Im new in PHP so can anyone help?

Where is the nampro input field in your screenshot?

mario.van.zadel
– mario.van.zadel

2015-09-22 05:46:19 +00:00
Commented Sep 22, 2015 at 5:46 — mario.van.zadel
– mario.van.zadel, Commented Sep 22, 2015 at 5:46
it's the input type text

Wingke
– Wingke

2015-09-22 05:48:34 +00:00
Commented Sep 22, 2015 at 5:48 — Wingke
– Wingke, Commented Sep 22, 2015 at 5:48
do you get 123 in echo $_POST['nampro']; ?

jitendrapurohit
– jitendrapurohit

2015-09-22 05:49:02 +00:00
Commented Sep 22, 2015 at 5:49 — jitendrapurohit
– jitendrapurohit, Commented Sep 22, 2015 at 5:49
@JitendraPurohit i believe $_POST['nampro'] is an array.

Manwal
– Manwal

2015-09-22 05:49:48 +00:00
Commented Sep 22, 2015 at 5:49 — Manwal
– Manwal, Commented Sep 22, 2015 at 5:49
no, it just return "Array"

Wingke
– Wingke

2015-09-22 05:50:29 +00:00
Commented Sep 22, 2015 at 5:50 — Wingke
– Wingke, Commented Sep 22, 2015 at 5:50

Manwal · Accepted Answer · 2015-09-22 05:53:37Z

4

As i can see both array is of same length, so you can do following:

$jam = $_POST['jam']; 
$namePro = $_POST['nampro'];

$sql = array();
foreach( $jam as $key=>$val ) {
    $sql[] = '("'.$val.'", '.$namePro[$key].')';
}
$result = $mysqli->query('INSERT INTO SCHEDULE VALUES '.implode(',', $sql));

Explanation:

$jam = ['test','google','facebook','yahoo']; 
$namePro = [123,112,110,100];

$sql = array();
foreach( $jam as $key=>$val ) {
    $sql[] = '("'.$val.'", '.$namePro[$key].')';
}
echo('INSERT INTO SCHEDULE VALUES '.implode(',', $sql));

will give you output:

INSERT INTO SCHEDULE VALUES ("test", 123),("google", 112),("facebook", 110),("yahoo", 100)

edited Sep 22, 2015 at 5:53

answered Sep 22, 2015 at 5:48

Manwal

23.9k15 gold badges65 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sandeep Nambiar · Accepted Answer · 2015-09-22 05:53:39Z

1

try this code

<?php
include_once("connect.php");
    if(!empty($_POST['jam'])){
        $namproPost     =   $_POST['nampro'];
        foreach($_POST['jam'] as $key=>$jmt){
           // echo $jmt."<br>";
            $nampro = $namproPost[$key];
            $result=$mysqli->query('INSERT INTO SCHEDULE VALUES ($jmt,$nampro)');
        }
    }
?>

answered Sep 22, 2015 at 5:53

Sandeep Nambiar

1,6764 gold badges23 silver badges40 bronze badges

1 Comment

Manwal Over a year ago

Because $nampro is an array in query you can't use it directly. You have to mention index of array for value like $nampro[0].

Collectives™ on Stack Overflow

Insert 2 array to mysql with PHP

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related