How to insert array key as table column and value as column value into mysql using php?

Question

I have an array that looks like:

$frmData = array([name]=>Abhi[cell]=>050000000[email]=>[email protected][address]=>1/2 South Road)

Now I want to insert data into my mysql db from the array, and use the array key [name][cell][email][address] as table column and values as column value.

I tried several times any ways but not sure how to do it. Any help is greatly appreciated.

"I tried several times any ways" Care to show us what you have tried? — Ruddy
– Ruddy, Commented Sep 27, 2013 at 8:02

Elorfin · Accepted Answer · 2013-09-27 08:10:25Z

2

You can try this :

$columns = array_keys($frmData);
$values = array_values($frmData);

$query = "INSERT INTO your_table (" . implode(", ", $columns) . ") VALUES ('" . implode("', '", $values) . "')";

OR if you want to make make calculation on values you can loop through your array with foreach ($frmData as $column => $value)

answered Sep 27, 2013 at 8:10

Elorfin

2,4972 gold badges28 silver badges50 bronze badges

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

Comments

Shimon Rachlenko · Accepted Answer · 2013-09-27 08:11:26Z

0

It should be something like:

$cols = array();
$vals = array();
foreach($frmData as $key => $val){
    $cols[]= $key;
    $vals[]= "'" . mysqli_real_escape_string($val) . "'";
}
$query = 'insert into your_table(' .implode(',', $keys) . ') values (' . implode(',', $vals) . ')';

answered Sep 27, 2013 at 8:11

Shimon Rachlenko

5,51742 silver badges51 bronze badges

1 Comment

Virus721 Over a year ago

I was about to +1 but then i realized that this is totally injection vulnerable :P And your edit only works with strin values.

Collectives™ on Stack Overflow

How to insert array key as table column and value as column value into mysql using php?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related