amitpatil321
8/12/2016 - 3:11 PM

Fetching data from custom table

Fetching data from custom table

<?
$modx->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$path = MODX_CORE_PATH . 'components/bankquality/';
$result = $modx->addPackage('bankquality',$path.'model/','bq_');

$query = $modx->newQuery('Reviews');
$query->limit(10,10);
$query->sortby('date_added1','DESC');
$quotes = $modx->getCollection('Reviews',$query);

print_r($query->toSQL());

foreach($quotes as $quote) {
    $output .= '<p>Id: ' . $quote->get('id');
    $output .= '<br/>Name: ' . $quote->get('email');
    $output .= '<br/>Type: ' . $quote->get('comment') . '<br/></p>';
}

return $output;