创建joomla模块以执行简单查询并显示结果

Question

Besides the tables of joomla, I create my own table in the same database joomla!

Now I wanted to create a module, which made ​​the selection of this table and show. How can I do this!

Table FRUITS

ID | NAME
1 | apple
2 | orange
3 | banana

I have already created the structure of the module! Now I lack the build file:

• helper.php
• tmpl / default.php

Answer 1

Try this,

Inside your helper.php

function GetDetails(){
  $db = JFactory::getDBO();
  $sql= "SELECT * FROM FRUITS";
  $db->setQuery($sql);
  $db->query();
  $res = $db->loadAssocList();
  return $res;
}

and in your mod_ file have call to this function like

$result = class_name :: GetDetails();
//$result is available in your default.php

For more about module development in joomla.

Hopes its help you..