ECSHOP 常用SQL

    $sql = 'SELECT * FROM ' . $ecs->table('reg_fields') . ' WHERE type < 2 AND display = 1 ORDER BY dis_order, id';
    $extend_info_list = $db->getAll($sql);

 

单一数据查询

    $rank_name = $GLOBALS['db']->getOne('SELECT rank_name FROM ' . $GLOBALS['ecs']->table('user_rank') . ' WHERE rank_id = '.$_SESSION['user_rank']);

一组数据查询

$rank_name = $GLOBALS['db']->getROW('SELECT rank_name FROM ' . $GLOBALS['ecs']->table('user_rank') . ' WHERE rank_id = '.$_SESSION['user_rank']);

数据插入

$sql = "INSERT INTO " . $GLOBALS['ecs']->table('user_address') . " (country,province,city,mobile,district,consignee,address,user_id) " .
                        "VALUES('$country','$province','$city','$mobile','$district','$consignee','$address','$user_id')";        
 $GLOBALS['db']->query($sql);

 

数据更新

$sql=" update ".$GLOBALS['ecs']->table('user_address')."set country='$country',province='$province',city='$city',mobile='$mobile',district='$district',consignee='$consignee',address='$address' where address_id='$address_id' ";
 $GLOBALS['db']->query($sql);