-
Notifications
You must be signed in to change notification settings - Fork 38
aql::sql
stanistan edited this page Apr 29, 2011
·
2 revisions
Returns an array with generated information based on the AQL statement.
$aql = " artist { name } artist_album { name as album_name } ";
$r = aql::sql($aql);
print_r($r);
/*
Array
(
Array
(
[sql] => SELECT artist.name as "name",
artist_album.name as "album_name",
artist.id as "artist_id",
artist_album.id as "artist_album_id"
FROM artist as artist
LEFT JOIN artist_album as artist_album on artist_album.artist_id = artist.id and artist_album.active = 1
WHERE artist.active = 1
[sql_count] => SELECT count(*) as count FROM artist as artist LEFT JOIN artist_album as artist_album on artist_album.artist_id = artist.id and artist_album.active = 1 WHERE artist.active = 1
[subs] =>
[objects] => Array
(
)
[primary_table] => artist
[left_joined] => Array
(
[0] => artist_album
)
[fk] => Array
(
[artist] => Array
(
[0] => artist_album
)
)
)
*/