自贡市大安区新冠病毒疫苗接种点及预约咨询电话

function getshangpin($params) { extract($params); if(empty($sid)) return null; $db = _G('db'); global $_G; $table_name = $_G['dns']['dbpre'] . 'subject'; $sids = array_map('intval', explode(',', $sid)); $select_fields = $select ? $select : 'sid,name,subname,thumb,catid,pid,reviews,avgsort,address,tel,description'; $sql = "SELECT {$select_fields} FROM `{$table_name}` WHERE sid IN (" . implode(',', $sids) . ") AND status = 1"; if($orderby) $sql .= " ORDER BY " . $orderby; else $sql .= " ORDER BY FIELD(sid, " . implode(',', $sids) . ")"; $limit_rows = isset($rows) ? (int)$rows : 10; $start = isset($start) ? (int)$start : 0; $sql .= " LIMIT {$start}, {$limit_rows}"; $result = $db->query($sql); if(!$result) return null; $return = array(); while($row = $db->fetch_array($result)) $return[] = $row; $db->free_result($result); return !empty($return) ? $return : null; } function subject_hyrw($params) { extract($params); if(empty($catid) && empty($sid)) return null; $db = _G('db'); global $_G; $table_name = $_G['dns']['dbpre'] . 'subject'; $where = array("status = 1"); if(!empty($catid)) $where[] = "catid = " . (int)$catid; if(!empty($sid)) $where[] = "sid IN (" . implode(',', array_map('intval', explode(',', $sid))) . ")"; if(!empty($city_id)) $where[] = "city_id = " . (int)$city_id; $select_fields = $select ? $select : 'sid,name,subname,thumb,catid,pid,reviews,avgsort'; $sql = "SELECT {$select_fields} FROM `{$table_name}` WHERE " . implode(' AND ', $where); if($orderby) $sql .= " ORDER BY " . $orderby; else $sql .= " ORDER BY sid DESC"; $limit_rows = isset($rows) ? (int)$rows : 10; $start = isset($start) ? (int)$start : 0; $sql .= " LIMIT {$start}, {$limit_rows}"; $result = $db->query($sql); if(!$result) return null; $return = array(); while($row = $db->fetch_array($result)) $return[] = $row; $db->free_result($result); return !empty($return) ? $return : null; } function product_pic_li($params) { extract($params); if(empty($sid)) return null; $db = _G('db'); global $_G; $table_name = $_G['dns']['dbpre'] . 'subject_picture'; $sids = array_map('intval', explode(',', $sid)); $select_fields = $select ? $select : 'sid,pid,title,description,thumb,pictures,posttime'; $sql = "SELECT {$select_fields} FROM `{$table_name}` WHERE sid IN (" . implode(',', $sids) . ") AND status = 1"; if($orderby) $sql .= " ORDER BY " . $orderby; else $sql .= " ORDER BY posttime DESC"; $limit_rows = isset($rows) ? (int)$rows : 10; $start = isset($start) ? (int)$start : 0; $sql .= " LIMIT {$start}, {$limit_rows}"; $result = $db->query($sql); if(!$result) return null; $return = array(); while($row = $db->fetch_array($result)) $return[] = $row; $db->free_result($result); return !empty($return) ? $return : null; }