ÎÞ·¨ÔØÈë mysql À©Õ¹£¬Çë¼ì²é PHP ÅäÖ᡽â¾ö°ì·¨
PS:ÎÒ½ñÌìÅäÖà ·þÎñÆ÷µÄʱºò³öÏÖµÄÎÊÌâ¾ÍÊÇÕâ¸ö£¬µ«ÊÇÕÕ×Å·½·¨¶¼×öÁË£¬Ñ¾µÄ¡£¡£»¹ÊÇûÓ㬼«¶ÈÓôÃÆËÀ¡£¡£°¥¡£¡£¡£ÎÒÒ²²»ÖªµÀʲôÔÒòÄØ¡£¡£¿ÉÄܵÄÔÒò¶¼ÕÒ¹ýÁË¡£¡£ÓôÃÆ°¡`~
apache2+mysql+php5+phpmyadminÅäÖÃÎÊÌ⣺ÎÞ·¨¼ÓÈëmysqlÀ©Õ¹£¬Çë¼ì²éphpÅäÖÃ...
°²×°Íêapache2+mysql+php5ºó£¬°²×°phpmyadmin²¢ÅäÖúÃÒÔºó£¬ÔÚä¯ÀÀÆ÷µØÖ·¿òÊäÈ룺http://localhost/phpmyadmin/ ÏÔʾÈçÏÂÌáʾÐÅÏ¢:
-----------------------------------------------
ÎÞ·¨ÔØÈë mysql À©Õ¹£¬
Çë¼ì²é PHP ÅäÖÃ
Îĵµ
----------------------------------------------
½â¾ö°ì·¨:ÐÞ¸Ä "c:/windows/php.ini" ²éÕÒphp_mysql.dll ½«Ç°ÃæµÄ×¢ÊÍ·û";"È¥µô
È»ºó½« "php°²×°Ä¿Â¼/libmysql.dll" ºÍ "php°²×°Ä¿Â¼/ext/php_mysql.dll" ¸´ÖƵ½ "c:/windows/system32/" ÏÂ ÖØÆôapache¼´¿É
ÁíÍ⣬µ±ÄãÔٴδò¿ªphpmyadminʱ£¬¿ÉÄÜ»áÌáʾ:
----------------------------------------------
ûÓз¢ÏÖ PHP µÄÀ©Õ¹ÉèÖÃmbstring£¬ ¶øµ±Ç°ÏµÍ³ºÃÏñÔÚʹÓÿí×Ö·û¼¯¡£Ã»ÓÐ mbstring À©Õ¹µÄ phpMyAdmin ²»ÄÜÕýȷʶ±ð×Ö·û´®£¬¿ÉÄܲúÉú²»¿ÉÒâÁϵĽá¹û.
----------------------------------------------
½â¾ö°ì·¨£¬ÐÞ¸Ä "c:/windows/php.ini" ²éÕÒextension=php_mbstring.dll È¥µôÇ°ÃæµÄ";"×¢ÊÍ·û£¬±£´æ¡£
È»ºó½« "php°²×°Ä¿Â¼/ext/php_mbstring.dll"¿½±´µ½ "c:/windows/system32" Ï£¬ ÖØÆôapache¼´¿É¡£
Ïà¹ØÎĵµ£º
Ê×ÏÈÕâ2¸öº¯Êý¶¼ÊǾßÓÐÌæ»»×Ö·û¹¦Äܵġ£µ«ÊÇstrtr±Èstr_replaceÐÔÄÜÉÏÒª¿é4±¶¡£¾ßÌåÇé¿öÇë¿´ÈçÏ·ֽ⣺
Ê×ÏÈÊÇstrtrº¯Êý£º
ʵÀý1£ºµ±
ÒÔÏÂΪÒýÓõÄÄÚÈÝ£º
<?php
//Õâ¸öʱºòÊä³öµÄΪbaicai¶ø²»ÊÇbai123cai,ÒòΪstr("pao")<strlen("bai123")
echo strtr("paocai!","pao","bai123");
?>
ʵÀý2£ºµ±±»Ìæ»»µÄÖ ......
Õ⼸ÌìÔÚ×öÒ»¸öÓÃphpÊÕ·¢ÓʼþµÄÏîÄ¿£¬²Å·¢ÏÖÓÐÌ«¶àµÄ¶«Î÷ҪѧÁË£¬ÎªÁËÒԺ󷽱㣬»òÕ߸ø»¹Ã»ÓнӴ¥Õâ·½ÃæµÄÈË·½±ã£¬ÎÒ°ÑÕâЩ֪ʶ¸ø¼Ç¼ÏÂÀ´¡£ ÏÈ¿´¿´ÓÐÄÄЩ·½·¨¿ÉÒÔʵÏÖ phpÊÕ·¢Óʼþ¡£ 1¡¢ÓÃfsocketÕâÖÖ·½·¨ÒªÓõ½pop3µÄÃüÁÕâÖÖ·½·¨Á¬½Ó»òÕß½ÓÊÕµÄËٶȱȽϿ졣 POP3ÃüÁîÂëÈçÏ£º
ÃüÁî ²ÎÊý ״̬ ÃèÊö
- ......
MySQL »á×Ô¶¯¶Ï¿ª IDLE ʱ¼ä³¬¹ý 8 СʱµÄÊý¾Ý¿âÁ¬½Ó£¬´Ó¶øµ¼ÖÂһЩ»ùÓÚÊý¾Ý¿âÁ¬½ÓµÄÓ¦ÓóÌÐò£¬ÌرðÊÇ WEB Ó¦ÓóÌÐò³ö´í¡£
ÓÐÁ½¸ö°ì·¨¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣺
µÚÒ»¸ö°ì·¨ÊÇÐÞ¸Ä MySQL µÄÅäÖòÎÊý¡£Õâ¸ö²ÎÊýµÄÃû³ÆÊÇ wait_timeout
£¬ÆäĬÈÏֵΪ 28800(µ¥Î»Ãë)£¬¸ÕºÃ¾ÍÊÇ 8 Сʱ¡£ÆäÒâÒåΪ¹Ø±ÕÒ»¸öÁ¬½Ó֮ǰÔÚÕâ¸öÁ¬½ÓÉϵ ......
user±í:
id | name
———
1 | libk
2 | zyfon
3 | daodao
user_action±í:
user_id | action
—————
1 | jump
1 | kick
1 | jump
2 | run
4 | swim
sql:
select id, name, action from user as u
left join user_action a on u.id = a.user_id
result:
id | ......
<?php
function checkMobile($str)
{
$pattern = "/^(13|15)\d{9}$/";
if (preg_match($pattern,$str))
{
Return true;
}
else
{
Return false;
}
}
$str = checkMobile("15800000001");
......