使用插入mysql表的最后一个数据生成下一个数字

Question

My database has a table named tbltest . in this there is column id that is set to auto increment and another column is named as app_id .

What i want here is i want to generate app_id when someone visit My Form page Called apply.php and submit application form there. is it possible to get the last inserted id in table and get the corresponding app_id generated for that id and generate new app_id on submit the form page.

Now As there is last inserted id is 1 and app_id is IVISA250531 , So, When We Submit the form, it Should generate Next app_id that Should be,

IVISA250532

Answer 1

you can do:

$sql = "SELECT * FROM tbltest ORDER BY id DESC LIMIT 1;";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result) ;

    $str = $row["app_id"];//"IVISA250532";
    $int = preg_replace('/[^0-9]/', '',$str);//to get the Int from string '250532'
    $pure_str = str_replace($int, "", $str);// tog get only the string word 'IVISA'

    $Next_app_id = $pure_str.($int+1); // << that is what you need "IVISA250533"
}