How to use loop in insert's values in php

Question

I would like to use a loop in insert's Values.

For example

$num = count($data);

for ($c=0; $c < $num; $c++) {
    echo $data[$c] . "<br />\n";

}
 $sql = "INSERT INTO $tbl_name VALUES (    '$data[$c]'   )";

If num is 5 then , then column will be created 5. which will be inserted 1 row with 5 columns.

or If num is 8 then , then column will be created 8. which will be inserted 1 row with 8 columns.

In VALUES, How can i use loop or

Since column number is not fixed. so How to insert column data dynamically which row will be created one(1).

Please any suggestion?

in your for loop for (...) { if($data[$c] == 5) { // insert query} }. Is this what you were looking for? — pregmatch
– pregmatch, Commented May 11, 2013 at 12:01
I think, THINK after reading the question 4-5 times that he wants dynamic fields in his query, not to run the same query multiple times. — OptimusCrime
– OptimusCrime, Commented May 11, 2013 at 12:03
Can you explain the part of the "dynamic" columns? How can the same table have different number of columns? — Tivie
– Tivie, Commented May 11, 2013 at 12:03
Tanks a lot Tivie. Every table column is fixed but table is dynamic.This script is for dynamic table — MD. ABDUL Halim
– MD. ABDUL Halim, Commented May 11, 2013 at 13:09

Yogesh Suthar · Accepted Answer · 2013-05-11 12:05:24Z

2

Try this

$sql = "INSERT INTO $tbl_name VALUES ( ";
for ($c=0; $c < $num; $c++) {
    $sql .= "'" . $data[$c] . "',";

}
$sql = substr($sql,0,-1); // removes last comma
$sql .= ")";

answered May 11, 2013 at 12:05

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

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

1 Comment

MD. ABDUL Halim Over a year ago

Thanks a lot. Can you help me to increase my reputation

sybear · Accepted Answer · 2013-05-11 12:08:14Z

0

You want this:

foreach ($data as &$piece){
  $piece = "('{$piece}')" ; //Or you can specify anything else
}

$values = implode(", ", $data) ;

$sql = "INSERT INTO $tbl_name VALUES {$values} ; ";

answered May 11, 2013 at 12:08

sybear

7,7921 gold badge25 silver badges38 bronze badges

Comments

DevZer0 · Accepted Answer · 2013-05-11 12:10:14Z

0

first of all you need to define 2 array of fields list for the two queries

$col5 = array('field1', 'field2', 'field3', 'field4', 'field5');
$col8 = array('field1', 'field2', 'field3', 'field4', 'field5', 'field6', 'field7', 'field8');

then

$num = count($data);

for ($c=0; $c < $num; $c++) {
    echo $data[$c] . "<br />\n";

}

if ($num == 5) {
    $fields = explode($col5, ",");
} else { //assume its 8 if not 5
    $fields = explode($col8, ",");
}

$sql = "INSERT INTO $tbl_name (" . $fields . ") VALUES ('" . explode($data, "','") . "')";

answered May 11, 2013 at 12:10

DevZer0

13.5k7 gold badges29 silver badges54 bronze badges

Collectives™ on Stack Overflow

How to use loop in insert's values in php

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related