Build insert query from array MySQL and PHP Build insert query from array MySQL and PHP arrays arrays

Build insert query from array MySQL and PHP


php mysql arrays key-value

Try this:

function addUser($usrData) {   $count = 0;   $fields = '';   foreach($usrData as $col => $val) {      if ($count++ != 0) $fields .= ', ';      $col = mysql_real_escape_string($col);      $val = mysql_real_escape_string($val);      $fields .= "`$col` = $val";   }   $query = "INSERT INTO `myTable` SET $fields;";}

php mysql arrays key-value

Elegant solution:

function create_insert_query($tablename, $array) {    $key = array_keys($array);    $val = array_values($array);    //sanitation needed!    $query = "INSERT INTO $tablename (" . implode(', ', $key) . ") "         . "VALUES ('" . implode("', '", $val) . "')";    return($query);}

php mysql arrays key-value

EDIT:
Oops ! forgot quotation around VALUES( ), removing the old code

$query = "INSERT INTO `mytable` ( ".          mysql_real_escape_string(implode(' , ',array_keys( $userData))).          ") VALUES ( '".          mysql_real_escape_string(implode("' , '", $userData)).          "' )";

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last