/** * @intellisense */ function add_db_quotes($field, $value, $table = "", $type = null) { global $strTableName, $locale_info; if($table=="") $table=$strTableName; $pSet = new ProjectSettings($table); if($type == null) $type = $pSet->getFieldType($field); if(IsBinaryType($type)) return db_addslashesbinary($value); if(($value==="" || $value===FALSE || is_null($value)) && !IsCharType($type)) return "null"; if(NeedQuotes($type)) { if(!IsDateFieldType($type)) $value=db_prepare_string($value); else { $y = "(\d\d\d\d)"; $m = "(0?[1-9]|1[0-2])"; $d = "(0?[1-9]|[1-2][0-9]|3[0-1])"; $delim = "(-|".preg_quote($locale_info["LOCALE_SDATE"], "/").")"; $reg = "/".$d.$delim.$m.$delim.$y."|".$m.$delim.$d.$delim.$y."|".$y.$delim.$m.$delim.$d."/"; if( !preg_match($reg, $value, $matches) ) return "null"; $value=db_datequotes($value); } } else { $strvalue = (string)$value; if(is_numeric($strvalue)) $value = str_replace(",",".",$strvalue); else $value=0; } return $value; }
function add_db_quotes($field, $value, $table = "", $type = null) { global $strTableName; if ($table == "") { $table = $strTableName; } $pSet = new ProjectSettings($table); if ($type == null) { $type = $pSet->getFieldType($field); } if (IsBinaryType($type)) { return db_addslashesbinary($value); } if (($value === "" || $value === FALSE || is_null($value)) && !IsCharType($type)) { return "null"; } if (NeedQuotes($type)) { if (!IsDateFieldType($type)) { $value = db_prepare_string($value); } else { $value = db_datequotes($value); } } else { $strvalue = (string) $value; $strvalue = str_replace(",", ".", $strvalue); if (is_numeric($strvalue)) { $value = $strvalue; } else { $value = 0; } } return $value; }
function WRadd_db_quotes($field,$value,$table="") { $type = WRGetFieldType($table.".".$field); if(IsBinaryType($type)) return db_addslashesbinary($value); if(($value==="" || $value===FALSE) && !IsCharType($type)) return "null"; if(NeedQuotes($type)) { if(!IsDateFieldType($type)) $value=db_prepare_string($value); else $value=db_datequotes($value); } else { $strvalue = (string)$value; $strvalue = str_replace(",",".",$strvalue); if(is_numeric($strvalue)) $value=$strvalue; else $value=0; } return $value; }