} else {
$sort = $val;
}
if (preg_match('/^[\w\.]+$/', $key)) {
$sort = strtoupper($sort);
$sort = in_array($sort, ['ASC', 'DESC'], true) ? ' ' . $sort : '';
$array[] = $this->parseKey($query, $key, true) . $sort;
} else {
throw new Exception('order express error:' . $key);
}
}
}
return empty($array) ? '' : ' ORDER BY ' . implode(',', $array);
}
/**
* orderField分析
lf___forward__ | /home/lists/lists/order/update_time%252Bdesc/update/2.html |
USER | bae |
HOME | /home/bae |
HTTP_USER_AGENT | claudebot |
HTTP_ACCEPT | */* |
HTTP_HOST | mingxintang.cn |
HTTP_CLIENTIP | 44.200.196.114 |
HTTP_X_FORWARDED_FOR | 44.200.196.114 |
HTTP_X_FORWARDED_PROTO | https |
REDIRECT_STATUS | 200 |
SERVER_NAME | mingxintang.cn |
SERVER_ADDR | 172.17.0.6 |
REMOTE_PORT | |
REMOTE_ADDR | 44.200.196.114 |
SERVER_SOFTWARE | nginx/1.16.1 |
GATEWAY_INTERFACE | CGI/1.1 |
SERVER_PROTOCOL | HTTP/1.1 |
DOCUMENT_ROOT | /home/bae/app |
DOCUMENT_URI | /index.php/home/lists/lists/order/update_time%2Bdesc/update/2.html |
REQUEST_URI | /home/lists/lists/order/update_time%252Bdesc/update/2.html |
CONTENT_LENGTH | |
CONTENT_TYPE | |
REQUEST_METHOD | GET |
QUERY_STRING | |
SERVER_PORT | 80 |
PATH_INFO | /home/lists/lists/order/update_time%252Bdesc/update/2.html |
SCRIPT_NAME | /index.php/home/lists/lists/order/update_time%2Bdesc/update/2.html |
SCRIPT_FILENAME | /home/bae/app/index.php |
FCGI_ROLE | RESPONDER |
PHP_SELF | /index.php/home/lists/lists/order/update_time%2Bdesc/update/2.html/home/lists/lists/order/update_time%252Bdesc/update/2.html |
REQUEST_TIME_FLOAT | 1711669265.8829 |
REQUEST_TIME | 1711669265 |
SERVER_SOFTWARE | bae/3.0 |
BAE_ENV_APPID | appids7k23m8d92 |
BAE_ENV_LOG_HOST | 172.17.0.1 |
BAE_ENV_LOG_PORT | 7000 |
BAE_MEMORY | 128 |
APP_PATH | /home/bae/app/application/ |
UID | 0 |