一个带缓存数据功能的mysqli类_PHP教程-php教程-PHP中文网

首页

后端开发

php教程

一个带缓存数据功能的mysqli类_PHP教程

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 13, 2016 pm 05:05 PM

mysqli下面分享功能带数据有的类缓存

下面来分享一个带缓存数据功能的mysqli类，有需要的同学可看看。

代码如下

复制代码

    /**
    * Mysqli类
    *
    * @author 废墟
    * @version v1.0 2009-08-18

    */
    class db_mysqli {
        protected $mysqli;
        protected $sql;
        protected $rs;
        protected $query_num    = 0;
        protected $fetch_mode    = MYSQLI_ASSOC;
        protected $cache_dir    = './cache/';
        protected $cache_time    = 1800;

        public function __construct($dbhost, $dbuser, $dbpass, $dbname) {
            $this->mysqli    = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
            if(mysqli_connect_errno()) {
                $this->mysqli    = false;
                echo '

'.mysqli_connect_error().'

';
                die();
            } else {
                $this->mysqli->set_charset("utf8");
            }
        }

        public function __destruct() {
            $this->free();
            $this->close();
        }

        protected function free() {
            @$this->rs->free();
        }

        protected function close() {
            $this->mysqli->close();
        }

        protected function fetch() {
            return $this->rs->fetch_array($this->fetch_mode);
        }

        protected function getQuerySql($sql, $limit = null) {
            if (@preg_match("/[0-9]+(,[ ]?[0-9]+)?/is", $limit) && !preg_match("/ LIMIT [0-9]+(,[ ]?[0-9]+)?$/is", $sql)) {
                $sql .= " LIMIT " . $limit;
            }
            return $sql;
        }

        protected function get_cache($sql,$method) {
            include_once './cache.php';//若框架中使用__autoload()，这里可以不用加载文件
            $cache    = new cache($this->cache_dir,$this->cache_time);
            $cache_file    = md5($sql.$method);
            $res    = $cache->get_cache($cache_file);
            if(!$res) {
                $res    = $this->$method($sql);
                $cache->set_cache($cache_file, $res);
            }
            return $res;
        }

        public function query_num() {
            return $this->query_num;
        }

        public function set_cache_dir($cache_dir) {
            $this->cache_dir    = $cache_dir;
        }

        public function set_cache_time($cache_time) {
            $this->cache_time    = $cache_time;
        }

        public function query($sql, $limit = null) {
            $sql    = $this->getQuerySql($sql, $limit);
            $this->sql    = $sql;
            $this->rs    = $this->mysqli->query($sql);
            if (!$this->rs) {
                echo "

".$this->mysqli->error."

";
                die();
            } else {
            $this->query_num++;
                return $this->rs;
            }
        }

        public function getOne($sql) {
            $this->query($sql, 1);
            $this->fetch_mode    = MYSQLI_NUM;
            $row = $this->fetch();
            $this->free();
            return $row[0];
        }

        public function get_one($sql) {
            return $this->getOne($sql);
        }

        public function cache_one($sql) {
            $sql    = $this->getQuerySql($sql, 1);
            return $this->get_cache($sql, 'getOne');
        }

        public function getRow($sql, $fetch_mode = MYSQLI_ASSOC) {
            $this->query($sql, 1);
            $this->fetch_mode    = $fetch_mode;
            $row = $this->fetch();
            $this->free();
            return $row;
        }

        public function get_row($sql, $fetch_mode = MYSQLI_ASSOC) {
            return $this->getRow($sql);
        }

        public function cache_row($sql) {
            $sql    = $this->getQuerySql($sql, 1);
            return $this->get_cache($sql, 'getRow');
        }

        public function getAll($sql, $limit = null, $fetch_mode = MYSQLI_ASSOC) {
            $this->query($sql, $limit);
            $all_rows = array();
            $this->fetch_mode    = $fetch_mode;
            while($rows = $this->fetch()) {
                $all_rows[] = $rows;
            }
            $this->free();
            return $all_rows;
        }
        public function get_all($sql, $limit = null, $fetch_mode = MYSQLI_ASSOC) {
            return $this->getAll($sql);
        }

        public function cache_all($sql, $limit = null) {
            $sql    = $this->getQuerySql($sql, $limit);
            return $this->get_cache($sql, 'getAll');
        }

        public function insert_id() {
            return $this->mysqli->insert_id();
        }

        public function escape($str) {
            if(is_array($str)) {
                foreach($str as $key=>$val) {
                    $str[$key] = $this->escape($val);
                }
            } else {
                $str = addslashes(trim($str));
            }
            return $str;
        }
    }
    //用法
    $db    = new db_mysqli('localhost', 'root', 111222, 'dict');
    $db->set_cache_time(10);
    $db->set_cache_dir('./cache/sql/');
    $sql = "select * from words order by word_id limit 10,10";
    $res1 = $db->get_all($sql);
    $res2 = $db->cache_all($sql);

    echo $db->query_num(),'
';
    ?>

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

如何使PHP应用程序更快May 12, 2025 am 12:12 AM

tomakephpapplicationsfaster，关注台词：1）useopcodeCachingLikeLikeLikeLikeLikePachetoStorePreciledScompiledScriptbyTecode.2）MinimimiedAtabaseSqueriSegrieSqueriSegeriSybysequeryCachingandeffeftExting.3）Leveragephp7 leveragephp7 leveragephp7 leveragephpphp7功能forbettercodeefficy.4）

PHP性能优化清单：立即提高速度May 12, 2025 am 12:07 AM

到ImprovephPapplicationspeed，关注台词：1）启用opcodeCachingwithapCutoredUcescriptexecutiontime.2）实现databasequerycachingusingpdotominiminimizedatabasehits.3）usehttp/2tomultiplexrequlexrequestsandredececonnection.4 limitsclection.4.4

PHP依赖注入：提高代码可检验性May 12, 2025 am 12:03 AM

依赖注入（DI）通过显式传递依赖关系，显着提升了PHP代码的可测试性。 1）DI解耦类与具体实现，使测试和维护更灵活。 2）三种类型中，构造函数注入明确表达依赖，保持状态一致。 3）使用DI容器管理复杂依赖，提升代码质量和开发效率。

PHP性能优化：数据库查询优化May 12, 2025 am 12:02 AM

databasequeryOptimizationinphpinvolVolVOLVESEVERSEVERSTRATEMIESOENHANCEPERANCE.1）SELECTONLYNLYNESSERSAYCOLUMNSTORMONTOUMTOUNSOUDSATATATATATATATATATATRANSFER.3）

简单指南：带有PHP脚本的电子邮件发送May 12, 2025 am 12:02 AM

phpisusedforsenderemailsduetoitsbuilt-inmail（）函数andsupportiveLibrariesLikePhpMailerandSwiftMailer.1）usethemail（）functionforbasicemails，butithasimails.2）butithasimimitations.2）

PHP性能：识别和修复瓶颈May 11, 2025 am 12:13 AM

PHP性能瓶颈可以通过以下步骤解决：1)使用Xdebug或Blackfire进行性能分析，找出问题所在；2)优化数据库查询并使用缓存，如APCu；3)使用array_filter等高效函数优化数组操作；4)配置OPcache进行字节码缓存；5)优化前端，如减少HTTP请求和优化图片；6)持续监控和优化性能。通过这些方法，可以显着提升PHP应用的性能。

PHP的依赖注入：快速摘要May 11, 2025 am 12:09 AM

依赖性注射（DI）InphpisadesignPatternthatManages和ReducesClassDeptions，增强量产生性，可验证性和Maintainability.itallowspasspassingDepentenciesLikEdenceSeconnectionSeconnectionStoclasseconnectionStoclasseSasasasasareTers，interitationApertatingAeseritatingEaseTestingEasingEaseTeStingEasingAndScalability。

提高PHP性能：缓存策略和技术May 11, 2025 am 12:08 AM

cachingimprovesphpermenceByStorcyResultSofComputationsorqucrouctationsorquctationsorquickretrieval，reducingServerLoadAndenHancingResponsetimes.feftectivestrategiesinclude：1）opcodecaching，whereStoresCompiledSinmememorytssinmemorytoskipcompliation; 2）datacaching datacachingsingMemccachingmcachingmcachings

See all articles