Setting up a simple page and using a query

[Brent W]

I want to create a page called members.php. Within that page I want to use a simple SQL query. What is the easiest way to do this? What all would I need to call within members.php to be able to query the database?

 

[Jeremy]

What is the end goal of this file?

 

[ProCom]

I'm looking for something very similar... an easy way to create pages with basic queries in them. I posted a similar request but haven't had success yet creating a dead simple page:
http://xenforo.com/community/threads/quick-easy-dirty-pages-with-sql-database-query-results.62865/

 

[AndyB]

Here's an example of using the xen:callback.

http://xenforo.com/community/threads/xen-callback-tag.62124/#post-691627

 

[Brent W]

What is the end goal of this file?

To handle vBSEO urls with no id in them and redirect to new url in xenForo.

 

[Lawrence]

I use Pages for a lot of different things, and each of my Pages requires data stored in the DB and as well to write data back to the database. In the Edit Page screen I use a PHP callback to handle the queries (for public facing data), for example: IcewindDaleRP_IcewindDale_PageCallback_Shop::shopServices

class IcewindDaleRP_IcewindDale_PageCallback_Shop
{
    public static function shopServices(XenForo_ControllerPublic_Abstract $controller, XenForo_ControllerResponse_Abstract $response)
    {
        $visitor = XenForo_Visitor::getInstance()->toArray();
        $shopsModel = XenForo_Model::create('IcewindDaleRP_IcewindDale_Model_Shops');
       
more code...

        $shopItems = $shopsModel->getAllItemsByShopId($criteria, $itemsPerPage, $sortBy);
               
        $response->params['adventurer'] = $visitor;
        $response->params['items'] = $shopItems;
        $response->params['shop_id'] = $shopId;
        $response->templateName = 'iwd_shop';
    }

Then I use Controller Public to handle any requests:

class IcewindDaleRP_IcewindDale_ControllerPublic_Inventory extends XenForo_ControllerPublic_Abstract
{
    public function actionItemInfo()
    {
        $itemId = $this->_input->filterSingle('item_id', XenForo_Input::UINT);
        $charId = $this->_input->filterSingle('char_id', XenForo_Input::UINT);
           
        $visitorId = XenForo_Visitor::getUserId();
        if ($visitorId != $charId)
        {
            throw $this->responseException($this->responseError(new XenForo_Phrase(
                'iwd_cheaters_dont_prosper'), 404)
            );
        }
        $item = $this->_getShopsModel()->getShopItemById($itemId);

        more code...
       
        $viewParams = array(
            'user_id' => $charId,
            'item' => $item
        );
        return $this->responseView(
            'IcewindDaleRP_IcewindDale_ViewPublic_Iwd_Char_Record_Item_Info',
             'iwd_char_record_item_info',
             $viewParams
        );
    }