PHP: ocirowcount - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

ocisavelob ocirollback

Last updated: Fri, 26 Jan 2007

view this page in

# ocirowcount

(PHP 3 >= 3.0.7, PHP 4, PHP 5)

ocirowcount -- Alias of oci_num_rows()

## Описание

This function is an alias of: oci_num_rows().

add a note User Contributed Notes
ocirowcount
sontung2603 at yahoo dot com
17-Feb-2006 02:35
`hello,
here'is an example who works:
$connexion = ("name_bd","pass_db"); //set up connexion on database
$query="select * from order "; // query for the test
$parse = ociparse($connexion,$query); // parse query
ociexecute($pase); // execute the query on server (on temporary memory)
ocifetchstatement($pase,$tab_result); // the result will be fetched in the table $tab_result
echo ocirowcount($parse); // show the numbers of result
/**** and if you want to posting the results of query ***/
$count = count($tab_result);
for($i=0;$i<=$count;$i++)
{
echo $tab_result[$i]."<br>";
}
you can also do it with the function ociresult():
while(ocifetch($parse))
{
echo ociresult($parse,"[capital letter of the name of feild that you want to show on naviator]");
}
Attention : all of name of tables on oracle database are in capital letter when you use an other application for connect to it.
example :
to select the field no_client on table client, on your script of posting, you should write :
echo ociresult($parse,"NO_CLIENT");
not :
echo ociresult($parse,"no_client");
//end
Enjoy`
justin at flakmag dot com
26-Aug-2000 06:59
`It appears the easiest workaround if you want to get numrows without moving to the end of the result set is to use:
numrows = OCIFetchStatement(...);
OCIExecute(...);
So that the execute re-executes the query. It's horribly inefficient to query twice, but it works.`
batti at digito dot com
16-Feb-2000 08:52
`this function can be used with select statement, and also return affected number of rows.
But remember this, use this after fetch statement.`
add a note
ocisavelob ocirollback

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST