Advertisement
c00lways

PHP PDO insert example

Apr 30th, 2013
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.50 KB | None | 0 0
  1. $insert = array("firstname"=>"value",
  2.     "lastname"=> "value2");
  3.  
  4. insertDB("user", $insert);
  5. function insertDB($table, $data) {
  6.     global $dbh;
  7.     $fields = array(); $params = array(); $boundparam = array();
  8.     foreach($data as $field => $value) {
  9.         $fields[] ="`".$field."`";
  10.         $params[] = $value;
  11.         $boundparam[] = "?";
  12.     }
  13.    
  14.     $sql = "INSERT INTO `".$table."`".
  15.         " (".implode(",",$fields).") VALUES (".implode(",",$boundparam).")";
  16.    
  17.     $stmt = $dbh->prepare($sql);
  18.     return $stmt->execute($params);
  19. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement