How to write your own database package (4)-Mysql Tutorial-php.cn

How to write your own database package (4)

PHPz

Release： 2017-04-04 14:26:42

Original

1785 people have browsed it

Test database source

In fact, it should have been handed over in the first issue, but it doesn’t hurt to mention it now
ReferenceInstallation mysqlSample database sakila

Scenario description

I have a database (sakila) for testing, with a table (actor) in it, now we will combine it with Model Class binding can easily read data

First, create a new class. The class name is arbitrary, but it is recommended to be consistent with the table name

Actor .php

<?php
/**
* 数据库中的Actor表
* 继承Model的属性和函数
*/
class Actor extends Model {
    // 由于我们的数据库表名和当前的类名是一样的,可以直接省略这一步
    // protected $table = &#39;Actor&#39;;

    // 设置Actor表的主键
    protected $identity = &#39;actor_id&#39;;

    // 或者设置unique key
    // 如果unique key只有一个
    // protected $unique = &#39;actor_id&#39;;
    // 如果多个unique key
    // protected $unique = [&#39;first_name&#39;, &#39;last_name&#39;];

}

Copy after login

Have you found it? Isn’t it very concise? Apart from all the comments you can even set it up with just one line

For example

No conditions required, I just want to read all the data in the table

<?php
/**
 * 特别预告
 * 想必有人发现需要require的文件可能多了一些
 * 这可以用自动载入来解决
 * 敬请期待
 */
// 辅助函数我都写helper里了
require &#39;lib/helper.php&#39;;
require &#39;lib/Connector.php&#39;;
require &#39;lib/Builder.php&#39;;
require &#39;lib/Grammar.php&#39;;
require &#39;lib/Model.php&#39;;
require &#39;model/Actor.php&#39;;

$a = Actor::get();
dd($a);

Copy after login

Return results

array (size=197)
  0 => 
    object(Actor)[207]
      public 'actor_id' => string '1' (length=1)
      public 'first_name' => string 'PENELOPE' (length=8)
      public 'last_name' => string 'GUINESS' (length=7)
      public 'last_update' => string '2006-02-15 04:34:33' (length=19)
  1 => 
    object(Actor)[211]
      public 'actor_id' => string '2' (length=1)
      public 'first_name' => string 'NICK' (length=4)
      public 'last_name' => string 'WAHLBERG' (length=8)
      public 'last_update' => string '2006-02-15 04:34:33' (length=19)
  2 => 
    object(Actor)[215]
      public 'actor_id' => string '3' (length=1)
      public 'first_name' => string 'ED' (length=2)
      public 'last_name' => string 'CHASE' (length=5)
      public 'last_update' => string '2006-02-15 04:34:33' (length=19)
  3 => 
    object(Actor)[219]
      public 'actor_id' => string '4' (length=1)
      public 'first_name' => string 'JENNIFER' (length=8)
      public 'last_name' => string 'DAVIS' (length=5)
      public 'last_update' => string '2006-02-15 04:34:33' (length=19)

// 更多数据......

Copy after login

More readable High and applicable to the current requirements of writing

// 这回多一个小要求, 我只想看以下两个声明的字段
$a = Actor::all(['first_name', 'last_name']);

Copy after login

$a = Actor::select('first_name', 'last_name')->get();

Copy after login

Return results

array (size=197)
  0 => 
    object(Actor)[207]
      public 'first_name' => string 'ADAM' (length=4)
      public 'last_name' => string 'GRANT' (length=5)
  1 => 
    object(Actor)[211]
      public 'first_name' => string 'ADAM' (length=4)
      public 'last_name' => string 'HOPPER' (length=6)
  2 => 
    object(Actor)[215]
      public 'first_name' => string 'AL' (length=2)
      public 'last_name' => string 'GARLAND' (length=7)
  3 => 
    object(Actor)[219]
      public 'first_name' => string 'ALAN' (length=4)
      public 'last_name' => string 'DREYFUSS' (length=8)

......

Copy after login

I want search first_name contains Data for the letter L, but do not need the first 5 pieces of data. Take the next 10 pieces of data. If you want to view the first_name and last_name fields, it is enough.
The most readable way of writing,
will give you a preview, PaginationThe prototype of (paginate) is here

$a = Actor::select('first_name', 'last_name')
  ->where('first_name', 'like', '%L%')
  ->skip(5) // 略过5条
  ->take(10) // 拿取10条
  ->get();

Copy after login

Return results

array (size=10)
0 => 
  object(Actor)[20]
    public 'first_name' => string 'ANGELA' (length=6)
    public 'last_name' => string 'HUDSON' (length=6)
1 => 
  object(Actor)[24]
    public 'first_name' => string 'ANGELA' (length=6)
    public 'last_name' => string 'WITHERSPOON' (length=11)
2 => 
  object(Actor)[28]
    public 'first_name' => string 'ANGELINA' (length=8)
    public 'last_name' => string 'ASTAIRE' (length=7)
3 => 
  object(Actor)[32]
    public 'first_name' => string 'BELA' (length=4)
    public 'last_name' => string 'WALKEN' (length=6)
4 => 
  object(Actor)[36]
    public 'first_name' => string 'CHARLIZE' (length=8)
    public 'last_name' => string 'DENCH' (length=5)
5 => 
  object(Actor)[40]
    public 'first_name' => string 'DARYL' (length=5)
    public 'last_name' => string 'CRAWFORD' (length=8)
6 => 
  object(Actor)[44]
    public 'first_name' => string 'DARYL' (length=5)
    public 'last_name' => string 'WAHLBERG' (length=8)
7 => 
  object(Actor)[48]
    public 'first_name' => string 'ELLEN' (length=5)
    public 'last_name' => string 'PRESLEY' (length=7)
8 => 
  object(Actor)[52]
    public 'first_name' => string 'ELVIS' (length=5)
    public 'last_name' => string 'MARX' (length=4)
9 => 
  object(Actor)[56]
    public 'first_name' => string 'EMILY' (length=5)
    public 'last_name' => string 'DEE' (length=3)

Copy after login

Want more examples? Leave a message and I will give the function chain in the comment area

DebuggingTips

Sometimes the lack of understanding of SQL statements may lead to BUG. At this time, you want to look at the native For SQL statements, you can add

// 读取数据
    public function read($sql, $bindings) {
        var_dump($sql); // 就是这一句
        var_dump($bindings); // 还可以确认条件值是否正确对应
        // 将sql语句放入预处理函数
        $statement = $this->connection->prepare($sql);
        // 将附带参数带入pdo实例
        $this->bindValues($statement, $bindings);
        // 执行
        $statement->execute();
        // 返回所有合法数据, 以Object对象为数据类型
        return $statement->fetchAll(PDO::FETCH_OBJ);
    }

Copy after login

to the read() function in Connector.php. Taking the last example as an example, the following two lines will be output:

string 'select first_name, last_name from Actor where Actor.first_name like ? order by 1 asc limit 10 offset 5' (length=102)

array (size=1)
  0 => string '%L%' (length=3)

Copy after login

The above is the detailed content of How to write your own database package (4). For more information, please follow other related articles on the PHP Chinese website!