Hello Sir, I have a question that when i feed numerice 10 digit mobile no in the form then it does not feed same as i feed. i took phone no type int(10)and also took different differnt value but in mysql database the value is changing when i feed 10 digit mobile no it convert into this no 2147483647. Please guide me with code and please show a suitable example to insert data into mysql database with different type of data type.

Member Avatar for diafol

Do not use int as it will take off any leading '0'. Use varchar (10) if you are certain that you will never need more than 10 digits. Else, use 15 or something else.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.