BLWqRwCJ

1
2
3<?php
4$connect = mysqli_connect("localhost", "root", "");
5
6if ($connect) {
7echo "<br/> Connected to server";
8}else{
9die("<br />Connection error ". mysqli_connect_error());
10}
11
12$selectdb = mysqli_select_db($connect, "insertdeleteedit");
13if ($selectdb) {
14echo "<br />Existing Database Selected";
15} else {
16	$sqlcreatedb = "CREATE DATABASE IF NOT EXISTS `insertdeleteedit`";
17	if (mysqli_query($connect, $sqlcreatedb)) {
18	 echo "<br />New database created";
19	 $selectdb2 = mysqli_select_db($connect, "insertdeleteedit");
20	 if ($selectdb2) {
21	 	echo "<br />Created database selected";
22	 		 $sqlcreatetable = "
23CREATE TABLE IF NOT EXISTS `insertdeleteedittable` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `firstname` varchar(100) NOT NULL,
26  `lastname` varchar(100) NOT NULL,
27  `email` varchar(100) NOT NULL,
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30	 ";
31	 if (mysqli_query($connect,$sqlcreatetable)) {
32	 echo "<br />New table created";
33	 } else {
34	 	echo "<br />No table created";
35	 }
36	 }
37	 
38	} else {
39		echo "<br />No database created";
40	}	
41}
42
43?>