· 7 years ago · Oct 05, 2018, 06:48 AM
1<!DOCTYPE html>
2<!--
3To change this license header, choose License Headers in Project Properties.
4To change this template file, choose Tools | Templates
5and open the template in the editor.
6-->
7<html>
8 <head>
9 <meta charset="UTF-8">
10 <title></title>
11 </head>
12 <body>
13 <form >
14
15
16
17
18
19
20 </form>
21 <?php
22
23
24 $server ='localhost';
25 $dbase = mysqli_connect($server, 'root','');
26
27
28 $dbase = 'DB-Iskola';
29 $sql="CREATE DATABASE $dbase"
30 ."CHARACTER SET utf8"
31 ."COLLATE utf8_hungarian_ci;";
32
33
34 $user ='root';
35 $password ='';
36 $table ='Tanulók';
37
38
39
40 if(!$sql)
41 {
42 die('Kapcsolódási hiba');
43 }
44 else
45 {
46 echo('Sikeres kapcsolódás!');
47 }
48
49 $sql2= "CREATE TABLE IF NOT EXISTS $table("
50 ."Vnev VARCHAR(20),"
51 ."Knev VARCHAR(20),"
52 ."Irsz INT(4),"
53 ."Helység VARCHAR(20),"
54 ."CÃm VARHCAR(30),"
55 ."Szülhely VARCHAR(30),"
56 ."Szülidő DATE,"
57 ."Szigszám VARCHAR(20));";
58
59 ?>
60 </body>
61</html>