method getOrder documentation in bbn\Db\Languages\Sqlite

Get a string starting with ORDER BY with corresponding parameters to $order.

function(array $cfg) { $res = ''; if (!empty($cfg['order'])) { foreach ($cfg['order'] as $col => $dir) { if (\is_array($dir) && isset($dir['field'])) { $col = $dir['field']; $dir = $dir['dir'] ?? 'ASC'; } if (isset($cfg['available_fields'][$col])) { // If it's an alias we use the simple name if (isset($cfg['fields'][$col])) { $f = $this->colSimpleName($col, true); } elseif ($cfg['available_fields'][$col] === false) { $f = $this->escape($col); } else { $f = $this->colFullName($col, $cfg['available_fields'][$col], true); } $res .= $f.' COLLATE NOCASE '. (strtolower($dir) === 'desc' ? 'DESC' : 'ASC' ).','.PHP_EOL; } } if (!empty($res)) { return 'ORDER BY '.substr($res,0, Strrpos($res,',')).PHP_EOL; } } return $res; }

Get a string starting with ORDER BY with corresponding parameters to $order. BBN is a suite of PHP and JS libraries and VueJS components - all open-source! bbn.io, build applications, the quick way

This website uses cookies to ensure you get the best experience on our website.