ÀûÓÃipµØÖ·²éÑ¯ÇøÓò php³ÌÐò
¸Ã³ÌÐòûÓÐÓÅ»¯ Ö»ÊÇ×îÔʼµÄ³ÌÐò ¿ÉÒÔ½«ÆäÓëflash½áºÏÆðÀ´£¡
Óëflash½áºÏÆðÀ´¾ÍÊǽ«phpµÃµ½µÄµØÖ·ºÍÇøÓò ´òÓ¡³öÀ´ÔÙ·µ»Ø¸öflash¶ËÕâô¼òµ¥
<?php
$getIP="218.11.140.23"; // ÕâÀïÊÇ×Ô¼ºËæ±ãдµÄÒ»¸öip ʵ¼ÊʱÄ㻹Ҫͨ¹ý³ÌÐòµÃµ½Õâ¸öip
//Ö»¿ªÊ¼Ê±²éǰÈý¶Î
$subIPs=explode(".",$getIP);
$subIP=$subIPs[0].$subIPs[1].$subIPs[2];
$lastIP=$subIPs[3];
$url="http://localhost/zendphp/IPQuery/ip.txt";//ÎÒµÄipÊý¾Ý¿âÎļþ ÎÒÓõÄÊÇtxt¸ñʽ
if(file_exists($url)){
die("δÕÒµ½Îļþ");
return;
}
$rows=file($url);
//ÐÐÊý
$len=count($rows);
$p=0;
$collection=array();
foreach ($rows as $line){
$ipData=preg_split ('/[\s]+/',$line);//×¢ÒâÕâÀïµÄ¿Õ°×Æ¥Åä
$startIP=$ipData[0];
//$endIP=$ipData[1];
$ipSerials=explode(".",$startIP);
//Ä¿±êip
$ip=$ipSerials[0].$ipSerials[1].$ipSerials[2];
$last=$ipSerials[3];
//ipÐÅÏ¢
$areaInfo=$ipData[2].$ipData[3];
//ÕâÀï¿ÉÒÔÓöþ·Ö²éÕÒ£¬ÎªÁ˼ò±ã¾ÍÖ±½Ó²é°É
if($subIP==$ip){
$p++;
if($p>1){
if($lastIP==$last){
echo "ÄãµÄipµØÖ·ÊÇ".$getIP."<br/> ÄúËùÔڵĵط½ÊÇ".$areaInfo;
}
}else{
echo "ÄãµÄipµØÖ·ÊÇ".$getIP."<br/> ÄúËùÔڵĵط½ÊÇ".$areaInfo;
}
}
}
?>
Ïà¹ØÎĵµ£º
¡¡×î½üÔÚÕÛÌÚ PHP + MYSQL
µÄ±à³Ì¡£Á˽âÁËһЩ PHP SQL ×¢Èë¹¥»÷
µÄ֪ʶ£¬ÓÚÊÇдÁËÕâÆªÎÄÕ¡¡http://www.xiaohui.com/weekly/20070314.htm£¬×ܽáһϾÑé¡£ÔÚÎÒ¿´À´£¬Òý·¢ SQL ×¢Èë¹¥»÷
µÄÖ÷ÒªÔÒò£¬ÊÇÒòΪÒÔÏÂÁ½µãÔÒò£º
¡¡¡¡1. php ÅäÖÃÎļþ php.ini ÖÐµÄ magic_quotes_gpc
Ñ¡ÏîûÓдò¿ª£¬±»ÖÃΪ off
¡¡¡¡2. ¿ª·¢ ......
phpÖÐis_dirÖÐÄÜ·ñÕýÈ··µ»ØÈ·ÊµºÍĿ¼ȨÏÞÉèÖÃÓйØÏµ¡£¡£¡£
ŪÁ˺þᣡ£Ò»Ö±ÒÔΪ²»ÊÇȨÏÞÎÊÌâ¡£
»·¾³ÊÇiis6.0+php5.2
ÍøÕ¾Ä¿Â¼ÊÇÔÚd:\vhost\web1
ÒªÓÃis_dirº¯Êý±ØÐëÉèÖÃȨÏÞd:\£¬d:\vhostΪ¿É¶Á¿ÉÁÐĿ¼
Ò²¾ÍÊÇweb1Ç°Ãæ¼¸¼¶µÄĿ¼¶¼ÒªÓпɶÁ¿ÉÁÐĿ¼µÄȨÏÞ¡£ ......
²½Ö裺
1.ÔËÐÐÃüÁ./ext_skel --extname=sharemem
2.ÔËÐÐÃüÁ./configure --with-php-config=/usr/local/lnmp/php/bin/php-config
3.make clean
make
make install
/usr/local/lnmp/php/sbin/php-fpm restart
/usr/local/lnmp/php/bin/php-cgi /data0/htdocs/blog/sharemem.php
´úÂëÈçÏ£º
1.config.m4
PHP_A ......
phpºÍjavaͨÓÃsqlÓï¾ä·¨
SELECT max(id) from table
¸Ã·½·¨ÔÚ¶àÏ̵߳ÈÇé¿öÏ¿ÉÄÜ»áÔì³É²»ÕýÈ·¡£
javaÈýÖÖ·½·¨
1¡¢¸ù¾ÝpsµÄgetGeneratedKeys
PreparedStatement ps = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS); //ºìÉ«Êǹؼü
ps.executeUpdate(); //Ö´Ðкó
ResultSet rs = ps.getGeneratedKeys ......
×î½üÓÐÈËÔÚÕбêÒª×ö¸öÏñ£ºwww.webjianzhi.com ÕâÑùµÄÈ˲ÅÕ¾£¬³õ¿´£¬Õâ¸öÍøÂç¼æÖ°Íø£¬½çÃæ»¹ÊDZȽÏÇåÎúµÄ¡£
ÕûÌå·ÖÎöÁËһϣ¬Ò»¸öÐÂÎÅÎÄÕ·¢²¼ÏµÍ³£¬Õâ¸ö²»ÊǺÜÄÑ£¬ÁíÒ»¸ö¾ÍÊÇ×ֶε÷ÓÃϵͳ£¬¾ÍÊÇÊ×Ò³µÄÖ°Òµ½éÉÜ£¬¼æÖ°ÈËÆø£¬µÄÕâЩµ÷Óá£
ÁíÒ»¸ö¾ÍÊÇ»áÔ±·¢²¼ÏµÍ³¡£
Õû¸öÓñí¸ñ²¼¾Ö£¬ÃÀ¹¤Éϲ»´æÔ ......