首頁 >php教程 >php手册 >PHP数据库操作常用命令,php数据库常用命令

PHP数据库操作常用命令,php数据库常用命令

WBOY
WBOY原創
2016-06-13 08:49:37920瀏覽

PHP数据库操作常用命令,php数据库常用命令

<?<span>php
</span><span>//</span><span>设置字符集</span>
<span>header</span>("content-type:text/html;charset=utf8"<span>);
</span><span>//</span><span>连接数据库并判断成功与否</span>
<span>$link</span>=<span>mysql_connect</span>('localhost','root','root')or <span>die</span> ('连接失败'<span>);
</span><span>//</span><span>选择数据库</span>
<span>mysql_select_db</span>('数据库名'<span>);
</span><span>//</span><span>设置字符集</span>
mysql_set_charset('utf8'<span>);
</span><span>//</span><span>准备sql语句</span>
<span>$sql</span>="select * from user"<span>;
</span><span>//</span><span>发送sql语句</span>
<span>$result</span>=<span>mysql_query</span>(<span>$sql</span><span>);
</span><span>//</span><span>判断执行的sql语句是否成功</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><span>关闭数据库连接</span>
<span>mysql_close</span><span>();

</span><span>//</span><span>PHP数据库操作常用命令</span>
<span>require</span> ,<span>include</span><span>//</span><span>使用 函数将某个文件包含进来</span>
<span>mysql_connect</span>('localhost','root','root')<span>//</span><span>连接数据库</span>
<span>mysql_select_db</span>('数据库名')<span>//</span><span>选择数据库</span>
mysql_set_charset('utf8')<span>//</span><span>设置字符集</span>

<span>mysql_errno</span>()<span>//</span><span>错误号</span>
<span>mysql_error</span>()<span>//</span><span>错误信息</span>

<span>mysql_query</span>('sql语句')<span>//</span><span>执行sql语句成功返回资源,失败返回false</span>
<span>mysql_free_result</span>(<span>$result</span>)<span>//</span><span>释放资源</span>
<span>mysql_close</span>()<span>//</span><span>关闭数据库</span>
<span>mysql_affected_rows</span>(<span>$link</span>)<span>//</span><span>返回受影响行数 一般 添加 修改 删除的时候进行判断</span>
<span>mysql_insert_id</span>(<span>$link</span>)<span>//</span><span>如果表中有自增id 添加成功将通过此函数返回自增id</span>
<span>mysql_num_rows</span>(<span>$result</span>)<span>//</span><span>只用于查询 返回结果集中的记录数</span>

<span>mysql_fetch_array</span>(<span>$result</span>)<span>//</span><span>将结果集中的记录以数组的形式返回 混合数组 了解即可</span>
<span>mysql_fetch_row</span>(<span>$result</span>)<span>//</span><span>将结果集中的记录以数组的形式返回 索引数组 了解即可</span>
<span>mysql_fetch_assoc</span>(<span>$result</span>)<span>//</span><span>将结果集中的记录以数组的形式返回 关联数组  推荐使用并且掌握</span>

 

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn