note 128712 added to function.oci-num-rows
| From: | vihanga dot kule99 at gmail dot com | Date: | Fri, 07 Jul 2023 08:57:47 +0000 |
| Subject: | note 128712 added to function.oci-num-rows | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-220673@lists.php.net to get a copy of this message | ||
The
oci_num_rows() function is used to retrieve the number of rows affected or returned
by a query executed with Oracle Database using the OCI8 extension. Here's an explanation of how
oci_num_rows() works:
1. Syntax:
php
oci_num_rows($statement);
2. Parameters:
$statement: This parameter represents the Oracle statement handle returned by
oci_parse() and executed using oci_execute(). It refers to the executed
query or statement for which you want to get the number of rows.
3. Return Value:
The oci_num_rows() function returns the number of rows affected or returned by the
executed query. It returns an integer value representing the count of rows.
4. Usage:
After executing a query with oci_execute(), you can use oci_num_rows() to
determine the number of rows affected or returned by the query.
- It is commonly used in scenarios where you need to know the count of rows for result sets or
the count of affected rows after an INSERT, UPDATE, or DELETE operation.
example that demonstrates the usage of oci_num_rows():
php
$sql = "SELECT * FROM employees";
$statement = oci_parse($connection, $sql);
oci_execute($statement);
// Get the number of rows returned by the query
$numRows = oci_num_rows($statement);
echo "Number of rows: " . $numRows;
this example, we execute a SELECT query to fetch records from the "employees" table. After
executing the query with oci_execute(), we use oci_num_rows() to retrieve
the number of rows returned by the query and store it in the $numRows variable.
Finally, we echo the count of rows.
----
Server IP: 45.112.84.4
Probable Submitter: 45.91.159.168 (proxied: 202.124.181.72)
----
Manual Page -- https://php.net/manual/en/function.oci-num-rows.php
Edit -- https://main.php.net/note/edit/128712
Del: integrated -- https://main.php.net/note/delete/128712/integrated
Del: useless -- https://main.php.net/note/delete/128712/useless
Del: bad code -- https://main.php.net/note/delete/128712/bad+code
Del: spam -- https://main.php.net/note/delete/128712/spam
Del: non-english -- https://main.php.net/note/delete/128712/non-english
Del: in docs -- https://main.php.net/note/delete/128712/in+docs
Del: other reasons-- https://main.php.net/note/delete/128712
Reject -- https://main.php.net/note/reject/128712
Search -- https://main.php.net/manage/user-notes.php