Joomla database operation sample code

The examples in this article describe the Joomla database operation method. Share it with everyone for your reference, the details are as follows:

1, jTable

$row =& JTable::getInstance('comment', 'Table');
$row->load($id);
$row->bind(JRequest::get('post'))
$row->store()

2, jModel

$this->_db->setQuery($query);
$this->_db->loadObject();
$this->_getList($query, 0, 0); 

3, jFactory

$db =& JFactory::getDBO();
$query = "SELECT count(*) FROM #__reviews";
$db->setQuery( $query );
$total = $db->loadResult();
$query = "SELECT * FROM #__reviews";
$db->setQuery( $query,$limitstart, $limit );
$rows = $db->loadObjectList();

I hope this article will help you design PHP programs based on joomla help.

The above introduces the Joomla database operation sample code, including the relevant content. I hope it will be helpful to friends who are interested in PHP tutorials.