PHP数据库开发框架Medoo.7z资源-CSDN下载

共1个文件

php：1个

17 浏览量 2023-03-18 18:47:58 上传评论收藏 5KB 7Z 举报

**PHP数据库开发框架Medoo详解** Medoo是一个轻量级且易于使用的PHP数据库框架，它旨在简化数据库操作，使得开发者可以更加专注于业务逻辑而非复杂的SQL语法。Medoo提供了丰富的功能，支持多种数据库类型，包括MySQL、PostgreSQL、SQLite、Oracle等，同时也支持PDO和mysqli扩展。下面将详细探讨Medoo的主要特性和使用方法。 ### 1. 安装与配置 Medoo的安装非常简单，可以通过Composer在项目中引入。在`composer.json`文件中添加依赖： ```json { "require": { "medoo/medoo": "^1.8" } } ``` 然后运行`composer install`命令即可。配置Medoo需要创建一个配置文件，例如`database.php`： ```php <?php return [ 'type' => 'mysql', // 数据库类型 'host' => 'localhost', // 主机名 'database' => 'test_db', // 数据库名 'username' => 'root', // 用户名 'password' => '', // 密码 'charset' => 'utf8mb4', // 字符集 ]; ``` ### 2. 连接数据库在PHP中，使用Medoo连接数据库只需要一行代码： ```php require 'database.php'; $database = new Medoo($config); ``` ### 3. 数据表操作 #### 3.1 插入数据插入数据到表中，使用`insert`方法： ```php $database->insert('table', [ 'name' => 'John Doe', 'email' => 'john@example.com', ]); ``` #### 3.2 查询数据查询数据，使用`get`或`select`方法： ```php // 获取单条记录 $result = $database->get('table', '*', ['id' => 1]); // 获取多条记录 $results = $database->select('table', '*', ['ORDER BY' => 'id DESC']); ``` #### 3.3 更新数据更新数据，使用`update`方法： ```php $database->update('table', [ 'name' => 'Jane Doe', ], ['id' => 1]); ``` #### 3.4 删除数据删除数据，使用`delete`方法： ```php $database->delete('table', ['id' => 1]); ``` ### 4. 链式操作 Medoo支持链式操作，如查询和条件判断： ```php $results = $database->table('table') ->where('id', 1) ->orWhere('status', 'active') ->order('created_at', 'DESC') ->limit(10) ->get(); ``` ### 5. 关联查询 Medoo支持一对一、一对多、多对多关联查询。例如，对于用户和其文章的一对多关联： ```php class User { public $id; public $name; public function articles() { return $this->hasMany('Article', 'user_id'); } } class Article { public $id; public $title; public $user_id; public function user() { return $this->belongsTo('User', 'user_id'); } } $user = $database->get('users', '*', ['id' => 1]); $articles = $user->articles(); ``` ### 6. 数据预处理与安全 Medoo自动对所有输入的数据进行预处理，防止SQL注入攻击，确保数据安全。 ### 7. 性能优化 Medoo的轻量级设计和高效的查询处理机制，使其在性能上表现出色。同时，它支持缓存功能，通过配置可以使用Memcached或Redis等缓存系统，进一步提升性能。 ### 8. 兼容性与社区支持 Medoo兼容PHP 5.3及以上版本，并且有活跃的社区支持，不断更新和完善。遇到问题，可以在官方GitHub仓库提issue或者参考已有的解决方案。总结，Medoo作为一款PHP数据库开发框架，以其简洁的API、强大的功能和广泛的数据库支持，为PHP开发者提供了一种高效、便捷的数据库操作方式，大大提高了开发效率。无论是小型项目还是大型应用，Medoo都能胜任。

资源推荐

资源详情

资源评论

收起资源包目录

PHP数据库开发框架Medoo.7z （1个子文件）

PHP数据库开发框架Medoo

medoo.php 20KB

<?php /*! * Medoo database framework * http://medoo.in * Version 0.9.8 * * Copyright 2015, Angel Lai * Released under the MIT license */ class medoo { // General protected $database_type; protected $charset; protected $database_name; // For MySQL, MariaDB, MSSQL, Sybase, PostgreSQL, Oracle protected $server; protected $username; protected $password; // For SQLite protected $database_file; // For MySQL or MariaDB with unix_socket protected $socket; // Optional protected $port; protected $option = array(); // Variable protected $logs = array(); protected $debug_mode = false; public function __construct($options = null) { try { $commands = array(); if (is_string($options) && !empty($options)) { if (strtolower($this->database_type) == 'sqlite') { $this->database_file = $options; } else { $this->database_name = $options; } } elseif (is_array($options)) { foreach ($options as $option => $value) { $this->$option = $value; } } if ( isset($this->port) && is_int($this->port * 1) ) { $port = $this->port; } $type = strtolower($this->database_type); $is_port = isset($port); switch ($type) { case 'mariadb': $type = 'mysql'; case 'mysql': if ($this->socket) { $dsn = $type . ':unix_socket=' . $this->socket . ';dbname=' . $this->database_name; } else { $dsn = $type . ':host=' . $this->server . ($is_port ? ';port=' . $port : '') . ';dbname=' . $this->database_name; } // Make MySQL using standard quoted identifier $commands[] = 'SET SQL_MODE=ANSI_QUOTES'; break; case 'pgsql': $dsn = $type . ':host=' . $this->server . ($is_port ? ';port=' . $port : '') . ';dbname=' . $this->database_name; break; case 'sybase': $dsn = 'dblib:host=' . $this->server . ($is_port ? ':' . $port : '') . ';dbname=' . $this->database_name; break; case 'oracle': $dbname = $this->server ? '//' . $this->server . ($is_port ? ':' . $port : ':1521') . '/' . $this->database_name : $this->database_name; $dsn = 'oci:dbname=' . $dbname . ($this->charset ? ';charset=' . $this->charset : ''); break; case 'mssql': $dsn = strstr(PHP_OS, 'WIN') ? 'sqlsrv:server=' . $this->server . ($is_port ? ',' . $port : '') . ';database=' . $this->database_name : 'dblib:host=' . $this->server . ($is_port ? ':' . $port : '') . ';dbname=' . $this->database_name; // Keep MSSQL QUOTED_IDENTIFIER is ON for standard quoting $commands[] = 'SET QUOTED_IDENTIFIER ON'; break; case 'sqlite': $dsn = $type . ':' . $this->database_file; $this->username = null; $this->password = null; break; } if ( in_array($type, explode(' ', 'mariadb mysql pgsql sybase mssql')) && $this->charset ) { $commands[] = "SET NAMES '" . $this->charset . "'"; } $this->pdo = new PDO( $dsn, $this->username, $this->password, $this->option ); foreach ($commands as $value) { $this->pdo->exec($value); } } catch (PDOException $e) { throw new Exception($e->getMessage()); } } public function query($query) { if ($this->debug_mode) { echo $query; $this->debug_mode = false; return false; } array_push($this->logs, $query); return $this->pdo->query($query); } public function exec($query) { if ($this->debug_mode) { echo $query; $this->debug_mode = false; return false; } array_push($this->logs, $query); return $this->pdo->exec($query); } public function quote($string) { return $this->pdo->quote($string); } protected function column_quote($string) { return '"' . str_replace('.', '"."', preg_replace('/(^#|$JSON$)/', '', $string)) . '"'; } protected function column_push($columns) { if ($columns == '*') { return $columns; } if (is_string($columns)) { $columns = array($columns); } $stack = array(); foreach ($columns as $key => $value) { preg_match('/([a-zA-Z0-9_\-\.]*)\s*$([a-zA-Z0-9_\-]*)$/i', $value, $match); if (isset($match[1], $match[2])) { array_push($stack, $this->column_quote( $match[1] ) . ' AS ' . $this->column_quote( $match[2] )); } else { array_push($stack, $this->column_quote( $value )); } } return implode($stack, ','); } protected function array_quote($array) { $temp = array(); foreach ($array as $value) { $temp[] = is_int($value) ? $value : $this->pdo->quote($value); } return implode($temp, ','); } protected function inner_conjunct($data, $conjunctor, $outer_conjunctor) { $haystack = array(); foreach ($data as $value) { $haystack[] = '(' . $this->data_implode($value, $conjunctor) . ')'; } return implode($outer_conjunctor . ' ', $haystack); } protected function fn_quote($column, $string) { return (strpos($column, '#') === 0 && preg_match('/^[A-Z0-9\_]*$[^)]*$$/', $string)) ? $string : $this->quote($string); } protected function data_implode($data, $conjunctor, $outer_conjunctor = null) { $wheres = array(); foreach ($data as $key => $value) { $type = gettype($value); if ( preg_match("/^(AND|OR)\s*#?/i", $key, $relation_match) && $type == 'array' ) { $wheres[] = 0 !== count(array_diff_key($value, array_keys(array_keys($value)))) ? '(' . $this->data_implode($value, ' ' . $relation_match[1]) . ')' : '(' . $this->inner_conjunct($value, ' ' . $relation_match[1], $conjunctor) . ')'; } else { preg_match('/(#?)([\w\.]+)(\[(\>|\>\=|\<|\<\=|\!|\<\>|\>\<|\!?~)\])?/i', $key, $match); $column = $this->column_quote($match[2]); if (isset($match[4])) { $operator = $match[4]; if ($operator == '!') { switch ($type) { case 'NULL': $wheres[] = $column . ' IS NOT NULL'; break; case 'array': $wheres[] = $column . ' NOT IN (' . $this->array_quote($value) . ')'; break; case 'integer': case 'double': $wheres[] = $column . ' != ' . $value; break; case 'boolean': $wheres[] = $column . ' != ' . ($value ? '1' : '0'); break; case 'string': $wheres[] = $column . ' != ' . $this->fn_quote($key, $value); break; } } if ($operator == '<>' || $operator == '><') { if ($type == 'array') { if ($operator == '><') { $column .= ' NOT'; } if (is_numeric($value[0]) && is_numeric($value[1])) { $wheres[] = '(' . $column . ' BETWEEN ' . $value[0] . ' AND ' . $value[1] . ')'; } else { $wheres[] = '(' . $column . ' BETWEEN ' . $this->quote($value[0]) . ' AND ' . $this->quote($value[1]) . ')'; } } } if ($operator == '~' || $operator == '!~') { if ($type == 'string') { $value = array($value); } if (!empty($value)) { $like_clauses = array(); foreach ($value as $item) { if ($operator == '!~') { $column .= ' NOT'; } if (preg_match('/^(?!%).+(?<!%)$/', $item)) { $item = '%' . $item . '%'; } $like_clauses[] = $column . ' LIKE ' . $this->fn_quote($key, $item); } $wheres[] = implode(' OR ', $like_clauses); } } if (in_array($operator, array('>', '>=', '<', '<='))) { if (is_numeric($value)) { $wheres[] = $column . ' ' . $operator . ' ' . $value; } elseif (strpos($key, '#') === 0) { $wheres[] = $column . ' ' . $operator . ' ' . $this->fn_quote($key, $value); } else { $wheres[] = $column . ' ' . $operator . ' ' . $this->quote($value); } } } else { switch ($type) { case 'NULL': $whe

评论收藏

内容反馈