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;

in insert query replace ,slot_timings with ,:slot_timings — itzmukeshy7
– itzmukeshy7, Commented Mar 29, 2016 at 6:18

Amrinder Singh · Accepted Answer · 2016-03-29 06:17:27Z

2

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));
     }

answered Mar 29, 2016 at 6:17

Amrinder Singh

5,62213 gold badges50 silver badges95 bronze badges

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

Comments

channasmcs · Accepted Answer · 2016-03-29 06:51:41Z

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, 2016 at 6:51

answered Mar 29, 2016 at 6:25

channasmcs

1,15612 silver badges28 bronze badges

2 Comments

Kavya Shree Over a year ago

syntax error, unexpected '$valuesArr' (T_VARIABLE)..other and all okay but in case of valuesArr[] it is showing error

Kavya Shree Over a year ago

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

Faiyaz Alam · Accepted Answer · 2016-03-29 10:00:46Z

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, 2016 at 10:00

answered Mar 29, 2016 at 6:20

Faiyaz Alam

1,22710 silver badges27 bronze badges

7 Comments

Kavya Shree Over a year ago

After using this it is showing "number of bound variables does not match number of tokens" error. i dont know whts d problem

Faiyaz Alam Over a year ago

can you show us the output for print_r($slot_timings1); ?

Kavya Shree Over a year ago

Array ( [0] => 6.10 [1] => 6.30 [2] => 6.40 )

Kavya Shree Over a year ago

Thank u so much @Er Faiyaz Alam

Kavya Shree Over a year ago

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"

|

Thejas · Accepted Answer · 2016-03-29 06:08:07Z

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, 2016 at 6:08

Thejas

3536 silver badges19 bronze badges

3 Comments

Kavya Shree Over a year ago

If i declare $slot_timings1[$i] it is showing error.

Kavya Shree Over a year ago

syntax error, unexpected '=', expecting ')' is the error im getting after used this

Thejas Over a year ago

try @Insomania solution. Its better using foreach. I am having some trouble with debugging right now.

Collectives™ on Stack Overflow

Insert multiple values in database using php

4 Answers 4

Comments

2 Comments

7 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

7 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related