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