Advertisement
Guest User

Untitled

a guest
Feb 12th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. public function GenericMultiple_insertData($arrayTableKeys, $paramsDeparams,$tabela){
  2.  
  3. $connection = new SQL();
  4.  
  5. $host = $connection->getHost();
  6. $dbusername = $connection->getUsername();
  7. $dbpassword = $connection->getPasswordinit7();
  8. $dbname = $connection->getDBname();
  9.  
  10. $link = new mysqli($host, $dbusername,$dbpassword,$dbname);
  11.  
  12.  
  13. $valkeys = "";
  14. for($i=0;$i<count($arrayTableKeys);$i++){
  15. if($i != 0){
  16. $valkeys = $valkeys.",";
  17. }
  18.  
  19. $valkeys = $valkeys.$arrayTableKeys[$i];
  20.  
  21.  
  22. }
  23.  
  24.  
  25.  
  26. $query = "INSERT INTO ".$tabela."(".$valkeys.")";
  27. $values = "";
  28. for($i = 0; $i<count($paramsDeparams);$i++){
  29. if($i != 0){
  30. $values = $values.",";
  31. }
  32.  
  33.  
  34. $paramvalues = "";
  35. for($j = 0; $j<count($paramsDeparams[$i]); $j++){
  36.  
  37. if($j != 0){
  38. $paramvalues = $paramvalues.",";
  39. }
  40. $paramvalues = $paramvalues."'".$paramsDeparams[$i][$j]."'";
  41.  
  42. }
  43. $values = $values."
  44. (".$paramvalues.")";
  45.  
  46.  
  47. }
  48. $query = $query." VALUES".$values;
  49.  
  50.  
  51. $stmt = $link->prepare($query);
  52. if($stmt) {
  53. $stmt->execute();
  54. while ($stmt->fetch()) {
  55. }
  56.  
  57. }
  58.  
  59.  
  60.  
  61. mysqli_close( $link);
  62. return False;
  63.  
  64.  
  65.  
  66. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement