Array
(
[CarrID] => 0
[Area] => 01785
[Number] => 07822
[TierID] => 2
[CtryID] => 0
[keyfield] => 1245422
)
<?php $querySet = "SET SQL_BIG_SELECTS = 1;"; $criteriaSet = new xPDOCriteria($modx->myDB, $querySet); $criteriaSet->prepare(); $criteriaSet->stmt->execute(); $query = "SELECT NationalArea.*, DestinationNames.Name FROM NationalArea JOIN DestinationNames ON NationalArea.Area=DestinationNames.Number WHERE NationalArea.Number = '01922'"; $criteria = new xPDOCriteria($modx->myDB, $query); if ($results = $modx->myDB->getCollection('NationalArea', $criteria)) { foreach ($results as $result) { $fields = $result->toArray(); echo '<pre>'; print_r ($fields); echo '</pre>'; $rows[] = $modx->getChunk('tpl.ShowDataNationalAreasOverView', $fields); } $ph['rows'] = implode('', $rows); $output = $modx->getChunk('tpl.ShowDataOuterNationalAreasOverview', $ph); } else { $output = $noresults; } return $output;
$querySet = "SET SQL_BIG_SELECTS = 1;"; $criteriaSet = new xPDOCriteria($modx->myDB, $querySet); $criteriaSet->prepare(); $criteriaSet->stmt->execute(); $query = "SELECT NationalArea.*, DestinationNames.Name FROM NationalArea JOIN DestinationNames ON NationalArea.Area=DestinationNames.Number WHERE NationalArea.Number = '".$_SESSION['areaCode']."'"; $criteria = new xPDOCriteria($modx->myDB, $query); if ($criteria->prepare()) { if ($criteria->stmt->execute()) { if ($results= $criteria->stmt->fetchAll(PDO_FETCH_ASSOC)) { foreach ($results as $result) { $fields = $result->toArray(); echo '<pre>'; print_r ($fields); echo '</pre>'; $rows[] = $modx->getChunk('tpl.ShowDataNationalAreasOverView', $fields); } $ph['rows'] = implode('', $rows); $output = $modx->getChunk('tpl.ShowDataOuterNationalAreasOverview', $ph); } else { $output = $noresults; } } } return $output;
Notice: Use of undefined constant PDO_FETCH_ASSOC - assumed 'PDO_FETCH_ASSOC' in /home/sites/domain.co.uk/public_html/nhs/core/cache/includes/elements/modsnippet/41.include.cache.php on line 39 Warning: PDOStatement::fetchAll() expects parameter 1 to be long, string given in /home/sites/domain.co.uk/public_html/nhs/core/cache/includes/elements/modsnippet/41.include.cache.php on line 39 No items found.
Fatal error: Call to a member function toArray() on a non-object in /home/sites/domain.co.uk/public_html/nhs/core/cache/includes/elements/modsnippet/41.include.cache.php on line 41
if ($criteria->prepare()) { if ($criteria->stmt->execute()) { if ($results= $criteria->stmt->fetchAll()) { foreach ($results as $result) { $rows[] = $modx->getChunk('tpl.ShowDataNationalAreasOverView', $result); } $ph['rows'] = implode('', $rows); $output = $modx->getChunk('tpl.ShowDataOuterNationalAreasOverview', $ph); } else { $output = $noresults; } } }