K0fUNUxj

1	$con1=mysqli_connect("localhost","root","root");
2	$databaze= "CREATE DATABASE IF NOT EXISTS firma";
3  mysqli_query($con1, $databaze);
4
5
6  $con=mysqli_connect("localhost","root","root","firma");
7  	// Check connection
8	if (mysqli_connect_errno())
9 	 {
10 	 echo "Failed to connect to MySQL: " . mysqli_connect_error();
11 	 }
12
13  $test = "SELECT * FROM Uzivatele";
14  $result = mysqli_query($con, $test);
15
16if(empty($result)) {
17                $tabulka = "CREATE TABLE  `firma`.`Uzivatele` (
18                          `ID` INT NOT NULL AUTO_INCREMENT ,
19                          `Jmeno` VARCHAR( 30 ) NOT NULL ,
20                          `Prijmeni` VARCHAR( 30 ) NOT NULL ,
21                          `Email` VARCHAR( 30 ) NOT NULL ,
22                          PRIMARY KEY (  `ID` )
23                          ) ENGINE = INNODB
24                          ";
25                $vytvoreni = mysqli_query($con, $tabulka);
26                $TABULKA = 0;
27                
28                if($vytvoreni){
29             		       }
30              		else{
31                     		 }    
32}