note 62012 added to function.ocirowcount
| From: | sontung2603 at yahoo dot com | 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