· 5 years ago · Mar 05, 2020, 12:32 PM
1<?php
2$db = new mysqli("localhost", "root", "") or die("xd");
3$dbcr = "CREATE DATABASE IF NOT EXISTS rozruba";
4if($db->query($dbcr)){}else{$db->error;}
5mysqli_select_db($db, "rozruba");
6$create = "CREATE TABLE IF NOT EXISTS dane(
7ID INT PRIMARY KEY AUTO_INCREMENT,
8IMIE VARCHAR(30) NOT NULL,
9NAZWISKO VARCHAR(30) NOT NULL,
10MIASTO VARCHAR(30) NOT NULL,
11PESEL CHAR(11) NOT NULL,
12ULICA VARCHAR(30) NOT NULL,
13DATA_UR DATE NOT NULL
14)";
15if($db->query($create)){}else{echo $db->error;}
16
17
18?>