Jfactory::getdbo Usage _php Example of Joomla database operation

This paper illustrates the JFACTORY::GETDBO usage of Joomla database operation. Share to everyone for your reference, specific as follows:

Jfactory is a static class used to get references to various system objects

Getdbo The database Connection object code for the method of obtaining the database object:

$db =& jfactory::getdbo ();

With database objects, you can do database operations, execute the query code:

<?php
$db =& jfactory::getdbo ();
$query = ' SELECT FirstName from #tablename ';
$db->setquery ($query);
($db->query ();//Make changes, additions, deletions)
$Result = $db->loadobjectlist ()//Data set
?>

Get the data set, output look:

<?php
  foreach ($Result as $key => $value)
  {
   echo $value->firstname. ', ';
  }
? >

More about Joomla interested readers can view the site topics: "The Zend framework framework to start the course", "Yii framework Introduction and common skills Summary", "PHP Excellent Development Framework Summary", "Smarty Template Primer Tutorial", " Thinkphp Common methods Summary, "PHP object-oriented Programming Introduction Course", "PHP string (String) Usage Summary", "Php+mysql Database operation Introduction Tutorial" and "PHP common database Operation skill Summary"

I hope this article is helpful to everyone based on the Joomla program design.