08/KukSQLite_06.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>KukSQLite_06</title>
7 </head>
8 <body>
9 <h3>Práca s výsledkom dopytu - fetch</h3>
10 <pre>
11 <?php
12 $db = new SQLiteDatabase ("kuk.sqlite");
13 $dopyt = $db->query( 'SELECT * FROM cisla ORDER BY meno' );
14
15 echo "\n<h3>SQLITE_NUM</h3>";
16 $riadok = $dopyt->fetch(SQLITE_NUM);
17 print_r($riadok);
18 echo $riadok[1]."\n";
19
20 echo "\n<h3>SQLITE_ASSOC</h3>";
21 $riadok = $dopyt->fetch(SQLITE_ASSOC);
22 print_r($riadok);
23 echo $riadok['meno']."\n";
24
25 echo "\n<h3>SQLITE_BOTH </h3>";
26 $riadok = $dopyt->fetch();
27 print_r($riadok);
28 echo $riadok[1]."\n";
29 echo $riadok['meno']."\n";
30
31 ?>
32 </pre>
33 </body>
34 </html>
35
36 <!-- Vysledok
37
38 Práca s výsledkom dopytu - fetch
39
40 SQLITE_NUMArray
41 (
42 [0] => 3
43 [1] => Buro Smutný
44 [2] => +421907890123
45 )
46 Buro Smutný
47
48 SQLITE_ASSOCArray
49 (
50 [id] => 2
51 [meno] => Hamo Veselý
52 [telefon] => +421903654321
53 )
54 Hamo Veselý
55
56 SQLITE_BOTH Array
57 (
58 [0] => 1
59 [id] => 1
60 [1] => Kuko Krátky
61 [meno] => Kuko Krátky
62 [2] => +421905123456
63 [telefon] => +421905123456
64 )
65 Kuko Krátky
66 Kuko Krátky
67
68 -->