8mJ5QbVe

1<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
2
3<form action="" method="post">
4		<input type="text" name="nazev" value="Jméno DB"/> 
5        <input type="submit" name="submit" value="Vytvořit DB"/>
6</form>
7
8<?php
9        $host = 'localhost';
10        $user = 'root';
11        $heslo = ''; 
12
13        $connect = mysql_connect($host, $user, $heslo)
14                or die("Nepodařilo se připojit do databáze");        
15        $mysql_kodovani = mysql_set_charset('utf8');
16?>
17 
18<?php
19        if(isset($_POST['submit']))
20        {
21			$filename = "NazevDB.txt";
22			unlink($filename);	
23					 
24			if (file_exists("NazevDB.txt")) 
25				{ 
26					$soubor=fopen("NazevDB.txt", "r+"); 
27				} 
28				else 
29				{ 
30					$soubor=fopen("NazevDB.txt", "w"); 
31				} 
32				rewind($soubor); 
33				fwrite($soubor,$_POST['nazev'],30); 
34				$databaze = $_POST['nazev'];				
35
36				fclose($soubor); 
37
38			$sql = "CREATE DATABASE IF NOT EXISTS ".$databaze;
39			$query = mysql_query($sql);
40			$database = mysql_select_db($databaze, $connect)
41                or die("Nepodařilo se zvolit databázi");
42			$sql = "CREATE TABLE IF NOT EXISTS `casy_nedele` (`startovni_cislo` int(11) NOT NULL, `cas_00` time NOT NULL, `cas_01` time NOT NULL);";
43			$query = mysql_query($sql);
44			$sql =  "CREATE TABLE IF NOT EXISTS `casy_sobota` (`startovni_cislo` int(11) NOT NULL,`cas_00` time NOT NULL,`cas_01` time NOT NULL);";
45			$query = mysql_query($sql);
46			$sql = "CREATE TABLE IF NOT EXISTS `startovacilistina` (`startovni_cislo` int(11) NOT NULL,`sobota` tinyint(1) NOT NULL DEFAULT '0',`nedele` tinyint(1) NOT NULL DEFAULT '0');";
47			$query = mysql_query($sql);
48			$sql = "CREATE TABLE IF NOT EXISTS `zavod` (`nazev_zavodu` char(255) NOT NULL,`datum` date NOT NULL,`poznamky` char(255) NOT NULL)";
49			$query = mysql_query($sql);
50        }         		
51?>