/**替换单引号,用于sql语句*/
function formatStr ($str )
{
$pos = strpos ($str ,"'");
if ($pos ===false )
{
$str = str_replace ("","'",$str );
}else
{
$str = str_replace ("'","",$str );
$str = str_replace ("","'",$str );
}return trim ($str );
}
/**替换单引号和双引号,用于文本框显示*/
function formatDisplay ($str )
{
$str = str_replace ("","'",$str );
$str = str_replace ('',""",$str );
return trim ($str );
}
/**替换双引号,用于生成CSV文件*/
function formatCSVStr ($str )
{
$str = str_replace (""","""",$str );
return trim ($str );
}
/**将日期格式化为mysql的默认格式*/
function to_mysql_date ($dt )
{
$result = $format ;
if (ereg ("([0-9]{1,2})/([0-9]{1,2})/([0-9]{4})", $dt , $adat )) return $adat [3 ]. "-". $adat [1 ]. "-". $adat [2 ];
if ($dt =="N/A") return "0000-00-00";
else return "3333-03-03";
} /**将mysql的默认日期格式转为指定日期格式*/
function from_mysql_date ($mysql_dt ,$format ="%m/%d/%Y")
{
$result = $format ;
if (ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $mysql_dt , $adat )) if (intval ($adat [1 ])==0 && intval ($adat [2 ])==0 && intval ($adat [3 ])==0 )
{
return "N/A";
} else if (intval ($adat [1 ])==3333 && intval ($adat [2 ])==3 && intval ($adat [3 ])==3 )
{
return "Ongoing Offer";
} else
{
return (ereg_replace ("%Y",$adat [1 ],ereg_replace ("%d",$adat [3 ],ereg_replace ("%m",$adat [2 ],$result ))));
} else return "Expiration Unknown";
}