Syntax error How can we write PHP script to count the affected rows by MySQL query?

How can we write PHP script to count the affected rows by MySQL query?

PHP uses mysql_affected_rows( ) function to find out how many rows a query changed. To illustrate it we are having the following example −

Example

<html>
   <head>
      <title>Rows affected by query</title>
   </head>
   <body>
      <?php
         $dbhost = 'localhost:3036';
         $dbuser = 'root';
         $dbpass = 'rootpassword';
         $conn = mysql_connect($dbhost, $dbuser, $dbpass);
         
         if(! $conn ) {
            die('Could not connect: ' . mysql_error());
         }
         echo 'Connected successfully<br />';
         
         mysql_select_db( 'TUTORIALS' );
         $result_id = mysql_query ($query, $conn_id);
         # report 0 rows if the query failed
         $count = ($result_id ? mysql_affected_rows ($conn_id) : 0);
         print ("$count rows were affected
");
      ?>
   </body>
</html>
Updated on: 2020-06-22T14:30:45+05:30

401 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements