A simple ORM class-php手册-php.cn

Home

php教程

php手册

A simple ORM class

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Dec 01, 2016 am 12:00 AM

I wrote a simple ORM class myself to provide some ideas for interested friends.
I wrote a simple ORM class by myself to provide some ideas for interested friends. I borrowed a little bit of TP’s ideas. <?php /** * author: NickBai *createTime: 2016/11/28 0028 4:00 pm */ class MyOrm implements ArrayAccess { Public $host = '127.0.0.1'; //Database address Public $dbname = 'test'; //Database name Public $user = 'root'; //Database user name Public $pwd = 'root'; //Database password Public $port = '3306'; //Database port Public $charset = 'utf8'; //Database encoding Private $ conn = null; // Database link resources Private $alias = []; //Record global statement parameters private $sql; // Store the last sql Public function __construct() { if( $dsn = "mysql:host=$this->host;dbname=$this->dbname;charset=$this->charset;port=$this->port"; $this->conn = new PDO( $dsn, $this->user, $this->pwd); } } //Field statement Public function field($field) { If (! Is_string ($ field)) { throw new exception("The parameters of the field statement must be strings"); } $this->alias['field'] = $field; Return $ this; } //table statement Public function table($table) { if( throw new exception("The parameters of the table statement must be strings"); } $this->alias['table'] = $table; Return $ this; } //where statement Public function where($where) { $this->alias['where'] = ''; if(is_array($where)){ foreach( $where as $key=>$vo ){ $this->alias['where'] .= " `$key`" . ' = ' . $vo . ' and '; } $this->alias['where'] = rtrim( $this->alias['where'], 'and ' ); }else if( is_string( $where )){ $this->alias['where'] = $where; }else{ throw new exception("The parameters of the where statement must be an array or a string"); } Return $ this; } //limit statement Public function limit($limit) { $this->alias['limit'] = ''; if( $this->alias['limit'] = '0,' . $limit; }else if( is_string( $limit )){ $this->alias['limit'] = $limit; }else{ throw new exception("The parameters of the limit statement must be numbers or strings"); } Return $ this; } //Order statement Public function order( $order) { if( throw new exception("The parameters of the order statement must be strings"); } $this->alias['order'] = $order; Return $ this; } //group statement Public function group($group) { If (! Is_string ($ Group)) { throw new exception("The parameter of the group statement must be a string"); } $this->alias['group'] = $group; Return $ this; } //Parse query sql statement Public function ParseSelectSql() { $this->sql = 'select *'; If( !empty( $this->alias['field'] ) ){ $this->sql = str_replace( '*', $this->alias['field'], $this->sql ); } If (Empty ($ this- & gt; alias ['table'])) { throw new exception("Please use the table clause to set the query table"); }else{ $this->sql .= ' from ' . $this->alias['table']; } If( !empty( $this->alias['where'] ) ){ $this->sql .= ' where ' . $this->alias['where']; } If( !empty( $this->alias['group'] ) ){ $this->sql .= ' group by ' . $this->alias['group']; } if( !empty( $this->alias['order'] ) ){ $this->sql .= ' order by ' . $this->alias['order']; } if( !empty( $this->alias['limit'] ) ){ $this->sql .= ' limit ' . $this->alias['limit']; } } //解析添加sql语句 public function ParseAddSql() { $this->sql = 'insert into '; if( empty( $this->alias['table'] ) ){ throw new exception("请用table子句设置添加表"); }else{ $this->sql .= $this->alias['table'] . ' set '; } return $this->sql; } //解析更新sql语句 public function ParseUpdateSql() { $this->sql = 'update '; if( empty( $this->alias['table'] ) ){ throw new exception("请用table子句设置修改表"); }else{ $this->sql .= $this->alias['table'] . ' set '; } if( empty( $this->alias['where'] ) ){ throw new exception("更新语句必须有where子句指定条件"); } return $this->sql; } //解析删除sql语句 public function ParseDeleteSql() { $this->sql = 'delete from '; if( empty( $this->alias['table'] ) ){ throw new exception("请用table子句设置删除表"); }else{ $this->sql .= $this->alias['table']; } if( empty( $this->alias['where'] ) ){ throw new exception("删除语句必须有where子句指定条件"); } $this->sql .= ' where ' . $this->alias['where']; return $this->sql; } //查询语句 public function select() { $this->ParseSelectSql(); $row = $this->conn->query( $this->sql )->fetchAll( PDO::FETCH_ASSOC ); $result = []; foreach( $row as $key=>$vo ){ $arrObj = clone $this; //Clone the current object to prevent contamination of this object $arrObj->data = $vo; $result[$key] = $arrObj; unset($arrObj); } Return $ result; } //Query one item Public function find() { $this->ParseSelectSql(); $row = $this->conn->query( $this->sql )->fetch( PDO::FETCH_ASSOC ); $arrObj = clone $this; //Clone the current object to prevent contamination of this object $arrObj->data = $row; $result = $arrObj; unset($arrObj); Return $ result; } //Add data Public function add($data) { if( throw new exception("Add data add method parameters must be arrays"); } $this->ParseAddSql(); foreach( $data as $key=>$vo ){ $this->sql .= " `{$key}` = '" . $vo . "',"; } $this->conn->exec( rtrim( $this->sql, ',' )); return $this->conn->lastInsertId(); } //Update statement Public function update($data) { if( throw new exception("Update data update method parameters must be arrays"); } $this->ParseUpdateSql(); foreach( $data as $key=>$vo ){ $this->sql .= " `{$key}` = '" . $vo . "',"; } $this->sql = rtrim( $this->sql, ',') . ' where ' . $this->alias['where']; return $this->conn->exec( $this->sql ); } //Delete statement Public function delete() { $this->ParseDeleteSql(); return $this->conn->exec( $this->sql ); } //获取查询数据 public function getData() { return $this->data; } //获取最后一次执行的sql语句 public function getLastSql() { return $this->sql; } public function __get($name) { return $this->getData()[$name]; } public function offsetExists($offset) { if( !isset( $this->getData()[$offset] ) ){ return NULL; } } public function offsetGet($offset) { return $this->getData()[$offset]; } public function offsetSet($offset, $value) { return $this->data[$offset] = $value; } public function offsetUnset($offset) { unset( $this->data[$offset] ); } }你可以这么用：$orm = new MyOrm(); //查询语句 $res = $orm->table('user')->order('id desc')->select(); $res = $orm->table('user')->where("name='test'")->order('id desc')->select(); $res = $orm->table('user')->where(['id' => 1])->order('id desc')->find(); $res = $orm->table('user')->where("age > 20")->group('group by name')->order('id desc')->limit(2)->select(); $res = $orm->table('user')->where("age > 20")->group('group by name')->order('id desc')->limit('2,2')->select(); //你可以这样处理数据 foreach( $res as $key=>$vo ){ echo $vo->name . ' '; } //也可以这样处理 foreach( $res as $key=>$vo ){ echo $vo['name'] . ' '; } //还可以这样 foreach( $res as $key=>$vo ){ print_r( $vo->getData() ) . ' '; } //添加数据 $data = [ 'name' => 'test1', 'age' => 20, 'password' => '21232f297a57a5a743894a0e4a801fc3', 'salt' => 'domain' ]; $res = $orm->table('user')->add( $data ); //更新数据 $res = $orm->table('user')->where(['id' => 4])->update( ['name' => 'sdfdsfdsd', 'salt' => '111'] ); //删除数据 $res = $orm->table('user')->where(['id' => 7, 'id' => 6])->delete(); //获取执行的sql语句 echo $orm->getLastSql(); var_dump($res);

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

主板上的数字音频输出接口-SPDIF OUTJan 14, 2024 pm 04:42 PM

主板上SPDIFOUT连接线序最近我遇到了一个问题，就是关于电线的接线顺序。我上网查了一下，有些资料说1、2、4对应的是out、+5V、接地；而另一些资料则说1、2、4对应的是out、接地、+5V。最好的办法是查看你的主板说明书，如果找不到说明书，你可以使用万用表进行测量。首先找到接地，然后就可以确定其他的接线顺序了。主板vdg怎么接线连接主板的VDG接线时，您需要将VGA连接线的一端插入显示器的VGA接口，另一端插入电脑的显卡VGA接口。请注意，不要将其插入主板的VGA接口。完成连接后，您可以

了解Python编程的入门级代码示例Jan 04, 2024 am 10:50 AM

了解Python编程的入门级代码示例Python是一种简单易学，功能强大的编程语言。对于初学者来说，了解Python编程的入门级代码示例是非常重要的。本文将为您提供一些具体的代码示例，帮助您快速入门。打印HelloWorldprint("HelloWorld")这是Python中最简单的代码示例。print()函数用于将指定的内容输出

PHP переменные в действии: 10 реальных примеров использованияFeb 19, 2024 pm 03:00 PM

PHP变量存储程序运行期间的值，对于构建动态且交互式的WEB应用程序至关重要。本文将深入探讨php变量，并通过10个真实的示例展示它们的实际应用。1.存储用户输入$username=$_POST["username"];$passWord=$_POST["password"];此示例从表单提交中提取用户名和密码，并将其存储在变量中以供进一步处理。2.设置配置值$database_host="localhost";$database_username="username";$database_pa

从入门到精通：Go语言中常用数据结构的代码实现Mar 04, 2024 pm 03:09 PM

标题：从入门到精通：Go语言中常用数据结构的代码实现数据结构在编程中起着至关重要的作用，它是程序设计的基础。在Go语言中，有许多常用的数据结构，掌握这些数据结构的实现方式对于成为一名优秀的程序员至关重要。本文将介绍Go语言中常用的数据结构，并给出相应的代码示例，帮助读者从入门到精通这些数据结构。1.数组（Array）数组是一种基本的数据结构，是一组相同类型

Go语言编程实例：Web开发中的代码示例Mar 04, 2024 pm 04:54 PM

《Go语言编程实例：Web开发中的代码示例》随着互联网的快速发展，Web开发已经成为各行业中必不可少的一部分。作为一门功能强大且性能优越的编程语言，Go语言在Web开发中越来越受到开发者们的青睐。本文将通过具体的代码示例，介绍如何利用Go语言进行Web开发，让读者能够更好地理解和运用Go语言来构建自己的Web应用。1.简单的HTTP服务器首先，让我们从一个

Java实现简单的冒泡排序代码Jan 30, 2024 am 09:34 AM

Java冒泡排序最简单的代码示例冒泡排序是一种常见的排序算法，它的基本思想是通过相邻元素的比较和交换来将待排序序列逐步调整为有序序列。下面是一个简单的Java代码示例，演示了如何实现冒泡排序：publicclassBubbleSort{publicstaticvoidbubbleSort(int[]arr){int

币圈货币种类有哪些？全球十大币圈交易所平台一览Feb 14, 2025 pm 08:33 PM

随着数字货币的兴起，币圈的世界日益庞大。本文重点介绍币圈中货币种类的多样性，并对全球十大币圈交易所平台进行全面考察。通过分析币种的特性和交易平台的优势，旨在为读者提供全面深入的币圈指南。

如何使用PHP编写库存管理系统中的库存分仓管理功能代码Aug 06, 2023 pm 04:49 PM

如何使用PHP编写库存管理系统中的库存分仓管理功能代码库存管理是许多企业中不可或缺的一部分。对于拥有多个仓库的企业来说，库存分仓管理功能尤为重要。通过合理管理和跟踪库存，企业可以实现不同仓库之间的库存调拨，优化运营成本，改善协同效率。本文将介绍如何使用PHP编写库存分仓管理功能的代码，并为您提供相关的代码示例。一、建立数据库在开始编写库存分仓管理功能的代码之

See all articles