php¸üÐÂÒ»×Ö¶Îij×Ö·û
±ÈÈ磺±í1×Ö¶Îtop °üÀ¨Êý¾Ý¡°a,b,c,d¡± ÎÒÒª¸üÐÂtop×Ö¶ÎÊý¾ÝΪ¡°a,c,d¡± Ò²¾ÍÊÇÈ¥µô¡°,b¡± µ«ÊÇ¡°,b¡±µÄλÖò»È·¶¨Ò²¿ÉÄÜÊÇ¡°a,c,d,b¡±
û¿´¶®ÄãµÄÎÊÌ⣬ÊǸüÐÂÊý¾Ý¿âÖеÄ×ֶΣ¿
Èç¹ûÄÇÑùÓ¦¸ÃÊÇSQLµÄÎÊÌâÁË
SQL code:
update tablename set top=replace(top,',b','');
ÕâÑùÖ»ÄÜÌæ»»¡®,b¡¯
ÒòΪ¡®,b¡¯µÄλÖÃÊDz»Ò»¶¨µÄ£¬ÓпÉÄÜ»áÊÇ¡®b¡¯£¬Ò²¾ÍÊÇ˵ÓпÉÄÜ¡®b¡¯ÅÅÔÚÇ°Ãæ»òºóÃæ
Õâ¾ÍÖ»ÄÜÓóÌÐòÍâÃæÊµÏÖÁË£¬±ÈÈçÓÃÕýÔò±í´ïʽ°ÑËüÌæ»»µô
Ö±½Ó°ÑÕûÁÐÌæ»»ÁËÄØ£¿
¶Ô£¡ÎÒ¾ÍÊÇÒ»¸öºÃµÄʵÁУ¡
SQL codeupdate t
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
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:
......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÕÐÆ¸Ö°Î»£ºÉè¼ÆÈËÔ±
ѧ Àú£º²»ÏÞ
Ö÷Òª¹¤×÷£ºÍøÒ³Éè¼Æ£¬Æ½ÃæÉè¼ÆµÈÉè¼ÆÀ๤×÷¡£
×îµÍÒªÇó£ºÖÁÉÙÓо«Í¨Ò»ÃÅÊìÁ·µÄÉè¼Æ¹¤¾ß£¬È磺PS¡¢AI¡¢FWµÈ¡£
н Ë®£ºÃæÒ飬ÊÔ¹¤×÷ÄÜÁ¦¶ø¶¨¡£
ÓÅÏÈ¿¼ÂÇÌõ¼þ£º
1. ´´Òâ˼Π......
ÒѾÐÞ¸ÄÁË
£¨1£©PHP.iniÖеÄpost_max_size ºÍupload_max_filesize£¬²¢ÇÒ±£Ö¤ÁËǰÕß´óÓÚºóÕß
£¨2£©Windows\System32\inetsvr\MetaBase.xmlÖеÄAspMaxRequestEntityAllowed
ÐÞ¸ÄÍê±Ïºó£¬ÖØÐÂÆô¶¯ÁËIIS·þÎñ£¬²¢ÇÒ¼Æ ......