$fp=fopen($filen,'r');
while(!feof($fp))
{
$buffer=fgets($fp,4096);
$buffer = iconv('GBK','utf-8',$buffer);
$this->db->query($buffer);
}
fclose($fp);
Mysql IP地址转换:
将IP地址转化为数字: SELECT inet_aton('192.168.1.139');
将数字转化为IP地址: SELECT inet_ntoa(3525181543);
时间整型转换日期型:SELECT FROM_UNIXTIME(1320423419); 2011-11-05 00:16:59
时间日期型转换整型:SELECT UNIX_TIMESTAMP("2011-11-05 00:20:00"); 1320423600
select UNIX_TIMESTAMP("2013-07-01 00:00:00");
1372608000
select UNIX_TIMESTAMP("2013-09-01 00:00:00");
1377964800
5356800L * 1000
长整型相算法 必须加L
//ip转为正整数
function ip2longM($ip){
//sprintf("%u", ip2long($ip));
return bindec(decbin(ip2long($ip)));
}
PHP 获取URL HTTPS或HTTP
echo $http = (isset($_SERVER['HTTPS'])&&$_SERVER['HTTPS']!='off')?'https':'http';
array('00ff00','0000ff','ff9900','FF99CC','ff0000','3366FF','ffff00','660099','cacaca','ff00ff')