(PHP 4, PHP 5)
mysql_query — 锟斤拷锟斤拷一锟斤拷 MySQL 锟斤拷询
锟斤拷锟斤拷展锟斤拷 PHP 5.5.0 锟斤拷锟窖凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 PHP 7.0.0 锟斤拷始锟斤拷锟狡筹拷锟斤拷应使锟斤拷 MySQLi 锟斤拷 PDO_MySQL 锟斤拷展锟斤拷锟芥换之锟斤拷锟轿硷拷 MySQL锟斤拷选锟斤拷 API 指锟斤拷锟皆硷拷锟斤拷锟� FAQ 锟斤拷锟斤拷取锟斤拷锟斤拷锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷校锟�
$query
[, resource $link_identifier = NULL
] ) : resource
mysql_query()
锟斤拷锟斤拷指锟斤拷锟斤拷 link_identifier 锟斤拷锟斤拷锟侥凤拷锟斤拷锟斤拷锟叫的碉拷前锟筋动锟斤拷锟捷库发锟斤拷一锟斤拷锟斤拷询锟斤拷锟斤拷支锟街讹拷锟斤拷锟斤拷询锟斤拷锟斤拷
querySQL 锟斤拷询锟斤拷锟�
锟斤拷询锟街凤拷锟斤拷锟斤拷应锟皆分号斤拷锟斤拷锟斤拷 锟斤拷询锟叫憋拷嵌锟斤拷锟斤拷锟斤拷锟接︼拷锟�锟斤拷确锟斤拷转锟斤拷锟斤拷
link_identifierMySQL
锟斤拷锟接★拷锟界不指锟斤拷锟斤拷锟接憋拷识锟斤拷锟斤拷使锟斤拷锟斤拷 mysql_connect()
锟斤拷锟斤拷蚩锟斤拷锟斤拷印锟斤拷锟斤拷没锟斤拷锟揭碉拷锟斤拷锟斤拷锟接ｏ拷锟结尝锟皆诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
mysql_connect()
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷没锟斤拷锟揭碉拷锟斤拷锟接伙拷锟睫凤拷锟斤拷锟斤拷锟斤拷锟接ｏ拷锟斤拷锟斤拷锟斤拷锟�
E_WARNING 锟斤拷锟斤拷拇锟斤拷锟�
mysql_query() 锟斤拷锟斤拷
SELECT锟斤拷SHOW锟斤拷DESCRIBE, EXPLAIN 锟斤拷锟斤拷锟斤拷锟斤拷锟�
锟斤拷浞碉拷锟揭伙拷锟� resource锟斤拷锟斤拷锟斤拷锟窖拷锟斤拷执锟斤拷锟斤拷蚍祷锟� FALSE锟斤拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵碉拷 SQL
锟斤拷洌拷锟斤拷锟絀NSERT, UPDATE, DELETE, DROP 之锟洁， mysql_query()
锟斤拷执锟叫成癸拷时锟斤拷锟斤拷 TRUE锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷 FALSE锟斤拷
锟斤拷锟截的斤拷锟斤拷锟皆从︼拷么锟斤拷莞锟� mysql_fetch_array() 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷,取锟斤拷锟斤拷锟截碉拷锟斤拷锟捷★拷
锟劫讹拷锟斤拷询锟缴癸拷锟斤拷锟斤拷锟皆碉拷锟斤拷 mysql_num_rows() 锟斤拷锟介看锟斤拷应锟斤拷 SELECT 锟斤拷浞碉拷锟斤拷硕锟斤拷锟斤拷校锟斤拷锟斤拷叩锟斤拷锟� mysql_affected_rows() 锟斤拷锟介看锟斤拷应锟斤拷 DELETE锟斤拷INSERT锟斤拷REPLACE 锟斤拷 UPDATE 锟斤拷锟接帮拷斓斤拷硕锟斤拷锟斤拷小锟�
锟斤拷锟矫伙拷锟饺拷薹锟斤拷什锟窖拷锟斤拷锟斤拷锟斤拷锟矫的憋拷时锟斤拷mysql_query()
也锟结返锟斤拷 FALSE锟斤拷
Example #1 锟斤拷效锟侥诧拷询
锟斤拷锟铰诧拷询锟斤法锟斤拷锟叫达拷锟斤拷锟�
mysql_query()
失锟杰诧拷锟斤拷锟斤拷 FALSE锟斤拷
<?php
$result = mysql_query('SELECT * WHERE 1=1');
if (!$result) {
die('Invalid query: ' . mysql_error());
}
?>
Example #2 锟斤拷效锟侥诧拷询
锟斤拷锟铰诧拷询锟斤法锟斤拷确锟斤拷锟斤拷锟斤拷 mysql_query() 锟斤拷锟斤拷锟斤拷一锟斤拷 resource锟斤拷
<?php
// 锟斤拷应锟斤拷锟斤拷锟矫伙拷锟结供,锟斤拷锟斤拷锟斤拷一锟斤拷示锟斤拷
$firstname = 'fred';
$lastname = 'fox';
// 锟斤拷锟斤拷锟窖�
// 锟斤拷锟斤拷执锟斤拷 SQL 锟斤拷玫姆锟绞�
// 锟斤拷锟斤拷锟斤拷锟接参硷拷 mysql_real_escape_string()
$query = sprintf("SELECT firstname, lastname, address, age FROM friends
WHERE firstname='%s' AND lastname='%s'",
mysql_real_escape_string($firstname),
mysql_real_escape_string($lastname));
// 执锟叫诧拷询
$result = mysql_query($query);
// 锟斤拷锟斤拷锟�
// 锟斤拷锟斤拷锟斤拷示锟斤拷实锟绞凤拷锟酵革拷 MySQL 锟侥诧拷询锟斤拷锟皆硷拷锟斤拷锟街的达拷锟斤拷锟斤拷缘锟斤拷院锟斤拷邪锟斤拷锟斤拷锟�
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
// 锟斤拷锟斤拷锟绞癸拷锟�
// 锟斤拷锟斤拷 print $result 锟斤拷锟斤拷锟斤拷取锟斤拷锟斤拷锟斤拷锟皆达拷械锟斤拷锟较�
// 锟斤拷锟皆憋拷锟斤拷锟斤拷锟斤拷使锟斤拷锟斤拷锟斤拷一锟斤拷 mysql 锟斤拷锟斤拷锟斤拷锟�
// 锟轿硷拷 mysql_result(), mysql_fetch_array(), mysql_fetch_row() 锟饺★拷
while ($row = mysql_fetch_assoc($result)) {
echo $row['firstname'];
echo $row['lastname'];
echo $row['address'];
echo $row['age'];
}
// 锟酵放癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟皆�
// 锟节脚憋拷锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷远锟斤拷锟斤拷锟�
mysql_free_result($result);
?>