Select code not working in article Joomla 3

Question

I need to display data in an article in tabular form.
I am using sourcerer by NoNumber for adding the select code in the article:

<?php

defined('_JEXEC') OR die("Restricted access"); 
$user =&JFactory::getUser();
$db =&JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('*');
$query->from('#__bat_score'); 
$query->where('id = 1');   //put your condition here    
$db->setQuery($query);
//echo $db->getQuery();exit;
if ($db->getErrorNum()) {
  echo $db->getErrorMsg();
  exit;
}
return $db->loadObjectList();

// from Joomla Resources 
// the current code is not showing anything 

The error i'm getting is like in this image:

The desired output is displaying the rows of the mysql table in a html table.

Please suggest some guidance on this as the best method to show the database data in the articles. Thanks in advance.

Answer 1

First, remove the following line of code as you won't need it.

defined('_JEXEC') OR die("Restricted access");

Secondly, you are returning something but you're only supposed to return in functions. In your case, all you need to do is echo the values,

Try using the following:

<?php
$user   = JFactory::getUser();
$db     = JFactory::getDbo();

$query = $db->getQuery(true);
$query->select(array('*'))
      ->from($db->quoteName('#__bat_score'))
      ->where($db->quoteName('id') . ' = 1');

$db->setQuery($query);
$rows = $db->loadObjectList();

if ($db->getErrorNum()) 
{
  echo $db->getErrorMsg();
  exit;
}

echo '<table>';
foreach ($rows as $row)
{
    echo '<tr>';
    echo '<td>' . $row->COLUMN_NAME   . '</td>'; 
    echo '<td>' . $row->COLUMN_NAME_2 . '</td>'; 
    echo '</tr>';
}
echo '</table>';
?>

You of course need to change COLUMN_NAME to whatever your column name if for your database table.

Answer 2

you don't need a third party extension you can copy the article view in your template html folder and then add your custom code (better with a content plugin), but you can get your data with:

$db = JFactory::getDBO();
$db->setQuery('select * from #__bat_score where id = 1');
$rows = $db->loadObjectList();
if(count($rows)) {
echo '<table>';
foreach($rows as $row) {
//print your table rows
}
echo '</table>';
}