Menu
Community /Pin to ProfileBookmark
@NogDogNov 16.2011 — #My guess (but I'm far from sure without more details or actual source code) is that it's an SQL issue: putting quotes around an integer value in the actual query, e.g.:
If those single quotes around $var (in this example) are getting added by some function in your script, then you may want to modify that function to do a is_numeric() check on the variable, and only wrap it in quotes if that function returns false.
string to integer in php
Hi,
My problem:
I have a column whose data type is int.
When my php program is filling the values in the insert statement, the value passed is passed as a string i.e. ’20’ and not 20.
Hence the data is not getting inserted in the table.
How do I pass the value as a integer value and not as a string via php? I want the value to be 20 and not ’20’.
Please can some one help me
Really appreciated the help.
Thanks a lot.
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogNov 16.2011 — #My guess (but I'm far from sure without more details or actual source code) is that it's an SQL issue: putting quotes around an integer value in the actual query, e.g.:[code=php]
$var = 20;
$sql = "INSERT INTO table_name (field_name) VALUES('$var')";
[/code]...when what you actually would want would be:[code=php]
$var = 20;
$sql = "INSERT INTO table_name (field_name) VALUES($var)";
[/code]If those single quotes around $var (in this example) are getting added by some function in your script, then you may want to modify that function to do a is_numeric() check on the variable, and only wrap it in quotes if that function returns false.