Documentation on database for 2.5? - Joomla! Forum - community, help and support


i've been looking @ page:
http://docs.joomla.org/accessing_the_da ... tabase/2.5

these docs woefully incomplete me. instance, there no description of how determine how many rows affected update or delete query. also, every example makes use of new-fangled "query chaining" rather describing how 1 might use traditional query (such "optimize my_table"). lastly, examples seem anecdotal rather comprehensive.

i see page contains links appears documentation generated phpdocumentor, documentation there doesn't match codbase. instance, this page says jdatabase::getinstance deprecated , jdatabasedriver::getinstance should used instead. cannot find , jdatabasedriver class or interface defined in code anywhere. api documentation refers version numbers 11.1 , 12.1 whereas i'm using joomla 2.5.

additionally, docs jdatabase::query doesn't tell @ return values.

does detailed documentation exist? i'm wondering few things
* gets returned $db->query when run update query or delete query? boolean? number of affected records?
* if change current custom queries use jdatabse::query, going mean have change them again joomla 3.0 because uses execute instead?
* possible check number of rows affected or returned query ? examples swell.

you have in source code when google search or joomla docs fail :)

start using $db->execute() in j2.5 avoid making changes in j3.0. $db->query() depreciated in j3.0 still available. thing if forget update code see "depreciated" warning in j3.0 logs.

as update/delete queries, $db->query()/$db->execute() return true on successful execution. can use $db->getaffectedrows() number of affected rows.





Comments

Popular posts from this blog

How to change text Component easybook reloaded *newbee* - Joomla! Forum - community, help and support

After Effect warning: A problem occurred when processing OpenGL commands

Preconditions Failed. - Joomla! Forum - community, help and support