From: Joe Presbrey <presbrey@mit.edu>
Date: Tue, 21 Aug 2007 21:13:34 +0000 (+0000)
Subject: is_numeric bug in fetchRows and more
X-Git-Url: http://andersk.mit.edu/gitweb/sql-web.git/commitdiff_plain/35d6bcaee2327c5c7bf5519044ba88f9cffb6a82

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 1ce55cc..3cabb1e 100644
--- 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' ";