YFF1j4hP

1<?php
2
3class CreateTable extends DbConnect{
4
5    
6    public function createtable(){
7        if(isset($_POST['register'])){
8            $sql = "CREATE TABLE IF NOT EXISTS users (
9                id INT AUTO_INCREMENT PRIMARY KEY, surname VARCHAR(20) NOT NULL, 
10                firstname VARCHAR(20) NOT NULL, othername VARCHAR(20) NOT NULL, 
11                dob VARCHAR(20) NOT NULL, email VARCHAR(40) NOT NULL, 
12                password VARCHAR(40) NOT NULL, phone VARCHAR(20) NOT NULL
13            ) ";
14            $result = $this->con()->query($sql);
15                
16            if($result === TRUE){
17                echo "table created";
18            }else{
19                echo "Error creating table";
20            }
21            
22        }
23    }
24}
25
26$crt = new CreateTable;
27$crt->createtable();
28
29
30?>