php ¾²Ì¬sql
ÇëÎÊÓÐÄÄλ֪µÀÔõÑùÔÚphp´úÂëÖÐʵÏÖ¾²Ì¬sqlÂð£¿Ð»Ð»£¡
ʲô½Ð"¾²Ì¬SQL"???
ÍøÉÏÒ»²é£º
ÎÒÃÇÒ»°ãËù˵µÄ¾²Ì¬SQLÓï¾ä£¬ÊÇָÿ´Îµ÷ÓÃʱ£¬Óï¾äÊǹ̶¨µÄ£¨Óï¾äÖбäÁ¿µÄȡֵ¿ÉÄܻ᲻ͬ£©£»¶ø¶¯Ì¬SQLÓï¾ä£¬Ã¿´Îµ÷ÓÃʱ£¬Ôò¸ù¾Ýµ÷ÓÃÕßµÄÐèÒªÀ´ÁÙʱƴ³ö£¬ÕâÑùÓï¾ä¾ÍÊDz»¹Ì¶¨µÄ¡£
ÀàËÆÕâÖÖµÄ
$sql = "select * from table where id = '".$id."'";
¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
<!--¹ºÂòÊýÁ¿-->
<div class='buyinfo'>
<table width='auto'>
<tr>
<td><span>¹ºÂòÊýÁ¿£º</sp ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
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 ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÈçÌ⣬ÓÐûÓÐÕâÑùµÄphp´úÂë¡£ÎÒÏÖÔÚÏ뽫excelµÄÄÚÈݲåÈëmysqlÊý¾Ý¿â£¬Ï£Íû¿ÉÒÔ½«excelת³Éxml,È»ºó½âÎöxml²åÈëÊý¾Ý¿âÖС£Èç¹ûÓÐÕâÑùµÄ´úÂ룬ÉõÖÁÊÇÓÐÃûµÄ´úÂ룬һ¶¨Òª¸æËßÎÒ°¡¡£
ÏȶÁ excel => È»ºóÉú³É xml = ......