Компонент вывода информации из внешней базы данных - Разработка расширений для Joomla 1.5

<?php
// No direct access to this file
defined('_JEXEC') or die('Restricted access');
// import the Joomla modellist library
jimport('joomla.application.component.modellist');
/**
 * HelloWorldList Model
 */
class HelloWorldModelHelloWorlds extends JModelList
{
	/**
	 * Method to build an SQL query to load the list data.
	 *
	 * @return	string	An SQL query
	 */
	protected function getListQuery()
	{
		
		$option = array(
        'driver' => 'mysqli',
        'host' => 'mysql.moyorodnoye.myjino.ru',
        'user' => 'moyorodnoye',
        'password' => '***',
        'database' => 'moyorodnoye_available',
        'prefix' => 'qp8br_'
        );
        
$db2 = JDatabase::getInstance( $option );

		// Create a new query object.		
		//$db = JFactory::getDBO();
		//$list = $db2->setQuery( 'SELECT * FROM #__table' )->loadObjectList();
		$query = $db2->getQuery(true);
		// Select some fields
		$query->select('id,greeting');   // а тут походу берет из локальной, хотя может оно еще где-то берет?..
		// From the hello table
		$query->from('#__helloworld');
		$db2->setQuery($query);
		$res = $db2->loadObject();
 		echo $res->greeting; // тут выводит сообщение из внешней базы как и надо 
		return $query;
	}
}

	public function __construct( $config = array() )
	{
		parent::__construct( $config );
		$this->_db = JDatabase::getInstance(
			array(
				'driver' => 'mysqli',
				'host' => 'mysql.moyorodnoye.myjino.ru',
				'user' => 'moyorodnoye',
				'password' => '***',
				'database' => 'moyorodnoye_available',
				'prefix' => 'qp8br_'
			)
		);
	}

$query = $this->getDbo()->getQuery(true);
$query->select('id,greeting')->from('#__helloworld');
return $query;

<?php
// No direct access to this file
defined('_JEXEC') or die('Restricted access');
 
// import Joomla modelitem library
jimport('joomla.application.component.modelitem');
 
/**
 * HelloWorld Model
 */
class HelloWorldModelHelloWorld extends JModelItem
{
	/**
	 * @var object item
	 */
	protected $item;
 
	/**
	 * Method to auto-populate the model state.
	 *
	 * This method should only be called once per instantiation and is designed
	 * to be called on the first call to the getState() method unless the model
	 * configuration flag to ignore the request is set.
	 *
	 * Note. Calling getState in this method will result in recursion.
	 *
	 * @return	void
	 * @since	2.5
	 */
	protected function populateState() 
	{
		$app = JFactory::getApplication();
		// Get the message id
		$id = JRequest::getInt('id');
		$this->setState('message.id', $id);
 
		// Load the parameters.
		$params = $app->getParams();
		$this->setState('params', $params);
		parent::populateState();
	}
 
	/**
	 * Returns a reference to the a Table object, always creating it.
	 *
	 * @param	type	The table type to instantiate
	 * @param	string	A prefix for the table class name. Optional.
	 * @param	array	Configuration array for model. Optional.
	 * @return	JTable	A database object
	 * @since	2.5
	 */
	public function getTable($type = 'HelloWorld', $prefix = 'HelloWorldTable', $config = array()) 
	{
		return JTable::getInstance($type, $prefix, $config);
	}
 
	/**
	 * Get the message
	 * @return object The message to be displayed to the user
	 */
	public function getItem() 
	{
		if (!isset($this->item)) 
		{
			$id = $this->getState('message.id');
			$this->_db->setQuery($this->_db->getQuery(true)
				->from('#__helloworld as h')
				->leftJoin('#__categories as c ON h.catid=c.id')
				->select('h.greeting, h.params, c.title as category')
				->where('h.id=' . (int)$id));
			
			if (!$this->item = $this->_db->loadObject()) 
			{
				$this->setError($this->_db->getError());
			}
			else
			{
				// Load the JSON string
				$params = new JRegistry;
                                // loadJSON is @deprecated    12.1  Use loadString passing JSON as the format instead.
				//$params->loadString($this->item->params, 'JSON');
                                $params->loadJSON($this->item->params);
				$this->item->params = $params;
 
				// Merge global params with item params
				$params = clone $this->getState('params');
				$params->merge($this->item->params);
				$this->item->params = $params;
			}
		}
		return $this->item;
	}
}

<?php
// No direct access to this file
defined('_JEXEC') or die('Restricted access');
 
// import Joomla modelitem library
jimport('joomla.application.component.modelitem');
 

class HelloWorldModelHelloWorld extends JModelItem
{

	protected $item;
 
	 	 public function __construct( $config = array() )
	{
		parent::__construct( $config );
		$db2 = $this->_db = JDatabase::getInstance(
			array(
			'driver' => 'mysqli',
            'host' => 'mysql.moyorodnoye.myjino.ru',
            'user' => 'moyorodnoye',
            'password' => '***',
            'database' => 'moyorodnoye_available',
            'prefix' => 'qp8br_'
			)
		);
	}
	
	protected function populateState() 
	{
		$app = $this->getApplication();
		// Get the message id
		$id = JRequest::getInt('id');
		$this->setState('message.id', $id);
 
		// Load the parameters.
		$params = $app->getParams();
		$this->setState('params', $params);
	//	echo $params;
		parent::populateState();
	}

	public function getTable($type = 'HelloWorld', $prefix = 'HelloWorldTable', $config = array()) 
	{
		return JTable::getInstance($type, $prefix, $config);
	}
 
	public function getItem() 
	{
	    
		if (!isset($this->item)) 
		{
			$id = $this->getState('message.id');
			
			$this->_db->setQuery($this->_db->getQuery(true)
				->from('#__helloworld as h')
				->leftJoin('#__categories as c ON h.catid=c.id')
				->select('h.greeting, h.params, c.title as category')
				->where('h.id=' . (int)$id));
				
		echo $this;	
			
			if (!$this->item = $this->_db->loadObject()) 
			{
				$this->setError($this->_db->getError());
			}
			else
			{
				// Load the JSON string
				$params = new JRegistry;
                                // loadJSON is @deprecated    12.1  Use loadString passing JSON as the format instead.
				//$params->loadString($this->item->params, 'JSON');
                                $params->loadJSON($this->item->params);
				$this->item->params = $params;
 
				// Merge global params with item params
				$params = clone $this->getState('params');
				$params->merge($this->item->params);
				$this->item->params = $params;
			}
		}
		
		return $this->item;
		echo $this;
	}
}

$db = JFactory::getDbo();
$query = $db->getQuery( true )->select( 'id, title' )->from( '#__categories' )->where( 'published=1' );
$categories = $db->setQuery( $query )->loadObjectList( 'id' );

foreach($this->items as $item){
	echo 'Категория: ' . $categories[$item->catid]->title;
}

<?php

// No direct access
defined( '_JEXEC' ) or die;
jimport( 'joomla.form.helper' );
JFormHelper::loadFieldClass( 'list' );

/**
 * Subcat Form Field class for the component
 */
class JFormFieldfields extends JFormFieldList
{

	protected $type = 'fields';

	/**
	 * Method to get a list of options for a list input.
	 * @return array An array of JHtml options.
	 */
	protected function getOptions()
	{
		$db = JFactory::getDbo();
		$query = $db->getQuery( true )->select( 'id, title' )->from( '#__table' );
		$items = $db->setQuery( $query )->loadObjectList();
		$options = array();
		if ( $items ) {
			foreach ( $items as $item ) {
				$options[] = JHtml::_( 'select.option', $item->id, $item->title );
			}
		}
		return array_merge( parent::getOptions(), $options );
	}

}

<field name="id" type="fields" label="JSELECT" description="JSELECT">
		<option>JSELECT</option>
</field>