DNrgJnYD

1try {
2    $DBH = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
3}
4catch(PDOException $e) {  
5    echo "Select DB Error: " .$e->getMessage(). "</br>";
6}
7	
8$DBH = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass, array(PDO::ATTR_PERSISTENT => true));
9	
10<?php
11
12include 'config.php';
13
14if(isset($_POST['submit']))
15{
16//Get Current User Login
17global $current_user;
18$current_user = wp_get_current_user();
19$ulog = $current_user->user_login;
20$tablename_cc = "cc_".$ulog;
21$tablename_db = "db_".$ulog;
22$tablename_misc = "misc_".$ulog;
23$tablename_cash = "cash_".$ulog;
24
25try {
26    $DBH->exec("CREATE TABLE IF NOT EXISTS " .$tablename_cc. " (ID bigint(100) NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), accnt TEXT(20), cc_num TEXT(4), cc_amnt DECIMAL(8,2), cc_app TEXT(20), cc_date VARCHAR(10), cc_time VARCHAR(10))");            
27    $DBH->exec("CREATE TABLE IF NOT EXISTS " .$tablename_db. " (ID bigint(100) NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), accnt TEXT(20), db_num TEXT(20), db_amnt DECIMAL(8,2), db_date VARCHAR(10), db_time VARCHAR(10))");        
28    $DBH->exec("CREATE TABLE IF NOT EXISTS " .$tablename_misc. " (ID bigint(100) NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), accnt TEXT(20), misc_item TEXT(1000), misc_amnt DECIMAL(8,2), misc_date VARCHAR(10), misc_time VARCHAR(10))");       
29    $DBH->exec("CREATE TABLE IF NOT EXISTS " .$tablename_cash. " (ID bigint(100) NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), accnt TEXT(20), cash_amnt DECIMAL(8,2), cash_time VARCHAR(10))");
30}
31catch(PDOException $e) {  
32    echo "Create Tables Error: " .$e->getMessage();
33}
34} ?>
35	
36SHOW PROCESSLIST