New answers tagged

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