Auto Number Generate Using PHP

bekar

Please for the source code

Sir thanks for this tutorial it was very very useful to me in my project

best tutorial for me because this is what i'm finding for my project. THANK YOU SO MUCH!

It was much helpful. But the number is stopping at EMP10 and EMP11 not generating. I couldn't make empid as primary because i have an column id as primary already.

Thank you for this tuto, i have a question. If i wanna use another variable but not the id for exemple i got the id, account_number, name right how can i auto generate account_number? cause it can't be incremented in the bd that id is already unique. How can i do that please?

isnt working after 10

Not working. It does not proceed to the next number series(ID)

Hi.. when the emp id reach 10 then if you add new employee the emp id is 10 instead of 11 how to fix that? thank you

It doesn't save after EMP10, just another DB save after EMP10. No work after 10

Hi i want to ask, it can run but it didn’t auto generate the number. The number remain the same EMP5 even i add 10 new data

What if the PHP file is separate from the HTML file? Can you make some Tutorial for it ?

Man Your Script Is Exceptional. First Optimize Your Script.
This Script Will Stop Till 10 Number 😂
Code Is Working Properly But Some Exception Are There ...
Solution ------

&empid = "EMP".(&empid + 1);
Now Write Like This -

If You Want To Get Value Till (99).
&empid = "EMP00".(&empid + 1);

If you want get value till (999).
&empid = "EMP000".(&empid + 1);

Thank u

Very Good your lessons

Fatal error: Uncaught TypeError: mysqli_fetch_array(): Argument #1 ($result) must be of type mysqli_result, bool given in F:\xampp\htdocs\PearlHospital\registration.php:181 Stack trace: #0 F:\xampp\htdocs\PearlHospital\registration.php(181): mysqli_fetch_array(false) #1 {main} thrown in F:\xampp\htdocs\PearlHospital\registration.php on line 181

can you plz share the source code link in the description..thanks already :)

novice code

stuck on 10 record no increment after 10

Sir, I have followed the above steps but after reaching order id 10 it is not getting incremented. I am getting same order id 10 in my next data entry. Request you to please help.

i need same thing in spring boot can please upload code for me
thanks

isnt working after 10

Abe Chutiya Saale Fuddu Bna Rha He Dena He To Shi Knowledge De Na Be Jinhe Nhi Pta He Or Koi Sources Nhi He Bo To YT Per Hi Aayga Na......

Isme 1-10 Tak To Properly Increment Ho Rha He But 10 Ke Aage Se Increment Stop Ho Gya He ...

Ager Aata He To Ye Isaue Solve Ker...

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\370project\addstd.php on line 5

Thanks a lot sir

hello sir, great tutorial btw,
i wanna ask about duplication if some other user accessing this form also, how can we prevent that ID is not duplicated?

terima kasih,

Thanks a lot bro for this wonderful tutorial, you are the best

But it can't work after number 10

please how can i reset so that it will start from 1 again ? help me please

nice tutorial you are the best thank you

Hey, good tutorial, just what I was looking for, thank you. I need some help. I need the increment to start from 01590 and not from 1

Pls zoom more

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\student\index.php on line 6
Notice: Trying to access array offset on the value of type null in C:\xampp\htdocs\student\index.php on line 7
i am getting like this why increment not working

thank you
i have this proplem
Notice: Trying to access array offset on value of type null in C:\xampp\htdocs\stores\customer.php on line 12
plse help me
this code
$select="SELECT * FROM customer order by id DESC LIMIT 1 " ;
$result= mysqli_query($conn, $select) ;

$row = mysqli_fetch_array($result);
$lastcustoer_id = $row['id'];
if($lastcustoer_id = "")
{
$custom_id = "CUST1";
}
else
{
$custom_id = substr($lastcustoer_id,3);
$custom_id = intval($custom_id);
$custom_id = "CUST1" . ($custom_id + 1);
}

?>

Give source code please

My sqli fetch array me error dikha raha hai

hi can you help with this. when i enter like EMP until 09 after that it goes to up it cant get data. how to put sequence in that

sir can't work submit button

sir mera ni ho rha auto nmber generate

Error in this line>>>>$row= mysqli_fetch_array($result);
Error>>>Trying to access array offset on value of type null
Sir how to solve it?

thanks it worked for me

data will not insert into database table and also the empid is not increment if refesh the browser the same id will display on the form

Good teacher

Super !! Its very interesting I can learn very well thanks sir

Sourcecode send pls