Guest User

Untitled

a guest
Oct 24th, 2018
366
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. $servername = "localhost";
  2. $username = "root";
  3. $password = "";
  4. $dbname = "someDbName";
  5. $conn = mysqli_connect($servername, $username, $password, $dbname);
  6. if (!$conn) {
  7. die("Connection failed: " . mysqli_connect_error());
  8. }
  9. $sql = "CREATE TABLE IF NOT EXISTS someTableName(
  10. someID INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  11. someVar1 VARCHAR(30) NOT NULL,
  12. someVar2 INT NOT NULL);
  13. INSERT INTO someTableName (someVar1 , someVar2 ) VALUES ('someString1', someInteger1),
  14. ('someString2',someInteger2);";
  15.  
  16. $sql = mysqli_real_escape_string($conn, $sql);
  17. if (mysqli_multi_query($conn, $sql)) {
  18. dtconsole("Tables populated successfully");
  19. } else {
  20. dtconsole("Error creating table: " . mysqli_error($conn));
  21. }
  22.  
  23. function dtconsole($data){
  24. $output=$data;
  25. if(is_array($output)){
  26. $output=implode(',',$output);
  27. }
  28. echo '<script>console.log("'.$output.'");</script>';
  29. }
Add Comment
Please, Sign In to add comment