ocirowcount

add a note User Contributed Notes

sontung2603 at yahoo dot com
17-Feb-2006 06: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
27-Aug-2000 09: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
17-Feb-2000 12: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

ocirowcount

说明