Detailed explanation of thinkPHP mall announcement function development issues-PHP Tutorial-php.cn

Detailed explanation of thinkPHP mall announcement function development issues

墨辰丷

Release： 2023-03-28 12:22:01

Original

1527 people have browsed it

This article mainly introduces the development issues of thinkPHP mall announcement function, and analyzes the ajax interaction and database operation related skills involved in implementing the mall announcement function based on thinkPHP in the form of examples. Friends in need can refer to the following

The effect is as follows

1. Set in the head

position: fixed;
z-index: 999;
top: 0;
opacity:1;

Copy after login

2.ajax processing json Data

// 获取商城公告
function getNotice() { // 获取公告函数
  var res;
  $.ajax({
    type: "POST",
    url: "{sh::U(&#39;Store/Mall/ajaxGetNotice&#39;,array(&#39;mid&#39;=>$mid))}",
    dataType:&#39;json&#39;, // 设为json之后，就能够很好的处理获取的json数据，json.status
    async: false,
    success: function(json){
      res = json;
    }
  });
  return res;
}

Copy after login

After setting dataType:'json', json data can be processed directly through json.

3. Finally loaded, the page looks better.

$(document).ready(function(e) { // 主函数
  // 获取公告
  var action_name = "{sh::ACTION_NAME}"; // 页面使用thinkphp常量
  var json = getNotice();
  if ( action_name == &#39;index&#39; && json.status == 1) { // 首页并且公告存在
    $(".top").css("margin-top", "70px"); // jquery设置css
    $(".main-sidebar").css("top" ,"70px");
    var html = &#39;&#39;;
    $.each(json.info, function(i, n){ // n为文本内容
      html += "<li><strong>"+n.content+"</strong></li>"
    });
    $(".top-notice").show();
    $(&#39;#notice ul&#39;).html(""+html);
    $(&#39;#notice&#39;).unslider(); // 轮播
  }
});

Copy after login

4. Get the thinkphp processing of the sql statement

// 获取公告
function ajaxGetNotice() {
    if (IS_AJAX) {
      $this->mid;
      // 获取有效的，且结束时间大于当前时间的，或者日期等于0的公告
      $mallNoticeModel = M(&#39;Mall_notice&#39;);
      $where[&#39;mall_id&#39;] = $this->mid;
      $where[&#39;status&#39;] = 1;
      $where[&#39;endtime&#39;] = array(array(&#39;eq&#39;,0),array(&#39;gt&#39;,time()), &#39;or&#39;) ;
      //SELECT * from sh_mall_notice where mall_id = 9 and status = 1 and (endtime = 0 or endtime>1458354366);
      $notice = $mallNoticeModel->where($where)->order(&#39;sort desc&#39;)->select();
      if (!empty($notice)) {
        $this->ajaxReturn(array(&#39;status&#39;=>&#39;1&#39;,&#39;info&#39;=>$notice,&#39;msg&#39;=>"获取成功"),&#39;JSON&#39;);
      } else {
        $this->ajaxReturn(array(&#39;status&#39;=>&#39;2&#39;,&#39;info&#39;=>$notice,&#39;msg&#39;=>"公告不存在"),&#39;JSON&#39;);
      }
    }
}

Copy after login

$where[&#39;endtime&#39;] = array(array(&#39;eq&#39;,0),array(&#39;gt&#39;,time()), &#39;or&#39;) ;

Copy after login

handles this logical relationship skillfully.

The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations: Detailed explanation of the login timeout detection function example in

php

php Detailed explanation of base64 encoding and decoding examples

phpHow to connect to mysql database

The above is the detailed content of Detailed explanation of thinkPHP mall announcement function development issues. For more information, please follow other related articles on the PHP Chinese website!