Insert array into MySQL database with PHP

by

You can not insert an array directly to MySQL as MySQL doesn’t understand PHP data types. MySQL only understands SQL. So to insert an array into a MySQL database you have to convert it to a SQL statement. This can be done manually or by a library. The output should be an INSERT statement.

Update for PHP7

Since PHP 5.5 mysql_real_escape_string has been deprecated and as of PHP7 it has been removed. See: php.net’s documentation on the new procedure.

Original answer:

Here is a standard MySQL insert statement.

INSERT INTO TABLE1(COLUMN1, COLUMN2, ....) VALUES (VALUE1, VALUE2..)

If you have a table with name fbdata with the columns which are presented in the keys of your array you can insert with this small snippet. Here is how your array is converted to this statement.

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

More Related Contents:

  1. Sign in form always showing "Wrong Credentials"
  2. Prevent creating duplicate entries in PHP
  3. i have stored array in database as a string how can retrieve that array?
  4. Sum values of multidimensional array by key without loop
  5. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  6. Save PHP array to MySQL?
  7. Notice: Array to string conversion in
  8. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  9. How get all values in a column using PHP?
  10. mysql select query within a serialized array
  11. PDO fetch one column from table into 1-dimensional array
  12. Get all mysql selected rows into an array
  13. Select from mysql table WHERE field=’$array’?
  14. MySQL query using an array [duplicate]
  15. How to insert json array into mysql database
  16. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  17. PHP/SQL Insert Error when using Named Placeholders
  18. Create PHP array from MySQL column
  19. Save array in mysql database
  20. MySQL PHP – SELECT WHERE id = array()? [duplicate]
  21. inserting information and image in php and mysql
  22. Project Links do not work on Wamp Server
  23. Get first key in a (possibly) associative array?
  24. Why doesn’t MySQL support millisecond / microsecond precision?
  25. Real escape string and PDO [duplicate]
  26. Run a mySQL query as a cron job?
  27. Looping a multidimensional array in php
  28. Can I create a database using PDO in PHP?
  29. Connect to remote MySQL server with SSL from PHP
  30. PDO and MySQL ‘between’

Leave a Comment