Store php foreach loop in string

Question

We have an Array Name valArray which is something like this :

$valArray = array (
             name => 'Rahul',
             Address => 'New Delhi',
             Pass => '1234',
             class => '10th',
             School => 'DPS',
             Roll => '134567',
           )

which generates dynamicaly, So, Actually we want is to run this type of sql query,

$query = "insert into table_name set
          foreach($valArray as $key => $value) {
            $key = "$value",
          }
         ";

and Statically which should be something like this :

$query = "insert into table_name set
              name = 'Rahul',
              Address = 'New Delhi',
              Pass = '1234',
              class = '10th',
              School = 'DPS',
              Roll = '134567'
        ";

I Know this is syntactically wrong but is there any way to perform this type of action.

be uber careful if these are raw user imputed values

user557846
– user557846

2015-06-13 03:48:52 +00:00
Commented Jun 13, 2015 at 3:48 — user557846
– user557846, Commented Jun 13, 2015 at 3:48

twentylemon · Accepted Answer · 2015-06-13 03:48:09Z

2

 $sql = "insert into $table(" . implode(',', array_keys($valArray)) . " values('" . implode("','", array_values($valArray)) . "')";

the call to array_values isn't necessary, but better illustrates the idea I think

edit: quoted values; they should be escaped too

edited Jun 13, 2015 at 3:48

answered Jun 13, 2015 at 3:46

twentylemon

1,2569 silver badges12 bronze badges

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

2 Comments

user557846 Over a year ago

only thing missing is the values should be quuoted

user4173586 Over a year ago

@twentylemon What will be happen when we will use sql update command.

Collectives™ on Stack Overflow

Store php foreach loop in string

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related