im是Joomla的新手,IM试图构建一个组件,该组件是VirueMart的插件,允许用户在其用户区域中访问发票PDF。要做到这一点
我一直在处理它,并提出以下内容,但似乎没有做任何事情:
$id =JFactory::getUser()->id;
$db =& JFactory::getDBO();
$sql = "SELECT * FROM jos_vm_orders";
$db->setQuery($sql);
$options = $db->loadObjectList();
return $options;
我想念什么吗?
您可以检查此文档中的数据库查询-http://docs.joomla.org/api16:jdatabasequery
交叉检查您的表prefix.或尝试此 -
$db =& JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('*');
$query->from('#__vm_orders');
$query->where('id = 1'); //put your condition here
$db->setQuery($query);
//echo $db->getQuery();exit;//SQL query string
//check if error
if ($db->getErrorNum()) {
echo $db->getErrorMsg();
exit;
}
return $db->loadObjectList();
$db =& JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('*');
$query->from('#__vm_orders');
$db->setQuery($query);
$options = $db->loadObjectList();
return $options;
或
$db =& JFactory::getDBO();
$sql = "SELECT * FROM #__vm_orders";
$db->setQuery($sql);
$options = $db->loadObjectList();
return $options;
尝试一下,让我知道您是否有任何问题。
尝试此
$user =JFactory::getUser();
$userId = $user->id;//also u get name,email etc
$db =& JFactory::getDBO();
$sql = "SELECT * FROM table where condition";
$db->setQuery($sql);
$db->query();
$options = $db->loadObjectList();
return $options;
$id =JFactory::getUser()->id;
$db =& JFactory::getDBO();
$sql = "SELECT * FROM #__vm_orders";
$db->setQuery($sql);
$options = $db->loadObjectList();
return $options;
我还建议在使用Joomla 2.5和Futher版本的复杂查询时使用查询链。在这里,您可以阅读:http://m4extensions.com/index.php/tutorials/3-access-database-from-your-your-joomla-extension