php教程:mysql数据库操作的DB类

当前位置：网学 > 编程文档 > PHP > 正文

作者：用户投稿来源：网络发布时间： 12/12/05

代码拷贝框
<?PHP/**MySQL数据库 DB类*@packagedb*@authoryytcpt(无影)*@version2008-03-27*@copyrigthhttp://www.d5s.cn/*/class db {var $connection_id = "";var $pconnect = 0;var $shutdown_queries = array();var $queries = array();var $query_id = "";var $query_count = 0;var $record_row = array();var $failed = 0;var $halt = "";var $query_log = array();function connect($db_config){if ($this->pconnect){$this->connection_id = mysql_pconnect($db_config["hostname"], $db_config["username"], $db_config["password"]);}else{$this->connection_id = mysql_connect($db_config["hostname"], $db_config["username"], $db_config["password"]);}if ( ! $this->connection_id ){$this->halt("Can not connect MySQL Server");}if ( ! @mysql_select_db($db_config["database"], $this->connection_id) ){$this->halt("Can not connect MySQL Database");}if ($db_config["charset"]) {@mysql_unbuffered_query("SET NAMES ''".$db_config["charset"]."''");}return true;}//发送SQL 查询，并返回结果集function query($query_id, $query_type=''mysql_query''){$this->query_id = $query_type($query_id, $this->connection_id);$this->queries[] = $query_id;if (! $this->query_id ) {$this->halt("查询失败:\n$query_id");}$this->query_count++;$this->query_log[] = $str;return $this->query_id;}//发送SQL 查询，并不获取和缓存结果的行function query_unbuffered($sql=""){return $this->query($sql, ''mysql_unbuffered_query'');}//从结果集中取得一行作为关联数组function fetch_array($sql = ""){if ($sql == "") $sql = $this->query_id;$this->record_row = @mysql_fetch_array($sql, MYSQL_ASSOC);return $this->record_row;}function shutdown_query($query_id = ""){$this->shutdown_queries[] = $query_id;}//取得结果集中行的数目，仅对 INSERT，UPDATE 或者 DELETEfunction affected_rows() {return @mysql_affected_rows($this->connection_id);}//取得结果集中行的数目，仅对 SELECT 语句有效function num_rows($query_id="") {if ($query_id == "") $query_id = $this->query_id;return @mysql_num_rows($query_id);}//返回上一个 MySQL 操作中的错误信息的数字编码function get_errno(){$this->errno = @mysql_errno($this->connection_id);return $this->errno;}//取得上一步 INSERT 操作产生的 IDfunction insert_id(){return @mysql_insert_id($this->connection_id);}//得到查询次数function query_count() {return $this->query_count;}//释放结果内存function free_result($query_id=""){if ($query_id == "") $query_id = $this->query_id;@mysql_free_result($query_id);}//关闭 MySQL 连接function close_db(){if ( $this->connection_id ) return @mysql_close( $this->connection_id );}//列出 MySQL 数据库中的表function get_table_names(){global $db_config;$result = mysql_list_tables($db_config["database"]);$num_tables = @mysql_numrows($result);for ($i = 0; $i < $num_tables; $i++) {$tables[] = mysql_tablename($result, $i);}mysql_free_result($result);return $tables;}//从结果集中取得列信息并作为对象返回，取得所有字段function get_result_fields($query_id=""){if ($query_id == "") $query_id = $this->query_id;while ($field = mysql_fetch_field($query_id)) {$fields[] = $field;}return $fields;}//错误提示function halt($the_error=""){$message = $the_error."<br/>\r\n";$message.= $this->get_errno() . "<br/>\r\n";$sql = "INSERT INTO `db_error`(pagename, errstr, timer) VALUES(''".<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>php教程:mysql数据库操作的DB类_网学</title> <meta name="keywords" content="php教程:mysql数据库操作的DB类|网学"/> <meta name="description" content="php教程:mysql数据库操作的DB类|网学"/> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <meta name="Robots" content="All"> <meta name="googlebot" content="All"> <meta http-equiv="X-UA-Compatible" content="IE=7" /> <link href="http://myeducs.cn/template/Images/Skin66.css" rel="stylesheet" type="text/css"> <script language="javascript" src="http://myeducs.cn/template/images/pic.js"></script> </head> <body id="current1"> <div class="sltopa"> <div class="sltop1" style="text-align:left;"> <a href="http://myeducs.cn" target="_blank" style="color:#cc0000;"> 网站导航</a>：<a href="http://www.myeducs.cn/" target="_blank">免费论文</a> <a href="http://wenku.myeducs.cn/">原创论文</a> <a href="http://www.myeducs.cn/chaxun/index.html">论文搜索</a> <a href="http://www.myeducs.cn/">原创论文</a> <a href="http://myeducs.cn/shejixiazai/wangxue-soft/">网学软件</a> <a href="http://myeducs.cn/wenxian/Index.asp">学术大家</a> <a href="http://wenku.myeducs.cn">资料中心</a> <a href="http://www.myeducs.cn/user">会员中心</a> <a href="http://www.myeducs.cn/ask/">问题解答</a> <a href="http://www.myeducs.cn/edu/web/About/orderpaper.htm">原创论文</a> <a href="http://www.myeducs.cn/Photo/tupiansucai/lunwensucai/index.html">论文素材</a> <a href="http://myeducs.cn/shejixiazai/">设计下载</a> <a href="http://wenku.myeducs.cn/latestthesis.html">最新论文</a> <a href="http://wenku.myeducs.cn/?top500.html">下载排行</a> <a href="http://www.myeducs.cn/Upload/yuanchuanglunwenfabu/index.html">论文上传</a> <a href="http://myeducs.cn/User/">在线投稿</a> <a href="http://myeducs.cn/guanyuwangxue/">联系我们</a> </div> </div> <div class="sltop"> <div class="sltop2"> <dl> <dt class="sltop2left"><a href="http://myeducs.cn"> <img src="http://myeducs.cn/template/Images/logo.gif" alt="返回网学首页" border="0" /></a> </dt> <dt class="sltop2c"> <a href="http://wenku.myeducs.cn/"><img border="0" alt="网学联系" src="http://myeducs.cn/template/Images/yclw.gif" height="60"></a></dt> <dt class="sltop2r"></dt> <div style="height:32px; overflow:hidden; padding-top:5px;"> <form method="Get" name="SearchForm" action="http://www.myeducs.cn/chaxun/index.html" target="_blank"> <input name="go" type="text" size="20" maxlength="50" value="请输入关键字" onmouseover="this.focus()" onblur="if (this.value =='')this.value='请输入关键字'" onfocus="this.select()" onclick="if (this.value=='请输入关键字') this.value=''" style="width:160px; height:18px; overflow:hidden"><input type="hidden" name="Field" value="Title" /><input type="submit" name="Submit" value=" 立即搜索 " style="margin-left:5px; width:96px; height:25px; background:#23a6df; color:#FFFFFF; border:1px solid #ccc; font-weight:bold; cursor:pointer;"></form> </div> <div style="height:26px;"> <a href="http://wenku.myeducs.cn/latestthesis.html" target="_blank" style="color:#CC0000"> 最新论文</a> <a href="http://www.myeducs.cn/chaxun/Search.html" target="_blank" style="color:#006600"> 推荐专题</a> <a href="http://wenku.myeducs.cn/?top500.html" target="_blank" style="color:#CC00FF"> 热门论文</a> <a href="http://myeducs.cn/lunwen-resource/" target="_blank" style="color:#f00;font-weight:bold;" title="素材专题"> 素材专题</a> </div> </dt> </dl> <div class="clear"> </div> </div> </div> <div class="sltop"> <div class="sltopmenu"> <div class="sltopmenua"> <ul> <li id="mu1"><a title="网站首页" href="http://myeducs.cn/">网站首页</a></li> <li><a href="http://myeducs.cn/shejixiazai/">设计下载</a></li><li><a href="http://myeducs.cn/guanyuwangxue/">关于网学</a></li><li><a href="http://myeducs.cn/chengxusheji/">程序设计</a></li><li><a href="http://myeducs.cn/lunwen-resource/">设计资源</a></li><li><a href="http://myeducs.cn/lunwen-template/">论文模板</a></li><li><a href="http://myeducs.cn/shejixiazai/wangxue-soft/">网学软件</a></li><li><a href="http://myeducs.cn/wangyesucai/">网页素材</a></li><li><a href="http://myeducs.cn/shejixiazai/wangye-template/">网页模板</a></li><li><a href="http://myeducs.cn/jingpinkejian/">精品课件</a></li><li><a href="http://myeducs.cn/game-pindao/">游戏频道</a></li> <li id="mu12"><a title="网学资料" href="http://wenku.myeducs.cn/" target="_blank">网学资料</a></li> <li id="mu13"><a title="原创论文" href="http://wenku.myeducs.cn/" target="_blank">原创论文</a></li> <li id="mu14"><a title="网站设计" href="http://myeducs.cn/wzsj/index.html" target="_blank">网站设计</a></li> <li id="mu15"><a title="源交易代码" href="/trade-daima/index.html" target="_blank">交易代码</a></li> </ul> <div class="clear"> </div> </div> </div> </div> <div class="menu2Bg"> <div class="menu2"> <a href="/shejixiazai/VC-yu-C-leibie/">C++</a> <a href="/shejixiazai/VB-leizuopin/">VB</a> <a href="/shejixiazai/ASP-leizuopin/">ASP</a> <a href="/shejixiazai/VF-leizuopin/">VF</a> <a href="/shejixiazai/DELPHI-leizuopin/">DELPHI</a> <a href="/shejixiazai/JSPNETJAVA-leibie/">JSP</a> <a href="/shejixiazai/dianqigongchengyuzidonghualeibie/">电气</a> <a href="/shejixiazai/jisuanjiqitayuyan/">计算机</a> <a href="/shejixiazai/jingjiji-manager-lei/">经济</a> <a href="/wangyesucai/qitasucai/">打包下载</a> <a href="/chengxusheji/chaxun-tool/">查询工具</a> <a href="/chengxusheji/shejianli/">设计案例</a> <a href="/chengxusheji/jiaoshouzhuanjia/">教授专家</a> <a href="/lunwen-resource/shiyongdaimapianduan/">实用代码</a> <a href="/lunwen-resource/wangyepeise/">网页配色</a> <a href="/bianjie-tool/">便捷工具</a> <a href="/lunwen-resource/biaodanmeihua/">表单美化</a> <a href="/lunwen-resource/keyonglunwen/free-lunwen/">免费论文</a> <a href="/lunwen-resource/keyonglunwen/">可用论文</a> <a href="/lunwen-resource/lunwenpeixun/">论文培训</a> <a href="/lunwen-resource/shijianyuxiaolv/">时间与效率</a> <a href="/lunwen-resource/CSSDIV-template/">DIV技术</a> <a href="/lunwen-resource/JS-daima/">JS代码</a> <a href="http://myeducs.cn/baibao/assist/index.htm">百宝箱</a> <a href="/wangyesucai/shejishi-intro/">设计师</a> <a href="/AJAX-daima/">AJAX代码</a> <a href="/wangyesucai/GIF-sucai/">GIF素材</a> <a href="/wangyesucai/beijingtupian/">背景图片</a> <a href="/wangyesucai/wangyetubiao/">网页图标</a> <a href="/wangyesucai/QQ-biaoqing/">QQ表情</a> <a href="/wangyesucai/png-tubiao/">png图标</a> <a href="/wangyesucai/donghuasucai/">动画素材</a> <a href="/shejixiazai/wangye-template/PPT-template/">PPT模板</a> <a href="/shejixiazai/wangye-template/DIVCSS-template/">DIVCSS模板</a> <a href="/shejixiazai/wangye-template/qiye-template/">企业模板</a> <a href="/shejixiazai/wangye-template/hanguo-template/">韩国模板</a> <a href="/shejixiazai/wangye-template/riben-template/">日本模板</a> <a href="/shejixiazai/wangye-template/geren-template/oumei-template/">欧美模板</a> <a href="/shejixiazai/wangye-template/geren-template/">个人模板</a> <a href="/shejixiazai/wangye-template/jieqing-template/">节庆模板</a> <a href="/chengxusheji/wangyeshiyong-tool/">实用工具</a> <a href="/wangyesucai/Psd-sucai/">Psd素材</a> <a href="/QQ/">QQ专栏</a> <a href="/shejixiazai/CAJ-wendang/">CAJ文档</a> <a href=/game-pindao/game-comment/>游戏评论</a> <a href=/game-pindao/game-gonglue/>游戏攻略</a> <a href=/game-pindao/game-shangxi/>游戏赏析</a> <a href=/game-pindao/game-qianzhan/>游戏前瞻</a> <a href=/game-pindao/game-news-dongtai/>游戏新闻</a> <a href=/game-pindao/game-zuobiqi/>游戏帮助</a> <a href=/game-pindao/game-miji/>游戏秘籍</a> <a href=/game-pindao/buding-download/>游戏补丁</a> <a href=/jingpinkejian/guowaijingpinkejian/>国外课件</a> <a href=/jingpinkejian/benkejingpinkejian/>本科课件</a> <a href=/jingpinkejian/network-jingpinkejian/>网络课件</a> <a href="http://www.lw80.cn/">原创设计</a> <a href=/downlw/index.asp>原创下载</a> <a href=/yuanchuanglunwen/index.html>原创论文</a> <a href=/Wzwf/index.html>网站维护(新)</a> <a href="/jingpinkejian/zaixianshiyan/">虚拟实验,在线实验系统</a> <a href="/jingpinkejian/koucaipeixun/">口才培训</a> <a href="/guanyuwangxue/jiazhaokaoshi/">驾照考试</a> <a href="/guanyuwangxue/jiuhoudaijia/">酒后代驾</a> <a href="http://www.myeducs.cn/edu/web/About/orderpaper.htm">设计定作</a> <a href="http://www.myeducs.cn/chaxun/Search.html">设计专题</a> <a href="http://www.lw80.cn/JiSuanJiYuanChuangLunWen/index.html">计算机原创</a> <a href="http://www.wljy8.com/index.html">网络教育</a> <a href="http://www.myeducs.cn/webseo/">收录查询</a> <a href="/guanyuwangxue/intro-yewu/sheji-yewu/"><font color="#FF0000">ASP,网站,C/S,设计等定作</font></a> <br>栏目导航： <a href=http://myeducs.cn/bianchengwendang/qitaleibie/>其他类别</a> <a href=http://myeducs.cn/bianchengwendang/Javascript/>Javascript</a> <a href=http://myeducs.cn/bianchengwendang/Android/>Android</a> <a href=http://myeducs.cn/bianchengwendang/Ajax/>Ajax</a> <a href=http://myeducs.cn/bianchengwendang/XHTML/>XHTML</a> <a href=http://myeducs.cn/bianchengwendang/MySQL/>MySQL</a> <a href=http://myeducs.cn/bianchengwendang/ORACLE/>ORACLE</a> <a href=http://myeducs.cn/bianchengwendang/SQLSERVER/>SQL SERVER</a> <a href=http://myeducs.cn/bianchengwendang/huibianyuyan/>汇编语言</a> <a href=http://myeducs.cn/bianchengwendang/PHP/>PHP</a> </div> </div> <div style="height:2px;width:1160px;overflow:hidden"> </div> <div class="tong" style="margin:0 auto;width:1160px; background:#fff;"> <script language="javascript" src="http://myeducs.cn/template/images/25.js"></script> </div>  <div class="jiange" style="height:4px;margin:0 auto;width:1160px;"> </div> <div class="indexm"> <div class="indexmbleft" style="background:#ffffff;"> <div class="wpath"> <div class="wpathleft"> 当前位置： <a href='/'>网学</a> > <a href='http://myeducs.cn/bianchengwendang/'>编程文档</a> > <a href='http://myeducs.cn/bianchengwendang/PHP/'>PHP</a> > 正文 </div> <div class="wpathright" style="margin-top:3px;"> </div> <div class="clear"> </div> </div> <div class="jiange"> </div> <div class="wlet"> php教程:mysql数据库操作的DB类</div> <div class="wle2"> <div id="gg46815">来源：<span><a href="Http://myeducs.cn">Http://myeducs.cn</a></span> 联系QQ：<span><a href="http://wpa.qq.com/msgrd?v=3&uin=3710167&site=网学网&menu=yes" target="_blank" ><img border="0" src="http://wpa.qq.com/pa?p=2:3710167:51" alt="点击这里给我发消息" title="点击这里给我发消息"/></a></span> 作者： <span>用户投稿</span> 来源： <span>网络</span> 发布时间： <span>12/12/05</span> </div> </div> <div id="wz_dianji" style="text-align:center;padding:5px 0px 0px 0px;"> </div> <div style="text-align:center"> <div id="alimama680"><script language="javascript" src="http://myeducs.cn/template/images/biadu1.js"></script> <a href="/Download/open.asp?id=57130&path=php教程:mysql数据库操作的DB类.rar" title="下载{$ArticleTitle}原创论文样式"><img src="http://myeducs.cn/template/images/down.gif" border="1" alt="下载{$ArticleTitle}原创论文样式"></a> </div> <div class="showwle4" id="test"> content </div> <div class="page"> </div> <div style="text-align:center"> <script language="javascript">var infoid = '57130';var classid = 'news';</script><script language = "JavaScript" src ="/Ajax/mood.js"></script> </div> <div id="wz_46860" style="margin:2px 0px 0px 0px"><script language="javascript" src="http://myeducs.cn/template/images/biadu2.js"></script></div> <div class="shuqian"><script language="javascript" src="/js/cang.js"></script></div> </div> <div class="clear"> </div> <div class="wle4" align=center> <a href="http://wenku.myeducs.cn/" title="点击进入论坛和大家一起交流设计,分享设计素材,结交设计朋" target="_blank" style="color:#ff0000; font-size:14px; ">点击进入论坛和大家一起交流设计,分享设计素材,结交设计朋友</a> </div> <div class="wle41"> <li>上一篇资讯： <a href='http://myeducs.cn/bianchengwendang/PHP/PHP-tech-cookie-heshuzudejieheshixiangouwuche/'>PHP教程:cookie和数组的结合实现购物车</a></li> </div> <div class="wle41"> <li>下一篇资讯： <a href='http://myeducs.cn/bianchengwendang/PHP/php-tech-php-shejimoshi-intro-zhizhiduixiangmoshi/'>php教程：php设计模式介绍之值对象模式</a></li> </div> <div class="wle5"> <script language="javascript" src="http://myeducs.cn/template/images/path.js"></script></div> <div class="jiange"> </div> <div class="indexmbleft1"> <div class="indexmbleft1t"> <h2>相关资讯</h2> <span></span> <div class="clear"> </div> </div> <div class="indexmbleft1li"> <div id="RelatedContainer"> <div class="related"> <div class="title"> <h3>相关文章</h3> </div> <ul class="list"> <li> <a title="php教程：php设计模式介绍之值对象模式" href="http://myeducs.cn/bianchengwendang/PHP/php-tech-php-shejimoshi-intro-zhizhiduixiangmoshi/" target="_blank"> <span>php教程：php设计模式介绍之值对象模式</span></a></li> <li> <a title="php教程：php设计模式之编程惯用法" href="http://myeducs.cn/bianchengwendang/PHP/php-tech-php-shejimoshizhibianchengguanyongfa/" target="_blank"> <span>php教程：php设计模式之编程惯用法</span></a></li> <li> <a title="php教程：php设计模式之前言" href="http://myeducs.cn/bianchengwendang/PHP/php-tech-php-shejimoshizhiqianyan/" target="_blank"> <span>php教程：php设计模式之前言</span></a></li> <li> <a title="轻松修复Discuz!数据库" href="http://myeducs.cn/bianchengwendang/PHP/qingsongxiufu-Discuz-shujuku/" target="_blank"> <span>轻松修复Discuz!数据库</span></a></li> <li> <a title="PHP使用zlib扩展实现页面GZIP压缩输出" href="http://myeducs.cn/bianchengwendang/PHP/PHP-shiyong-zlib-kuozhanshixian-page-GZIP-yasuoshuchu/" target="_blank"> <span>PHP使用zlib扩展实现页面GZIP压缩输出</span></a></li> </ul> <div class="clear"> </div> </div> <div class="related" style=" margin-left:7px;"> <div class="title"> <h3>相关专题</h3> </div> <ul class="list"> <li><a href="http://myeducs.cn/bianchengwendang/PHP/PHP-V53-zhongdexintexing-mingcheng-space/" target="_blank" title="PHP V5.3 中的新特性: 名称空间"><span>PHP V5.3 中的新特性: 名称空间</span></a></li> <li><a href="http://myeducs.cn/bianchengwendang/PHP/IIS-xia-PHP-de-ISAPI-he-FastCGI-bijiao/" target="_blank" title="IIS下PHP的ISAPI和FastCGI比较"><span>IIS下PHP的ISAPI和FastCGI比较</span></a></li> <li><a href="http://myeducs.cn/bianchengwendang/PHP/PHP-kaifakuangjiadexianzhuanghezhanwang_bc41d8d4/" target="_blank" title="PHP开发框架的现状和展望"><span>PHP开发框架的现状和展望</span></a></li> <li><a href="http://myeducs.cn/bianchengwendang/PHP/optimize-PHP-daimade-40-tiaojianyi_ae3b9f13/" target="_blank" title="优化PHP代码的40条建议"><span>优化PHP代码的40条建议</span></a></li> <li><a href="http://myeducs.cn/bianchengwendang/PHP/PHP-MVC-jiagouxiadeyixieliuhangkuangjia/" target="_blank" title="PHP MVC架构下的一些流行框架..."><span>PHP MVC架构下的一些流行框架...</span></a></li> </ul> <div class="clear"> </div> </div> <div class="clear"> </div> </div> </div> </div> </div> <div class="indexmr"> <div class="indexrightgg"> <script language="javascript" src="http://myeducs.cn/template/images/250_250.js"></script> </div> <div class="jiange"> </div> <div class="indexmr1"> <div class="indexmr1t"> <h2>网学推荐</h2> </div> <div class="indexmr1li"> <script language="javascript" src="http://myeducs.cn/template/images/1.js"></script> </div> </div> <div class="jiange"> </div> <div class="indexmr1"> <div class="indexmr1t"> <h2>免费论文</h2> </div> <div class="indexmr1li"> <script language="javascript" src="http://myeducs.cn/template/images/2.js"></script> </div> </div> <div class="jiange"> </div> <div class="indexmr1"> <div class="indexmr1t"> <h2>原创论文</h2> </div> <div class="indexmr1li"> <script language="javascript" src="http://myeducs.cn/template/images/3.js"></script> </div> </div> <div class="jiange"> </div> <div class="indexmr1"> <div class="indexmr1t"> <h2>文章排行榜</h2> </div> <div class="indexmr1li"> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/PHP-50-zhongduotaixingdeshixianfanganqianxi/" target="_blank"><span>PHP 5.0中多态性的实现方案浅析</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/zai-PHP-zhongshixianchongzaigouzaohanshudefangfa/" target="_blank"><span>在PHP中实现重载构造函数的方法</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/xiangjie-PHP-demianxiangduixiangbiancheng/" target="_blank"><span>详解PHP的面向对象编程</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/ZendStudio-for-Eclipse-tiaoshirumenpian-duandiantiaoshi/" target="_blank"><span>ZendStudio for Eclipse 调试入门篇</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/PHP-mianxiangduixiangchengxushejide-61-tiaohuangjinfaze/" target="_blank"><span>PHP面向对象程序设计的61条黄金法则</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/php-mianxiangduixiang-oop/" target="_blank"><span>php面向对象oop</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/php-caozuowenjianxingshujuku-SQLite/" target="_blank"><span>php操作文件型数据库SQLite</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/phpmysql-fenyechulidetantao/" target="_blank"><span>php+mysql分页处理的探讨 </span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/PHP-zhongshiyong-FCKeditor/" target="_blank"><span>PHP中使用FCKeditor</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/PHP-zhongshiyong-FCKeditor232-peizhi/" target="_blank"><span>PHP中使用FCKeditor2.3.2配置</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/zai-php-zhongshiyong-FCKeditor242/" target="_blank"><span>在php中使用FCKeditor2.4.2</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/zhimeng-dedecms-congdiceng-label-shixianerjicaidan/" target="_blank"><span>织梦dedecms从底层标签实现二级菜单</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/iis-xia-php-wufazhaodaogaiye-decuowujiejue/" target="_blank"><span>iis下php无法找到该页的错误解决</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/PHP-V53-zhongdexintexing-mingcheng-space/" target="_blank"><span>PHP V5.3 中的新特性: 名称空间</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/IIS-xia-PHP-de-ISAPI-he-FastCGI-bijiao/" target="_blank"><span>IIS下PHP的ISAPI和FastCGI比较</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/PHP-kaifakuangjiadexianzhuanghezhanwang_bc41d8d4/" target="_blank"><span>PHP开发框架的现状和展望</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/optimize-PHP-daimade-40-tiaojianyi_ae3b9f13/" target="_blank"><span>优化PHP代码的40条建议</span></a></li> <li>· <a href="http://myeducs.cn/bianchengwendang/PHP/PHP-MVC-jiagouxiadeyixieliuhangkuangjia/" target="_blank"><span>PHP MVC架构下的一些流行框架...</span></a></li> </div> </div> </div> <div class="clear"> </div> </div> <div style="DISPLAY:none"> 浏览： <script src="http://myeducs.cn/plus/count/js.asp?id=57130" language="javascript"></script> </div> <div class="foot"> <div class="foott"> <a onclick="this.style.behavior='url(#default#homepage)';this.setHomePage('http://myeducs.cn');" href="#" style="color:#CC6600">设为首页</a> | <a href="javascript:window.external.addFavorite('http://myeducs.cn','网学网');" style="color:#3300FF">加入收藏</a> | <a href="http://myeducs.cn/lunwen/">论文首页</a> | <a href="http://myeducs.cn/专题.asp">论文专题</a> | <a href="http://myeducs.cn/shejixiazai/">设计下载</a> | <a href="http://myeducs.cn/shejixiazai/wangxue-soft/">网学软件</a> | <a href="http://myeducs.cn/lunwen-template/">论文模板</a> | <a href="http://myeducs.cn/lunwen-resource/">论文资源</a> | <a href="http://myeducs.cn/chengxusheji/">程序设计</a> | <a href="http://myeducs.cn/guanyuwangxue/">关于网学</a> | <a href="http://myeducs.cn/plus/search/">站内搜索</a> | <a href="http://www.myeducs.cn/dinggou/">网学留言</a> | <a href="http://www.myeducs.cn/plus/link/reg/">友情链接</a> | <a target="_blank" href="http://wenku.myeducs.cn">资料中心</a></div> <div class="footli"> 版权所有 QQ:3710167 邮箱：<a href="mailto:3710167@qq.com">3710167@qq.com</a> 网学网 [<a href="http://myeducs.cn" target="_blank">Myeducs.cn</a>] 您电脑的分辨率是 <span class="v"> <script language="JavaScript">document.write(screen.width+' x '+screen.height); </script> </span>像素 <br /> Copyright 2008-2015 <a href="http://myeducs.cn" target="_blank">myeducs.Cn</a> <a href="http://www.myeducs.cn" target="_blank">www.myeducs.Cn</a> All Rights Reserved <br /> 湘ICP备09003080号 <div> </div> </div> </div><script src="http://myeducs.cn/template/images/bottom.js" type="text/javascript"></script> </body> </html> SERVER["PHP_SELF"]."'', ''".addslashes($message)."'', ".time().")";@mysql_unbuffered_query($sql);if (DEBUG==true){echo "<html><head><title>MySQL 数据库错误</title>";echo "<style type=\"text/css\"></style></head>\r\n";echo "<body>\r\n";echo "<blockquote>\r\n";echo "<textarea class=\"error\" rows=\"15\" cols=\"100\" wrap=\"on\" >" . htmlspecialchars($message) . "</textarea>\r\n";echo "</blockquote>\r\n</body></html>";exit;}}function __destruct(){$this->shutdown_queries = array();$this->close_db();}function sql_select($tbname, $where="", $limit=0, $fields="*", $orderby="id", $sort="DESC"){$sql = "SELECT ".$fields." FROM `".$tbname."` ".($where?" WHERE ".$where:"")." ORDER BY ".$orderby." ".$sort.($limit ? " limit ".$limit:"");return $sql;}function sql_insert($tbname, $row){foreach ($row as $key=>$value) {$sqlfield .= $key.",";$sqlvalue .= "''".$value."'',";}return "INSERT INTO `".$tbname."`(".substr($sqlfield, 0, -1).") VALUES (".substr($sqlvalue, 0, -1).")";}function sql_update($tbname, $row, $where){foreach ($row as $key=>$value) {$sqlud .= $key."= ''".$value."'',";}return "UPDATE `".$tbname."` SET ".substr($sqlud, 0, -1)." WHERE ".$where;}function sql_delete($tbname, $where){return "DELETE FROM `".$tbname."` WHERE ".$where;}//新增加一条记录function row_insert($tbname, $row){$sql = $this->sql_insert($tbname, $row);return $this->query_unbuffered($sql);}//更新指定记录function row_update($tbname, $row, $where){$sql = $this->sql_update($tbname, $row, $where);return $this->query_unbuffered($sql);}//删除满足条件的记录function row_delete($tbname, $where){$sql = $this->sql_delete($tbname, $where);return $this->query_unbuffered($sql);}/*根据条件查询，返回所有记录*$tbname 表名, $where <a href='http://www.myeducs.cn/chaxun/index.html' title='查询' target='_blank'>查询</a>条件, $limit 返回记录, $fields 返回字段*/function row_select($tbname, $where="", $limit=0, $fields="*", $orderby="id", $sort="DESC"){$sql = $this->sql_select($tbname, $where, $limit, $fields, $orderby, $sort);return $this->row_query($sql);}//详细显示一条记录function row_select_one($tbname, $where, $fields="*", $orderby="id"){$sql = $this->sql_select($tbname, $where, 1, $fields, $orderby);return $this->row_query_one($sql);}function row_query($sql){$rs = $this->query($sql);$rs_num = $this->num_rows($rs);$rows = array();for($i=0; $i<$rs_num; $i++){$rows[] = $this->fetch_array($rs);}$this->free_result($rs);return $rows;}function row_query_one($sql){$rs = $this->query($sql);$row = $this->fetch_array($rs);$this->free_result($rs);return $row;}//计数统计function row_count($tbname, $where=""){$sql = "SELECT count(id) as row_sum FROM `".$tbname."` ".($where?" WHERE ".$where:"");$row = $this->row_query_one($sql);return $row["row_sum"];}}?>
[Ctrl+A 全部选择然后拷贝]

很久没有发帖了，把我常用的一些php类文件分享出来。
如果您加了新功能，或者是有改进，请与大家一起分享。

<?php
    $db_config["hostname"]    = "127.0.0.1";    //服务器地址
    $db_config["username"]    = "root";        //数据库用户名
    $db_config["password"]    = "root";        //数据库密码
    $db_config["database"]    = "wap_blueidea_com";        //数据库名称
    $db_config["charset"]        = "utf8";
    include(''db.php'');
    $db    = new db();
    $db->connect($db_config);
    //例：查询表 table_name 中 cid=1的所有记录。
    $row = $db->row_select(''table_name'', ''cid=1'');
?>

更详细的使用方法，请参考 db类文件中的注释。

(责任编辑：admin)

点击进入论坛和大家一起交流设计,分享设计素材,结交设计朋友

上一篇资讯： PHP教程:cookie和数组的结合实现购物车

下一篇资讯： php教程：php设计模式介绍之值对象模式