Ejemplo n.º 1
0
 /**
  * 添加记录
  * return lastid
  */
 function insert($pData, $pReplace = false)
 {
     if ($this->_filter($pData)) {
         $tField = '`' . join('`,`', array_keys($pData)) . '`';
         $tVal = join("','", $pData);
         //echo ($pReplace? "REPLACE": "INSERT") . " INTO `$this->table`($tField) VALUES ('$tVal')";
         if ($this->exec(($pReplace ? "REPLACE" : "INSERT") . " INTO {$this->table}({$tField}) VALUES ('{$tVal}')")) {
             return $this->db->lastInsertId();
         }
     }
     return 0;
 }
Ejemplo n.º 2
0
 /**
  * 添加类别
  *
  * @param array $data 类别信息数组
  */
 public function add(array $data)
 {
     $node['cate_name'] = $data['cate_name'];
     $node['parent_id'] = $data['parent_id'];
     $node['sort_order'] = $data['sort_order'];
     $node['is_show'] = $data['is_show'];
     if (!empty($data['cate_id'])) {
         // 导入数据需要设定id
         $node['cate_id'] = $data['cate_id'];
     }
     $this->db->insert('category', $node);
     $lastId = $this->db->lastInsertId();
     // 更新路径信息
     $path = $this->getPath($node['parent_id']) . "{$lastId};";
     $where = $this->db->quoteInto('cate_id = ?', $lastId);
     $this->db->update('category', array('path' => $path), $where);
     $this->_allCates = null;
 }