note 62012 added to function.ocirowcount

From: Date: Fri, 17 Feb 2006 10:35:05 +0000
Subject: note 62012 added to function.ocirowcount
Groups: php.notes 
Request: Send a blank email to php-notes+get-103895@lists.php.net to get a copy of this message
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 ---- Server IP: 217.174.203.10 Probable Submitter: 194.57.174.243 (proxied: 172.16.109.201) ---- Manual Page -- http://www.php.net/manual/en/function.ocirowcount.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+62012 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+62012&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+62012&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+62012&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+62012&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+62012&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+62012&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+62012&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+62012&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#103895) next »