PHP+mysql 2¼¶Áª¶¯ÏÂÀ
MYSQLÊý¾Ý¿âÊÇÕâÑùµÄ£º
area_id parent_id area_name
110000 0 ±±¾©
110101 110000 ¶«³ÇÇø
110102 110000 Î÷³ÇÇø
110103 110000 ³çÎÄÇø
230000 0 ºÚÁú½Ê¡
230100 230000 ¹þ¶û±õÊÐ
230102 230000 µÀÀïÇø
230103 230000 ÄϸÚÇø
310000 0 ÉϺ£ÊÐ
310101 310000 »ÆÆÖÇø
310103 310000 ¬ÍåÇø
...... ...... .....
ÇóÒ»¸ö2¼¶Áª¶¯ÏÂÀ²Ëµ¥£¡
ûÈË»áÂð£¿ÎÒÖ÷ÒªÊÇÊý¾ÝÁ¿±È½Ï´ó¡£¿ªÊ¼µãÒ³ÃæµÄ»°ÒªºÜ¾Ã.×Ô¼ºÓÃJSдµÄ²»ºÃ£¡
HTML code:
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<?
mysql_connect("localhost","root","");
mysql_select_db( "tt" );
$sql="select * from area_district where parent_id !='0'";
$result = mysql_query( $sql );
$count = 0;
while($res = mysql_fetch_row($result))
{
?>
subcat[
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......