public function Get_Now_update() { $bookinfo_query = bookinfo::find(); $bookinfo = $bookinfo_query->limit(30)->orderBy('article_last_updatetime desc')->asArray()->all(); //var_dump($bookinfo); return $bookinfo; }
public function actionIndex() { $keywords = $_GET['keyword']; $array = bookinfo::find()->andFilterWhere(['like', 'bookname', $keywords])->orwhere(['like', 'author', $keywords])->orwhere(['like', 'bookname_pinyin', $keywords])->asArray()->all(); //var_dump($array);exit; //$this->redirect('http://www.baidu.com'); 可跳转 return $this->render('index', ['keywords' => $keywords, 'search_result' => $array]); }
public function Class_Recommendation($class) { $bookinfo = new bookinfo(); $Class_Recommendation = $bookinfo->find()->andwhere(['Class_Recommendation' => 1, 'Class' => $class])->asArray()->all(); return $Class_Recommendation; }
public function insert_Book_Info($class, $bookname, $author, $Description, $update_time) { $bookinfo = new bookinfo(); $Pinyin = new TransPinyin(); $bookname_pinyin = $Pinyin->Pinyin($bookname); $status = 1; $return_status = $bookinfo->find()->createCommand()->insert('bookinfo', ['class' => $class, 'bookname' => $bookname, 'bookname_pinyin' => $bookname_pinyin, 'author' => $author, 'Description' => $Description, 'updatetime' => $update_time, 'status' => $status])->execute(); //echo '插入bookinfo'.'<br>'; return $return_status; }
public function Get_Book_Id($bookname) { $bookinfo = new bookinfo(); $bookid = $bookinfo->find()->where(['bookname' => $bookname])->asArray()->One(); return $bookid['id']; }