当前位置: 首页>>代码示例>>PHP>>正文


PHP article::where方法代码示例

本文整理汇总了PHP中article::where方法的典型用法代码示例。如果您正苦于以下问题:PHP article::where方法的具体用法?PHP article::where怎么用?PHP article::where使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在article的用法示例。


在下文中一共展示了article::where方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: dosearch

 /**
  * Cnews::dosearch()
  * 
  * @param string $st
  * @param integer $offset
  * @param integer $limit
  * @return
  */
 function dosearch($st = "", $offset = 0, $limit = 5)
 {
     $this->load->helper('text');
     $separate = "aaaaaaa23423dddeeeeee838234eeeeefffffff99923ffffffsdfsdfsdfsdf";
     $sep = "239847293dlkfaslf::sdflksdf::sdkfjsldf";
     $this->load->helper('remove_vn');
     $logged_role = $this->logged_in_user->adminrole->id;
     if ($_SERVER['REQUEST_METHOD'] == "GET") {
         $key_list = explode($sep, $st);
         $news = new article();
         if ($key_list[0] != $separate) {
             $news->like('title_vietnamese', $key_list[0]);
         }
         if ($key_list[1] != $separate) {
             $news->where('newscatalogue_id', $key_list[1]);
         } else {
             $news->where_related_newscatalogue('parentcat_id', 7);
         }
         if ($key_list[2] != $separate) {
             $news->where('created >', $key_list[2]);
             $news->where('created <', $key_list[3]);
         }
         if ($key_list[4] != 3) {
             $news->where('active', $key_list[4]);
         }
         if ($key_list[5] != 3) {
             $news->where('hot', $key_list[5]);
         }
         if ($key_list[6] != 3) {
             $news->where('home_hot', $key_list[6]);
         }
         $news->where('recycle', $key_list[7]);
         //arrange by
         switch ($key_list[8]) {
             case "thoigian":
                 $news->order_by('id', $key_list[9]);
                 break;
             case "docnhieu":
                 $news->order_by('view_count', $key_list[9]);
                 break;
         }
         $news->get_paged($offset, $key_list[10], TRUE);
         //       $this->firephp->log($news->check_last_query());
         setPagination($this->admin . 'cnews/dosearch/' . $st, $news->paged->total_rows, $key_list[10], 5);
         $dis['base_url'] = base_url();
         $dis['view'] = 'news/search';
         $dis['news'] = $news;
         $dis['search_result'] = 1;
         $dis['menu_active'] = "Tìm kiếm";
         $dis['title_table'] = "Trang hiện tại:" . $news->paged->current_page . '/' . $news->paged->total_pages;
         $dis['title'] = "Kết quả tìm kiếm";
         $dis['searchkey'] = $key_list[0] != $separate ? $key_list[0] : "";
         $dis['catalogue_id'] = $key_list[1];
         $dis['date_start'] = $key_list[2] != $separate ? $key_list[2] : "";
         $dis['date_end'] = $key_list[3] != $separate ? $key_list[3] : "";
         $dis['active'] = $key_list[4];
         $dis['hot_cat'] = $key_list[5];
         $dis['hot_home'] = $key_list[6];
         $dis['recycle'] = $key_list[7];
         $dis['arrange_by'] = $key_list[8];
         $dis['arrange_direct'] = $key_list[9];
         $dis['showperpage'] = $key_list[10];
         $newscatalogue = new Newscatalogue();
         $newscatalogue->where('parentcat_id', 7);
         $newscatalogue->order_by('position', 'asc');
         $newscatalogue->get();
         $dis['newscatalogue'] = $newscatalogue;
         $this->viewadmin($dis);
     } else {
         $searchkey = trim($this->input->post('searchkey'));
         $catalogue_id = $this->input->post('newscatalogue');
         $date_start = $this->input->post('date_start');
         $date_end = $this->input->post('date_end');
         $active = $this->input->post('active');
         $hot_cat = $this->input->post('hot_cat');
         $hot_home = $this->input->post('hot_home');
         $arrange_by = $this->input->post('arrange_by');
         $arrange_direct = $this->input->post('arrange_direct');
         $showperpage = $this->input->post('showperpage');
         $recycle = $this->input->post('recycle') == 1 ? $this->input->post('recycle') : 0;
         //create string uri query
         $search_string = "";
         $search_string .= $searchkey == "" ? $separate : $searchkey;
         $search_string .= $sep . ($catalogue_id ? $catalogue_id : $separate);
         $search_string .= $sep . ($date_start != "" ? $date_start : $separate);
         $search_string .= $sep . ($date_end != "" ? $date_end : $separate);
         $search_string .= $sep . $active;
         $search_string .= $sep . $hot_cat;
         $search_string .= $sep . $hot_home;
         $search_string .= $sep . $recycle;
         $search_string .= $sep . $arrange_by;
         $search_string .= $sep . $arrange_direct;
//.........这里部分代码省略.........
开发者ID:lxthien,项目名称:batdongsan,代码行数:101,代码来源:cnews.php

示例2: article

 function set_home()
 {
     if ($this->home_hot != 1) {
         $o = new article();
         $o->where('home_hot', 1);
         $o->select_max('home_hot_position');
         $o->get();
         if (count($o->all) != 0) {
             $max = $o->home_hot_position + 1;
             $this->home_hot_position = $max;
         } else {
             $this->home_hot_postion = 2;
         }
         $this->home_hot = 1;
         $this->save();
         $this->arrange_position_home();
     }
 }
开发者ID:lxthien,项目名称:batdongsan,代码行数:18,代码来源:article.php

示例3: update

 /**
  * Update the specified resource in storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function update($id)
 {
     $article = article::where('id', '=', Input::get('id'))->update(array('title' => Input::get('title'), 'short_description' => Input::get('short_description'), 'description' => Input::get('description'), 'image' => Input::get('image')));
     return 'Updated';
 }
开发者ID:asykar-ma,项目名称:ayam_kalasan,代码行数:11,代码来源:ArticleController.php

示例4:

 </form>
<div class="" style="margin-left:auto;margin-right:auto;">
        <div class="contentwarper2" style="">
        <div class="content-warper" style="max-width:100%;margin: 0 0 0 0;" >




        <div style="max-width:100%; margin-left:auto; margin-right:auto; float:left; width:100%; padding: 0px 0 0px 0;">
        
            <div id="" style="padding:15px auto 15px auto;margin:15px auto 15px auto;">    

                    <div id="data">

                      <?php 
$hasil = article::where("category_id", "=", "3")->get();
$i = 1;
?>

   
                        <!-- Carousel items -->
                                @foreach ($hasil as $row) 
                                    <div class='row news-block'>
                                        <div class="col-md-2 blok-tanggal color-RedSolusi font-white">
                                            <div class="col-md-12 blok-tanggal-d">{{ date_format($row->created_at,"d") }}</div>
                                            <div class="col-md-12 blok-tanggal-my">{{ date_format($row->created_at,"M Y") }}</div>
                                        </div>
                                        <div class="col-md-10">
                                            <div class="timeline-panel">
                                                <div class="timeline-heading">
                                                    <h4 >{{ $row->title }}</h4>
开发者ID:asykar-ma,项目名称:ayam_kalasan,代码行数:31,代码来源:ManageKonten.blade.php

示例5: search

 function search()
 {
     if ($_SERVER['REQUEST_METHOD'] == "POST") {
         $searchKey = $this->input->post('searchKey');
         redirect("tim-kiem/" . urlencode(htmlentities($searchKey)));
     }
     $searchKey = $this->uri->segment(2, "");
     $viewType = $this->uri->segment(3, "all");
     $page = $this->uri->segment(4, "trang-1");
     $limitProduct = 50;
     $limitNews = 10;
     $dis['page'] = $page;
     //$searchKey = urldecode($searchKey);
     $searchKeyEncode = $searchKey;
     $searchKey = html_entity_decode(urldecode($searchKey));
     if ($searchKey == "") {
         $resultStatus = false;
     }
     if ($viewType == "all") {
         $resultStatus = true;
         //find dien thoai & mtb
         $phoneCat = new productcat($this->config->item('catPhoneId'));
         $phoneChildCat = $this->getListId($phoneCat->getAllChildCat());
         $tabletCat = new productcat($this->config->item('catTabletId'));
         $tabletChildCat = $this->getListId($tabletCat->getAllChildCat());
         $phoneTabletCat = array_merge($phoneChildCat, $tabletChildCat);
         $phoneTabletProduct = new product();
         $phoneTabletProduct->distinct();
         $phoneTabletProduct->group_start();
         $phoneTabletProduct->like('name', $searchKey);
         $phoneTabletProduct->or_like('searchKey', $searchKey);
         $phoneTabletProduct->group_end();
         $phoneTabletProduct->where_in_related_productcat('id', $phoneTabletCat);
         $phoneTabletProduct->where('active', 1);
         $phoneTabletProduct->order_by('id', 'desc');
         $phoneTabletProduct->group_by('id');
         $phoneTabletProduct->get_iterated(10);
         $dis['phoneTabletProduct'] = $phoneTabletProduct;
         //find accessory with the searchkey condition
         $accessoryCat = new productcat();
         $accessoryCat->where_in('id', $this->config->item('allAccessoriesId'));
         $accessoryCat->get_iterated();
         $accessoryChildCat = array();
         foreach ($accessoryCat as $row) {
             $accessoryChildCat = array_merge($accessoryChildCat, $this->getListId($row->getAllChildCat()));
         }
         $accessoryProduct = new product();
         $accessoryProduct->distinct();
         $accessoryProduct->group_start();
         $accessoryProduct->like('name', $searchKey);
         $accessoryProduct->or_like('searchKey', $searchKey);
         $accessoryProduct->group_end();
         $accessoryProduct->where_in_related_productcat('id', $accessoryChildCat);
         $accessoryProduct->where('active', 1);
         $accessoryProduct->group_by('id');
         $accessoryProduct->order_by('id', 'desc');
         $accessoryProduct->get_iterated(10);
         $dis['accessoryProduct'] = $accessoryProduct;
         //find the new by keyword
         $newCat = array(58, 59, 60, 61, 62, 64);
         $newsResult = new article();
         $newsResult->where_in('newscatalogue_id', $newCat);
         $newsResult->like('title_vietnamese', $searchKey);
         $newsResult->where('active', 1);
         $newsResult->where('recycle', 0);
         $newsResult->order_by('id', 'desc');
         $newsResult->get_iterated(10);
         $dis['newsResult'] = $newsResult;
         $dis['view'] = 'product/search_all';
     }
     if ($viewType == "dien-thoai-may-tinh-bang") {
         $resultStatus = true;
         //find dien thoai & mtb
         $phoneCat = new productcat($this->config->item('catPhoneId'));
         $phoneChildCat = $this->getListId($phoneCat->getAllChildCat());
         $tabletCat = new productcat($this->config->item('catTabletId'));
         $tabletChildCat = $this->getListId($tabletCat->getAllChildCat());
         $phoneTabletCat = array_merge($phoneChildCat, $tabletChildCat);
         $offset = ($this->getPageNumber($page) - 1) * $limitProduct;
         $phoneTabletProduct = new product();
         $phoneTabletProduct->distinct();
         $phoneTabletProduct->group_start();
         $phoneTabletProduct->like('name', $searchKey);
         $phoneTabletProduct->or_like('searchKey', $searchKey);
         $phoneTabletProduct->group_end();
         $phoneTabletProduct->where_in_related_productcat('id', $phoneTabletCat);
         $phoneTabletProduct->where('active', 1);
         $phoneTabletProduct->order_by('id', 'desc');
         $phoneTabletProduct->group_by('id');
         $phoneTabletProduct->get_paged_iterated($offset, $limitProduct);
         $dis['phoneTabletProduct'] = $phoneTabletProduct;
         $dis['view'] = 'product/search_product';
         $url = "tim-kiem/" . $searchKeyEncode . '/dien-thoai-may-tinh-bang';
         $dis['url'] = $url;
         $config['base_url'] = site_url($url . "/trang-");
         $config['total_rows'] = $phoneTabletProduct->paged->total_rows;
         $config['per_page'] = $limitProduct;
         $config['use_page_numbers'] = TRUE;
         $config['uri_segment'] = 4;
         $config['num_links'] = 3;
//.........这里部分代码省略.........
开发者ID:lxthien,项目名称:batdongsan,代码行数:101,代码来源:fgalleries.php

示例6:

                    </section>
                </div>


                <div class="row about-container">
                    <section>
                        <div class="col-md-8" >
                              {{ $row->description }}
                        </div>

      <?php 
}
?>
                        <div class="col-md-4 div-menu-aboutus">
                            <ul class="ul-menu-aboutus">
                                <b>{{ucfirst($category)}}</b><br><br>
                                <?php 
$rows = article::where("category_id", "=", $category)->where("active", "=", "1")->get();
?>

                                @foreach ($rows as $row)
                                  <li><a class="font-merahsolusi" href="/{{ucfirst($category)}}/{{$row->id}}">{{ $row->title }}</a></li>
                                @endforeach 
                            </ul>
                        </div>
                    </section>
                </div>


@stop
开发者ID:asykar-ma,项目名称:ayam_kalasan,代码行数:30,代码来源:Default.blade.php


注:本文中的article::where方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。