New answers tagged mysql
0
After working on that problem i figured out a solution with a little help and jsut wanted to share the solution to you.
$query = "SELECT sortb.value, sortb.field_id, sortc.value, sortc.field_id,
content.*, fieldvalues.* ";
FROM #__fields_values AS fieldvalues, #__content AS content
LEFT JOIN (#__fields_values AS ...
0
Your best bet would be to use joomla db to get all the rows and then use php array sorts to analyse and sort the result. Something like
$db = Factory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
$query->select('content.*');
$query->select('fieldsvalues.*');
$query->from('`#__content` AS content')...
3
On the SQL side, data inserted using JDatabaseDriver::insertObject() and JDatabaseDriver::updateObject() methods is escaped automatically.
On HTML side, you should filter user input to prevent XSS. Normally, Joomla\CMS\Component\ComponentHelper::filterText() is used to filter content where HTML is allowed. These filters can be configured per user group in ...
Top 50 recent answers are included
