Start blank section for tomorrow
← Older revision
Revision as of 03:44, 31 August 2013
Line 9:
Line 9:
Joomla can use different kinds of SQL database systems and run in a variety of environments with different table-prefixes. In addition to these functions, the class automatically creates the database connection. Besides instantiating the object you need just two lines of code to get a result from the database in a variety of formats. Using the Joomla database layer ensures a maximum of compatibility and flexibility for your extension.
Joomla can use different kinds of SQL database systems and run in a variety of environments with different table-prefixes. In addition to these functions, the class automatically creates the database connection. Besides instantiating the object you need just two lines of code to get a result from the database in a variety of formats. Using the Joomla database layer ensures a maximum of compatibility and flexibility for your extension.
+
+
==Dealing with Errors==
==Query Results ==
==Query Results ==
Line 311:
Line 313:
Note: if you run getNumRows() after loadRowList() - or any other retrieval method - you may get a PHP Warning:
Note: if you run getNumRows() after loadRowList() - or any other retrieval method - you may get a PHP Warning:
<pre>Warning: mysql_num_rows(): 80 is not a valid MySQL result resource
<pre>Warning: mysql_num_rows(): 80 is not a valid MySQL result resource
−
in
D:\xampp\htdocs\joomla1.5a\
libraries\joomla\database\database\mysql.php on line 344</pre>
+
in libraries\joomla\database\database\mysql.php on line 344</pre>