mysql浣跨敤浠€涔堝嚱鏁版潵鎵цmysql璇彞
瀹氫箟鍜岀敤娉?/p>
mysql_query() 鍑芥暟鎵ц涓€鏉?MySQL 鏌ヨ銆?/p>
璇硶
mysql_query(query,connection)鍙傛暟 鎻忚堪
query 蹇呴渶銆傝瀹氳鍙戦€佺殑 SQL 鏌ヨ銆傛敞閲婏細鏌ヨ瀛楃涓蹭笉搴斾互鍒嗗彿缁撴潫銆?/p>
connection 鍙€夈€傝瀹?SQL 杩炴帴鏍囪瘑绗︺€傚鏋滄湭瑙勫畾锛屽垯浣跨敤涓婁竴涓墦寮€鐨勮繛鎺ャ€?/p>
璇存槑
濡傛灉娌℃湁鎵撳紑鐨勮繛鎺ワ紝鏈嚱鏁颁細灏濊瘯鏃犲弬鏁拌皟鐢?mysql_connect() 鍑芥暟鏉ュ缓绔嬩竴涓繛鎺ュ苟浣跨敤涔嬨€?/p>
杩斿洖鍊?/p>
mysql_query() 浠呭 SELECT锛孲HOW锛孍XPLAIN 鎴?DESCRIBE 璇彞杩斿洖涓€涓祫婧愭爣璇嗙锛屽鏋滄煡璇㈡墽琛屼笉姝g‘鍒欒繑鍥?FALSE銆?/p>
瀵逛簬鍏跺畠绫诲瀷鐨?SQL 璇彞锛宮ysql_query() 鍦ㄦ墽琛屾垚鍔熸椂杩斿洖 TRUE锛屽嚭閿欐椂杩斿洖 FALSE銆?/p>
闈?FALSE 鐨勮繑鍥炲€兼剰鍛崇潃鏌ヨ鏄悎娉曠殑骞惰兘澶熻鏈嶅姟鍣ㄦ墽琛屻€傝繖骞朵笉璇存槑浠讳綍鏈夊叧褰卞搷鍒扮殑鎴栬繑鍥炵殑琛屾暟銆傚緢鏈夊彲鑳戒竴鏉℃煡璇㈡墽琛屾垚鍔熶簡浣嗗苟鏈奖鍝嶅埌鎴栧苟鏈繑鍥炰换浣曡銆?/p>
鎻愮ず鍜屾敞閲?/p>
娉ㄩ噴锛氳鍑芥暟鑷姩瀵硅褰曢泦杩涜璇诲彇鍜岀紦瀛樸€傚闇€杩愯闈炵紦瀛樻煡璇紝璇蜂娇鐢?mysql_unbuffered_query()銆?/p>
渚嬪瓙 1
$con = mysql_connect("localhost","mysql_user","mysql_pwd");
if (!$con)
{
die("Could not connect: " . mysql_error());
}
$sql = "SELECT * FROM Person";
mysql_query($sql,$con);
// 涓€浜涗唬鐮?/p>
mysql_close($con);
?>
渚嬪瓙 2
閫氳繃 mysql_query() 鍑芥暟鍒涘缓涓€涓柊鏁版嵁搴擄細
$con = mysql_connect("localhost","mysql_user","mysql_pwd");
if (!$con)
{
die("Could not connect: " . mysql_error());
}
$sql = "CREATE DATABASE my_db";
if (mysql_query($sql,$con))
{
echo "Database my_db created";
}
else
{
echo "Error creating database: " . mysql_error();
}
?>