PHP ʖ²ἯTH º󍋼/A LXIII. MySQL º¯ʽ¿⼯H1 ģ¿ɒԊ¹Ӄ¸ú¯ʽ¿ⷃΊ MySQL ʽ¾ݿⷾαƷ¡£Ӑ¹ؠMySQL µďꏸЅϢ¿ɒԵ½ http://www.mysql.com/ ²鑯¡£ MySQL µĎĵµ¿ɒԔڠ http://www.mysql.com/documentation/ Ւµ½¡£ Шdz ΪKĜ¹»˳;µĊ¹Ӄ¸ú¯ʽ¿⣬ģ±ؐ딚±ҫ PHP µĊ±º򌭼ӠMySQL µĖ§³֡£ °²װ ¾¯¸漯B ԋАʱŤփ բЩº¯ʽµĐЎªʜµ½ȫ¾ּA HREF="configuration.html#configuration.file" Ťփ΄¼þ php.ini µē°Ϭ¡£ ѡϮû³Ƽ/TH Ĭȏֵ ¿ɱ䵄 mysql.allow_persistent "On" PHP_INI_SYSTEM mysql.max_persistent "-1" PHP_INI_SYSTEM mysql.max_links "-1" PHP_INI_SYSTEM mysql.default_port NULL PHP_INI_ALL mysql.default_socket NULL PHP_INI_ALL mysql.default_host NULL PHP_INI_ALL mysql.default_user NULL PHP_INI_ALL mysql.default_password NULL PHP_INI_ALL mysql.connect_timeout "0" PHP_INI_SYSTEM µ±ʹӃ±¾µ؁¬½ӵĊ±º򣬄¬ȏµĠsocket û³ơ£ ׊Դ Ѝ Ԛ MySQL ģ¿閐ʹӃK}֖׊Դ Ѝ¡£µڒ»֖ʇʽ¾ݿⵄl½Ӿ䱺£¬µڶþ֖ʇ SQL ²鑯·µ»صĽṻ¼¯¡£ Ԥ¶¨ҥ³£ ³£ èʶ MYSQL_CLIENT_COMPRESS ʹӃѹ˵µč¨ѶЭҩ MYSQL_CLIENT_IGNORE_SPACE ԊЭԚº¯ʽûº󁴿ո񎻼/TD MYSQL_CLIENT_INTERACTIVE ³£ èʶ MYSQL_ASSOC MYSQL_BOTH MYSQL_NUM ·¶= =ד 1. MySQL )չ·¶= ?php /* l½ӑ¡Աʽ¾ݿ⠪/ $link = mysql_connect("mysql_host", "mysql_user", "mysql_password") or die("Could not connect"); print "Connected successfully"; mysql_select_db("my_database") or die("Could not select database"); /* ִА SQL ²鑯 */ $query = "SELECT * FROM my_table"; $result = mysql_query($query) or die("Query failed"); /* Ԛ HTML ֐´򓡽ṻ */ print "table \n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {print "\t tr \n"; foreach ($line as $col_value) {print "\t\t td $col_value /td \n";} print "\t /tr \n";} print" /table \n"; /* ʍ·ŗʔ´ */ mysql_free_result($result); /* ¶Ͽªl½Ӡ*/ mysql_close($link);? º󍋼/A ưµ㼯A msql ɏһ¼¶ mysql_affected_rows