Работа с базой данных - Модификации расширений для Joomla

// Get a db connection.
$db = JFactory::getDbo();
 
// Create a new query object.
$query = $db->getQuery(true);
 

$query->select('name');
$query->from('q8abm_users');
$query->where('username = Podopitniy');
 
// Reset the query using our newly populated query object.
$db->getQuery($query);
 
// Load the results as a list of stdClass objects.
$results = $db->loadObjectList();

print_r($results);

$db = JFactory::getDBO();
$sql = "SELECT name FROM q8abm_users WHERE username = 'Podopitniy'";
$db->setQuery($sql);
$list = $db->loadObjectList();
echo $db->loadObjectList();

<?php
$user = JFactory::getUser('Podopitniy');
//$user = JFactory::getUser(42);

var_dump($user);
//Здесь ваши данные
?>

$query->where('name = $user');

$query->where('name = ' . $user);

$db = JFactory::getDbo();
$query->where('name = ' . $db->quote($user));

<?php
 echo JHTML::_ ('link', JRoute::_ ($link, FALSE), $order->ofis_ispolnitel, array('title' => JText::_ ('Внести изменения в заказ'). ' ' . $order->ofis_ispolnitel));
?>

$select = " o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name "
.', u.kontak_lic_no_rigistr, u.ww, u.dop_phone_no_rigistr, u.kontakn_pfone_no_rigistr, u.name_no_rigistr, u.virtuemart_user_id, u.dataj, u.time20140310, u.last_name_2, u.ofis_ispolnitel,  u.email as order_email,pm.payment_name AS payment_method ';