Zckgns7B

1$connect_stock = new PDO('mysql:host=localhost;dbname=daily_inventory', 'user', 'password');
2
3$table_name = 'stock_'.date('dmY');
4$query = "CREATE TABLE IF NOT EXISTS '$table_name' (
5          `id` int(11) NOT NULL AUTO_INCREMENT,
6          `item` varchar(250) DEFAULT NULL,
7          `brand` varchar(250) DEFAULT NULL,
8          `gender` varchar(250) DEFAULT NULL,
9          `size` varchar(250) DEFAULT NULL,
10          `sleeve` varchar(250) DEFAULT NULL,
11          `fabric` varchar(250) DEFAULT NULL,
12          `style` varchar(250) DEFAULT NULL,
13          `wholesaler` varchar(250) DEFAULT NULL,
14          `extra_features` varchar(250) DEFAULT NULL,
15          `date_time` datetime DEFAULT CURRENT_TIMESTAMP,
16          `cost_price` decimal(10,2) DEFAULT NULL,
17          `quantity` int(11) DEFAULT NULL,
18          `product_code` varchar(250) DEFAULT NULL COMMENT 'product_code will be set to Not Null',
19          PRIMARY KEY (`id`)
20         )";
21
22try {
23     $connect_stock->exec($query);
24     echo "Created $table_name Table.n";
25   } catch(PDOException $e){
26            echo $e->getMessage();
27}