Why its add wrong value? All values are right accept mobile_no

Question

https://www.sololearn.com/post/1034847/?ref=app
https://www.sololearn.com/post/1034848/?ref=app

Answer 1

Here is your answer
https://stackoverflow.com/questions/12726037/not-able-to-inserting-correct-mobile-number-to-phpmyadmin-using-php
https://stackoverflow.com/questions/10255724/incorrect-integer-2147483647-is-inserted-into-mysql
Thank so much for your help..😀😀

Answer 2

Why only number column value changed? I don't understand

Answer 3

Prafull Epili
Don't copy answer when you want to mention.. To mention someone in answer just use @ and type name.

Answer 4

Prafull Epili
What data type you choose for Phone number?

Answer 5

Prafull Epili
What data type you choose for Phone number?
int

Answer 6

Prafull Epili
Use VARCHAR and see.

Answer 7

Prafull Epili
Use VARCHAR and see.
First i had used varchar then its shown error that why i changed it int.

Answer 8

Prafull Epili
It should not give error but anyway there is two more datatype to Store mobile number that is BIGINT and Text. You can try them.

Answer 9

Here is your answer
https://stackoverflow.com/questions/12726037/not-able-to-inserting-correct-mobile-number-to-phpmyadmin-using-php
https://stackoverflow.com/questions/10255724/incorrect-integer-2147483647-is-inserted-into-mysql

Answer 10

The largest value for data type INT is 2147483647. If the number you're inserting is bigger than 2147483647, then it will cause the problem. For solution, change the data type from INT to BIGINT as BIGINT has a maximum value of 9223372036854775807.
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html

Answer 11

Prafull Epili
Your Mobile Number start with mostly 6-7-8-9 digit but Int data type has size 2^31 means (-2147483648 to 2^31-1)
That's why it's inserting 2147483648 because mobile number is overflowing this range.. So to insert number you can use BIGINT which has size 2^63 to 2^63-1 or you can use VARCHAR.