How can we write a PHP script to free the cursor memory associated with MySQL results?

王林
Release: 2023-09-22 14:06:01
forward
1127 people have browsed it

How can we write a PHP script to free the cursor memory associated with MySQL results?

We know that PHP uses the msql_free_result() function to release the cursor memory related to MySQL results. To illustrate this, we are using the following example -

Example

In this example, we are writing the following PHP script that will free the memory after fetching the records from the table named ' tutorial_tbl'.

<?php
   $dbhost = &#39;localhost:3036&#39;;
   $dbuser = &#39;root&#39;;
   $dbpass = &#39;rootpassword&#39;;
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   
   if(! $conn )  {
      die(&#39;Could not connect: &#39; . mysql_error());
   }
   
   $sql = &#39;SELECT tutorial_id, tutorial_title, tutorial_author, submission_date
      FROM tutorials_tbl&#39;;
   mysql_select_db(&#39;TUTORIALS&#39;);
   $retval = mysql_query( $sql, $conn );

   if(! $retval ) {
      die(&#39;Could not get data: &#39; . mysql_error());
   }

   while($row = mysql_fetch_array($retval, MYSQL_NUM)) {
      echo "Tutorial ID :{$row[0]} <br> ".
         "Title: {$row[1]} <br> ".
         "Author: {$row[2]} <br> ".
         "Submission Date : {$row[3]} <br> ".
         "--------------------------------<br>";
   }
   mysql_free_result($retval);
   echo "Fetched data successfully</p><p>";
   mysql_close($conn);
?>
Copy after login

The above is the detailed content of How can we write a PHP script to free the cursor memory associated with MySQL results?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:tutorialspoint.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template