Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

php ÖÐʹÓÃlikeʱ Ôõô²»Çø·Ö´óСд£¿

ÔÚPHPÖУ¬Ê¹ÓÃlike²éѯÄÚÈÝʱ ÈçºÎ²»Çø·Ö´óСд£¿
Linuxϵͳ
¾ÍÊÇÊäÈëµÄ¹Ø¼ü´ÊÊÇ love ʱ£¬Êý¾Ý¿âÖÐΪLove LOVE lovE¶¼ÄÜÆ¥Åä
²¹³ä£º ÊÇmysqlÊý¾Ý¿â´æ
ʹÓÃÕâÑùµÄÓï¾ä£ºsql="select * from abc where a_name like '%$keyword%'";


ÄãÓõÄÊÇʲôÊý¾Ý¿â
Èç¹ûÊÇmysqlµÄ»° ²éѯµÄʱºòĬÈϾÍÊDz»Çø·Ö´óСд

ÄãÊÇ˵µÄSQLÓï¾äÖеÄLIKEÂð£¿Èç¹ûÊÇSQLÓï¾äÖеÄLIKEµÄ»°£¬ÄÇÊÇÒÔΪÄãÔÚ½¨Á¢Êý¾Ý¿â±íµÄʱºòʹÓÃÁ˶þ½øÖÆ£¬È¡ÏûÁ˾ͿÉÒÔ

Ïà·´ Èç¹ûÄã񻂿·Ö´óСдµÄ»° ÐèÒªÔÚ²éѯÓï¾äµÄwhere¹Ø¼ü×ÖºóÃæ¼Óbinary¹Ø¼ü×Ö

Çø·Ö´óСд£º
SELECT * from table WHERE BINARY Ìõ¼þ


ÓдíÎóÇëÌá³ö

ʹÓöþ½øÖÆ£¿ÎÒÓõÄ×Ö¶ÎÀàÐÍÊÇvarchar

Õâ¸öÊǺÍÄã¸Ã×ֶεÄCollationsÏà¹ØµÄ
CollationsÒÔ_ci½áβµÄ´óСдÎÞ¹Ø
CollationsÒÔ_cs½áβµÄ´óСдÏà¹Ø

Ã÷°×ÁË£¬ÎÒÔ­À´ÊÇÉèÖóÉgbk_bin£¬¸Ä³Égbk_chinese_ci(ÒÔ_ci½áβµÄ´óСдÎÞ¹Ø)¾Í¿ÉÒÔÁË¡£Ð»Ð»´ó¼Ò¡£

´ÓÀ´²»ÓÃGBK£¬Ò»Ö±UTF8


Ïà¹ØÎÊ´ð£º

PHP³¬¼¶¼òµ¥ÎÊÌ⣬50·Ö - PHP / »ù´¡±à³Ì

<!--¹ºÂòÊýÁ¿-->
  <div class='buyinfo'>
  <table width='auto'>
  <tr>
  <td><span>¹ºÂòÊýÁ¿£º</sp ......

phpʱ¼äÕýÔòÎÊÌâ - PHP / »ù´¡±à³Ì

PHP code:

$date = '2009-12-25';
$ptn = '/([\d]{4})[- \/](0?[\d]|1[0-2])[-\/ ](0?[\d]|[1-2][\d]|3[0-1])/';
if (preg_match($ptn,$date,$out))
{
print_r($out);exit();
}
½á¹ûΪ:
PHP code:
......

php »ñÈ¡Ò³ÃæÄÚÈÝ - PHP / »ù´¡±à³Ì

Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......

PHP»ñÈ¡IP

µÃµ½¿Í»§¶ËIPÀÏÎÊÌâÁË£¬µ«Õâ´Î»·¾³Óе㲻һÑù£¨ ¿Í»§ÊÇÕâÑùµÄ»·¾³Ã»°ì·¨£¬ËµBTµÄÇëÆ®¹ý :) £©¡£
win2k3¸Ãϵͳ£¨Ï³ÆÏµÍ³A£©ÉÏ×°ÁËVMware Server£¬VMÏÂÓиöwin2k3ϵͳ(ϳÆÏµÍ³B)¡£
ϵͳA£ºÖ±½ÓÁ¬½Ó¹«Íø¡£Óй«ÍøI ......

linux ¶¨Ê±ÖØÆô·þÎñ£¬ÔÚÏßµÈ - PHP / »ù´¡±à³Ì

ÎÒµÄÏîÄ¿ËùÔڵĻ·¾³ÊÇphp+apache+linux
ÏÖÎÒÖØÆô·þÎñÊÇ service httpd restart 
ÏÖÎÒÏë¶¨Ê±ÖØÆô´ËÏî·þÎñ£¨¶¨ÔÚÿÌìÏÂÎç4µã£© ÔõôʵÏÖѽ£¬¶àл
crontab
* 16 * * * service httpd restart

ѧϰ + d ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ