2. PHPRunner General questions
  3. Pop ups
This topic is locked

Pop ups

 		4/11/2008 2:41:42 AM
PHPRunner General questions
D
 dieter author

On the Computers_list page I have PC_ID, PC_Name, PC_Domain, IP_Address ...., Monitor, Printer, Other_Periph as fields.

In the Tables Monitors, Printers, Other_Periph I have a field PC where I assign the Printer(Monitor) to a PC.
Now I would have on Computers_list page in the field Monitor a link to this Monitor and a view (on Mouse over) in a Box with this Monitors Details.

The same for Peripherals and Printer in the Computers_list.
Is this possible, because I can not use Multiple Master/Detail relations ?

A search in the Forum didn´t find any matches.
thank you
Dieter
PS: I work with PHPRunner 4.1
J
 		Jane 4/11/2008

Hi,
use custom format on the "View as" settings dialog on the Visual Editor tab for this purpose.

Here is just a sample:

global $conn;

//select field values from Monitors table

$str = "select field1,field2,field3 from Monitors where MonitorID=".$value;

$rs = db_query($str,$conn);

$data = db_fetch_array($rs);

$str = $data["field1"]." ".$data["field2"]." ".$data["field3"];
//onMouseOver - open small window with detailed information

//onMouseOut - close this window

$str = "<a href=# onMouseOver=\"java script: pwin = window.open('',null,'height=300,width=400,status=yes,resizable=yes,toolbar=no,menubar=no,location

=no,left=150,top=200,scrollbars=yes'); pwin.document.write('" . htmlspecialchars(jsreplace(nl2br($str))) ."');\" onMouseOut=\"pwin.close()\">".$value."</a>";

$value = $str;