×ÛºÏÍøµêϵͳÊÇÓÉEÒ×ÍøÂç(68ws.cn)»ùÓÚphp+mysql¿ª·¢£¬¼æÈݸ÷ÀàÉÌÆ·µÄ·¢²¼¡¢Õ¹Ê¾ºÍ¶©¹º¡£³ýÁ˾ßÓÐÍêÉÆµÄÉÌÆ·ÀàÐ͹ÜÀí¡¢ÉÌÆ·¹ÜÀí¡¢ÅäËÍÖ§¸¶¹ÜÀí¡¢¶©µ¥¹ÜÀí¡¢»áÔ±·Ö×é¡¢»áÔ±¹ÜÀí¡¢²éѯͳ¼ÆºÍ¶àÏîÉÌÆ·´ÙÏú¹¦ÄÜ£¬»¹¾ßÓÐÍêÕûµÄÎÄÕ¡¢Í¼ÎÄ¡¢ÏÂÔØ¡¢µ¥Ò³¡¢¹ã¸æ·¢²¼µÈÍøÕ¾ÄÚÈݹÜÀí¹¦ÄÜ¡£ÏµÍ³¾ßÓо²Ì¬HTMLÉú³É¡¢UTF-8¶àÓïÑÔÖ§³Ö¡¢¿ÉÊÓ»¯Ä£°æÒýÇæµÈ¼¼ÊõÌØµã£¬Ö§³Ö¶àƵµÀµ÷Óò»Í¬Ä£°æºÍÈÎÒâÉèÖÃÆµµÀÊ×Ò³£¬ÊʺϽ¨Á¢ÄÚÈݷḻµÄ´óÐÍ×ÛºÏÍøµê¡£ÏµÍ³¾ßÓÐÒÔÏÂÖ÷Òª¹¦ÄÜÄ£¿é£º
ÍøÕ¾²ÎÊýÉèÖà - ¶ÔÍøÕ¾µÄһЩ²ÎÊý½øÐиöÐÔ»¯¶¨Òå
»áÔ±ÀàÐÍÉèÖà - ¿ÉÒÔÈÎÒâ´´½¨¶à¸ö»áÔ±ÀàÐÍ£¬ÉèÖò»Í¬»áÔ±ÀàÐ͵ÄȨÏ޺ͼ۸ñ¼¶±ð
»õ±ÒÀàÐÍÉèÖà - ¶¨Òå¶à±ÒÖֺͻãÂʹØÏµ
Ö§¸¶·½·¨ÉèÖà - ÉèÖÃÖ§¸¶·½Ê½£¬Ö§³ÖÔÚÏßÖ§¸¶¡¢ÏßÏÂÖ§¸¶ºÍÔ¤¸¶¿î¿Û¿îÖ§¸¶Èý´óģʽ£¬ÔÚÏßÖ§¸¶½Ó¿Ú¿ÉÀ©Õ¹
ÅäËÍ·½·¨ÉèÖà - ¿É°´²»Í¬ÇøÓòÉ趨ÅäËÍ·½·¨ºÍÅäËÍ·ÑÓüÆËã·½°¸£¬¼æÈݼò½àµÄ¼ÆËã·½°¸ºÍÔ˷ѼÆË㹫ʽ
ÉÌÆ·ÀàÐÍÉèÖà - Õë¶Ô²»Í¬ÉÌÆ·ÀàÐÍÉèÖò»Í¬µÄ·¢²¼²ÎÊý£¬°üÀ¨¿ÉÌî²ÎÊý¡¢Ñ¡µ¥²ÎÊýºÍÊÇ·ñÔÚ¶©¹ºÊ±¿ÉÑ¡µÈÉèÖÃ
ÉÌÆ·¹ÜÀíÄ£¿é - ¾ßÓÐÉÌÆ··ÖÀà¡¢ÉÌÆ··¢²¼¡¢ÅúÁ¿µ¼ÈëºÍÉÌÆ·¹ÜÀí¹¦ÄÜ£»²»Í¬ÉÌÆ·ÀàÐ;ßÓв»Í¬µÄ ......
1£¬°ó¶¨²ÎÊý
$mysqli=new mysqli($host,$user,$pass,$db);
if(mysqli_connect_errno()){
echo 'Á¬½Ó³öÏÖÒì³£ÁË:'.mysqli_connect_error();
exit(0); }
$sql = 'insert into user(name,pass,email) values(?,?,?)';
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('sss',$name,$paassword,$email);
$name= '2';
$paassword=md5('12345');
$email = 'iamtsgx08@google.com';
$stmt->execute();
echo 'ÐÞ¸ÄÁË'.$stmt->affected_rows.'ÐÐ';
$stmt->close();
$mysqli->close();
2£¬°ó¶¨½á¹û¼¯
$s ......
ÍøÉÏ»¨µêϵͳÊÇÓÉEÒ×ÍøÂç(68ws.cn)»ùÓÚphp+mysql¿ª·¢£¬Ô¤ÉèÏÊ»¨,µ°¸â,ÀñÆ·,ÂÌÖ²µÈÉÌÆ·ÀàÐÍ,¾ßÓÐÍøÉ϶©»¨,×ÔÖú¶©»¨µÈÍøÉÏÏÊ»¨ÏúÊÛ³£Óù¦ÄܺÍÍêÉÆµÄÉÌÆ·ÀàÐ͹ÜÀí¡¢ÉÌÆ·¹ÜÀí¡¢ÅäËÍÖ§¸¶¹ÜÀí¡¢¶©µ¥¹ÜÀí¡¢»áÔ±·Ö×é¡¢»áÔ±¹ÜÀí¡¢²éѯͳ¼ÆºÍ¶àÏîÉÌÆ·´ÙÏú¹¦ÄÜ¡£ÏµÍ³¾ßÓо²Ì¬HTMLÉú³É¡¢UTF-8¶àÓïÑÔÖ§³Ö¡¢¿ÉÊÓ»¯Ä£°æÒýÇæµÈ¼¼ÊõÌØµã£¬ÊʺϽ¨Á¢ÏÊ»¨ÀñÆ·ÏúÊÛÀàÍøµê¡£ÏµÍ³¾ßÓÐÒÔÏÂÖ÷Òª¹¦ÄÜÄ£¿é£º
ÍøÕ¾²ÎÊýÉèÖà - ¶ÔÍøÕ¾µÄһЩ²ÎÊý½øÐиöÐÔ»¯¶¨Òå
»áÔ±ÀàÐÍÉèÖà - ¿ÉÒÔÈÎÒâ´´½¨¶à¸ö»áÔ±ÀàÐÍ£¬ÉèÖò»Í¬»áÔ±ÀàÐ͵ÄȨÏ޺ͼ۸ñ¼¶±ð
»õ±ÒÀàÐÍÉèÖà - ¶¨Òå¶à±ÒÖֺͻãÂʹØÏµ
Ö§¸¶·½·¨ÉèÖà - ÉèÖÃÖ§¸¶·½Ê½£¬Ö§³ÖÔÚÏßÖ§¸¶¡¢ÏßÏÂÖ§¸¶ºÍÔ¤¸¶¿î¿Û¿îÖ§¸¶Èý´óģʽ£¬ÔÚÏßÖ§¸¶½Ó¿Ú¿ÉÀ©Õ¹
ÅäËÍ·½·¨ÉèÖà - ¿É°´²»Í¬ÇøÓòÉ趨ÅäËÍ·½·¨ºÍÅäËÍ·ÑÓüÆËã·½°¸£¬¼æÈݼò½àµÄ¼ÆËã·½°¸ºÍÔ˷ѼÆË㹫ʽ
ÉÌÆ·ÀàÐÍÉèÖà - Õë¶Ô²»Í¬ÉÌÆ·ÀàÐÍÉèÖò»Í¬µÄ·¢²¼²ÎÊý£¬°üÀ¨¿ÉÌî²ÎÊý¡¢Ñ¡µ¥²ÎÊýºÍÊÇ·ñÔÚ¶©¹ºÊ±¿ÉÑ¡µÈÉèÖÃ
ÉÌÆ·¹ÜÀíÄ£¿é - ¾ßÓÐÉÌÆ··ÖÀà¡¢ÉÌÆ··¢²¼¡¢ÅúÁ¿µ¼ÈëºÍÉÌÆ·¹ÜÀí¹¦ÄÜ£»²»Í¬ÉÌÆ·ÀàÐ;ßÓв»Í¬µÄ·¢²¼²ÎÊý
¸½¼Ó¶©¹ºÄ£¿é - ¸½Ê ......
¿Í»§¶ËIPÏà¹ØµÄ±äÁ¿
1. $_SERVER['REMOTE_ADDR']; ¿Í»§¶ËIP£¬ÓпÉÄÜÊÇÓû§µÄIP£¬Ò²ÓпÉÄÜÊÇ´úÀíµÄIP¡£
2. $_SERVER['HTTP_CLIENT_IP']; ´úÀí¶ËµÄIP£¬¿ÉÄÜ´æÔÚ£¬¿ÉαÔì¡£
3. $_SERVER['HTTP_X_FORWARDED_FOR']; Óû§ÊÇÔÚÄĸöIPʹÓõĴúÀí£¬¿ÉÄÜ´æÔÚ£¬¿ÉÒÔαÔì¡£
·þÎñÆ÷¶ËIPÏà¹ØµÄ±äÁ¿
1. $SERVER_NAME£¬ÐèҪʹÓú¯Êýgethostbyname()»ñµÃ¡£Õâ¸ö±äÁ¿ÎÞÂÛÔÚ·þÎñÆ÷¶Ë»¹Êǿͻ§¶Ë¾ùÄÜÕýÈ·ÏÔʾ¡£
2. $HTTP_SERVER_VARS["SERVER_ADDR"]£¬ÔÚ·þÎñÆ÷¶Ë²âÊÔ£º127.0.0.1£¨Õâ¸öÓëhttpd.confÖÐBindAddressµÄÉèÖÃÖµÏà¹Ø£©¡£ÔÚ¿Í»§¶Ë²âÊÔ½á¹ûÕýÈ·¡£
3. $_SERVER['LOCAL_ADDR'] ¡¢$HTTP_SERVER_VARS['LOCAL_ADDR']£¬²âÊÔÖУ¬Î´»ñµÃÈκνá¹û£¨²âÊÔ»·¾³PHP5£©¡£
ÍêÕûµÄ»ñµÃIPÀà
class getIP{
function clientIP(){
$cIP = getenv('REMOTE_ADDR');
$cIP1 = getenv('HTTP_X_FORWARDED_FOR');
$cIP2 = getenv('HTTP_CLIENT_IP');
$cIP1 ? $cIP = $cIP1 : null;
$cIP2 ? $cIP = $cIP2 : null;
return $cIP;
}
function serverIP(){
return gethostbyname($_SERVER_NAME);
}
}
$getIP = new getIP();
$clientIp = getIP::clientIP();
$serverIp = getIP::serverIP();
& ......
ÍøÉÏÊéµêϵͳÊÇÓÉEÒ×ÍøÂç(68ws.cn)»ùÓÚphp+mysql¿ª·¢£¬³ýÁ˾ßÓÐÍøÉÏÊéµê±Ø±¸µÄÉÌÆ·¹ÜÀí¡¢ÅäËÍÖ§¸¶¹ÜÀí¡¢¶©µ¥¹ÜÀí¡¢»áÔ±·Ö×é¡¢»áÔ±¹ÜÀí¡¢²éѯͳ¼ÆºÍ¶àÏîÉÌÆ·´ÙÏú¹¦ÄÜ£¬»¹¾ßÓÐÍêÕûµÄÎÄÕ¡¢Í¼ÎÄ¡¢ÏÂÔØ¡¢µ¥Ò³¡¢¹ã¸æ·¢²¼µÈÍøÕ¾ÄÚÈݹÜÀí¹¦ÄÜ¡£ÏµÍ³¾ßÓо²Ì¬HTMLÉú³É¡¢UTF-8¶àÓïÑÔÖ§³Ö¡¢¿ÉÊÓ»¯Ä£°æÒýÇæµÈ¼¼ÊõÌØµã£¬Ö§³Ö¶àƵµÀµ÷Óò»Í¬Ä£°æºÍÈÎÒâÉèÖÃÆµµÀÊ×Ò³£¬ÊʺϽ¨Á¢¸÷ÖÖ¹æÄ£µÄÍøÉÏÊéµê¡£ÏµÍ³¾ßÓÐÒÔÏÂÖ÷Òª¹¦ÄÜÄ£¿é£º
ÍøÕ¾²ÎÊýÉèÖà - ¶ÔÍøÕ¾µÄһЩ²ÎÊý½øÐиöÐÔ»¯¶¨Òå ¡¶ÍøÉÏÊéµêϵͳÓû§Êֲᡷ
»áÔ±ÀàÐÍÉèÖà - ¿ÉÒÔÈÎÒâ´´½¨¶à¸ö»áÔ±ÀàÐÍ£¬ÉèÖò»Í¬»áÔ±ÀàÐ͵ÄȨÏ޺ͼ۸ñ¼¶±ð
»õ±ÒÀàÐÍÉèÖà - ¶¨Òå¶à±ÒÖֺͻãÂʹØÏµ
Ö§¸¶·½·¨ÉèÖà - ÉèÖÃÖ§¸¶·½Ê½£¬Ö§³ÖÔÚÏßÖ§¸¶¡¢ÏßÏÂÖ§¸¶ºÍÔ¤¸¶¿î¿Û¿îÖ§¸¶Èý´óģʽ£¬ÔÚÏßÖ§¸¶½Ó¿Ú¿ÉÀ©Õ¹
ÅäËÍ·½·¨ÉèÖà - ¿É°´²»Í¬ÇøÓòÉ趨ÅäËÍ·½·¨ºÍÅäËÍ·ÑÓüÆËã·½°¸£¬¼æÈݼò½àµÄ¼ÆËã·½°¸ºÍÔ˷ѼÆË㹫ʽ
ÉÌÆ·ÀàÐÍÉèÖà - Õë¶Ô²»Í¬ÉÌÆ·ÀàÐÍÉèÖò»Í¬µÄ·¢²¼²ÎÊý£¬°üÀ¨¿ÉÌî²ÎÊý¡¢Ñ¡µ¥²ÎÊýºÍÊÇ·ñÔÚ¶©¹ºÊ±¿ÉÑ¡µÈÉèÖÃ
ÉÌÆ·¹ÜÀíÄ£¿é - ¾ßÓÐÉÌÆ··ÖÀà¡¢ÉÌÆ··¢²¼¡¢ÅúÁ¿µ¼ÈëºÍÉÌÆ·¹ÜÀí¹¦ÄÜ£»²»Í¬ ......
·þ×°Íøµê¹ÜÀíϵͳÊÇÓÉEÒ×ÍøÂç(68ws.cn)»ùÓÚphp+mysql¿ª·¢£¬¾ßÓзþ×°ÀàÍøµêµÄ³£ÓõŦÄܺÍÍêÉÆµÄÉÌÆ·ÀàÐ͹ÜÀí¡¢ÉÌÆ·¹ÜÀí¡¢ÅäËÍÖ§¸¶¹ÜÀí¡¢¶©µ¥¹ÜÀí¡¢»áÔ±·Ö×é¡¢»áÔ±¹ÜÀí¡¢²éѯͳ¼ÆºÍ¶àÏîÉÌÆ·´ÙÏú¹¦ÄÜ¡£ÏµÍ³¾ßÓо²Ì¬HTMLÉú³É¡¢UTF-8¶àÓïÑÔÖ§³Ö¡¢¿ÉÊÓ»¯Ä£°æÒýÇæµÈ¼¼ÊõÌØµã£¬ÊʺϽ¨Á¢·þ×°¡¢Ð¬Ã±¡¢·þÊÎÀàÍøµê¡£ÏµÍ³¾ßÓÐÒÔÏÂÖ÷Òª¹¦ÄÜÄ£¿é£º
ÍøÕ¾²ÎÊýÉèÖà - ¶ÔÍøÕ¾µÄһЩ²ÎÊý½øÐиöÐÔ»¯¶¨Òå
»áÔ±ÀàÐÍÉèÖà - ¿ÉÒÔÈÎÒâ´´½¨¶à¸ö»áÔ±ÀàÐÍ£¬ÉèÖò»Í¬»áÔ±ÀàÐ͵ÄȨÏ޺ͼ۸ñ¼¶±ð
»õ±ÒÀàÐÍÉèÖà - ¶¨Òå¶à±ÒÖֺͻãÂʹØÏµ
Ö§¸¶·½·¨ÉèÖà - ÉèÖÃÖ§¸¶·½Ê½£¬Ö§³ÖÔÚÏßÖ§¸¶¡¢ÏßÏÂÖ§¸¶ºÍÔ¤¸¶¿î¿Û¿îÖ§¸¶Èý´óģʽ£¬ÔÚÏßÖ§¸¶½Ó¿Ú¿ÉÀ©Õ¹
ÅäËÍ·½·¨ÉèÖà - ¿É°´²»Í¬ÇøÓòÉ趨ÅäËÍ·½·¨ºÍÅäËÍ·ÑÓüÆËã·½°¸£¬¼æÈݼò½àµÄ¼ÆËã·½°¸ºÍÔ˷ѼÆË㹫ʽ
ÉÌÆ·ÀàÐÍÉèÖà - Õë¶Ô²»Í¬ÉÌÆ·ÀàÐÍÉèÖò»Í¬µÄ·¢²¼²ÎÊý£¬°üÀ¨¿ÉÌî²ÎÊý¡¢Ñ¡µ¥²ÎÊýºÍÊÇ·ñÔÚ¶©¹ºÊ±¿ÉÑ¡µÈÉèÖÃ
ÉÌÆ·¹ÜÀíÄ£¿é - ¾ßÓÐÉÌÆ··ÖÀà¡¢ÉÌÆ··¢²¼¡¢ÅúÁ¿µ¼ÈëºÍÉÌÆ·¹ÜÀí¹¦ÄÜ£»²»Í¬ÉÌÆ·ÀàÐ;ßÓв»Í¬µÄ·¢²¼²ÎÊý
·þ×°Ñ¡µ¥¶©¹º - Ö§³Ö·þ×°µÈÉÌÆ·ÔÚ¶©¹ºÊ±¿ÉÑ¡Ôñ³ßÂë¡¢ÑÕÉ«µÈ¼Û¸ñÎÞÇø±ðÏîÄ¿µÄ¿ÉÑ¡¶©¹º¹¦ÄÜ
¸½¼Ó¶©¹ºÄ£¿é - ¸½Ê ......