如何显示来自joomla表的所有数据？ [英] how to show all data from joomla table?

问题描述

最近我学会了如何通过此方法从数据库获取数据

recently i learned how to get data from database by this method

public static function getdb($params)
{
// Get a database object
$db = JFactory::getDbo();

$query = $db->getQuery(true);
$query->select('*');
$query->from('#__categories');

// sets up a database query for later execution
$db->setQuery($query);

// fetch result as an object list
$result = $db->loadObjectList();
foreach ( $result as $row ) {
echo "$row->extension .<br>";
}
}

此行

echo "$row->extension .<br>";

我们得到单行值。如何获取#__categories的所有行值？

we get single row value. how to we get all row value of #__categories? by any short code.

推荐答案

您可以使用另一个 foreach / p>

You can use another foreach inside

foreach ( $result as $row ) {  // it is like  foreach($objects as $object)
  foreach ($row as $r) {       // it is like  foreach($object as $values)
    echo "$r .<br>";
  }
}

但您应该在视图中打印代码模型，控制器等。

But you should print the code in the view not in the model, controller, etc.

这篇关于如何显示来自joomla表的所有数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！