PHP : Function Reference : Oracle Functions : oci_fetch_assoc PHP Examples Tutorials References

Examples ( Source code ) » oci_fetch_assoc


<?php

// Open the database connection

if (!($db = oci_connect('GUEST', 'secret', 'SERVICE.NAME'))) {

    // Handle errors

    die('SQL ERROR: Connection failed: ' . oci_error());

}


// Switch to the appropriate schema that we want to deal with:

$sql = 'alter schema set current_schema=SCHEMANAME';


// Parse & Execute this statement:

$stmt = oci_parse($db, $sql) or die ("SQL ERROR: " . oci_error($db));

oci_execute($stmt) or die ("SQL ERROR: " . oci_error($stmt));


// Prepare a SQL insert: assume we received the description from the user

$desc = 'Mortising Machine';

$escaped = str_replace("'", "''", $desc);

$sql = "insert into TOOLS (DESC, QTY) values ('{$escaped}', 0)";


// Do the insertion, making sure to commit afterwards!

$stmt = oci_parse($db, $sql) or die ("SQL ERROR: " . oci_error($db));

oci_execute($stmt) or die ("SQL ERROR: " . oci_error($stmt));

oci_commit($db) or die ("SQL ERROR: " . oci_error($db));


// Select data from the table:

$sql = 'select ID, DESC from TOOLS order by ID asc';

$stmt = oci_parse($db, $sql) or die ("SQL ERROR: " . oci_error($db));

oci_execute($stmt) or die ("SQL ERROR: " . oci_error($stmt));


// Read all the data back in as associative arrays

while ($row = oci_fetch_assoc($stmt)) {

    echo "{$row['id']}. {$row['desc']}<br />\n";

}


// Now close the connection

oci_close($db);

?>

Code Examples / Notes » oci_fetch_assoc

24-jul-2006 02:52

keys for oci_fetch_assoc($rsc) is case-sensitive. Especially, if the query has an alias name, the alias name is automatically put to capital. For example, query: select id, sum(fee) fee from acct group by id will have keys of { 'ID', 'FEE' }

adrian dot crossley

For earlier PHP versions use ocifetchinto with OCI_ASSOC

oci_fetch_assoc

Returns the next row from the result data as an associative array (PHP 5, PECL oci8:1.1-1.2.4)
array oci_fetch_assoc ( resource statement )

Related Examples ( Source code ) » oci_fetch_assoc

Code Examples / Notes » oci_fetch_assoc

Change Language

oci_fetch_assoc

Returns the next row from the result data as an associative array (PHP 5, PECL oci8:1.1-1.2.4) array oci_fetch_assoc ( resource statement )

Related Examples ( Source code ) » oci_fetch_assoc

Code Examples / Notes » oci_fetch_assoc

Change Language

Returns the next row from the result data as an associative array (PHP 5, PECL oci8:1.1-1.2.4)
array oci_fetch_assoc ( resource statement )