¡¡¡¡
ÈçºÎÁ¬½ÓÊý¾Ý¿â£º
PHP¼òÖ±¾ÍÊÇÒ»¸öº¯Êý¿â£¬·á¸»µÄº¯ÊýʹPHPµÄijЩµØ·½Ï൱¼òµ¥¡£½¨Òé´ó¼ÒdownÒ»±¾PHPµÄº¯ÊýÊֲᣬ×ÜÓõĵ½¡£
ÎÒÕâÀï¾Í¼òµ¥ËµÒ»ÏÂÁ¬½ÓMySQLÊý¾Ý¿â¡£
1¡¢mysql_connect
´ò¿ªMySQL·þÎñÆ÷Á¬½Ó¡£
Óï·¨£ºint mysql_connect(string [hostname] [ ort], string [username], string [password]);
·µ»ØÖµ£ºÕûÊý
±¾º¯Êý½¨Á¢ÓëMySQL ÎñÆ÷µÄÁ¬½Ó¡£ÆäÖÐËùÓеIJÎÊý¶¼¿ÉÊ¡ÂÔ¡£µ±Ê¹Óñ¾º¯ÊýÈ´²»¼ÓÈκβÎÊýʱ£¬²ÎÊýhostnameµÄĬÈÏֵΪlocalhost¡¢²ÎÊýusernameµÄĬÈÏֵΪPHPÖ´ÐÐÐг̵ÄÓµÓÐÕß¡¢²ÎÊýpasswordÔòΪ¿Õ×Ö·û´®£¨¼´Ã»ÓÐÃÜÂ룩¡£¶ø²ÎÊýhostnameºóÃæ¿ÉÒÔ¼ÓðºÅÓë¶Ë¿ÚºÅ£¬´ú±íʹÓÃÄĸö¶Ë¿ÚÓëMySQLÁ¬½Ó¡£µ±È»ÔÚʹÓÃÊý¾Ý¿âʱ£¬ÔçµãʹÓÃmysql_close()½«Á¬½Ó¹Øµô¿ÉÒÔ½ÚÊ¡×ÊÔ´¡£
2¡¢ mysql_select_db
Ñ¡ÔñÒ»¸öÊý¾Ý¿â¡£
Óï·¨£ºint mysql_select_db(string database_name, int [link_identifier]);
·µ»ØÖµ£ºÕûÊý
±¾º¯ÊýÑ¡ÔñMySQL·þÎñÆ÷ÖеÄÊý¾Ý¿âÒÔ¹©Ö®ºóµÄ×ÊÁϲéѯ×÷Òµ(query)´¦Àí¡£³É¹¦·µ»Øtrue£¬Ê§°ÜÔò·µ»Øfalse¡£
×î¼òµ¥µÄÀý×Ó¾ÍÊÇ£º
$conn=mysql_connect ("127.0.0.1", "", "");
mysql_select_db("shop");
Á¬½Ó»úMySQLÊý¾Ý¿â£¬´ò¿ªSHOPÊý¾Ý¿â¡£ÔÚʵ¼ÊÓ¦ÓÃÖÐÓ¦µ±¼ÓÇ¿µã´íÎóÅжÏ
¶ÁÈ¡Êý¾Ý
ÏÈ¿´Á½¸öº¯Êý£º
1¡¢mysql_query
ËͳöÒ»¸öquery×Ö·û´®¡£
Óï·¨£ºint mysql_query(string query, int [link_identifier]);
·µ»ØÖµ£ºÕûÊý
±¾º¯ÊýËͳöquery×Ö·û´®¹©MySQL×öÏà¹ØµÄ´¦Àí»òÕßÖ´ÐС£ÈôûÓÐÖ¸¶¨link_identifier²ÎÊý£¬Ôò³ÌÐò»á×Ô¶¯Ñ°ÕÒ×î½ü´ò¿ªµÄID¡£µ±query²éѯ×Ö·û´®ÊÇUPDATE¡¢INSERT¼°DELETEʱ£¬·µ»ØµÄ¿ÉÄÜÊÇtrue»òÕßfalse£»²éѯµÄ×Ö·û´®ÊÇSELECTÔò·µ»ØÐµÄIDÖµ£¬µ±·µ»Øfalseʱ£¬²¢²»ÊÇÖ´Ðгɹ¦µ«ÎÞ·µ»ØÖµ£¬¶øÊDzéѯµÄ×Ö·û´®ÓдíÎó¡£
2¡¢mysql_fetch_object
·µ»ØÀà×ÊÁÏ¡£
Óï·¨£ºobject mysql_fetch_object(int result, int [result_typ]);
·µ»ØÖµ£ºÀà
±¾º¯ÊýÓÃÀ´½«²éѯ½á¹ûresult²ðµ½Àà±äÁ¿ÖС£ÈôresultûÓÐ×ÊÁÏ£¬Ôò·µ»ØfalseÖµ¡£
¿´Ò»¸ö¼òµ¥µÄÀý×Ó£º
$exec="select * from user";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
echo "username:".$rs->username."
";
}
?>
µ±È»£¬±íuserÖÐÓÐÒ»¸öusernameµÄ×ֶΣ¬Õâ¾ÍÀàËÆaspÖеÄ
<%
exec="select * from user"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
do while not rs.eof
response.write "username:"&rs("username")&"
"
rs.movenext
loop
%>