Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.02 KB | None | 0 0
  1. function insert($field_names, $alias, $assignment, $table_name){
  2.     // Das funzt
  3.     global $db;
  4.  
  5.    
  6.     $array = array();
  7.     $array['table'] = $table_name;
  8.     $array['field_names'] = $field_names;
  9.     $array['alias'] = $alias;
  10.     $array['assignment'] = $assignment;
  11.  
  12.     $q = "INSERT INTO `%s` (%s) VALUES (%s)";
  13.     $q = sprintf($q, $array['table'], implode(", ",$array['field_names']), implode(", ",$array['alias']));
  14.     $q = $db->prepare($q);
  15.     $r = $q->execute($assignment);
  16.        
  17.     $id = $db->lastInsertId();
  18.       return $id;
  19.  
  20. }
  21.  
  22. function update($field_names, $alias, $assignment, $table_name){
  23.     // das nicht :-(
  24.     global $db;
  25.     $array = array();  
  26.     $array['table'] = $table_name;
  27.     $array['field_names'] = $field_names;
  28.     $array['alias'] = $alias;
  29.     $array['assignment'] = $assignment;
  30.  
  31.    
  32.     $q = "UPDATE `%s` SET (%s) = (%s)";
  33.  
  34.     $q = sprintf($q, $array['table'], implode(", ",$array['field_names']), implode(", ",$array['alias']));
  35.   $q = $db->prepare($q);
  36.   $r = $q->execute($assignment);
  37.        
  38.         return $r;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement