Content

1. How to create automatic counter of record number in MySQL table using PHP?
2. How to delete all files in a folder?
3. Is it possible in PHP to replace blocks if…else with another conditional operation?
4. How to delete strings from a text file using the PHP language?

How to create automatic counter of record number in MySQL table using PHP?

For this, we’ll use the following function:

<?php

// The function is designed for obtainment of record number of the table 
function get_id($tbl_dt)
{   // Do descending sorting 
    $result = mysql_query("SELECT id FROM ".$tbl_dt." ORDER BY `id` DESC");   
    $myrow = mysql_fetch_array($result);
    $num_rows = mysql_num_rows($result);
    
    // if a number of records coincide with the last id, then...
    if ($num_rows==$myrow['id'])
    {  // ...take the first element  
      //in the sampling with the highest id value ,
     // by increasing this value by a unity 
       return $myrow['id'] + 1;
       } else { // Do ascending sorting, then...
        $res1=mysql_query("SELECT id FROM ".$tbl_dt." ORDER BY `id` ASC");
        $myrow1 = mysql_fetch_array($res1);
        $i = 1;
        do // ...look for "empty" id and add a record for this id
        {
            if ($i == $myrow1['id']) {
                $i++;
                continue;
            } else {
                return $i;
            }
        }
        while ($myrow1 = mysql_fetch_array($res1));
    }
}

?>

Read more