K3e0rs0z

1<?php                   
2//session_start();
3define('DBSERVER','127.0.0.1'); // database server localhost
4define('DBUSERNAME','root');   // database username root
5
6$con = mysqli_connect(DBSERVER, DBUSERNAME, "") or die ("Cannot connect Server."); //connection string
7
8$mydatabase = mysqli_query($con, "CREATE DATABASE IF NOT EXISTS `mydbtest` ");
9$mydatabase = mysqli_query($con, " 
10                CREATE TABLE IF NOT EXISTS `mydbtest` . `tbl_info` (
11                    `id` int(11) NOT NULL AUTO_INCREMENT,
12                    `fname` varchar(10) NOT NULL,
13                    `lname` varchar(10) NOT NULL,
14                    `email` varchar(30) NOT NULL,
15                    `contact` varchar(11) NOT NULL,
16					`uname` varchar(20) NOT NULL,
17					`pwd` varchar(20) NOT NULL,
18                    PRIMARY KEY(`id`)
19                ) ENGINE = InnoDB;");
20
21
22
23if($con === false){
24    die("Cannot connect database" . mysqli_error());
25}
26else{
27    mysqli_select_db($con, "mydbtest");     //connection open
28   // echo "CONNECTION SUCCESS";
29}
30
31?>