joomla查询数据库操作

		$db = JFactory::getDbo();   //工厂模式获得JDatabaseDriver数据库实例

		// Calculate number of guests and users
		$result	     = array();
		$user_array  = 0;
		$guest_array = 0;

		$query = $db->getQuery(true)
			->select('guest, client_id')
			->from('#__session')
			->where('client_id = 0');  //生成查询语句，是个对象
		
	
		$db->setQuery($query);   //查询

		$sessions = (array) $db->loadObjectList();  //获取数据库

		if (count($sessions))   //遍历输出
		{
			foreach ($sessions as $session)
			{
				// If guest increase guest count by 1
				if ($session->guest == 1)
				{
					$guest_array ++;
				}

				// If member increase member count by 1
				if ($session->guest == 0)
				{
					$user_array ++;
				}
			}
		}