<?<span>php
</span><span>
<span>header</span>(
"content-type:text/html;charset=utf8"
<span>);
</span><span>
<span>
$link
</span>=<span>mysql_connect</span>(
'localhost'
,
'root'
,
'root'
)
or
<span>
die
</span> (
'连接失败'
<span>);
</span><span>
<span>mysql_select_db</span>(
'数据库名'
<span>);
</span><span>
mysql_set_charset(
'utf8'
<span>);
</span><span>
<span>
$sql
</span>=
"select * from user"
<span>;
</span><span>
<span>
$result
</span>=<span>mysql_query</span>(<span>
$sql
</span><span>);
</span><span>
<span>
if
</span>(<span>
$result
</span> && <span>mysql_affected_rows</span>()>0<span>){
</span><span>
echo
</span>
'查询成功'
<span>;
}</span><span>
else
</span><span>{
</span><span>
echo
</span>
'查询失败'
<span>;
}
</span><span>
<span>mysql_close</span><span>();
</span><span>
<span>
require
</span> ,<span>
include
</span><span>
<span>mysql_connect</span>(
'localhost'
,
'root'
,
'root'
)<span>
<span>mysql_select_db</span>(
'数据库名'
)<span>
mysql_set_charset(
'utf8'
)<span>
<span>mysql_errno</span>()<span>
<span>mysql_error</span>()<span>
<span>mysql_query</span>(
'sql语句'
)<span>
<span>mysql_free_result</span>(<span>
$result
</span>)<span>
<span>mysql_close</span>()<span>
<span>mysql_affected_rows</span>(<span>
$link
</span>)<span>
<span>mysql_insert_id</span>(<span>
$link
</span>)<span>
<span>mysql_num_rows</span>(<span>
$result
</span>)<span>
<span>mysql_fetch_array</span>(<span>
$result
</span>)<span>
<span>mysql_fetch_row</span>(<span>
$result
</span>)<span>
<span>mysql_fetch_assoc</span>(<span>
$result
</span>)<span>