How to save data from array (PHP) to MySQL table? (using MySQLi)

Question

Here is generated array:

$data = array();
  for($i = 0; $i < 100; $i++){
      $data[] = array(
      'name'        => md5(rand()),
      'active'        => rand(0, 1)?'active':'banned',
      'create_date'    => rand(0, 1)?'now':'2014/12/31 14:51:52',
      'income'        => base64_encode(rand(-9999, 9999)),
      );
  }

And my try to save this data to database:

$columns = implode(", ",array_keys($data));
$escaped_values = array_map('mysql_real_escape_string', array_values($data));
$values  = implode(", ", $escaped_values);
$sql = "INSERT INTO `data`($columns) VALUES ($values)";

But unfortunately it doesn't work, showing this warning: "MYSQL_REAL_ESCAPE_STRING() EXPECTS PARAMETER 1 TO BE STRING, ARRAY GIVEN IN..."

How to solve this?

Daniel · Accepted Answer · 2015-07-04 18:05:19Z

1

You should write it something like that:

'name'        => mysql_real_escape_string(md5(rand())),

and delele:

$escaped_values = array_map('mysql_real_escape_string', array_values($data));

answered Jul 4, 2015 at 18:05

Daniel

3404 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

How to save data from array (PHP) to MySQL table? (using MySQLi)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related