PHP Script

[tommyxv]

How can I get a PHP Script to run either on a vBavanced or WebTemplate page?

This is the script

PHP Code:

 <?php

    include(dirname(__FILE__)."/language.php");
    include(dirname(__FILE__)."/lib.php");
    include(dirname(__FILE__)."/engine_dml.php");
    
    $x = new DataList;
    if($HTTP_POST_VARS["Filter_x"] != ""  || $HTTP_POST_VARS['CSV_x'] != "")
    {
        // Query used in filters page and CSV output
        $x->Query = "select engine.id as 'Part Number', engine.name as 'Part Name', engine.description as 'Description' from engine";
    }
    else
    {
        // Query used in table view
        $x->Query = "select engine.id as 'Part Number', engine.name as 'Part Name', engine.description as 'Description' from engine";
    }
    
    // handle date sorting correctly
    // end of date sorting handler
    
    $x->DataHeight = 150;
    $x->AllowSelection = 0;
    $x->AllowDelete = 1;
    $x->AllowInsert = 1;
    $x->AllowUpdate = 1;
    $x->AllowFilters = 0;
    $x->AllowSavingFilters = 0;
    $x->AllowSorting = 1;
    $x->AllowNavigation = 1;
    $x->AllowPrinting = 1;
    $x->AllowCSV = 0;
    $x->HideTableView = 0;
    $x->RecordsPerPage = 10;
    $x->QuickSearch = 3;
    $x->QuickSearchText = $Translation["quick search"];
    $x->ScriptFileName = "engine_view.php";
    $x->TableTitle = "Partnumber";
    $x->PrimaryKey = "engine.id";
    $x->ColWidth[] = 150;
    $x->ColWidth[] = 150;
    $x->ColWidth[] = 150;
    $x->Template = 'engine_templateTV.html';
    $x->SelectedTemplate = 'engine_templateTVS.html';
    $x->ShowTableHeader = 1;
    $x->ShowRecordSlots = 1;
    $x->HighlightColor = '#FFE4E1';
    $x->Render();
    
    include(dirname(__FILE__)."/header.php");
    echo $x->HTML;
    include(dirname(__FILE__)."/footer.php");
?>

[tommyxv]

Any suggestions?