load->model('product_model','product'); $this->load->model('type_model','type'); } // public function hehe(){ // $sql = "CREATE TABLE `product` ( // `id` int(11) NOT NULL AUTO_INCREMENT, // `type` varchar(255) NOT NULL DEFAULT '', // `title` varchar(255) NOT NULL DEFAULT '', // `pid` varchar(255) NOT NULL DEFAULT '', // `level` tinyint(4) NOT NULL DEFAULT '0', // `img` text NOT NULL, // `desc` text NOT NULL, // `sence` text NOT NULL, // `addtime` int(10) NOT NULL DEFAULT '0', // `publishtime` int(10) NOT NULL DEFAULT '0', // `ord` int(11) NOT NULL DEFAULT '0', // `status` int(4) NOT NULL DEFAULT '0', // PRIMARY KEY (`id`) // ) ENGINE=InnoDB DEFAULT CHARSET=utf8"; // $this->db->query($sql); // echo $this->db->last_query(); // } public function getProducts() { $types = $this->type->all(); $products = $this->product->all(); foreach($products as &$product) { $t = $product['type']; $t_arr = explode(',', $t); $product['type'] = implode(', ', $t_arr); $product['img'] = json_decode($product['img'], true); } $item['types'] = $types; $item['products'] = $products; $data = $item; $this->echoJson($data); } public function getProductDetail() { $id = $this->input->get('id', true); $data = $this->product->get($id); $type = $this->type->get($data['type']); $data['type_name'] = $type['name']; $data['img'] = json_decode($data['img'], true); $this->echoJson($data); } private function fetchWebSetting($name){ $item = $this->web_setting->getValueByName($name); $data = json_decode($item[0]['value'] , true); return $data; } private function fetchWebSetting2($name){ $item = $this->web_setting->getValueByName($name); $data = $item[0]['value']; return $data; } private function echoJson($data){ if($data){ $code = 200; $msg = 'success'; } else{ $code = 500; $msg = 'fails'; } $res['code'] = $code; $res['msg'] = $msg; $res['data'] = $data; header('Content-type:text/json'); echo json_encode($res); } } ?>