Esempi in PHP per jFactory::getDbo

Esempio n. 1

File: helper.php Progetto: isengartz/com_dash

 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;
 }

Esempio n. 2

File: ajaxTeacherDetails.php Progetto: isengartz/com_dash

<?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>';