Numeric Datatypes in PHP

Anon

Does anyone know how to properly get Is_Int() or Is_Integer() to work or evaluate? I have the following code:

if (is_int($value)) {
$whereSQL .= "$value";
} else {
$whereSQL .= "'$value'";
}

I want that code to add '' around the value if it is not numeric. Otherwise, I want it to add the single quotes. This code does not evaluate properly. Any ideas? Also, I want to add dates in. Thank you

Anon

I haven't tried your code, but you can add quotes around a value in an SQL-query even if that value is an integer. Simple solution, replace the if-statement with

$whereSQL .= "'$value'"

Johan

Anon

I just posted a reply to Amanda on this forum on this same subject - I get no problems trying what you're saying.

$valSQL="where field = ";
$dataval="bert";
if (is_int($dataval)) {
$valSQL .= "$dataval";
} else {
$valSQL .= "'$dataval'";
}
echo "$valSQL";

This gives "where field = 'bert'"

$valSQL="where field = ";
$dataval=1;
if (is_int($dataval)) {
$valSQL .= "$dataval";
} else {
$valSQL .= "'$dataval'";
}
echo "$valSQL";

This gives "where field = 1"

What results do you get, if you say its not correct?

toma42

use is_numeric instead, but that won't prevent a number going into a string column.

btw, the two above posts are wrong as good dbms's require no quotes around numbers.

Tom

watski

True, but since they accept quotes around numbers, why not use them all the time? Much simpler than checking types and all.

Johan