频道导航

• ▸ PHP
• ▸ Java
• ▸ Java SE
• ▸ Python
• ▸ C#
• ▸ C&C++
• ▸ Ruby
• ▸ VB
• ▸ asp.Net
• ▸ Go
• ▸ Perl
• ▸ netty
• ▸ Django
• ▸ Delphi
• ▸ Jsp
• ▸ .NET Core
• ▸ Spring
• ▸ Flask
• ▸ Springboot
• ▸ SpringMVC
• ▸ Lua
• ▸ Laravel
• ▸ Mybatis
• ▸ Asp
• ▸ Groovy
• ▸ ThinkPHP
• ▸ Yii
• ▸ swoole
• ▸ HTML
• ▸ HTML5
• ▸ JavaScript
• ▸ CSS
• ▸ jQuery
• ▸ Bootstrap
• ▸ Angularjs
• ▸ TypeScript
• ▸ Vue
• ▸ Dojo
• ▸ Json
• ▸ Electron
• ▸ Node.js
• ▸ extjs
• ▸ Express
• ▸ XML
• ▸ ES6
• ▸ Ajax
• ▸ Flash
• ▸ Unity
• ▸ React
• ▸ Flex
• ▸ Ant Design
• ▸ Web前端
• ▸ 微信小程序
• ▸ 微信公众号
• ▸ iOS
• ▸ Android
• ▸ Swift
• ▸ Hybrid
• ▸ Cocos2d-x
• ▸ Flutter
• ▸ Xcode
• ▸ Silverlight
• ▸ cocoa
• ▸ Cordova

• 前端之家
• PHP
• 《PHP编程最快明白》第六讲：Mysql数据库操作

<div class="codebody" id="code14387"> @H_403_0@<?PHP @H_403_0@class opMysqL{ @H_4030@private $host = 'localhost'; //服务器地址 @H403_0@private $name = 'root'; //登录账号 @H_403_0@private $pwd = ''; //登录密码 @H_403_0@private $dBase = 'a0606123620'; //数据库名称 @H_403_0@private $conn = ''; //数据库链接资源 @H_4030@private $result = ''; //结果集 @H4030@private $msg = ''; //返回结果 @H4030@private $fields; //返回字段 @H4030@private $fieldsNum = 0; //返回字段数 @H4030@private $rowsNum = 0; //返回结果数 @H4030@private $rowsRst = ''; //返回单条记录的字段数组 @H4030@private $filesArray = array(); //返回字段数组 @H4030@private $rowsArray = array(); //返回结果数组 @H4030@private $idusername=array(); @H4030@private $idsubtitle=array(); @H4030@//初始化类 @H403_0@function _construct($host='',$name='',$pwd='',$dBase=''){ @H4030@if($host != '') @H4030@$this->host = $host; @H4030@if($name != '') @H4030@$this->name = $name; @H4030@if($pwd != '') @H4030@$this->pwd = $pwd; @H4030@if($dBase != '') @H4030@$this->dBase = $dBase; @H403_0@$this->initconn(); @H4030@} @H403_0@//链接数据库 @H_403_0@function initconn(){ @H403_0@$this->conn=@MysqLconnect($this->host,$this->name,$this->pwd); @H403_0@@MysqL_selectdb($this->dBase,$this->conn); @H403_0@MysqLquery("set names utf8"); @H4030@} @H403_0@//查询结果 @H_403_0@function MysqL_query_rst($sql){ @H_4030@if($this->conn == ''){ @H403_0@$this->initconn(); @H4030@} @H403_0@$this->result = @MysqL_query($sql,$this->conn); @H_403_0@} //取得查询结果字段数目 @H_403_0@function getFieldsNum($sql){ @H_403_0@$this->MysqL_query_rst($sql); @H_403_0@$this->fieldsNum = @MysqL_numfields($this->result); @H4030@} @H403_0@//取得查询结果行数目 @H_403_0@function getRowsNum($sql){ @H_403_0@$this->MysqL_query_rst($sql); @H_403_0@if(MysqLerrno() == 0){ @H403_0@return @MysqL_numrows($this->result); @H4030@}else{ @H4030@return ''; @H4030@} @H4030@} @H4030@//取得记录数组有索引（单条记录） @H403_0@function getRowsRst($sql){ @H_403_0@$this->MysqL_query_rst($sql); @H_403_0@if(MysqLerror() == 0){ @H403_0@$this->rowsRst = MysqL_fetch_array($this->result,MysqLASSOC); @H4030@return $this->rowsRst; @H4030@}else{ @H4030@return ''; @H4030@} @H4030@} @H4030@//取得记录数组有索引（多条记录）全部 @H403_0@function getRowsArray($sql){ @H_403_0@$this->MysqL_query_rst($sql); @H_403_0@if(MysqLerrno() == 0){ @H403_0@while($row = MysqL_fetch_array($this->result,MysqLASSOC)) { @H4030@$this->rowsArray[] = $row; @H4030@} @H4030@return $this->rowsArray; @H4030@}else{ @H4030@return ''; @H4030@} @H4030@} @H403_0@//更新、删除、添加记录数，返回影响到的行数 @H_403_0@function uidRst($sql){ @H_4030@if($this->conn == ''){ @H403_0@$this->initconn(); @H4030@} @H403_0@@MysqL_query($sql); @H_403_0@$this->rowsNum = @MysqL_affectedrows(); @H403_0@if(MysqLerrno() == 0){ @H4030@return $this->rowsNum; @H4030@}else{ @H4030@return ''; @H4030@} @H4030@} @H403_0@//获取对应的字段值，一条数字索引，MysqL_arrayrows才是带字段索引 @H403_0@function getFields($sql,$fields){ @H_403_0@$this->MysqL_query_rst($sql); @H_403_0@if(MysqLerrno() == 0){ @H403_0@if(MysqL_numrows($this->result) > 0){ @H403_0@$tmpfld = @MysqL_fetchrow($this->result); @H4030@$this->fields = $tmpfld[$fields]; } @H4030@return $this->fields; @H4030@}else{ @H4030@return ''; @H4030@} @H403_0@} //错误信息 @H_403_0@function msgerror(){ @H403_0@if(MysqLerrno() != 0) { @H403_0@$this->msg = MysqLerror(); @H4030@} @H4030@return $this->msg; @H4030@} @H4030@//释放结果集 @H403_0@function closerst(){ @H403_0@MysqL_freeresult($this->result); @H4030@$this->msg = ''; @H4030@$this->fieldsNum = 0; @H4030@$this->rowsNum = 0; @H4030@$this->filesArray = ''; @H4030@$this->rowsArray = ''; @H4030@$this->idsubtitle=''; @H4030@$this->idusername=''; @H4030@} @H403_0@//关闭数据库 @H_403_0@function closeconn(){ @H403_0@$this->closerst(); @H403_0@MysqLclose($this->conn); @H4030@$this->conn = ''; @H4030@} @H4030@} @H4030@?> @H4030@