Joomla กับการเชื่อม Database สร้างโมดูลขึ้นเว็บไซต์ที่ใช้ joomla

<link rel="stylesheet"href='<? echo $mooConfig_live_site;?>/modules/mod_dog.css'type="text/css" />
<link href="mod_dog.css" rel="stylesheet" type="text/css" />

<?php
/**
 * @package		Joomla.Site
 * @subpackage	module
 * @copyright	Copyright (C) 2005 - 2012 Open Source Matters, Inc. All rights reserved.
 * @license		GNU General Public License version 2 or later; see LICENSE.txt
 */
 
defined('_JEXEC') or die('Direct Access to this location is not allowed');
$db =&JFactory::getDBO();
$query = "
SELECT *
FROM ".$db->nameQuote('#__dog')."
WHERE ".$db->nameQuote('village')." = ".$db->quote('หมู่ที่ 1')."order by iddog asc limit 0,".$num_records.";";

$db->setQuery($query);
$data = $db->loadresult();
$db->query(); 
$user_id = $db->insertid();
$rows = $db->loadObjectList();

$content = '<ul class="dog'.$class_sfx.'">';

foreach($rows as $row){
	$village = $row->village;
	$link = "folder/view1.php?id=".$row->id;
	$nameog = $row->namedog;
			
	$content.= "<li class='dog$class_sfx'>";
	
	$content.= "<img src='mod_dog.css/$nameog' width=10><br>";
	$content.="<a href='$link'>$village $nameog</a></li> ";
}?>

<?xml version="1.0" encoding="utf-8"?>
<extension
	type="module"
	version="2.5.6"
	client="site"
	method="upgrade">
	<name>module</name>
	<author>ComputerScience 52/12</author>
	<creationDate>2013</creationDate>
	<copyright>Copyright (C) 2005 - 2012 Open Source Matters. All rights reserved.</copyright>
	<license>GNU General Public License version 2 or later; see LICENSE.txt</license>
	<authorEmail>[email protected]</authorEmail>
	<authorUrl>www.joomla.org</authorUrl>
	<version>2.5.6</version>
<desciption>DOG :Shows your dog or contents</desciption>
<files>
<filename module="mod_dog">mod_dog.php</filename>
<filename module="mod_dog">mod_dog.css</filename>
<filename module="mod_dog">arrow.png</filename>
</files>
<params>
<param name="moduleclass_sfx" type="text" default="" label="Module Class Suffix" description="A suffix to be applied to the css class of the module (table.moduletable),this allows individual module module styling" />
</params>
</extension>