9kceXdtb

1<?php
2/*
3*
4* File:         PDOcreateTabletcompany.php
5* By:          Jay
6* Date:       24-10-13
7*
8*  This script createsTableintoDB
9*
10*====================================
11*
12*/
13try {
14    $db = new PDO("mysql:dbname=mydb;host=localhost", "root", "" );
15} catch(PDOException $e) {
16    echo $e->getMessage();
17}
18$table= "tcompany";
19$columns = "ID INT( 11 ) AUTO_INCREMENT PRIMARY KEY, Prename VARCHAR( 50 ) NOT NULL, Name VARCHAR( 250 ) NOT NULL,
20 StreetA VARCHAR( 150 ) NOT NULL, StreetB VARCHAR( 150 ) NOT NULL, StreetC VARCHAR( 150 ) NOT NULL, 
21 County VARCHAR( 100 ) NOT NULL, Postcode VARCHAR( 50 ) NOT NULL, Country VARCHAR( 50 ) NOT NULL " ;
22
23
24$createTable = $db->exec("CREATE TABLE IF NOT EXISTS mydb.$table ($columns)");
25
26if ($createTable) 
27{
28    echo "Table $table - Created!<br /><br />";
29}
30else { echo "Table $table not successfully created! <br /><br />";
31}
32?>
33	
34$table = "tcompany";
35try {
36     $db = new PDO("mysql:dbname=mydb;host=localhost", "root", "" );
37     $db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );//Error Handling
38     $sql ="CREATE table $table(
39     ID INT( 11 ) AUTO_INCREMENT PRIMARY KEY,
40     Prename VARCHAR( 50 ) NOT NULL, 
41     Name VARCHAR( 250 ) NOT NULL,
42     StreetA VARCHAR( 150 ) NOT NULL, 
43     StreetB VARCHAR( 150 ) NOT NULL, 
44     StreetC VARCHAR( 150 ) NOT NULL, 
45     County VARCHAR( 100 ) NOT NULL,
46     Postcode VARCHAR( 50 ) NOT NULL,
47     Country VARCHAR( 50 ) NOT NULL);" ;
48     $db->exec($sql);
49     print("Created $table Table.n");
50
51} catch(PDOException $e) {
52    echo $e->getMessage();//Remove or change message in production code
53}
54	
55CREATE TABLE IF NOT EXISTS