pulading1988

date('Ym', strtotime('-1 month', strtotime("first day of this month"))),

pulading1988

SELECT *
FROM `market_list`
WHERE `id` IN ('1', '2')
	AND `status` = '1'
	AND (`start_time` IS NULL
		OR `start_time` <= '2017-07-31 17:05:57')
	AND (`end_time` IS NULL
		OR `end_time` >= '2017-07-31 17:05:57')
ORDER BY `priority` DESC
LIMIT 5

pulading1988

mysql> SELECT LOCATE('bar', 'foobarbar');
+---------------------------------------------------------+
| LOCATE('bar', 'foobarbar')                              |
+---------------------------------------------------------+
| 4                                                       |
+---------------------------------------------------------+
1 row in set (0.00 sec)

pulading1988

// 先按点赞数据排序，再按评论时间排序
$likeCounts = array();
$reviewTimes = array();
foreach ($commentList as $item) {
    $likeCounts[] = $item['likeCount'];
    $reviewTimes[] = $item['reviewTime'];
}

array_multisort($likeCounts, SORT_DESC, $reviewTimes, SORT_DESC, $commentList);

pulading1988

var mobileRE = /^(((13[0-9]{1})|(14[57]{1})|(15[0-9]{1})|(17[678]{1})|(18[0-9]{1}))+\d{8})$/;
var passwordRE = /^[A-Za-z0-9]{6,20}$/;
var BASE_PATH = '${basePath}';
var j_captchaUrl = '${basePath}/jcaptcha'; // 获取验证码的后端地址
var app = new Vue({
  el: '#app',

  data: {
    mobile: '',
    j_captcha: '',