48hsWnF3

1<?php
2$servername = "localhost";
3$username = "root";
4$password = "";
5 
6// Create connection
7$conn = new mysqli($servername, $username, $password);
8// Check connection
9if ($conn->connect_error) {
10    die("Connection failed: " . $conn->connect_error);
11}
12 
13// Create database
14$sql = "CREATE DATABASE IF NOT EXISTS `loja` CHARSET = UTF8 COLLATE = utf8_general_ci;";
15 
16if ($conn->query($sql) === TRUE) {
17    echo 'Database criada.';
18} else {
19    echo "Error creating database: " . $conn->error;
20}
21 
22$db_selected = mysqli_select_db($conn, "loja");
23if (!$db_selected)
24    {
25    die ('Can\'t use database : ' . mysqli_error());
26}
27else
28{
29    $sql2 = "CREATE TABLE IF NOT EXISTS `tb_custumer` (
30                               `id` INT(11) NOT NULL AUTO_INCREMENT,
31                               `idext` VARCHAR(20) NULL DEFAULT NULL,
32                               `custumer` VARCHAR(50) NOT NULL,
33                               `cpf` VARCHAR(11) NULL DEFAULT NULL,
34                               `birthdate` DATE NULL DEFAULT NULL,
35                               `voter` VARCHAR(20) NULL DEFAULT NULL,
36                               `cellphone` VARCHAR(15) NULL DEFAULT NULL,
37                               `postalcode` VARCHAR(8) NULL DEFAULT NULL,
38                               `address` VARCHAR(50) NULL DEFAULT NULL,
39                               `district` VARCHAR(50) NULL DEFAULT NULL,
40                               `city` VARCHAR(50) NULL DEFAULT NULL,
41                               `state` VARCHAR(50) NULL DEFAULT NULL,
42                               PRIMARY KEY (`id`)
43)
44
45COLLATE='utf8_general_ci'
46    ENGINE=InnoDB
47    AUTO_INCREMENT=118";
48   
49    $conn->query($sql2);
50    echo '<br> Tabelas criadas';
51}
52 
53 
54 
55 
56 
57 
58$conn->close();
59?>