note 25870 deleted from ref.oracle by danbrown
| From: | danbrown@php.net | Date: | Fri, 28 Nov 2008 22:25:07 +0000 |
| Subject: | note 25870 deleted from ref.oracle by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-147332@lists.php.net to get a copy of this message | ||
Note Submitter: thebestion at gmx dot de
----
A simple function
# list query in array
#
# $conn: connection
# $query: query_string
#
# return: $templist[$row][$column]=$value;
function get_query($conn,$query){
$cursor = ora_open($conn);
ora_parse($cursor, $query) or die;
ora_exec($cursor);
$numcols = ora_numcols($cursor);
$i=0;
while(ora_fetch($cursor)){
for($column=0; $column < $numcols; $column++){
$colname = trim(ora_columnname($cursor, $column));
$data = trim(ora_getcolumn($cursor, $column));
$templist[$i][$colname]=$data;
}
$i++;
}
return $templist;
}
i.e.:
$conn = ora_plogon( "user", "passwd")or die;
$cursor = ora_open($conn);
ora_commitoff($conn);
$query = "SELECT * FROM table";
$result=get_query($conn,$query);
for($i=0;$result[$i];$i++){
echo $result[$i][column];
}