cant get dbapi to work correctly

24 Posts

a_BIG_man Reply #1, 18 years, 7 months ago

So im having some issue trying to make a simple query using the bdapi in a snippet.

<?php
$myID = $modx->getLoginUserID();
$table = $modx->getFullTableName("myTableHere");
$dataQuery = $modx->db->select('*', $table, 'User_ID = '.$myID);


echo '<pre>';
print_r($dataQuery);
echo '</pre>';
?>

using the code above, the only output i get is "Resource id #21". Not sure what that means, but i should be getting a whole array full of data. Is there something wrong with my syntax?

☆ A M B ☆
24,524 Posts

sottwell Reply #2, 18 years, 7 months ago

Not at all. You are getting exactly what you are supposed to be getting. You have to extract the data from the resource that the query returned. Use $modx->db->getRow($dataQuery) to get each row of data (this is usually done in a loop)

while($row = $modx->db->getRow($dataQuery)) { print_r($row); }

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org

24 Posts

a_BIG_man Reply #3, 18 years, 7 months ago

ah great. Thanks. One more line of code...