Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function GenericMultiple_insertData($arrayTableKeys, $paramsDeparams,$tabela){
- $connection = new SQL();
- $host = $connection->getHost();
- $dbusername = $connection->getUsername();
- $dbpassword = $connection->getPasswordinit7();
- $dbname = $connection->getDBname();
- $link = new mysqli($host, $dbusername,$dbpassword,$dbname);
- $valkeys = "";
- for($i=0;$i<count($arrayTableKeys);$i++){
- if($i != 0){
- $valkeys = $valkeys.",";
- }
- $valkeys = $valkeys.$arrayTableKeys[$i];
- }
- $query = "INSERT INTO ".$tabela."(".$valkeys.")";
- $values = "";
- for($i = 0; $i<count($paramsDeparams);$i++){
- if($i != 0){
- $values = $values.",";
- }
- $paramvalues = "";
- for($j = 0; $j<count($paramsDeparams[$i]); $j++){
- if($j != 0){
- $paramvalues = $paramvalues.",";
- }
- $paramvalues = $paramvalues."'".$paramsDeparams[$i][$j]."'";
- }
- $values = $values."
- (".$paramvalues.")";
- }
- $query = $query." VALUES".$values;
- $stmt = $link->prepare($query);
- if($stmt) {
- $stmt->execute();
- while ($stmt->fetch()) {
- }
- }
- mysqli_close( $link);
- return False;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement