phpstudyÔõôŲÓÃÊý¾Ý¿â
ʹÓà php study ŲÓÃÊý¾Ý¿â°ì·¨ÈçÏ£ºµ¼Èë sql Îļþ²¢Ñ¡ÕªÒª²Ù×÷µÄÊý¾Ý¿â°æ±¾£»Ê¹Óà mysql_connect() ÅþÁ¬µ½Êý¾Ý¿â£¬ÌṩÖ÷»ú¡¢Óû§Ãû¡¢ÃÜÂëºÍÊý¾Ý¿âÃû£»Ê¹Óà mysql_select_db() Ñ¡ÕªÒª²Ù×÷µÄÊý¾Ý¿â£»Ê¹Óà mysql_query() Ö´ÐÐ sql ÅÌÎÊ£»Ê¹Óà mysql_fetch_assoc() »ñÈ¡ÅÌÎÊЧ¹û£»Ê¹Óà mysql_close() ¹Ø±ÕÊý¾Ý¿âÅþÁ¬¡£
ÔõÑùʹÓà PHP Study ŲÓÃÊý¾Ý¿â
1. µ¼ÈëÊý¾Ý¿â
·¿ª PHP Study ¿ØÖÆÃæ°å£¬µã»÷¡°Êý¾Ý¿â¡±¡£
µã»÷¡°µ¼ÈëÊý¾Ý¿â¡±£¬Ñ¡ÕªÒªµ¼ÈëµÄ SQL Îļþ¡£
Ñ¡ÕªÒªµ¼ÈëÊý¾Ý¿âµÄ MySQL °æ±¾¡£
2. ÅþÁ¬Êý¾Ý¿â
·¿ª PHP Îļþ»òÒ³Ãæ¡£
ʹÓà mysql_connect() º¯ÊýÅþÁ¬µ½Êý¾Ý¿â¡£
$host = 'localhost'; $user = 'username'; $password = 'password'; $database = 'database_name'; $conn = mysql_connect($host, $user, $password);
µÇ¼ºó¸´ÖÆ
3. Ñ¡ÔñÊý¾Ý¿â
Á¬Ã¦Ñ§Ï°¡°PHPÃâ·ÑѧϰÌõ¼Ç£¨ÉîÈ룩¡±£»
ʹÓà mysql_select_db() º¯ÊýÑ¡ÕªÒª²Ù×÷µÄÊý¾Ý¿â¡£
mysql_select_db($database, $conn);
µÇ¼ºó¸´ÖÆ
4. Ö´ÐÐ SQL ÅÌÎÊ
ʹÓà mysql_query() º¯ÊýÖ´ÐÐ SQL ÅÌÎÊ¡£
$query = 'SELECT * FROM users'; $result = mysql_query($query, $conn);
µÇ¼ºó¸´ÖÆ
5. ´¦ÀíÅÌÎÊЧ¹û
ʹÓà mysql_fetch_assoc() º¯Êý»ñÈ¡ÅÌÎÊЧ¹û¡£
while ($row = mysql_fetch_assoc($result)) { // ´¦ÀíÊý¾Ý }
µÇ¼ºó¸´ÖÆ
6. ¹Ø±ÕÅþÁ¬
ʹÓà mysql_close() º¯Êý¹Ø±ÕÊý¾Ý¿âÅþÁ¬¡£
mysql_close($conn);
µÇ¼ºó¸´ÖÆ
ÒÔÉϾÍÊÇphpstudyÔõôŲÓÃÊý¾Ý¿âµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡