一款简单实用的php操作mysql数据库类

2021-10-08 08:56:12分类：编程 / PHP编程阅读(6004)评论(0)

这篇文章主要介绍了一款简单实用的php操作mysql数据库类,不但包含了php针对mysql数据库的常见操作之外,还有针对危险字符的过滤功能,非常具有实用价值,需要的朋友可以参考下

本文实例讲述了一款简单实用的php操作mysql数据库类。分享给大家供大家参考。具体如下：

复制代码 代码如下:

/*
本款数据库连接类，他会自动加载sql防注入功能，过滤一些敏感的sql查询关键词，同时还可以增加判断字段 show table status的性质与show table类 获取数据库所有表名等。*/
@ini_set('mysql.trace_mode','off');
class mysql
{
 public $dblink;
 public $pconnect;
 private $search = array('/union(s*(/*.**/)?s*)+select/i', '/load_file(s*(/*.**/)?s*)+(/i', '/into(s*(/*.**/)?s*)+outfile/i');
 private $replace = array('union   select', 'load_file   (', 'into   outfile');
 private $rs;
 
 function __construct($hostname,$username,$userpwd,$database,$pconnect=false,$charset='utf8')
 {
  define('allowed_htmltags', '<meta><body><a><p><br><hr><h1><h2><h3><h4><h5><h6><font><u><i><b><strong><div><span><ol><ul><li><table><tr><td><map>');  <br/>   $this->pconnect=$pconnect; <br/>   $this->dblink=$pconnect?mysql_pconnect($hostname,$username,$userpwd):mysql_connect($hostname,$username,$userpwd); <br/>   (!$this->dblink||!is_resource($this->dblink)) && fatal_error("connect to the database unsuccessfully!"); <br/>   @mysql_unbuffered_query("set names {$charset}"); <br/>   if($this->version()>'5.0.1') <br/>   { <br/>    @mysql_unbuffered_query("set sql_mode = ''"); <br/>   } <br/>   @mysql_select_db($database) or fatal_error("can not select table!"); <br/>   return $this->dblink; <br/>  } <br/>  <br/>  function query($sql,$unbuffered=false) <br/>  { <br/>   //echo $sql.'<br>'; <br/>   $this->rs=$unbuffered?mysql_unbuffered_query($sql,$this->dblink):mysql_query($sql,$this->dblink); <br/>   //(!$this->rs||!is_resource($this->rs)) && fatal_error("execute the query unsuccessfully! error:".mysql_error()); <br/>   if(!$this->rs)fatal_error('在执行sql语句 '.$sql.' 时发生以下错误:'.mysql_error()); <br/>   return $this->rs; <br/>  } <br/>  <br/>  function fetch_one($sql) <br/>  { <br/>   $this->rs=$this->query($sql); <br/>   return dircms_strips教程lashes($this->filter_pass(mysql_fetch_array($this->rs,mysql_assoc))); <br/>  } <br/>  <br/>  function get_maxfield($filed='id',$table) // 获取$table表中$filed字段的最大值 <br/>  { <br/>   $r=$this->fetch_one("select {$table}.{$filed} from `{$table}` order by `{$table}`.`{$filed}` desc limit 0,1"); <br/>   return $r[$filed]; <br/>  } <br/>  <br/>  function fetch_all($sql) <br/>  { <br/>   $this->rs=$this->query($sql); <br/>   $result=array(); <br/>   while($rows=mysql_fetch_array($this->rs,mysql_assoc)) <br/>   { <br/>    $result[]=$rows; <br/>   } <br/>    <br/>   mysql_free_result($this->rs); <br/>   return dircms_stripslashes($this->filter_pass($result));  <br/>  } <br/>  <br/>  function fetch_all_withkey($sql,$key='id') <br/>  { <br/>   $this->rs=$this->query($sql); <br/>   $result=array(); <br/>   while($rows=mysql_fetch_array($this->rs,mysql_assoc)) <br/>   { <br/>    $result[$rows[$key]]=$rows; <br/>   } <br/>    <br/>   mysql_free_result($this->rs); <br/>   return dircms_stripslashes($this->filter_pass($result));  <br/>  } <br/>  <br/>  function last_insert_id() <br/>  { <br/>   if(($insertid=mysql_insert_id($this->dblink))>0)return $insertid; <br/>   else //如果 auto_increment 的列的类型是 bigint，则 mysql_insert_id() 返回的值将不正确. <br/>   { <br/>    $result=$this->fetch_one('select last_insert_id() as insertid'); <br/>    return $result['insertid']; <br/>   } <br/>  } <br/>  <br/>  function insert($tbname,$varray,$replace=false) <br/>  { <br/>   $varray=$this->escape($varray); <br/>   $tb_fields=$this->get_fields($tbname); // 升级一下，增加判断字段是否存在 <br/>    <br/>   foreach($varray as $key => $value) <br/>   { <br/>    if(in_array($key,$tb_fields)) <br/>    { <br/>     $fileds[]='`'.$key.'`'; <br/>     $values[]=is_string($value)?'''.$value.''':$value; <br/>    } <br/>   } <br/>  <br/>   if($fileds) <br/>   { <br/>    $fileds=implode(',',$fileds); <br/>    $fileds=str_replace(''','`',$fileds); <br/>    $values=implode(',',$values); <br/>    $sql=$replace?"replace into {$tbname}({$fileds}) values ({$values})":"insert into {$tbname}({$fileds}) values ({$values})"; <br/>    $this->query($sql,true); <br/>    return $this->last_insert_id(); <br/>   } <br/>   else return false; <br/>  } <br/>  <br/>  function update($tbname, $array, $where = '') <br/>  { <br/>   $array=$this->escape($array); <br/>   if($where) <br/>   { <br/>    $tb_fields=$this->get_fields($tbname); // 增加判断字段是否存在 <br/>     <br/>    $sql = ''; <br/>    foreach($array as $k=>$v) <br/>    { <br/>     if(in_array($k,$tb_fields)) <br/>     { <br/>      $k=str_replace(''','',$k); <br/>      $sql .= ", `$k`='$v'"; <br/>     } <br/>    } <br/>    $sql = substr($sql, 1); <br/>     <br/>    if($sql)$sql = "update `$tbname` set $sql where $where"; <br/>    else return true; <br/>   } <br/>   else <br/>   { <br/>    $sql = "replace into `$tbname`(`".implode('`,`', array_keys($array))."`) values('".implode("','", $array)."')"; <br/>   } <br/>   return $this->query($sql,true); <br/>  } <br/>   <br/>  function mysql_delete($tbname,$idarray,$filedname='id') <br/>  { <br/>   $idwhere=is_array($idarray)?implode(',',$idarray):intval($idarray); <br/>   $where=is_array($idarray)?"{$tbname}.{$filedname} in ({$idwhere})":" {$tbname}.{$filedname}={$idwhere}"; <br/>  <br/>   return $this->query("delete from {$tbname} where {$where}",true); <br/>  } <br/>  <br/>  function get_fields($table) <br/>  { <br/>   $fields=array(); <br/>   $result=$this->fetch_all("show columns from `{$table}`"); <br/>   foreach($result as $val) <br/>   { <br/>    $fields[]=$val['field']; <br/>   } <br/>   return $fields; <br/>  } <br/>  <br/>  function get_table_status($database) <br/>  { <br/>   $status=array(); <br/>   $r=$this->fetch_all("show table status from `".$database."`"); /////// show table status的性质与show table类似，不过，可以提供每个表的大量信息。 <br/>   foreach($r as $v) <br/>   { <br/>    $status[]=$v; <br/>   } <br/>   return $status; <br/>  } <br/>  <br/>  function get_one_table_status($table) <br/>  { <br/>   return $this->fetch_one("show table status like '$table'"); <br/>  } <br/>  <br/>  function create_fields($tbname,$fieldname,$size=0,$type='varchar') // 2010-5-14 修正一下 <br/>  {   <br/>   if($size) <br/>   { <br/>    $size=strtoupper($type)=='varchar'?$size:8; <br/>    $this->query("alter table `{$tbname}` add `$fieldname` {$type}( {$size} )  not null",true); <br/>   } <br/>   else $this->query("alter table `{$tbname}` add `$fieldname` mediumtext  not null",true); <br/>   return true; <br/>  } <br/>  <br/>  function get_tables() //获取所有表表名 <br/>  { <br/>   $tables=array(); <br/>   $r=$this->fetch_all("show tables"); <br/>   foreach($r as $v) <br/>   { <br/>    foreach($v as $v_) <br/>    { <br/>     $tables[]=$v_; <br/>    } <br/>   } <br/>   return $tables; <br/>  } <br/>  <br/>  function create_model_table($tbname) //创建一个内容模型表（start：初始只有字段contentid int(20)，用于内容表，/////////////////////// update：2010-5-20     默认加入`content` mediumtext not null,字段） <br/>  { <br/>   if(in_array($tbname,$this->get_tables())) return false;  ///////////////////// 当表名已经存在时，返回 false <br/>   if($this->query("create table `{$tbname}` ( <br/> `contentid` mediumint(8) not null , <br/> `content` mediumtext not null, <br/> key ( `contentid` )  <br/> ) engine = myisam default charset=utf8",true))return true;   ////////////////////  成功则返回 true <br/>   return false; //////////////失败返回 false <br/>  } <br/>  <br/>  function create_table($tbname) //创建一个会员模型空表（初始只有字段userid int(20)，用于会员表，2010-4-26） <br/>  { <br/>   if(in_array($tbname,$this->get_tables())) return false; <br/>   if($this->query("create table `{$tbname}` ( <br/> `userid` mediumint(8) not null , <br/> key ( `userid` )  <br/> ) engine = myisam default charset=utf8",true))return true; <br/>   return false; <br/>  } <br/>  <br/>  function escape($str) // 过滤危险字符 <br/>  { <br/>   if(!is_array($str)) return str_replace(array('n', 'r'), array(chr(10), chr(13)),mysql_real_escape_string(preg_replace($this->search,$this->replace, $str), $this->dblink)); <br/>   foreach($str as $key=>$val) $str[$key] = $this->escape($val); <br/>   return $str; <br/>  } <br/>  <br/>  function filter_pass($string, $allowedtags = '', $disabledattributes = array('onabort', 'onactivate', 'onafterprint', 'onafterupdate', 'onbeforeactivate', 'onbeforecopy', 'onbeforecut', 'onbeforedeactivate', 'onbeforeeditfocus', 'onbeforepaste', 'onbeforeprint', 'onbeforeunload', 'onbeforeupdate', 'onblur', 'onbounce', 'oncellchange', 'onchange', 'onclick', 'oncontextmenu', 'oncontrolselect', 'oncopy', 'oncut', 'ondataavaible', 'ondatasetchanged', 'ondatasetcomplete', 'ondblclick', 'ondeactivate', 'ondrag', 'ondragdrop', 'ondragend', 'ondragenter', 'ondragleave', 'ondragover', 'ondragstart', 'ondrop', 'onerror', 'onerrorupdate', 'onfilterupdate', 'onfinish', 'onfocus', 'onfocusin', 'onfocusout', 'onhelp', 'onkeydown', 'onkeypress', 'onkeyup', 'onlayoutcomplete', 'onload', 'onlosecapture', 'onmousedown', 'onmouseenter', 'onmouseleave', 'onmousemove', 'onmoveout', 'onmouseo教程ver', 'onmouseup', 'onmousewheel', 'onmove', 'onmoveend', 'onmovestart', 'onpaste', 'onpropertychange', 'onreadystatechange', 'onreset', 'onresize', 'onresizeend', 'onresizestart', 'onrowexit', 'onrowsdelete', 'onrowsinserted', 'onscroll', 'onselect', 'onselectionchange', 'onselectstart', 'onstart', 'onstop', 'onsubmit', 'onunload')) <br/>  { <br/>   if(is_array($string)) <br/>   { <br/>    foreach($string as $key => $val) $string[$key] = $this->filter_pass($val, allowed_htmltags); <br/>   } <br/>   else <br/>   { <br/>    $string = preg_replace('/s('.implode('|', $disabledattributes).').*?([s>])/', '', preg_replace('/<(.*?)>/ie', "'<'.preg_replace(array('/网页特效:[^"']*/i', '/(".implode('|', $disabledattributes).")[ ]*=[ ]*["'][^"']*["']/i', '/s+/'), array('', '', ' '), stripslashes('')) . '>'", strip_tags($string, $allowedtags))); <br/>   } <br/>   return $string; <br/>  } <br/>  <br/>  function drop_table($tbname) <br/>  { <br/>   return $this->query("drop table if exists `{$tbname}`",true); <br/>  } <br/>  <br/>  function version() <br/>  { <br/>   return mysql_get_server_info($this->dblink); <br/>  } <br/> } <br/></div></p><p>希望本文所述对大家的PHP程序设计有所帮助。</p></div><p>以上就是一款简单实用的php操作mysql数据库类的详细内容，更多请关注0133技术站其它相关文章！</p></article><div class="post-actions"><a href="javascript:;" etap="like" class="post-like action action-like" data-pid="0"><i class="fa fa-thumbs-o-up"></i>赞(<span>0</span>)</a><a href="javascript:;" class="action action-rewards" data-event="rewards"><i class="fa fa-jpy"></i> 打赏</a></div><div class="post-copyright">未经允许不得转载：<a href="/">0133技术站首页</a> » <a href="/cate153/">PHP编程</a></div><!--<div class="article-tags">标签：<a href="/archives/tag/javascript" rel="tag">JavaScript</a><a href="/archives/tag/%e5%be%ae%e4%bf%a1" rel="tag">微信</a><a href="/archives/tag/%e5%be%ae%e4%bf%a1%e7%9a%84%e7%89%88%e6%9c%ac%e5%8f%b7" rel="tag">微信的版本号</a><a href="/archives/tag/%e7%89%88%e6%9c%ac%e5%8f%b7" rel="tag">版本号</a><a href="/archives/tag/%e8%af%ad%e4%b9%89%e5%8c%96" rel="tag">语义化</a></div>--><nav class="article-nav"><span class="article-nav-prev">上一篇<br><a href="/cate153/11547370584025.html" rel="prev">Laravel实现批量更新多条数据</a></span><span class="article-nav-next">下一篇<br><a href="/cate153/11547385381025.html" rel="next">php多文件上传功能实现原理及代码</a></span></nav><div class="relates relates-thumb"><div class="title"><h3>相关文章</h3></div><ul><li><a href="/cate153/1114368776900.html"><img data-src="https://ss.0133.cn/article/64/2a/15/642a15d53978530b59926bd274131468.jpg-160" alt="thinkPHP5使用Rabc实现权限管理" class="thumb"></a><a href="/cate153/1114368776900.html">thinkPHP5使用Rabc实现权限管理</a></li><li><a href="/cate153/1114615561025.html"><img data-src="https://ss.0133.cn/article/31/68/3d/31683d3113636bc99952c06ff8d4bfbd.jpg-160" alt="php4的session功能评述（二）" class="thumb"></a><a href="/cate153/1114615561025.html">php4的session功能评述（二）</a></li><li><a href="/cate153/1114672436900.html"><img data-src="https://ss.0133.cn/article/7c/c8/6c/7cc86ca9ff7e48b453c41ba7f1b7eb98.jpg-160" alt="php比较两个指定的日期的实例讲解" class="thumb"></a><a href="/cate153/1114672436900.html">php比较两个指定的日期的实例讲解</a></li><li><a href="/cate153/1114673648225.html"><img data-src="https://ss.0133.cn/article/7c/c8/6c/7cc86ca9ff7e48b453c41ba7f1b7eb98.jpg-160" alt="laravel多视图共享数据实例代码" class="thumb"></a><a href="/cate153/1114673648225.html">laravel多视图共享数据实例代码</a></li><li><a href="/cate153/1114674859600.html"><img data-src="https://ss.0133.cn/article/58/93/a1/5893a175f403b71a1ad32a1cbe84cb91.jpg-160" alt="图文详解laravel多对多关联模型" class="thumb"></a><a href="/cate153/1114674859600.html">图文详解laravel多对多关联模型</a></li><li><a href="/cate153/1114676071025.html"><img data-src="https://ss.0133.cn/article/58/93/a1/5893a175f403b71a1ad32a1cbe84cb91.jpg-160" alt="HTTP中header头部信息详解" class="thumb"></a><a href="/cate153/1114676071025.html">HTTP中header头部信息详解</a></li><li><a href="/cate153/1114677282500.html"><img data-src="https://ss.0133.cn/article/58/93/a1/5893a175f403b71a1ad32a1cbe84cb91.jpg-160" alt="Elasticsearch属性单词常用解析说明" class="thumb"></a><a href="/cate153/1114677282500.html">Elasticsearch属性单词常用解析说明</a></li><li><a href="/cate153/1114678494025.html"><img data-src="https://ss.0133.cn/article/58/93/a1/5893a175f403b71a1ad32a1cbe84cb91.jpg-160" alt="PHP之CI框架学习讲解" class="thumb"></a><a href="/cate153/1114678494025.html">PHP之CI框架学习讲解</a></li></ul></div><!-- <div class="title" id="comments"><h3>评论 <small>抢沙发</small></h3></div><div id="respond" class="no_webshot"><form action="return false;" method="post" id="commentform"><div class="comt"><div class="comt-title"><img data-src="https://secure.gravatar.com/avatar/?s=100&d=mm" class="avatar avatar-100" height="50" width="50"><p><a id="cancel-comment-reply-link" href="javascript:;">取消</a></p></div><div class="comt-box"><textarea placeholder="你的评论可以一针见血" class="input-block-level comt-area" name="comment" id="comment" cols="100%" rows="3" tabindex="1" onkeydown="if(event.ctrlKey&&event.keyCode==13){document.getElementById('submit').click();return false};"></textarea><div class="comt-ctrl"><div class="comt-tips"><input type='hidden' name='comment_post_ID' value='6053' id='comment_post_ID'/><input type='hidden' name='comment_parent' id='comment_parent' value='0'/><p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="40dd7081eb"/></p><label for="comment_mail_notify" class="checkbox inline hide" style="padding-top:0"><input type="checkbox" name="comment_mail_notify" id="comment_mail_notify" value="comment_mail_notify" checked="checked"/>有人回复时邮件通知我</label><p style="display: none;"><input type="hidden" id="ak_js" name="ak_js" value="245"/></p></div><button type="button" name="submit" id="submit" tabindex="5">提交评论</button>--><!-- <span data-type="comment-insert-smilie" class="muted comt-smilie"><i class="icon-thumbs-up icon12"></i> 表情</span> --><!-- </div></div><div class="comt-comterinfo" id="comment-author-info"><ul><li class="form-inline"><label class="hide" for="author">昵称</label><input class="ipt" type="text" name="author" id="author" value="" tabindex="2" placeholder="昵称"><span class="text-muted">昵称 (必填)</span></li><li class="form-inline"><label class="hide" for="email">邮箱</label><input class="ipt" type="text" name="email" id="email" value="" tabindex="3" placeholder="邮箱"><span class="text-muted">邮箱 (必填)</span></li><li class="form-inline"><label class="hide" for="url">网址</label><input class="ipt" type="text" name="url" id="url" value="" tabindex="4" placeholder="网址"><span class="text-muted">网址</span></li></ul></div></div></form></div>--></div></div><div class="sidebar"><div class="widget widget_ui_tags"><h3>编程</h3><div class="items"><a href="/cate104/">Java</a><a href="/cate105/">C语言</a><a href="/cate133/">新手学堂</a><a href="/cate149/">数据库</a><a href="/cate151/">ASP编程</a><a href="/cate153/">PHP编程</a><a href="/cate154/">XML/RSS</a><a href="/cate155/">Flex</a><a href="/cate156/">正则表达式</a><a href="/cate158/">R语言</a><a href="/cate159/">汇编语言</a><a href="/cate160/">其他教程</a><a href="/cate165/">移动</a></div></div><form method="get" class="search-form clearfix" id="search-formhybrid-search" target="_blank" action="/search/article/"><div class="search-input-wrap"><input type="text" class="search-text" placeholder="来搜我" name="word" id="search-texthybrid-search" value="" data-placeholder=""><b class="search-liaosheji"></b><button type="submit" class="search-button"><i class="icon-search"></i></button></div></form><div style="text-align:center;margin:0 auto;"><ul class='hot-search layui-clear'><li style="float:left;margin-right:20px;">热门搜索：</li><li style="float:left;margin-right:20px;"><a href='/search/article/?word=操作MySQL数据库'>操作MySQL数据库</a></li><li style="float:left;margin-right:20px;"><a href='/search/article/?word=数据库操作类'>数据库操作类</a></li><li style="float:left;margin-right:20px;"><a href='/search/article/?word=一个简单的php实现的MySQL数据浏览器'>一个简单的php实现的MySQL数据浏览器</a></li><li style="float:left;margin-right:20px;"><a href='/search/article/?word=PHP数据库调用类'>PHP数据库调用类</a></li><li style="float:left;margin-right:20px;"><a href='/search/article/?word=数据库操作'>数据库操作</a></li></ul></div><br/><div class="widget widget_ui_posts"><h3>置顶推荐</h3><ul><li><a href="/cate99/113249168437025.html"><span class="thumbnail"><img data-src="https://ss.0133.cn/upload/article/000/000/001/61c03e45239f0358.jpg" alt="微信青少年监护人可以看聊天记录吗" class="thumb"></span><span class="text">微信青少年监护人可以看聊天记录吗</span><span class="muted">2021-12-20</span></a></li></ul></div><div class="widget widget_recent_entries"><h3>猜你喜欢</h3><ul><li><a href="/cate153/11555762755025.html" target="_blank">php网页标题中文乱码的有效解决方法</a><span class="post-date">2021-10-08</span></li><li><a href="/cate153/11550237528400.html" target="_blank">深入掌握include_once与require_once的区别</a><span class="post-date">2021-10-08</span></li><li><a href="/cate153/1156448968100.html" target="_blank">用PHP实现弹出消息提示框的两种方法</a><span class="post-date">2021-09-13</span></li><li><a href="/cate153/1157700804100.html" target="_blank">利用PHP扩展Xhprof分析项目性能实践教程</a><span class="post-date">2021-09-13</span></li><li><a href="/cate153/11321024188100.html" target="_blank">php数据库的增删改查 php与javascript之间的交互</a><span class="post-date">2021-10-04</span></li><li><a href="/cate153/1159826674025.html" target="_blank">PHPstorm激活码2020年5月13日亲测有效</a><span class="post-date">2021-09-14</span></li><li><a href="/cate153/11521998985025.html" target="_blank">php获取从百度、谷歌等搜索引擎进入网站关键词的方法</a><span class="post-date">2021-10-08</span></li><li><a href="/cate153/1160000462500.html" target="_blank">PHP中文分词的简单实现代码分享</a><span class="post-date">2021-09-14</span></li></ul></div><!--<div class="widget widget_ui_tags"><h3>热门标签</h3><div class="items"><a href="/archives/tag/javascript">JavaScript (324)</a></div></div><div class="widget widget_ui_comments"><h3>最新评论</h3><ul><li><a href="" title=""><img data-src="" class="avatar avatar-100" height="50" width="50"><strong></strong></a></li></ul></div>--></div><div id="leftbar" class="leftbar"><div class="leftbar-con"><div style="text-align: center; width: 160px;"></div></div></div></section><footer class="footer"><div class="container"><p>© 2022 <a href="/">WEB前端开发</a></p><p><a href="/cate88/">工具教程</a> | <a href="/cate71/">前端开发</a> | <a href="/cate61/">常见问题</a> | <a href="/cate129/">操作系统</a> | <a href="/cate103/">编程</a> | <a href="/cate108/">网络安全</a> | <a href="/cate120/">设计</a> | <a href="/cate137/">站长技巧</a></p><div class="footer-gav" style="margin-bottom: 10px ;font-size: 12px;"><img src="https://ss.0133.cn/newimg88/2016/06/beian-gov-cn.png" style="vertical-align: middle; height: 14px;"/><a href="https://beian.miit.gov.cn/" target="_blank">鄂ICP备2021014202号-2</a></div><div class="footer-qrcode"></div></div></footer><script> window.jsui = { www: '', uri: '/wp-content/themes/dux', ver: '5.2.5', roll: ["1", "2"], ajaxpager: '0', url_rp: '/about' }; </script><script type='text/javascript' src='/wp-content/themes/dux/js/libs/bootstrap.min.js?ver=5.2.5'></script><script type='text/javascript' src='/wp-content/themes/dux/js/loader.js?ver=5.2.5'></script><script type='text/javascript' src='/wp-includes/js/wp-embed.min.js?ver=5.0.2'></script><script async="async" type='text/javascript' src='/wp-content/plugins/akismet/_inc/form.js?ver=4.0.8'></script><script type="text/javascript"> var $win = jQuery(window); var $WindowW = $win.width(); var $threebar = jQuery("#leftbar"); if ($threebar.length) { var offsetT = $threebar.offset().top; $win.on("scroll.leftbar", function () { if ($WindowW >= 1200) { if ($win.scrollTop() >= (offsetT)) { $threebar.find(".leftbar-con").css({ "position": "fixed", "top": 0 }); } else { $threebar.find(".leftbar-con").css("position", "static") } } }); } // Array var imagesArr = []; $('#article-content').find("img").each(function (index, Element) { imagesArr.push(Element) }); mediumZoom(imagesArr, { margin: 24, background: '#FFFFFF', scrollOffset: 0 }) </script><script> (function (i, s, o, g, r, a, m) { i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function () { (i[r].q = i[r].q || []).push(arguments) }, i[r].l = 1 * new Date(); a = s.createElement(o), m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m) })(window, document, 'script', '//www.google-analytics.com/analytics.js', 'ga'); ga('create', 'UA-3448069-1', 'css88.com'); ga('send', 'pageview'); </script><script> var _hmt = _hmt || []; (function () { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?08985692e4db1e8be1cff8097c2979b7"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })(); </script><script> (function () { var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script></body></html>