Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
--TEST--
2 
DB_driver::locale
3 
--INI--
4 
error_reporting = 2047
5 
--SKIPIF--
6 
<?php
7 
require_once dirname(__FILE__) . '/skipif.inc';
8 
if (!function_exists('setlocale')) {
9 
    die('skip setlocale is not defined');
10 
}
11 
if (!OS_UNIX) {
12 
    die('skip not on a UNIX-like platform');
13 
}
14 
?>
15 
--FILE--
16 
<?php
17 
require_once dirname(__FILE__) . '/mktable.inc';
18 
 
19 
if ($dbh->phptype == 'odbc') {
20 
    if ($dbh->dbsyntax == 'odbc') {
21 
        $type = $dbh->phptype;
22 
    } else {
23 
        $type = $dbh->dbsyntax;
24 
    }
25 
} else {
26 
    $type = $dbh->phptype;
27 
}
28 
 
29 
switch ($type) {
30 
    case 'access':
31 
        $decimal = 'SINGLE';
32 
        break;
33 
    case 'db2':
34 
    case 'ibase':
35 
        $decimal = 'DECIMAL(3,1)';
36 
        break;
37 
    case 'ifx':
38 
        // doing this for ifx to keep certain versions happy
39 
        $decimal = 'DECIMAL(3,1)';
40 
        break;
41 
    case 'msql':
42 
        $decimal = 'REAL';
43 
        break;
44 
    case 'fbsql':
45 
    case 'oci8':
46 
        $decimal = 'DECIMAL(3,1)';
47 
        break;
48 
    default:
49 
        $decimal = 'DECIMAL(3,1)';
50 
}
51 
 
52 
$dbh->setErrorHandling(PEAR_ERROR_RETURN);
53 
drop_table($dbh, 'localetest');
54 
 
55 
$res = $dbh->query("CREATE TABLE localetest (a $decimal)");
56 
if (DB::isError($res)) {
57 
    echo 'Unable to create table: '.$res->getMessage()."\n";
58 
}
59 
 
60 
setlocale(LC_NUMERIC, 'de_DE');
61 
 
62 
$res = $dbh->query('INSERT INTO localetest (a) VALUES (?)', array(42.2));
63 
if (DB::isError($res)) {
64 
    echo 'Error inserting record: '.$res->getMessage()."\n";
65 
    var_dump($res);
66 
}
67 
 
68 
setlocale(LC_NUMERIC, 'en_AU');
69 
 
70 
$res = $dbh->query('INSERT INTO localetest (a) VALUES (?)', array(42.2));
71 
if (DB::isError($res)) {
72 
    echo 'Error inserting record: '.$res->getMessage()."\n";
73 
    var_dump($res);
74 
}
75 
 
76 
$res = $dbh->query('SELECT * FROM localetest');
77 
if (DB::isError($res)) {
78 
    echo 'Error retrieving count: '.$res->getMessage()."\n";
79 
    var_dump($res);
80 
} else {
81 
    echo 'Got '.$res->numRows()." records.\n";
82 
}
83 
 
84 
drop_table($dbh, 'localetest');
85 
 
86 
?>
87 
--EXPECT--
88 
Got 2 records.