php 小积累

//获取文件名称  
$url="http://www.sina.com.cn/abc/de/fg.php?id=1";  
$str = strrchr($url, '.');  
echo substr($str, 1, strpos($str, '?')-1);  

//sql语句，查询1-30号每天9:00-17:00的数据
DATE_FORMAT转数据格式
AND go.pdate >  '2014-04-11 12:33:30'
AND go.pdate <  '2014-04-11 12:35:00'
AND DATE_FORMAT(go.pdate,'%H:%i:%S') BETWEEN '12:33:00' and  '12:34:00'