Shulou(Shulou.com)06/01 Report--

Query query class tags (for front-end traversal)

Example:

{query:name=goods}

{$item ['name']}

{/ query}

I actually write the code application in the development:

Paging:

{set:$page=IReq::get ('page') = = null?1:IReq::get (' page');} / / define paging variables

{query:name=goods page=$page pagesize=5}

{$key}: {$item ['name']}

{/ query}

{$query- > getPageBar ()} / / call the paging method

Database reads and writes:

IQuery class:

IQuery provides a wealth of properties and functions, through simple property configuration, you can achieve a lot of SQL query functions, such as we need to query business

For the id=10 items in the goods, then:

$goodsDB = new IQuery ('goods')

$goodsDB- > where = "id = 10"

$goodsData = $goodsDB- > find ()

. Find () is an interface that performs a query on the final data.

Once the IQuery object is created, you can set various class properties to combine the query data.

The list of main attributes is as follows:

Attribute name data type description

Fields String optional default * read the field data of the table

Where String optional default no query condition

Join String defaults to table-less join operations, such as:

$db = new IQuery ('goods as g')

$db- > join= "left join products as p on g.id = p.goods_id"

$db- > find ()

Group String defaults to table-less grouping operations, such as:

$db = new IQuery ('goods as g')

$db- > group = "price"

$db- > find ()

Having String can choose to filter the results of grouping without tables by default. Setting the group attribute is meaningful.

Order String optional default no table sort field

Limit Int can choose 20 entries by default to read the specified number of entries

Page Int optionally defaults to no paging. Add paging attribute to IQuery class library after setting (paging class)

Pagesize Int can choose the default 20 pieces of data displayed in each page. Setting the page property makes sense.

Pagelength Int can choose how many pages are displayed by default 10 pages. Setting the page property makes sense.

Cache String optional memcache, cache query results to improve efficiency and reduce database pressure. Fill in the caching mode, provided that your system supports iWebShop caching technology

Debug Int optional 0 off by default; 1 enable debugging SQL statement, the system will automatically output a complete SQL original statement

The application of writing code in my actual development

Query:

Function give_goods_list () {$giveaway_Obj = new IQuery ('giveaway'); $giveaway_Obj-> where = "is_del = 0"; $giveaway_infos = $giveaway_Obj-> find (); $this- > data = $giveaway_infos; $this- > redirect (' give_goods_list');}

IModel class:

IModel class is generally used for database writing. Currently, update (update), add (add), del (delete) and dropTable (uninstall) are supported.

Table), createTable (create table).

Generally, the database instance is created by creating a new IModel (table name) object, and then the setData () API is called to set the data.

Buy.

For example, to update the price field of the goods table, it is:

$goodsDB = new IModel ('goods')

$goodsDB- > setData (array ('price' = > 1000))

$goodsDB- > update ('id = 2')

Method name data type description

Update ($where

$except=array ()

)

$where:string update condition

$except:array special expression

Field (non-string type)

Update record

Use $this- > setData ($array); $array (field = > update data)

Table update fields corresponding to data relations

Add () add record

Through $this- > setData ($array); $array (field = > add data)

Table add record corresponding data relationship

Del ($where) $where:string delete condition delete record

Delete all records that meet the $where condition

DropTable () unload table

Delete the table corresponding to the current IModel instance

CreateTable () create a table

Create the table corresponding to the current IModel instance

Create table elements (multidimensional arrays) through $this- > setData ($array); settings

$array = array (

"column" = > Field configuration array ("type" = > data type, "default"

= > default value, "comment" = > field comments, "auto_increment" = >

The value is self-increasing)

"comment" = > Table comments

"index" = > Table index array ("index class

Type: PRIMARY,KEY,UNIQUE "= >" Field name ")

I actually write the code application in the development:

Add:

Function supplier_edit_add () {$id = IFilter::act (IReq::get ('id'),' int'); $company = IFilter::act (IReq::get ('firm_name')); $address = IFilter::act (IReq::get (' address')); $pname = IFilter::act (IReq::get ('name')); $mobile = IFilter::act (IReq::get (' mobile')); $phone = IFilter::act (IReq::get ('telephone')) $img = IFilter::act (IReq::get ('img')); $account = IFilter::act (IReq::get (' account_num')); $bank = IFilter::act (IReq::get ('bank_name')); $province = IFilter::act (IReq::get (' province'), 'int'); $city = IFilter::act (IReq::get (' city'), 'int') $area = IFilter::act (IReq::get ('area'),' int'); $_ POST ['area'] = ""; if ($province & & $city & & $area) {$_ POST [' area'] = array ($province,$city,$area);} $user_id = $this- > admin ['admin_id']; $stock = new IModel (' supplier_list') $stock_Init = array ('firm_name' = > $company,' area' = > $_ POST ['area']? "," .join (",", $_ POST [' area']). ",": ", 'address' = > $address,' name' = > $pname, 'mobile' = > $mobile,' telephone' = > $phone 'img' = > $img,' account_num' = > $account, 'bank_name' = > $bank,' create_time' = > date ('Y-m-d Hpuri Sparky time ()),' admin_id' = > $user_id) If ($id) {$stock- > setData ($stock_Init); $stock- > update ('id ='. $id);} else {$stock- > setData ($stock_Init); $stock- > add ();} $this- > redirect ('supplier_list');} Delete: (note: soft deletion, database retention) function supplier_list_del () {$id = IFilter::act (IReq::get (' id'), 'int') $stock = new IModel ('supplier_list'); $stock- > setData (array (' is_del'= > 1)); if ($id) {$stock- > update (Util::joinStr ($id));} else {die ('Please select data to delete');} $this- > redirect ("supplier_list");}

Update:

Function suppliet_list_restore () {$id = IFilter::act (IReq::get ('id'),' int'); / / generate goods objects $stock = new IModel ('supplier_list'); $stock- > setData (array (' is_del'= > 0)); if ($id) {$stock- > update (Util::joinStr ($id));} else {die ('Please select data to recover') } $this- > redirect ("supplier_list");}

The original SQL can be IDBFactory::getDB ()-> query ($sql); at this point, you can write the original SQL statement directly, but pay attention to it

Add the table prefix to the SQL statement, because IDBFactory will not make any changes to $sql and will directly send it to mysql as-is.

This method can be used for some special, complex SQL.

I actually write the code application in the development:

$sql_class = "SELECT zce.category_id,gs.brand_id,zc.parent_id from (zqwy_goods as gs left join zqwy_category_extend as zce on gs.id = zce.goods_id) left join zqwy_category as zc on zce.category_id = zc.id WHERE gs.id =". $v ['goods_id']. ";; $goods_class = IDBFactory::getDB ()-> query ($sql_class)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.