public function getActionLists($filed, $where, $orderby, $limit) { self::initDB(); $sql = 'select ' . $filed . ' from `' . self::$table_action_info . '` LEFT JOIN `' . self::$table_action_group . '` ON action_group_id=group_id where ' . $where . ' ' . $order . ' ' . $limit; $query = self::$dbConn->query($sql); if (!$query) { self::$errCode = '1803'; self::$errMsg = "[{$sql}] is error"; return false; } if ($this->{$is_count} === true) { $this->{$is_count} = false; return self::$dbConn->num_rows($query); } return self::$dbConn->fetch_array_all($query); }
public function actionGroupList($id) { self::initDB(); $sql = "SELECT group_name FROM " . self::$table_action_group . " WHERE group_system_id = {$id}"; $query = self::$dbConn->query($sql); if (!$query) { self::$errCode = '1803'; self::$errMsg = "[{$sql}] is error"; return false; } $result = array(); $ret = self::$dbConn->fetch_array_all($query); for ($i = 0; $i < count($ret); $i++) { array_push($result, $ret[$i]['group_name']); } return $result; }