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