PHPCMS V9 Database Operation function

indicates that the default current Load_model (' xxxx ') module is located in the table name xxxx

to specify the table name: Operation $this->db->select (...) in mysql.class.php

1. Enquiry
$this->select ($where = ', $data = ' * ', $limit = ', $order = ', $group = ', $key = ') returns an array of result sets
condition, field (Id,name,email ...), sort by, group by, sort by name


2. Querying multiple data and paging

listinfo ($where = ', $order = ', $page = 1, $pagesize =, $key = ', $setpages = ten, $urlrule = ', $array = array ())

3. Get a single record query

get_one ($where = ', $data = ' * ', $order = ', $group = ')

4. Execute SQL query directly

query ($sql);

5. Get the primary key number of the last record added insert_id ()

6, perform Update record action update ($data, $where = ") $data suggested array, $where can be a string for the array

7. Perform Delete record operation Delete ($where)

8. Count the number of records counted ($where = ")

9. Gets the number of bars affected by the last database Operation Affected_rows ()

10. Get data Table primary key get_primary ()

11. Get table field get_fields ($table _name = ")

12, check whether the table exists table_exists ($table)

13. Check if the field exists field_exists ($field)

Phpcms V9 Database operation function