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