is_numeric bug in fetchRows and more

git-svn-id: svn://presbrey.mit.edu/php/lib@128 a142d4bd-2cfb-0310-9673-cb33a7e74f58

diff --git a/lib/joe/util.lib.php b/lib/joe/util.lib.php
index 1ce55cca57540d0d6f94c98f506effa2a91d994a..3cabb1e1e40810cf89204fed13c3314600c5d868 100644 (file)
--- a/lib/joe/util.lib.php
+++ b/lib/joe/util.lib.php
@@ -125,7 +125,7 @@ function buildSQLSet($fields, $values=null, $safeFields=false) {
         foreach($fields as $field) {
             if ($c++) $sql .= ',';
                        $value = array_shift($values);
-                       if (is_numeric($value))
+                       if ((string)intval($value)===(string)$value)
                                $sql .= " `$field`=".mysql_real_escape_string($value);
                        else
                                $sql .= " `$field`='".mysql_real_escape_string($value)."'";
@@ -135,7 +135,7 @@ function buildSQLSet($fields, $values=null, $safeFields=false) {
             if ($c++) $sql .= ',';
             if (in_array($value,$ex) || (is_array($safeFields) && in_array($field,$safeFields))) {
                 $sql .= " `$field`=$value";
-            } elseif (is_numeric($value)) {
+            } elseif ((string)intval($value)===(string)$value) {
                 $sql .= " `$field`=".mysql_real_escape_string($value);
                        } else {
                 $sql .= " `$field`='".mysql_real_escape_string($value)."'";
@@ -161,7 +161,7 @@ function buildSQLInsert($array, $table=null, $safeFields=false) {
             $sql .= " $value ";
                } else {
                $value = mysql_real_escape_string($value);
-                       if (is_numeric($value)) {
+                       if ((string)intval($value)===(string)$value) {
                                $sql .= " $value ";
                        } else {
                                $sql .= " '$value' ";