Tutorial: PhpRunner 9.8 and Photo Display

From dftwiki3
Revision as of 15:57, 1 June 2018 by Thiebaut (talk | contribs) (Create Photo Project)
Jump to: navigation, search

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
  • Server Database Connections
  • Create new connection
  • $host="localhost";
  • $user="nohoSkies";
  • $pwd="xxxxxxxxxxx"
  • $port="";
  • $sys_dbname="NohoSkies";
  • User new connection made