Guest User

Untitled

a guest
Mar 4th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.45 KB | None | 0 0
  1. //CONNECTING WITH MYSQLI
  2. <?php
  3. $db_host = "place_your_db_host";
  4. $db_username = "place_your_username";
  5. $db_pass = "place_your_db_password";
  6. $db_name = "place_your_db_name";
  7. $myConnection = mysqli_connect("$db_host","$db_username","$db_pass", "$db_name") or die ("could not connect to mysql");
  8. ?>
  9.  
  10. //CREATING A TABLE USING MYSQLI
  11.  
  12. <?php
  13. require_once "connect_to_mysql.php";
  14. if (mysqli_connect_errno()) {    
  15.     echo "<h2>Failure:</h2><em>" . mysqli_connect_error() . "</em>";    
  16. } else {    
  17.     $tableCreate = "CREATE TABLE members (
  18.                                          id int(11) NOT NULL auto_increment,
  19.                                          username varchar(255) NOT NULL,
  20.                                          email varchar(255) NOT NULL,
  21.                                          password varchar(255) NOT NULL,
  22.                                          website varchar(255) NULL,
  23.                                          account_type enum('a','b','c') NOT NULL default 'a',
  24.                                          PRIMARY KEY (id),
  25.                                          UNIQUE KEY email (email)
  26.                                          )
  27.    ";
  28.     $queryResult = mysqli_query($myConnection, $tableCreate);
  29.     if ($queryResult === TRUE) {
  30.         print "<br /><br />Success in TABLE creation! Happy Coding!";
  31.     } else {
  32.         print "<br /><br />No TABLE created. Check";
  33.     }
  34. }
  35. mysqli_close($myConnection);
  36. ?>
Add Comment
Please, Sign In to add comment