static function getTeachers() { $db = jFactory::getDbo(); $query = $db->getQuery(true); $query->select('*')->from($db->quoteName('#__dash_teachers')); $db->setQuery($query); $teachers = $db->loadObjectList(); return $teachers; }
<?php define('_JEXEC', 1); define('DS', DIRECTORY_SEPARATOR); define('JPATH_BASE', $_SERVER['DOCUMENT_ROOT']); require_once JPATH_BASE . DS . 'includes' . DS . 'defines.php'; require_once JPATH_BASE . DS . 'includes' . DS . 'framework.php'; require_once JPATH_BASE . DS . 'libraries' . DS . 'joomla' . DS . 'factory.php'; require_once JPATH_BASE . DS . 'configuration.php'; $id = $_POST['id']; var_dump($id); $db = jFactory::getDbo(); $query = $db->getQuery(true); $query->select('*')->from($db->quoteName('#__dash_teachers'))->where('id=' . $id); $db->setQuery($query); $teachers = $db->loadObjectList(); echo '<p>' . $teachers[0]->firstname . '</p>';