php几个实用的函数
2006-05-24 13:48:07
编辑来源:互联网
国际版 评论
/**替换单引号，用于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";
}
[code]
/**替换单引号，用于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";
}
[/code]
订阅
