array data to mysql

Question

I need to parse the following code and process the resulting data.

foreach($job as $x=>$x_value)
  {
  echo "Key=" . $x . ", Value=" . $x_value;
  echo "<br>";
  }

The above code is returning the following as expected.

Key=vca_id, Value=20130<br>Key=uuid, Value=3c87e0b3-cfa<br>Key=originate_time, Value=2013-03-15 14:30:18<br>

What I need to do is to put the values in mysql database. So the insert statement would look something like this...

insert into test.master_table (vca_id, uuid, originate_time) values ('20130', '3c87e0b3-cfa', '2013-03-15 14:30:18')

What is the correct way to save the array values to mysql database?

this duplicate might help you: stackoverflow.com/questions/4028037/… although you should use some PDO or other database abstraction layer — Patrick Moore
– Patrick Moore, Commented Mar 18, 2013 at 6:51

Rajeev Vyas · Accepted Answer · 2013-03-18 06:53:42Z

1

<?php 
mysql_query("insert into test.master_table(vca_id, uuid, originate_time)values('".$job['vca_id']."','".$job['uuid']."','".$job['originate_time']."')");
?>

answered Mar 18, 2013 at 6:53

Rajeev Vyas

1821 silver badge7 bronze badges

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

Comments

Muhammad Raheel · Accepted Answer · 2013-03-18 07:05:44Z

1

Well i will recommend implode

$keys = array();
$values = array();
foreach($job as $x => $x_value)
{
    $keys[] =   $x;
    $values[]   =   $x_value;
}

$query  =   'INSERT INTO test.master_table' . '('.implode(',',$keys) .') VALUES (' .implode(',',$values) . ')';

answered Mar 18, 2013 at 7:05

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

Comments

alwaysLearn · Accepted Answer · 2013-03-18 07:07:12Z

1

You can try this

$temp_value_arr = array();
$query = "INSERT into test.master_table SET ";
foreach($job as $x=>$x_value)
{
   $query .= "$x = '$x_value',";
}

$query = rtrim($query, ',');
mysql_query($query);

answered Mar 18, 2013 at 7:07

alwaysLearn

6,9507 gold badges45 silver badges69 bronze badges

Collectives™ on Stack Overflow

array data to mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related