Ò²Ì¸ PHP ºÍ MYSQL

5年以前 | 阅读数：678 次 | 编程语言：PHP

½«PHPºÍMYSQLºÏÀiÇÒÓÐÐ§µÄ½aºÏÔÚÒ»Æð¿ÉÒÔÖÆ×÷³o¾«ÖÂµÄÊý¾Ý¿aÍøÕ¾¡£MYSQLÊÇÒ»ÖÖÐ¡ÐÍµÄ£¬½oÃÜµÄÊý¾ÝþÎñÆ÷£¬Ö§³Ö±e×¼SQL¡£ËuÔÚUNIXºÍWINDOWS»¾³ÏÂ¶¼ÄÜ¹»Ê¹ÓÃ¡£
PHPºÍMYSQL¶¼ÊÇÃaÑµÄ¿ªÅÔ´Âe¡£ËuÃÇµÄ½aºÏ¿ÉÒÔÔÚWINDOWSÖÐ¢Õ¹£¬ÔÚUNIXÖÐ×oþÎñ¡£PHPÒ²Ö§³ÖÆaËuÒ»Ð(C)Êý¾Ý¿a°uÀ¨PostgreSQL.

ÏÂÃaeÓÐÒ»¸oÀý×Ó£º
Ê×ÏÈÄaÒÑ¾°²×°ÁËPHP¼°MYSQL. Õa¸o¼oµ¥µÄ½Å±¾Àý×ÓÊÇ´ÓÊý¾Ý¿aÖÐ¶ÁÈ¡Êý¾ÝÈ»ºoÏÔÊ¾³oÀ´¡£

$db = mysql_connect("localhost", "root");
mysql_select_db("mydb", $db);
$result = mysql_query("SELECT * FROM books",$db);
echo "Title: ".mysql_result($result,0,"title")."
\n";
echo "Author: ".mysql_result($result,0,"author")."
\n";
echo "Price: ".mysql_result($result,0,"price")."
\n";

º¯Êýmysql_connect()ÊÇÖ¸ÔÚÖ¸¶¨µÄÖ÷»uÉÏÍ¨¹ýÓÃ»§Ãu£¨Ò²¿ÉÍ¨¹ýÖ¸¶¨ÃÜÂe£(C)Á¬½ÓÒ»¸oMYSQL*þÎñÆ÷¡£±aÁ¿ $db ÊÇÓÃÀ´Ìa½»Õa¸oÁ¬½Ó¡£.

mysql_select_db() Ö¸¶¨Êý¾Ý¿aÓÃÔÚºoÃaeµÄÒÉÎÊ¡£º¯Êý mysql_query() ÊÇ¢ËÍ SQL ÒÉÎÊµ½ MySQL ½øÐÐÖ´ÐÐ £¬ ½a¹uµ»Ø²¢´ae´¢ÔÚ±aÁ¿ $result ÖÐ.

×iºo mysql_result() º¯ÊýÊÇµÃ³o½a¹u¡£