DBAPI and INNER JOIN

12 Posts

panayotisk Reply #1, 13 years, 4 months ago

Hi all,
I am using Evo 1.10.
I need to perform an sql select statement that needs to join two tables.
Is this possible to do with DBAPI select command? I could not find any examples.

Thank you

788 Posts

breezer Reply #2, 13 years, 4 months ago

Maybe this will help

$sql= "SELECT wu.username, wua.*
       FROM " . $modx->getFullTableName( "web_users" ) . " wu
       INNER JOIN " . $modx->getFullTableName( "web_user_attributes" ) . " AS wua ON wua.internalKey=wu.id
       WHERE wu.id='$uid'";

$row = $modx->db->getRow( $modx->db->query( $sql ) );

if( $row ){
                
    // code here
}

xforum
http://frsbuilders.net (under construction) forum for evolution

12 Posts

panayotisk Reply #3, 13 years, 4 months ago

Thank you very much for your reply.
I was aware of the API:DBAPI:query() function, but I was somehow put off by the following words in the documentation:

It is recommended to use the specific database function to run your queries (such as using $modx->db->select() to perform a SELECT query) instead of using this function, when possible. This function is intended for "internal use only", which means that it is intended for use by the database functions.

But if this is the way you would choose to do it then I should follow it too.

Thanks again

788 Posts

breezer Reply #4, 13 years, 4 months ago

I found that code being used in the weblogin snippet (which was created by coders with much more experience than myself), and it works fine for me in other applications, your mileage may vary

xforum
http://frsbuilders.net (under construction) forum for evolution