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
Ïà¹ØÎÊ´ð£º
<!--¹ºÂòÊýÁ¿-->
<div class='buyinfo'>
<table width='auto'>
<tr>
<td><span>¹ºÂòÊýÁ¿£º</sp ......
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:
......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
µÃµ½¿Í»§¶ËIPÀÏÎÊÌâÁË£¬µ«Õâ´Î»·¾³Óе㲻һÑù£¨ ¿Í»§ÊÇÕâÑùµÄ»·¾³Ã»°ì·¨£¬ËµBTµÄÇëÆ®¹ý :) £©¡£
win2k3¸Ãϵͳ£¨Ï³ÆÏµÍ³A£©ÉÏ×°ÁËVMware Server£¬VMÏÂÓиöwin2k3ϵͳ(ϳÆÏµÍ³B)¡£
ϵͳA£ºÖ±½ÓÁ¬½Ó¹«Íø¡£Óй«ÍøI ......
ÎÒµÄÏîÄ¿ËùÔڵĻ·¾³ÊÇphp+apache+linux
ÏÖÎÒÖØÆô·þÎñÊÇ service httpd restart
ÏÖÎÒÏë¶¨Ê±ÖØÆô´ËÏî·þÎñ£¨¶¨ÔÚÿÌìÏÂÎç4µã£© ÔõôʵÏÖѽ£¬¶àл
crontab
* 16 * * * service httpd restart
ѧϰ + d ......