Advertisement
Guest User

Miro Balearski : PDO Insert wrapper

a guest
Feb 22nd, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.82 KB | None | 0 0
  1. something like that
  2.  
  3.     function insert_data($con, $tablename, $params){
  4.    
  5.         try{
  6.             foreach($params as $key=>$value){
  7.                
  8.                 $keys[]="`$key`";
  9.                 $values[]=":$key"; 
  10.             }  
  11.            
  12.             $keys_string= implode(', ', $keys);
  13.             $values_string= implode(', ', $values);
  14.            
  15.             $qry= "insert into $tablename($keys_string) values ($values_string)";
  16.        
  17.             $stmt=$con->prepare($qry);
  18.            
  19.             foreach($params as $key=>$value){
  20.                
  21.                 $stmt->bindparam(":$key", $value);
  22.             }
  23.            
  24.             $stmt->execute();
  25.            
  26.             return $con->lastInsertId();
  27.        
  28.         }catch Exception($e){
  29.             echo $e->getMessage();
  30.             throw($e);
  31.         }  
  32.     }
  33.    
  34.     $tablename='clientz';
  35.    
  36.     $params['name']='Miro';
  37.     $params['addrezz']='NY NY';
  38.     $params['mail']='miro@example.com';
  39.     $params['registered']=date("Y-m-d H:i:s");
  40.    
  41.     insert_data($con, $tablename, $params);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement