Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "someDbName";
- $conn = mysqli_connect($servername, $username, $password, $dbname);
- if (!$conn) {
- die("Connection failed: " . mysqli_connect_error());
- }
- $sql = "CREATE TABLE IF NOT EXISTS someTableName(
- someID INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
- someVar1 VARCHAR(30) NOT NULL,
- someVar2 INT NOT NULL);
- INSERT INTO someTableName (someVar1 , someVar2 ) VALUES ('someString1', someInteger1),
- ('someString2',someInteger2);";
- $sql = mysqli_real_escape_string($conn, $sql);
- if (mysqli_multi_query($conn, $sql)) {
- dtconsole("Tables populated successfully");
- } else {
- dtconsole("Error creating table: " . mysqli_error($conn));
- }
- function dtconsole($data){
- $output=$data;
- if(is_array($output)){
- $output=implode(',',$output);
- }
- echo '<script>console.log("'.$output.'");</script>';
- }
Add Comment
Please, Sign In to add comment