integer Archives - Mukesh Chapagain Blog

MySQL: Auto-increment (integer) limit exhausted

December 27, 2022 by Mukesh Chapagain

We generally set the primary key of a database table as “auto-increment”. The auto-increment column of your MySQL table has a maximum value based on the integer type. When you have a lot of data in your table, the auto-increment value can be exhausted by reaching its maximum value. After that, no data can be … Read more

PHP: How to get integer or decimal from a string?

December 25, 2014April 29, 2010 by Mukesh Chapagain

Suppose, I have a string with text and number and I only want the number. I don’t want the characters and text of the string. Here is the way out:- In this example, you will get only integer. It will omit all characters and text from the string. $string = 'Nrs 89,994,874.0098'; echo preg_replace("/[^0-9]/", '', … Read more