Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. Public Function Insert_Advance_Data ( $Type, $Data ) {
  2.  
  3. $sql = "INSERT INTO ";
  4.  
  5. switch ( $Type ) {
  6.  
  7. case 'appartement':
  8. $this -> Id_Type_Prop = 1;
  9. $sql .= sprintf ( "`appartements` (`%s`) VALUES ('%s');", implode ( "`, `", array_keys ( $Data ) ), implode ( "', '", $Data ) );
  10. break;
  11.  
  12. case 'bureau_local':
  13. $this -> Id_Type_Prop = 2;
  14. $sql .= sprintf ( "`bureaux_locals` (`%s`) VALUES ('%s');", implode ( "`, `", array_keys ( $Data ) ), implode ( "', '", $Data ) );
  15. break;
  16.  
  17. case 'immeuble':
  18. $this -> Id_Type_Prop = 3;
  19. $sql .= sprintf ( "`immeubles` (`%s`) VALUES ('%s');", implode ( "`, `", array_keys ( $Data ) ), implode ( "', '", $Data ) );
  20. break;
  21.  
  22. case 'maison':
  23. $this -> Id_Type_Prop = 4;
  24. $sql .= sprintf ( "`maisons` (`%s`) VALUES ('%s');", implode ( "`, `", array_keys ( $Data ) ), implode ( "', '", $Data ) );
  25. break;
  26.  
  27. case 'terrain':
  28. $this -> Id_Type_Prop = 5;
  29. $sql .= sprintf ( "`terrains` (`%s`) VALUES ('%s');", implode ( "`, `", array_keys ( $Data ) ), implode ( "', '", $Data ) );
  30. break;
  31.  
  32. default:
  33. Return FALSE;
  34. }
  35.  
  36. $a = new DB();
  37. $a -> query( $sql );
  38.  
  39. $this -> Id_Advance = ( $a -> insert_id ( ) );
  40.  
  41. $a -> close();
  42.  
  43. Return TRUE;
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement