PHPRunner 6.0 manual - Show data from master table on detail view/edit/add page

Show data from master table on detail view/edit/add page.

To add this event use (Insert PHP code snippet) button on the Visual Editor page.

Note: Change the values listed in red to match your specific needs.

global $dal, $strTableName;

echo "Master Info ";

if ($_SESSION[$strTableName."_masterkey1"])

{

$tblMaster = $dal->Table("MasterTableName");

$rs = $tblMaster->Query("Masterkey=".$_SESSION[$strTableName.

"_masterkey1"],"");

if ($data = db_fetch_array($rs))

{

echo "Field1: ".$data["Field1"]." ";

echo "Field2: ".$data["Field2"]." ";

}

For example, Orders is a master table, while Order details is a details.

global $dal, $strTableName;

echo "Order Info ";

if ($_SESSION[$strTableName."_masterkey1"])

{

$tblOrders = $dal->Table("Orders");

$rs = $tblOrders->Query("OrderID=".$_SESSION[$strTableName.

"_masterkey1"],"");

if ($data = db_fetch_array($rs))

{

echo "Customer: ".$data["CustomerID"]." ";

echo "Employee: ".$data["EmployeeID"]." ";

}

For more information about using Data Access Layer (DAL), see Data Access Layer.