Tutorial: PhpRunner 9.8 and Photo Display

D. Thiebaut (talk) 10:38, 25 May 2018 (EDT)

---

...

Create Photo Project

• Windows 7
• PhpRunner 9.8
• Blank Project
• MySQL 192.168.1.139 (whatever ifconfig returns on Mac)
• Tables

• originals
• reproduced
• Master - Details relationship

• [Master] Reproduced:originalId <===> [Details] Originals:Id

• SQL Query

• Add CONCAT fields to queries for original and reproduced:

  CONCAT( `widthP`, ' x ', `heightP` ) as wxh_p,
  CONCAT( `widthIn`, ' x ', `heightP` ) as wxh_In,
  CONCAT( `width`, 'x', `height` ) as wxh,

• Fields

• unselect individual width and height fields, and select CONCAT fields

• Fields Order and Totals

• Put Details:Original at the top in pages showing reproduced records

• Miscellaneous

• Change the labels to use when displaying all the fields

• Security

• Add login using users table

• Style Editor

• Boostrap1/Darkly

• Output Directory

• Z:Documents\PHPRunnerOutput\
• Server Database Connections
• Create new connection

• $host="localhost";
• $user="nohoSkies";
• $pwd="xxxxxxxxxxx"
• $port="";
• $sys_dbname="NohoSkies";

• User new connection made