Модуль С выводом данных ИЗ таблицы - Разработка расширений для Joomla 3.x

$result=mysql_query('SELECT * FROM `skb01_cin_films` WHERE city REGEXP "(^|[[:space:][:punct:]])0([[:space:][:punct:]]|$)" AND pokaz=0');

// Устанавливаем поля для выборки
		$fields = array('name', 'username');

		// Конструируем запрос
		$query->select($db->quoteName($fields))
			->from($db->quoteName('#__users'))
			->where($db->quoteName('block'). ' = 0')
			->order($db->quoteName('registerDate'). ' DESC');

		// Устанавливаем запрос
		$db->setQuery($query, 0, $params->get('count', 5));

$result=mysql_query('SELECT * FROM `skb01_cin_films` WHERE city REGEXP "(^|[[:space:][:punct:]])0([[:space:][:punct:]]|$)" AND pokaz=0');

WHERE city IN (1, 2, 0)

echo 'мой модуль';

$sdd_db_host='localhost'; 
$sdd_db_name='prosto'; 
$sdd_db_user='root'; 
$sdd_db_pass=''; 
@mysql_connect($sdd_db_host,$sdd_db_user,$sdd_db_pass); 
@mysql_select_db($sdd_db_name);

$result=mysql_query('SELECT * FROM `skb01_cin_films` WHERE city REGEXP "(^|[[:space:][:punct:]])1([[:space:][:punct:]]|$)" AND pokaz=1'); 
 
и т.д.

$db = JFactory::getDBO();
$sql = 'SELECT * FROM `skb01_cin_films` WHERE city REGEXP "(^|[[:space:][:punct:]])1([[:space:][:punct:]]|$)" AND pokaz=1';
$db->setQuery($sql);
$result = $db->loadObjectList();
var_dump($result);

<files>
		<filename>mod_films.xml</filename>
		<filename module="mod_films">mod_films.php</filename>
		<filename>helper.php</filename>
		<filename>index.html</filename>
		<folder>tmpl</folder>
		<folder>assets</folder>
		<folder>language</folder>
	</files>
	<languages folder="language">
		<language tag="ru-RU">ru-RU.mod_films.ini</language>
		<language tag="ru-RU">ru-RU.mod_films.sys.ini</language>
	</languages>
	
	<config>
		<fields name="params">
			<fieldset name="basic">
				<field name="cityfilm" type="text" default="" label="MOD_FILMS_FIELD_CITY_LABEL" description="MOD_FILMS_FIELD_CITY_DESC" filter="raw" />
				<field name="pokazfilm" type="list" label="MOD_FILMS_FIELD_POKAZ_LABEL" description="MOD_FILMS_FIELD_POKAZ_DESC">
					<option	value="nowfi">MOD_FILMS_FIELD_POKAZ_TODAY</option>
					<option	value="soonfi">MOD_FILMS_FIELD_POKAZ_SOON</option>
				</field>
			</fieldset>
			<fieldset
				name="advanced">
				<field
					name="layout"
					type="modulelayout"
					label="JFIELD_ALT_LAYOUT_LABEL"
					description="JFIELD_ALT_MODULE_LAYOUT_DESC" />

				<field
					name="moduleclass_sfx"
					type="textarea" rows="3"
					label="COM_MODULES_FIELD_MODULECLASS_SFX_LABEL"
					description="COM_MODULES_FIELD_MODULECLASS_SFX_DESC" />

				<field
					name="cache"
					type="list"
					default="1"
					label="COM_MODULES_FIELD_CACHING_LABEL"
					description="COM_MODULES_FIELD_CACHING_DESC">
					<option
						value="1">JGLOBAL_USE_GLOBAL</option>
					<option
						value="0">COM_MODULES_FIELD_VALUE_NOCACHING</option>
				</field>
				<field
					name="cache_time"
					type="text"
					default="900"
					label="COM_MODULES_FIELD_CACHE_TIME_LABEL"
					description="COM_MODULES_FIELD_CACHE_TIME_DESC" />
				<field
					name="cachemode"
					type="hidden"
					default="static">
					<option
						value="static"></option>
				</field>
			</fieldset>
		</fields>
	</config>
</extension>

<?php

defined('_JEXEC') or die;
?>


<?php if (!empty($name)) : ?>
	<ul class="films><?php echo $moduleclass_sfx ?>">
	<?php foreach ($names as $name) : ?>
		<li>
			<?php echo $name->name; ?>
		</li>
	<?php endforeach;  ?>
	</ul>
<?php endif; ?>

<?php

defined('_JEXEC') or die;

class ModFilmsHelper
{

	public static function getFilms($params)
	{
		$db		= JFactory::getDbo();
		$query	= $db->getQuery(true)
			->select('*')
			->order('id DESC')
			->from('#__cin_films')
			->where('city REGEXP "(^|[[:space:][:punct:]])$cityfilm([[:space:][:punct:]]|$)" AND pokaz=$pokazfilm');
		$films = JFactory::getFilms();


		$db->setQuery($query, 0, $params->get('cityfilm'));
		$db->setQuery($query, 0, $params->get('pokazfilm'));
		$result = $db->loadObjectList();
		
		

		return (array) $result;
	}
	
}

<?php

defined('_JEXEC') or die;

require_once __DIR__ . '/helper.php';

$cityfilm = $params->get('cityfilm');
$pokazfilm = $params->get('pokazfilm');
$moduleclass_sfx = htmlspecialchars($params->get('moduleclass_sfx'));

require JModuleHelper::getLayoutPath('mod_films', $params->get('layout', 'default'));

->where('city REGEXP "(^|[[:space:][:punct:]])0([[:space:][:punct:]]|$)" AND pokaz=1');

<fields name="params">
			<fieldset name="basic">
				<field name="cityfilm" type="text" default="" label="MOD_FILMS_FIELD_CITY_LABEL" description="MOD_FILMS_FIELD_CITY_DESC" filter="raw" />
				<field name="pokazfilm" type="list" label="MOD_FILMS_FIELD_POKAZ_LABEL" description="MOD_FILMS_FIELD_POKAZ_DESC">
					<option	value="nowfi">MOD_FILMS_FIELD_POKAZ_TODAY</option>
					<option	value="soonfi">MOD_FILMS_FIELD_POKAZ_SOON</option>
				</field>
			</fieldset>

<?php

class ModFilmsHelper
{

	public static function getFilms($params)
	{
	$pokazfilm = $params->get('pokazfilm');
		$db		= JFactory::getDbo();
		$query	= $db->getQuery(true)
			->select('*')
			->order('id DESC')
			->from('#__cin_films')
			->where('city REGEXP "(^|[[:space:][:punct:]])0([[:space:][:punct:]]|$)" AND pokaz=1');
		$user = JFactory::getUser();



		$db->setQuery($query, 0, $params->get('cityfilm'));
		$result = $db->loadObjectList();

		return (array) $result;
	}
}

<?php

defined('_JEXEC') or die;
?>


<?php if (!empty($names)) : ?>
<div class="cols"><?php echo $moduleclass_sfx ?>
<?php foreach ($names as $name) : ?>
<div class="col">
		<img src="<?php echo $name->izo; ?>" alt="" />
		<div class="title-film"><a href="index.php?option=com_cinema&view=films&id=<?php echo $name->id; ?>"><?php echo $name->name.((isset($name->category_id) && isset($name->params) && $name->category_id and $name->params->get('show_category'))? (' ('.$name->category_id.')') : '');  ?></a></div>
		<div class="janr"><?php echo $name->janr; ?></div>
</div>
<?php endforeach;  ?>
</div>
<?php endif; ?>

<?php

defined('_JEXEC') or die;

require_once __DIR__ . '/helper.php';

$cityfilm = $params->get('cityfilm');
$names	= ModFilmsHelper::getFilms($params);
$pokazfilm = $params->get('pokazfilm');
$moduleclass_sfx = htmlspecialchars($params->get('moduleclass_sfx'));

require JModuleHelper::getLayoutPath('mod_films', $params->get('layout', 'default'));