Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //CONNECTING WITH MYSQLI
- <?php
- $db_host = "place_your_db_host";
- $db_username = "place_your_username";
- $db_pass = "place_your_db_password";
- $db_name = "place_your_db_name";
- $myConnection = mysqli_connect("$db_host","$db_username","$db_pass", "$db_name") or die ("could not connect to mysql");
- ?>
- //CREATING A TABLE USING MYSQLI
- <?php
- require_once "connect_to_mysql.php";
- if (mysqli_connect_errno()) {
- echo "<h2>Failure:</h2><em>" . mysqli_connect_error() . "</em>";
- } else {
- $tableCreate = "CREATE TABLE members (
- id int(11) NOT NULL auto_increment,
- username varchar(255) NOT NULL,
- email varchar(255) NOT NULL,
- password varchar(255) NOT NULL,
- website varchar(255) NULL,
- account_type enum('a','b','c') NOT NULL default 'a',
- PRIMARY KEY (id),
- UNIQUE KEY email (email)
- )
- ";
- $queryResult = mysqli_query($myConnection, $tableCreate);
- if ($queryResult === TRUE) {
- print "<br /><br />Success in TABLE creation! Happy Coding!";
- } else {
- print "<br /><br />No TABLE created. Check";
- }
- }
- mysqli_close($myConnection);
- ?>
Add Comment
Please, Sign In to add comment