This paper describes the Jfactory::getdbo usage of Joomla database operation. Share to everyone for your reference, as follows:
Jfactory is a static class that gets references to various system objects
Getdbo get the database connection object code for the method of obtaining the database object:
$db =& jfactory::getdbo ();
With the database object, you can do the database operation and execute the query code:
<?php$db =& jfactory::getdbo (); $query = ' SELECT FirstName from #tablename '; $db->setquery ($query);($db Query ();//perform change, add, delete) $Result = $db->loadobjectlist ();//Get DataSet?>
Get the data set and output to see:
<?php foreach ($Result as $key = + $value) { echo $value->firstname. ', '; }? >
More about Joomla related content readers can view this site topic: "Zend Framework Framework Introductory Tutorial", "Yii framework Introduction and common skills Summary", "PHP Excellent Development Framework Summary", "Smarty Template Primer Basic Tutorial", " Summary of common methods of thinkphp, PHP Introduction to Object-oriented programming, PHP string usage Summary, PHP+MYSQL database Operations Primer and PHP Common database operations Tips Summary
It is hoped that this article is helpful to everyone based on Joomla program design.
The above describes the Joomla database operation of the JFACTORY::GETDBO usage, including the FACTORY,JOOMLA aspects of the content, I hope that the PHP tutorial interested in a friend helpful.