note 128712 added to function.oci-num-rows

From: 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

« previous php.notes (#220673) next »