ݿ⣺
PHPֱһ⣬ḻĺʹPHPijЩط൱downһPHPĺֲᣬõĵ
ͼ˵һMySQLݿ⡣
1mysql_connect
MySQLӡ
int mysql_connect(string [hostname] [ ort], string [username], string [password]);
ֵ
MySQL ӡеIJʡԡʹñȴκβʱhostnameĬֵΪlocalhostusernameĬֵΪ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ݿ⡣ʵӦӦǿж
ȡ
ȿ
1mysql_query
ͳһqueryַ
int mysql_query(string query, int [link_identifier]);
ֵ
ͳqueryַMySQLصĴִСûָlink_identifierԶѰIDqueryѯַUPDATEINSERTDELETEʱصĿtruefalseѯַSELECTµIDֵfalseʱִгɹֵDzѯַд
2mysql_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
%>