Introduction to Daject

Daject is used

github address: https://github.com/kasonyang/Daject

How to Daject

Suppose there is a table named user in the database, the fields are id, name, age, and the primary key is id

First, let’s introduce Daject

<span include</span> 'Daject/Daject.php';

Copy after login

Then, we create a Table model

<span class</span> UserTable <span extends</span><span  DajectTableBase{
    </span><span protected</span> <span $keys</span> = <span array</span>('id'<span );
}</span>

Copy after login

Pay attention to the name of the class. The naming rule is: table name + Table

In order to use Daject to query data normally, we need to initialize Daject first.

<span //</span><span 新增一个数据库</span>
DajectConfig::addDatabase('master', 'mysql', 'localhost', 'root', 'your_password', 'your_database_name', 'utf8'<span );
</span><span //</span><span 设置当前数据库</span>
DajectConfig::setDatabase('master', 'master'<span );
</span><span //</span><span 设置当前数据库前缀</span>
DajectConfig::setTablePrefix('');

Copy after login

Next, we can perform CURD operations on the database

<span //</span><span 实例化UserTable</span>
<span $table</span> = <span new</span><span  UserTable();
</span><span //</span><span 读取user表的前10条记录</span>
<span $data</span> = <span $table</span>->select(10<span );
</span><span foreach</span>(<span $data</span> <span as</span> <span $d</span><span ){
    </span><span echo</span> 'id:',<span $d</span>['id'],';name:',<span $d</span>['name'<span ];
}

</span><span //</span><span 插入一条记录</span>
<span $table</span>->insert(<span array</span>('name' => '张三','age' => 20<span ));

</span><span //</span><span 增加where条件</span>
<span $table</span>->where(<span array</span>('name'=>'张三'<span ));

</span><span //</span><span 更新数据</span>
<span $table</span>->update(<span array</span>('age'=>25<span ));

</span><span //</span><span 删除数据</span>
<span $table</span>->delete();

Copy after login

Pay attention to the above code. There are no SQL statements in the entire code, but we have completed the common select, insert, update, and delete operations. In fact, when we access the select(), insert(array), update(array) and delete methods, Daject will automatically generate SQL for us and execute it, and then return the data to us. Since we don’t have to write SQL, we greatly reduce the time we waste on writing SQL, and at the same time reduce the probability of SQL syntax errors.

Of course, the above are just some basic operations of Daject. There is more knowledge about Daject. I will share it with you slowly in future articles!