iyH65rzh

1class Kanexon{
2    private $conn = null;
3
4    public function getDb(){
5            $this->conn = new PDO('sqlite:NXT_Gym.db');
6            $this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);   
7            return $this->conn;
8    }
9}
10	
11require_once '../db/Kanexon.php';
12
13class Create_Table {
14
15    private $conn = null;
16
17    public function __construct() {
18        $Data = new Kanexon();
19        $this->conn = $Data->getDb();
20    }
21
22    public function Followup() {
23        $enq = "CREATE TABLE IF NOT EXISTS FOLLOW_UP(
24         ID INTEGER PRIMARY KEY,
25     VISITOR_ID INTEGER  ,  
26     VISITOR_NAME TEXT ,  
27     LONGDATE INTEGER  ,  
28         FEED_BACK TEXT ,              
29     NEXT_CONTACT INTEGER  ,              
30     FEED_BACK_SUMMARY TEXT ,  
31     FOLLOWUP_BY TEXT,  
32         SERVER INTEGER)";
33        try {
34            $this->conn->exec($enq);
35            echo "nTable Created....";
36        } catch (PDOException $ex) {
37            echo $ex->getMessage();
38        }
39    }
40
41}
42	
43<?php
44include 'classes/Create_Tables.php';
45$Cr = new Create_Table();
46$Cr->Followup();
47?>