输入类型文本字段给出固定错误2147483647

Question

I have input type field as mobile but every time it feeds in this particular value in my database ie 2147483647 irrespective whatever values we fill

td><span class="style5">Mobile</span></td>
  <td><input type="number" name="mob" class="text-input" maxlength="10" /></td>

connecting code $Mobile= mysql_real_escape_string( $_POST['mob']);

"INSERT INTO old VALUES('','$ID','$Car','$Name','$Name','$Gender','$DOB','$Age','$Mobile','$A   ddress','$City','$EmailId')"

Answer 1

Your column in a signed INT which holds integers up to 2147483647. Your value is clearly larger than that. You will need to use BIGINT or VARCHAR for that data depending on what it represents (phone numbers should be stored as VARCHAR/CHAR since you are not going to be doing math with them).

See Integer Types (Exact Value)