09/KukMySQLi_01.php
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "DTD/xhtml1-strict.dtd">
2 <html>
3 <head>
4 <meta http-equiv="Author" content="Imrich BURANSKY" />
5 <meta http-equiv="Content-Type" content="text/html; charset=Windows-1250" />
6 <title>MySQLi 01</title>
7 </head>
8 <body>
9 <h3>MySQLi 01</h3>
10 <pre>
11 <?php
12
13 // Vytvoriť spojenie s MySQL serverom
14 $spoj = mysqli_connect(
15 'localhost', // host
16 'root', // pouzivatel
17 'heslo', // heslo
18 'kuk') // databaza
19 or die ("Nebolo vytvorené spojenie. Chyba: ".mysqli_connect_error());
20
21 // Vyber udajov
22 if ($vyber = mysqli_query($spoj, 'SELECT meno, telefon, email FROM kontakty')) {
23
24 // Prevzatie vysledku vyberu po riadkoch
25 while( $riadok = mysqli_fetch_assoc($vyber) ){
26 echo $riadok['meno']." ".
27 $riadok['telefon']." ".
28 $riadok['email']."\n";
29 }
30 // uvolnenie vysledku
31 mysqli_free_result($vyber);
32 }
33
34 // Zatvorenie spojenia
35 mysqli_close($spoj);
36 ?>
37
38 </pre>
39 </body>
40 </html>
41 <!-- Vysledok
42
43 Pre pokusy bolo treba:
44 - nainstalovat MySQL 4.1.7,
45 - vytvorit databazu
46 - povolit pouzitie rozsirenia ext\mysqli.exe v php.ini
47
48 Vytvorenie databazy a tabulky:
49 ------------------------------------------------------------
50
51 C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqladmin create kuk
52
53 C:\Program Files\MySQL\MySQL Server 4.1\bin>mysql -u root -p
54 Enter password: ******
55 Welcome to the MySQL monitor. Commands end with ; or \g.
56 Your MySQL connection id is 7 to server version: 4.1.7-nt
57
58 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
59
60 mysql> use kuk
61 Database changed
62 mysql> CREATE TABLE kontakty (
63 -> id_kontakt SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
64 -> meno CHAR(25) NOT NULL,
65 -> telefon CHAR(15) NOT NULL,
66 -> email CHAR(25) NOT NULL,
67 -> PRIMARY KEY (id_kontakt)
68 -> );
69 Query OK, 0 rows affected (0.52 sec)
70
71 mysql> INSERT INTO kontakty VALUES
72 -> (NULL, 'Kuko', '111111', 'kuko@kuk.sk'),
73 -> (NULL, 'Hamo', '222222', 'hamo@ham.sk'),
74 -> (NULL, 'Buro', '333333', 'buro@bur.sk');
75 Query OK, 3 rows affected (0.30 sec)
76 Records: 3 Duplicates: 0 Warnings: 0
77
78 ------------------------------------------------------------
79
80 Vlastny vysledok behu skriptu:
81
82 MySQLi
83 Kuko 111111 kuko@kuk.sk
84 Hamo 222222 hamo@ham.sk
85 Buro 333333 buro@bur.sk
86
87 -->