ECMall's simple method for calling MySQL data _ PHP Tutorial

ECMall is a simple method for calling MySQL data. Many ecmall developers will ask how to use the mysql class library of Ecmall to call data. In principle, Ecmall data calling is performed by using the data module + Module class library for mysql data calling. many ecmall developers will ask how to use the Ecmall mysql class library for data calling. In principle, Ecmall calls mysql data in the form of a data module + Module class library. all data modules are stored in the includesmodels directory, these calls are complex for beginners. for example, the product data call function cannot be used for store data calls, each data table has its own function class library and a small number of public class libraries. Therefore, it is difficult for beginners to call mysql data.

A simple call method can meet more than 95% of mysql data call requests. Sufficient for secondary development of ecmall.

Example:

$ Db = & db (); // value the database class library in step 1, $ db-> query (SQL); // execute the mysql statement in step 2;

Common Database functions:

1. Get a row of data

$user=$db->getrow("select * from ecm_member where user_id=111");print_r($user);

2. Get a column of data

$user=$db->getcol("select user_id from ecm_member ");print_r($user);

3. Get all data

$user=$db->getall("select user_id from ecm_member ");foreach ( $user as $row){print_r($row);}

4. Returns a value.

$user=$db->getone("select count(*) from ecm_member ");echo $user;

5. Execute SQL statements

$db->query("update ecm_member  set user_name='aaa' ");

6. Obtain the last ID.

$db->query("insert ecm_member  set user_name='aaa' ");$user_id = $db->insert_id();echo $user_id;

Example:

Function userlist () {$ db = & db (); $ user = $ db-> getall ("select user_id from ecm_member"); foreach ($ user as $ row) {echo "user name = ". $ row ['User _ name']. "User phone = ". $ row ['tel'];}

Bytes. In principle, Ecmall's data calling is based on the data module + Module class library for mysql data calling...