File: fetchmodes.inc

package info (click to toggle)
php4 4.0.3pl1-0potato3
  • links: PTS
  • area: main
  • in suites: potato
  • size: 15,168 kB
  • ctags: 20,556
  • sloc: ansic: 155,237; php: 10,827; sh: 9,608; yacc: 1,874; lex: 1,742; makefile: 788; java: 424; awk: 359; cpp: 335; perl: 181; xml: 57
file content (39 lines) | stat: -rw-r--r-- 1,088 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php

$dbh->setErrorHandling(PEAR_ERROR_DIE);

// testing default default
$sth = $dbh->query("SELECT * FROM phptest");
$row = $sth->fetchRow();
//var_dump($row);
print implode(" ", array_keys($row))."\n";

// testing ordered default
$dbh->setFetchMode(DB_FETCHMODE_ORDERED);
$sth = $dbh->query("SELECT * FROM phptest");
$row = $sth->fetchRow();
//var_dump($row);
print implode(" ", array_keys($row))."\n";

// testing assoc default
$dbh->setFetchMode(DB_FETCHMODE_ASSOC);
$sth = $dbh->query("SELECT * FROM phptest");
$row = $sth->fetchRow();
//var_dump($row);
print implode(" ", array_keys($row))."\n";

// testing ordered default with assoc specified
$dbh->setFetchMode(DB_FETCHMODE_ORDERED);
$sth = $dbh->query("SELECT * FROM phptest");
$row = $sth->fetchRow(DB_FETCHMODE_ASSOC);
//var_dump($row);
print implode(" ", array_keys($row))."\n";

// testing assoc default with ordered specified
$dbh->setFetchMode(DB_FETCHMODE_ASSOC);
$sth = $dbh->query("SELECT * FROM phptest");
$row = $sth->fetchRow(DB_FETCHMODE_ORDERED);
//var_dump($row);
print implode(" ", array_keys($row))."\n";

?>