CODEWITHSUNDEEP
mysqljoomla
Joshi
Joshi

Reputation: 2790

Accessing data from database in joomla

I am using this query in Fabrik (Joomla Application) to pull the data from database, which is not working.

The same query with mysql syntax is working fine in PHPMYADMIN.

$db = FabrikWorker::getDbo(false, 2);

$query = $db->getQuery(true);

$query
    ->select('hostel_fee')
    ->from('hostel_fee AS a')
    ->join('INNER','students AS b ON (b.class = a.class)');     
$db->setQuery($query);
$a = $db->loadResult();
return $a;

Upvotes: 1

Views: 1762

Answers (2)

Toretto
Toretto

Reputation: 4711

Instead of using this 

$db = FabrikWorker::getDbo(false, 2);

Use this.

$db =& JFactory::getDBO();

Or if you want to use any external database to connect to your extension you can use this

Connecting to an external database

Upvotes: 1

Rakesh Sharma
Rakesh Sharma

Reputation: 13728

use the full queries like this

$db = &JFactory::getDBO();

$query = "SELECT m.id, m.title,m.level,mt.menutype FROM #__menu AS m

     INNER JOIN #__menu_types AS mt ON mt.menutype = m.menutype

     WHERE mt.menutype = m.menutype AND m.published = '1' ORDER BY mt.menutype,m.level";

$db->setQuery($query);

$rows = $db->loadObjectList();
OR
$rows = $db->loadResult();

Upvotes: 1

Related Questions