Advanced Search

PHP: Insert Data Into MySQL Table Using An Array [mysql] [php] [array] [INSERT]

/ Published in: PHP
Save to your folder(s)
Inserts the values of an array into a table. Also supports specifying if a specific field needs to be encoded using PASSWORD()
Parameters:
Table: Name of table to insert into
Data: array of $field->$value of new data
Password Field: Which field in the data array needs to be surrounded with PASSWORD() (optional)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. function mysql_insert_array($table, $data, $password_field = "") {
  2. 	foreach ($data as $field=>$value) {
  3. 		$fields[] = '`' . $field . '`';
  4.  
  5. 		if ($field == $password_field) {
  6. 			$values[] = "PASSWORD('" . mysql_real_escape_string($value) . "')";
  7. 		} else {
  8. 			$values[] = "'" . mysql_real_escape_string($value) . "'";
  9. 		}
  10. 	}
  11. 	$field_list = join(',', $fields);
  12. 	$value_list = join(', ', $values);
  13.  
  14. 	$query = "INSERT INTO `" . $table . "` (" . $field_list . ") VALUES (" . $value_list . ")";
  15.  
  16. 	return $query;
  17. }

URL: http://snippets.dzone.com/posts/show/4350

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.