fork download
copy 
  1. <?php
  2. error_reporting(-1);
  3.  
  4. class Database {
  5.  
  6. 	private $user = 'root';
  7. 	private $pass = '';
  8. 	private $dbName = 'test_data';
  9.  
  10. 	public function __construct() {
  11. 		$this->db = new PDO('mysql:host=localhost;dbname=' . $this->dbName, $this->user, $this->pass);
  12. 	}
  13.  
  14. 	function insertBatch($table, $data) {
  15.  
  16. 		$tableColNamesArray = array();
  17. 		$tableColParamsArray = array();
  18. 		$tableColValuesArray = array();
  19.  
  20.  
  21. 		foreach ($data as $num => $dataRow) {
  22.  
  23. 			$oneRowValuesArray = array();
  24.  
  25. 			foreach ($dataRow as $tableColName => $value) {
  26. 				if ($num == 1) {
  27. 					$tableColNamesArray[] = $tableColName;
  28. 					$tableColParamsArray[] = '?';
  29.  				}
  30. 				$oneRowValuesArray[] = $value;
  31.  
  32. 			}
  33. 			$tableColValuesArray[] = $oneRowValuesArray;
  34. 		}
  35.  
  36. 		$query = 'INSERT INTO '. $table .' (' . implode(', ', $tableColNamesArray) . ') VALUES (' . implode(', ', $tableColParamsArray) . ')';
  37.  
  38. 		// var_dump($tableColValuesArray);
  39. 		// exit;
  40.  
  41. 		$this->db->beginTransaction();
  42. 		$stmt = $this->db->prepare($query);
  43.  
  44. 		foreach($tableColValuesArray as $insertRow) {
  45. 			//var_dump($insertRow);
  46.  
  47. 			$stmt->execute($insertRow);
  48. 		}
  49. 		$this->db->commit();
  50. 		print_r($this->db->errorInfo()); 
  51. 	}
  52.  
  53. }
Success #stdin #stdout 0s 82560KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/pG9yPF
language:
PHP (php 7.3.5)
created:
5 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!