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

PHP±¸·ÝÊý¾Ý¿âÔ­ÀíºÍ·½·¨

php100ѧϰ
Ô´Â룺http://bbs.php100.com/read-htm-tid-11052.html
1¡¢PHP±¸·ÝÊý¾Ý¿âµÄÔ­Àí
2¡¢PHPÖÐmysqlÏà¹Øº¯Êý
mysql_list_tables() ±í²éѯº¯Êý£¬ÀàËÆmysql_query() º¯Êý
mysql_fetch_field() ×Ö¶ÎÐÅÏ¢º¯Êý£¬·µ»Ø¾ä±ú
Name ×ֶεÄÃû³Æ
Table ×Ö¶ÎËùÊôÊý¾Ý±íµÄÃû³Æ
Type ×ֶεÄÀàÐÍ
max_length ×ֶεÄ×î´ó³¤¶È
not_null ×Ö¶ÎÊÇ·ñ²»ÄÜΪ¿Õ£¬ÊÇ£¬ÔòÕâÒ»ÏîµÄֵΪ1
primary_key ×Ö¶ÎÊÇ·ñΪÖ÷¼ü£¬ÊÇ£¬ÔòÕâÒ»ÏîµÄֵΪ1
unique_key ×Ö¶ÎÊÇ·ñΪunique¼ü£¬ÊÇ£¬ÔòÕâÒ»ÏîµÄֵΪ1
multiple_key ×Ö¶ÎÊÇ·ñ²»Îªunique¼ü£¬ÊÇ£¬ÔòÕâÒ»ÏîµÄֵΪ1
Numeric ×Ö¶ÎÊÇ·ñΪÊý×ÖÐÍ£¬ÊÇ£¬ÔòÕâÒ»ÏîµÄֵΪ1
Blob ×Ö¶ÎÊÇ·ñΪblobÐÍ£¬ÊÇ£¬ÔòÕâÒ»ÏîµÄֵΪ1
Unsigned Êý×ÖÐ͵Ä×Ö¶ÎÊÇ·ñΪunsignedµÄ£¬ÊÇ£¬ÔòÕâÒ»ÏîµÄֵΪ1
Zerofill Êý×ÖÐ͵Ä×Ö¶ÎÊÇ·ñΪzerofilledµÄ£¬ÊÇ£¬ÔòÕâÒ»ÏîµÄֵΪ1
3¡¢±¸·ÝʱºòµÄ×¢ÒâÊÂÏî
 ×¢ÒâÊý¾Ý¿âµÄ´óС£¬¹ý´ó»òÕß¹ý¶àµÄ±í·Ö¶Î´¦Àí
 Éú³ÉµÄSQLÎļþÃû»òÕß´æ·Å²»Ò×±»²Âµ½
 ±¸·ÝÉú³ÉÎļþ¿ÉÒÔ±í»òÕß×Ö¶ÎΪµ¥Î»±£´æ
 ¿ÉÒÔʹÓÃZIP×é¼þѹËõÉú³ÉµÄÎļþÒԱ㱣³Ö
ÏÂÔØµÄÒ»¸öÔ´Â룺
http://www.cnpeng.org/php/upload/mysql_backup.rar


Ïà¹ØÎĵµ£º

ÎÒÑ¡ÔñµÄPHP¿ªÔ´ÍøÉÏÉ̳Ç

Õâ¶Îʱ¼äÔÚÒ»¸öµç×ÓÉÌÎñ¹«Ë¾´ýÔÚ£¬ËùÒÔ½Ó´¥µ½ºÜ¶àµç×ÓÉÌÎñµÄ¸ÅÄî¡£
Ò²½Ó´¥µ½ÁËÒ»¸öȫеĵç×ÓÉÌÎñģʽ¡£ÕâÀïÓÉÓÚÉæ¼°µ½Á˹«Ë¾µÄÓªÏú
²ßÂÔ·½ÃæµÄÉÌÎñ»úÃÜ£¬ËùÒÔ²»±ã¹ý¶àµÄ̸¼°¡£
²»¹ýÒ»¸öºÃµÄidea£¬×ÜÊǻṴÆðºÜ¶àµÄ²»Î·Ê§°ÜµÄ³¢ÊÔ¡£ÎҾʹÓ×î»ù
´¡µÄµç×ÓÉÌÎñ¿ªÊ¼ß·¡£
¸ÕºÃÓиöÅóÓÑ×¼±¸×öÊÖ»úµÄµç×ÓÉÌÎñ£¬ÓÃǰ¼¸ÆªÎÄÕÂÌá ......

php½Ì³Ì£ºmysqlµÄ³£ÓÃÓï¾ä

¹ØÓÚ PHP ½Ì³ÌµÄÎÄÕÂÒѾ­ºÜ¶àÁË£¬½ñÌì¸ø´ó¼Ò½éÉܼ¸¸ö³£ÓõÄMYSQLÓï¾ä¡£
ÏÔʾÊý¾Ý¿â»ò±í:
show databases;//È»ºó¿ÉÒÔuse database_name;
show tables;
¸ü¸Ä±íÃû:
alter table table_name rename new_t;
Ìí¼ÓÁÐ :
alter table table_name add column c_n column attributes;
ɾ³ýÁÐ:
alter table table_name ......

dz̸php²å¼þÀ©Õ¹

 ×î½üÍ»·¢ÆæÏ룬.net¶¼ÓÐÃüÃû¿Õ¼ä»úÖÆ£º
       using System.data;.......,
  ÎÒÃÇÔÚ¿ª·¢phpʱ£¬ÊÇ·ñÒ²ÄÜʵÏÖÕâÖÖ»úÖÆÄØ£¬ÎÒÃÇÖªµÀÏÖÔÚµÄphp v5.2.9»¹²»Ö§³ÖÃüÃû¿Õ¼äµÄ¸ÅÄ
  µ«Ïà¹Øphp v5.3µÄ ×ÊÁϱíÃ÷ ÒѾ­Ê¹ÓÃÃüÃû¿Õ¼äµÄ¸ÅÄî £º
    &nb ......

ÈçºÎÀûÓÃAPC»º³åPHP½Å±¾À´Ìá¸ß·þÎñÆ÷ÐÔÄÜ

Ô­Ìù£ºhttp://www.phpchina.com/html/05/n-2005.html
ÈçºÎÀûÓÃAPC»º³åPHP½Å±¾À´Ìá¸ß·þÎñÆ÷ÐÔÄÜ
·¢²¼Ê±¼ä:2006-10-16 09:01 ¡¡¡¡×÷Õß: bulider.com.cn ¡¡¡¡ÐÅÏ¢À´Ô´:
bulider.com.cn¡¡¡¡[ÎÒÀ´ËµÁ½¾ä
(3765
Ìõ)]
ѧ»áÔõÑùÀûÓÃAPC
»º³åPHP
½Å±¾À´Ìá¸ß·þÎñÆ÷ÐÔÄÜ¡£
Ï£
ÍûÄúµÄWeb·þÎñÆ÷·¢»Ó×î´óµÄÐÔÄÜÂð£¿Èç¹ûÄúÕýÔÚÊ ......

ÖÕÓڸ㶨PHPÁ¬½ÓSQLServer2005.

ΪÁËphpÁ¬½Ósql2005 ,ÎÒÔÚÍøÂçÉÏÕÒÁËÒ»´ó¶Ñ×ÊÁÏÔÚÎÒµÄcsdn²©¿ÍÖÐ.ÍíÉÏ3:05·ÖʱºòÖÕÓڸ㶨ÁË phpÁ¬½Ósql2005µÄÎÊÌâ,ÏÖÔÚÕûºÏ,ͬʱ°ÑFAQÕûºÏÉÏ. ÎÒÇ°ÃæÐ´µÄ½Ì³Ì: Á¬½ÓǰÅäÖÃϵͳ: 1.¼ì²éÎļþ php5.2.5\ntwdblib.dll ĬÈÏÏÂÃæÓÐÒ»¸ö,²»ÄÜÁ¬½ÓÔÙÌæ»». ÏÂÔØÕýÈ·°æ±¾µÄ ntwdblib.dll (2000.80.194.0)£¬µØÖ·£º http://webzila ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ