登录
首页 >  数据库 >  MySQL

php + redis 入门及简单应用

来源:SegmentFault

时间:2023-02-24 17:28:02 169浏览 收藏

本篇文章向大家介绍《php + redis 入门及简单应用》,主要包括MySQL、Redis、PHP,具有一定的参考价值,需要的朋友可以参考一下。

一、实验环境: win10 + redis3.2 + php7
二、php-redis / redis /redis图形管理工个等安装,此步骤略过;
三、redis常用的五种数据类型,不做详细说明
参考:http://www.runoob.com/redis/r...
四、php + mysql + redis 简单应用
数据库名称:redis 数据表:redis_user
模拟 php 操作Mysql + redis 的 CURD 操作

1、config.php配置文件

array(
        'host'=>'127.0.0.1',
        'user'=>'root',
        'pass'=>'root',
        'dbname'=>'redis',
        'prefix'=>'redis_'
    ),
    'redis'=>array(
        'host'=>'127.0.0.1',
        'port'=>6379
    )
);

index.php 入口文件,操作Mysql时请使用主键ID

table('user')->insert(['user'=>'张三','pass'=>md5('123456'),'create_time'=>date('Y-m-d H:i:s')]);

//删除数据
// echo Mysql::getInstance()->table('user')->where(array('id'=>30))->delete();

//查看单条数据
// $data = Mysql::getInstance()->table('user')->where(array('id'=>'30'))->find();
// print_r($data);

//查找所有数据
// $all = Mysql::getInstance()->table('user')->field('id,user')->select();
$all = Mysql::getInstance()->table('user')->select();
print_r($all);

//修改数据
// echo Mysql::getInstance()->table('user')->where(array('id'=>30))->update(['user'=>'张三adfadfasdf11111111','pass'=>md5('123456aaa')]);
?>

图片描述

图片描述

图片描述

Mysql.php 数据库以及redis操作文件

options['prefix'] = $config['mysql']['prefix'];
        $this->conn = $conn;
        $this->redis = new Redis();
        $this->redis->connect($config['redis']['host'],$config['redis']['port']);
    }

    //获取对象实例
    static function getInstance()
    {
        if(self::$instance) {
            return self::$instance;
        } else {
            self::$instance = new self();
            return self::$instance;
        }
    }

    //设置表名
    public function table(string $table)
    {
        $this->options['table'] = '`'.$this->options['prefix'].$table.'`';
        return $this;
    }

    //设置redis键名
    public function redis(string $key)
    {
        $this->options['key'] = $key;
        return $this;
    }

    //设置条件
    public function where(array $where)
    {
        $condition = '';
        $and = count($where) > 1 ? ' and ' : '';
        foreach ($where as $key => $value) {
            if($key == 'id') {$this->options['user_id'] = $value;}
            if(strpos($key,':')) {
                $arr = explode(':', $key);
                $condition .= '`'.$arr['0'].'` '.$arr['1']. ' "'.$value.'" ' . $and ; 
            } else {
                $condition .= '`'.$key.'` = ' .'"'.$value.'"' .$and  ; 
            }
        }
        $this->options['where'] = rtrim($condition,' and ');
        return $this;
    }

    //设置字段
    public function field(string $field)
    {
        $this->options['field'] = $field;
        return $this;
    }
    
    //增加数据
    public function insert(array $data)
    {
        $key = '`'.implode('`,`', array_keys($data)).'`';
        $value = '"'.implode('","', $data).'"';
        $sql = "insert into {$this->options['table']} (".$key.") values (".$value.");";
        if( mysqli_query($this->conn,$sql) ) {
            $user_id = $this->conn->insert_id;
            $data['id'] = $user_id;
            //以hash类型存储
            $this->redis->hset($this->options['table'],$user_id,json_encode($data));
            return $user_id;
        } else {
            return 0;
        }
    }

    //删除数据
    public function delete()
    {
        $where = $this->options['where'] ? $this->options['where'] : '1';
        $sql = "delete from {$this->options['table']} where {$where};";
        if(mysqli_query($this->conn,$sql)) {
            $this->redis->hdel($this->options['table'],$this->options['user_id']);
            return 1;
        } else {
            return 0;
        }
    }

    //修改数据
    public function update(array $data)
    {
        $condition = '';
        $where = $this->options['where'] ? $this->options['where'] : '1';
        foreach ($data as $key => $value) {
            $condition .= ", `".$key."` = '".$value."'";
        }
        $condition = substr($condition, 1);
        $sql = " update {$this->options['table']} set {$condition} where {$where} ; ";
        if(mysqli_query($this->conn,$sql)) {
            $hashData = (array)json_decode($this->redis->hget($this->options['table'],$this->options['user_id']));
            foreach ($data as $key => $value) {
                $hashData[$key] = $value;
            }
            $this->redis->hset($this->options['table'],$this->options['user_id'],json_encode($hashData));
            return 1;
        } else {
            return 0;
        }
    }


    //查找单条数据
    public function find()
    {
        $field  = $this->options['field'] ? $this->options['field'] : '*';
        $where = $this->options['where'] ? $this->options['where'] : '1';
        if($this->options['user_id']) {
            echo '从redis获取数据
';
            $data = (array)json_decode($this->redis->hget($this->options['table'],$this->options['user_id']));
            if($field != '*') {
                $field = explode(',', $field);
                foreach ($field as $value) {
                    $arr[$value] = $data[$value];
                    $arr['typ'] = 'redis';
                }
                return $arr;
                
            }
            return $data;
            
        } else {
            
            $sql = " select {$field} from {$this->options['table']} where {$where}; ";
            if($query = mysqli_query($this->conn,$sql)) {
                return mysqli_fetch_assoc($query);
            } else {
                return array();
            }
        }
    }
    //查找所有数据
    public function select()
    {
        $data = array();
        $field  = $this->options['field'] ? $this->options['field'] : '*';
        $hashData = $this->redis->hgetall($this->options['table']);
        if($hashData) {
            if($field != '*') { 
                $field = explode(',', $field);
            }
            foreach ($hashData as $key => $value) {
                $data[$key] = array();
                $values = (array)json_decode($value);
                if($field != '*') {
                    foreach ($field as $k => $v) {
                        $data[$key][$v] = $values[$v];
                    }
                }else{
                    $data[$key] = $values;
                }
            }
            echo '从redis获取数据
';
        } else {
            $sql = " select {$field} from {$this->options['table']} ; ";
            if($query = mysqli_query($this->conn,$sql)) {
                while ($row = mysqli_fetch_assoc($query)) {
                    $data[] = $row;
                }
            }
        }
        return $data;
    }

    

    public function __destruct()
    {
        mysqli_close($this->conn);
    }
}

以上就是本文的全部内容了,是否有顺利帮助你解决问题?若是能给你带来学习上的帮助,请大家多多支持golang学习网!更多关于数据库的相关知识,也可关注golang学习网公众号。

声明:本文转载于:SegmentFault 如有侵犯,请联系study_golang@163.com删除
相关阅读
更多>
最新阅读
更多>
课程推荐
更多>
评论列表