Php ocirowcount () function

Write your php code

(PHP 3>= 3.0.7, PHP 4 , PHP 5)

ocirowcount -- Gets the number of affected rows

Syntax

int ocirowcount ( resource stmt )

ocirowcount() returns the number of rows affected for e.g. update-statements. This function will not tell you the number of rows that a select will return!

Example 1. ocirowcount() example


<?php
    echo "<pre>";
    $conn = OCILogon("scott", "tiger");
    $stmt = OCIParse($conn, "create table emp2 as select * from emp");
    OCIExecute($stmt);
    echo OCIRowCount($stmt) . " rows inserted.<br />";
    OCIFreeStatement($stmt);
    $stmt = OCIParse($conn, "delete from emp2");
    OCIExecute($stmt);
    echo OCIRowCount($stmt) . " rows deleted.<br />";
    OCICommit($conn);
    OCIFreeStatement($stmt);
    $stmt = OCIParse($conn, "drop table emp2");
    OCIExecute($stmt);
    OCIFreeStatement($stmt);
    OCILogOff($conn);
    echo "</pre>";
?>

Note: This function was renamed to oci_num_rows() after PHP >= 5.0.0. For downward compatibility ocirowcount() can also be used. This is deprecated, however.

Php ocirowcount Function syntax tag

ocirowcount php code on this is provided for your study purpose, it will guide you to know how create and design a website using php. use it to practice and train your self online

Php ocirowcount syntax tutorial

php tutorial guide and code design are for easy learning and programming. The code practice section provided at the top is for practising of this syntax. Use the code section up to practice your php programming online. Learning php is very easy, all you need is to use the examples on this site and practice them to perfect your skills.