Subversion-Projekte lars-tiefland.php_share

--TEST--

DB_driver::query

--INI--

error_reporting = 2047

--SKIPIF--

<?php

/**

 * Calls the query() method in various ways against any DBMS.

 *

 * @see      DB_common::query()

 *

 * @package  DB

 * @version  $Id: 17query.phpt 284375 2009-07-19 16:26:16Z danielc $

 * @category Database

 * @author   Daniel Convissor <danielc@analysisandsolutions.com>

 * @internal

 */

chdir(dirname(__FILE__));

require_once dirname(__FILE__) . '/skipif.inc';

?>

--FILE--

<?php

// $Id: 17query.phpt 284375 2009-07-19 16:26:16Z danielc $

/**

 * Connect to the database and make the phptest table.

 */

require_once dirname(__FILE__) . '/mktable.inc';

/**

 * Local error callback handler.

 *

 * Drops the phptest table, prints out an error message and kills the

 * process.

 *

 * @param object  $o  PEAR error object automatically passed to this method

 * @return void

 * @see PEAR::setErrorHandling()

 */

function pe($o) {

    global $dbh;

    $dbh->setErrorHandling(PEAR_ERROR_RETURN);

    drop_table($dbh, 'phptest');

    die($o->toString());

}

$dbh->setErrorHandling(PEAR_ERROR_CALLBACK, 'pe');

$dbh->setFetchMode(DB_FETCHMODE_ASSOC);

$res =& $dbh->query('DELETE FROM phptest WHERE a = 17');

print '1) delete: ' . ($res === DB_OK ? 'okay' : 'error') . "\n";

$res =& $dbh->query("INSERT INTO phptest (a, b, cc) VALUES (17, 'one', 'One')");

print '2) insert: ' . ($res === DB_OK ? 'okay' : 'error') . "\n";

$res =& $dbh->query('INSERT INTO phptest (a, b, cc) VALUES (?, ?, ?)', array(17, 'two', 'Two'));

print '3) insert: ' . ($res === DB_OK ? 'okay' : 'error') . "\n";

$res =& $dbh->query('SELECT a, b FROM phptest WHERE a = 17');

$row = $res->fetchRow();

print "4) a = {$row['a']}, b = {$row['b']}\n";

$res->free();  // keep fbsql happy.

$res =& $dbh->query('SELECT a, b FROM phptest WHERE cc = ?', array('Two'));

$row = $res->fetchRow();

print "5) a = {$row['a']}, b = {$row['b']}\n";

$array = array(

    'foo' => 11,

    'bar' => 'three',

    'baz' => null,

);

$res =& $dbh->query('INSERT INTO phptest (a, b, d) VALUES (?, ?, ?)', $array);

print '6) insert: ' . ($res === DB_OK ? 'okay' : 'error') . "\n";

$res =& $dbh->query('SELECT a, b, d FROM phptest WHERE a = ?', 11);

$row = $res->fetchRow();

print "7) a = {$row['a']}, b = {$row['b']}, d = ";

if ($dbh->phptype == 'msql') {

    if (array_key_exists('d', $row)) {

        $type = gettype($row['d']);

        if ($type == 'NULL' || $row['d'] == '') {

            print "got expected value\n";

        } else {

            print "ERR: expected d's type to be NULL but it's $type and the value is ";

            print $row['d'] . "\n";

        }

    } else {

        // http://bugs.php.net/?id=31960

        print "Prior to PHP 4.3.11 or 5.0.4, PHP's msql extension silently"

              . " dropped columns with null values. You need to upgrade.\n";

    }

} else {

    $type = gettype($row['d']);

    if ($type == 'NULL' || $row['d'] == '') {

        print "got expected value\n";

    } else {

        print "ERR: expected d's type to be NULL but it's $type and the value is ";

        print $row['d'] . "\n";

    }

}

$res =& $dbh->query('DELETE FROM phptest WHERE a = ?', array(17));

print '8) delete: ' . ($res === DB_OK ? 'okay' : 'error') . "\n";

$res =& $dbh->query('DELETE FROM phptest WHERE a = ?', array(0));

print '9) delete with array(0) as param: ' . ($res === DB_OK ? 'okay' : 'error') . "\n";

$res =& $dbh->query('DELETE FROM phptest WHERE a = ?', 0);

print '10) delete with 0 as param: ' . ($res === DB_OK ? 'okay' : 'error') . "\n";

$dbh->nextQueryIsManip(true);

$res =& $dbh->query('SELECT * FROM phptest');

print '11) query is manip (with override): ' . ($dbh->_last_query_manip ? 'true' : 'false') . "\n";

$dbh->nextQueryIsManip(false);

$res =& $dbh->query('SELECT * FROM phptest');

print '12) query is manip (without override): ' . ($dbh->_last_query_manip ? 'true' : 'false') . "\n";

// This one's here for bug #11716.

if ($dbh->phptype == 'msql' || $dbh->phptype == 'ibase' || $dbh->phptype == 'oci8') {

    // Some databases don't support quoted identifiers. They are full of lose.

    $res =& $dbh->query('SELECT a FROM phptest');

} else {

    $res =& $dbh->query('SELECT '.$dbh->quoteIdentifier('a').' FROM phptest');

}

print '13) select with quoteIdentifier: ';

$row = $res->fetchRow(DB_FETCHMODE_ASSOC);

if (isset($row['a'])) {

    if ($row['a'] == 42) {

        print "okay\n";

    } else {

        print "field value incorrect\n";

    }

} else {

    print "expected field not in row\n";

}

$dbh->setErrorHandling(PEAR_ERROR_RETURN);

drop_table($dbh, 'phptest');

?>

--EXPECT--

1) delete: okay

2) insert: okay

3) insert: okay

4) a = 17, b = one

5) a = 17, b = two

6) insert: okay

7) a = 11, b = three, d = got expected value

8) delete: okay

9) delete with array(0) as param: okay

10) delete with 0 as param: okay

11) query is manip (with override): true

12) query is manip (without override): false

13) select with quoteIdentifier: okay