Insert multiple values in database using php

Question

I am trying to insert multiple values in my database. But I could not find the Solution to do what I want.

My problem here is that I have a array of values like ("6.40","6.50","7.00","7.10","7.20","7.30") and I want to insert these values in each row like 6.40 will store in one row corresponding of id "1".

Similarly "6.50" will store in id of "2". The id will just auto increment.

Similarly it will insert values in database until array empty. If anyone has any ideas on how to solve this problem please help me out! Please bear my doubts. I am new to PHP. Thanks in advance.

 for ($i=0;$i < count($slot_timings1); $i++)
 { 
    $q = $this->link->prepare('INSERT INTO doctor_appointment (doctor_name,doctor_id,appointment_date,slot_name,slot_timings) VALUES (:doctor_name,:doctor_id,:appointment_date,:slot_name,slot_timings)');
    $q->execute(array(':doctor_name'=>$doctor_name,':doctor_id'=>$doctor_id, ':appointment_date'=>$appointment_date,':slot_name'=>$slot_name,':slot_timings'=‌>$slot_timings));
 } 
 $counts = $q->rowCount(); 
 return $counts;

Possible duplicate of [How does 'foreach' actually work?](http://stackoverflow.com/questions/10057671/how-does-foreach-actually-work) — Pathik Vejani, Mar 29 '16 at 06:01
if u do with for each or for loop ... it effects ur site performance :) use single query for multiple insertion — Maninderpreet Singh, Mar 29 '16 at 06:02
for ($i=0;$slot_timings[$i]; $i++) if this is correct or not — Kavya Shree, Mar 29 '16 at 06:07
in insert query replace `,slot_timings` with `,:slot_timings` — itzmukeshy7, Mar 29 '16 at 06:18

score 2 · Answer 1 · answered Mar 29 '16 at 06:17

Try something like this.

foreach($slot_timings1 as $data)
     { 
        $q = $this->link->prepare('INSERT INTO doctor_appointment (doctor_name,doctor_id,appointment_date,slot_name,slot_timings) VALUES (:doctor_name,:doctor_id,:appointment_date,:slot_name,slot_timings)');
        $q->execute(array(':doctor_name'=>$doctor_name,':doctor_id'=>$doctor_id, ':appointment_date'=>$appointment_date,':slot_name'=>$slot_name,':slot_timings'=‌>$data));
     }

Faiyaz Alam · Answer 2 · 2016-03-29T10:00:46.440

1

try this:

if(is_array($slot_timings1) && !empty($slot_timings1))
{
 foreach ($slot_timings1 as $slot_timing)
 { 
$q = $this->link->prepare('INSERT INTO doctor_appointment (doctor_name,doctor_id,appointment_date,slot_name,slot_timings) VALUES (:doctor_name,:doctor_id,:appointment_date,:slot_name,:slot_timings)');

 $q->execute(array(':doctor_name'=>$doctor_name,':doctor_id'=>$doctor_id, ':appointment_date'=>$appointment_date,':slot_name'=>$slot_name,':slot_timings'=>$slot_timing));
} 

return count($slot_timings1);    
}

edited Mar 29 '16 at 10:00

answered Mar 29 '16 at 06:20

Faiyaz Alam

1,191
9
27

After using this it is showing "number of bound variables does not match number of tokens" error. i dont know whts d problem – Kavya Shree Mar 29 '16 at 06:52
can you show us the output for print_r($slot_timings1); ? – Faiyaz Alam Mar 29 '16 at 07:09
Array ( [0] => 6.10 [1] => 6.30 [2] => 6.40 ) – Kavya Shree Mar 29 '16 at 07:58
Thank u so much @Er Faiyaz Alam – Kavya Shree Mar 29 '16 at 10:13
I have one more doubt is it possible to specify the position where i can insert this array of values.example insert should take place from the position of id="25" – Kavya Shree Mar 29 '16 at 11:18
@KavyaShree yes it is possible. for this you have to use on more sql field 'id' for first time inside the foreach loop. – Faiyaz Alam Mar 29 '16 at 11:32
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/107628/discussion-between-kavya-shree-and-faiyaz-alam). – Kavya Shree Mar 29 '16 at 11:37

channasmcs · Answer 3 · 2016-03-29T06:51:41.160

1

if(is_array($slot_timings1)){


 sort($slot_timings1); //Sort the elements of the array in ascending

$sql = "INSERT INTO doctor_appointment (doctor_name,doctor_id,appointment_date,slot_name,slot_timings) VALUES ";

$query_val = array();
foreach($slot_timings1 as $gettime){

    $row1 = $doctor_name;
    $row2 = $doctor_id;
    $row3 = $appointment_date;
    $row4 = $slot_name;
    $row5 = $gettime;
    $query_val[] = "('$row1', '$row2', '$row3', '$row4', '$row5')";
}

$sql .= implode(',', $query_val);

mysql_query($sql) or exit(mysql_error()); 
}

edited Mar 29 '16 at 06:51

answered Mar 29 '16 at 06:25

channasmcs

1,104
12
27

syntax error, unexpected '$valuesArr' (T_VARIABLE)..other and all okay but in case of valuesArr[] it is showing error – Kavya Shree Mar 29 '16 at 06:42
Ya i find the mistake. u forgt to mention one semicolon but what the problem is im using PHP pdo..bt the code u specified in mysqli – Kavya Shree Mar 29 '16 at 06:53

score 0 · Answer 4 · answered Mar 29 '16 at 06:08

0

Try this:

for ($i=0;$i < count($slot_timings1); $i++)
 { 
$q = $this->link->prepare('INSERT INTO doctor_appointment (doctor_name,doctor_id,appointment_date,slot_name,slot_timings) VALUES (:doctor_name,:doctor_id,:appointment_date,:slot_name,slot_timings)');
 $q->execute(array(':doctor_name'=>$doctor_name,':doctor_id'=>$doctor_id, ':appointment_date'=>$appointment_date,':slot_name'=>$slot_name,':slot_timings'=‌>$slot_timings1[$i]));
} 
$counts = $q->rowCount(); 
return $counts;

answered Mar 29 '16 at 06:08

Thejas

353
6
19

If i declare $slot_timings1[$i] it is showing error. – Kavya Shree Mar 29 '16 at 06:14
syntax error, unexpected '=', expecting ')' is the error im getting after used this – Kavya Shree Mar 29 '16 at 06:16
try @Insomania solution. Its better using foreach. I am having some trouble with debugging right now. – Thejas Mar 29 '16 at 06:22

Insert multiple values in database using php

4 Answers4