Integer problem with a mysql prepared statement

[burnside]

Hi, I have a prepared statement that sends a few strings and a couple int values to a table. This data comes from an online form. The problem is that one of the form values, the phone number, is not being entered into the table correctly. The table does become populated with all the correct values except for the phone number column which receives a 0 as it's value instead of the value from the form. In the form, I make sure that the phone number only contains numbers, but that still doesn't help.

I then casted the phone number variable as so:

intval($phone_number);

That didn't solve the problem either. Now if I hard code this within the form processing:

$phone_number = 5551234567;

then everything works fine. Any idea why this is not working correctly?

Thanks!
b

[NogDog]

Are you sure you are referencing the correct form element name in the $_POST array? Did you check to see if it had a value? Other than that, not much I can think of without seeing the actual code, except that I would suggest you treat a phone number as a string instead of as an integer, even if it happens to be a string of numeric digits. For one thing, the maximum size of a 32-bit signed integer is 2147483647, so if treated as an integer, any phone number "larger" than that would have unexpected results when cast as an integer in 32-bit mode.

[burnside]

Hey, I'll try that. I think you're exactly right with the 32-bit signed integer. I didn't even think of that. Time to change that into a string!