Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $insert = array("firstname"=>"value",
- "lastname"=> "value2");
- insertDB("user", $insert);
- function insertDB($table, $data) {
- global $dbh;
- $fields = array(); $params = array(); $boundparam = array();
- foreach($data as $field => $value) {
- $fields[] ="`".$field."`";
- $params[] = $value;
- $boundparam[] = "?";
- }
- $sql = "INSERT INTO `".$table."`".
- " (".implode(",",$fields).") VALUES (".implode(",",$boundparam).")";
- $stmt = $dbh->prepare($sql);
- return $stmt->execute($params);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement