<?php
include('/big/dom/xphplens/www/php/phplens/phplens.inc.php');
session_start();
//----------------------------------------
// The following lines are for formatting
// the page and not needed by phplens
$gTitle = "Products";
$HIDEHEADER=true;
include('./header.php');
?>
<?php
$lens = PHPLensConnect('ex905',
"select productid,productname from products order by 2",
'mysql',$gEX_server,$gEX_userid,$gEX_password,$gEX_db);
if ($lens) {
//$lens->dynEdit = 0; // disable designer editing
$lens->showDetails = false; // Show details grid
$lens->menuHide = 'ALL'; // Which menu items to hide.
$lens->pageSize = 1000; // rows per page, 0=show all rows
$lens->showRecNo = 0; // 0=hide 1=left 2=right
$lens->nameLens = ';PRODUCTNAME^Product^^^;';
$lens->gridLens = 'PRODUCTNAME';
$lens->powerLens =
'PRODUCTNAME^<a target=right href=ex905right.php?show={productid}>{ProductName}</a>;';
$lens->colorTitle = 'orange';
//-----------------
// Generate HTML
$lens->Render();
$lens->Close();
}
?>
<h4>Notes</h4>
<p>This demo shows the use of a powerLens to set the anchor tag for PRODUCTNAME to drill down to details.
<p>Note that each PHPLens object is created using a different ID (the first parameter in the
constructor): <i>ex905</i> and <i>ex905right</i> to ensure that there are no conflicts.</p>
<?php
include ('./footer.php');
?>