Difference between revisions of "Tutorial: PhpRunner 9.8 and Photo Display"
(→Create Photo Project) |
(→Create Photo Project) |
||
| Line 253: | Line 253: | ||
::* Master - Details relationship | ::* Master - Details relationship | ||
:::* [Master] Reproduced:originalId <===> [Details] Originals:Id | :::* [Master] Reproduced:originalId <===> [Details] Originals:Id | ||
| − | + | * SQL Query | |
| − | + | :* Add CONCAT fields to queries for original and reproduced: | |
| − | + | :<source lang="mysql"> | |
CONCAT( `widthP`, ' x ', `heightP` ) as wxh_p, | CONCAT( `widthP`, ' x ', `heightP` ) as wxh_p, | ||
CONCAT( `widthIn`, ' x ', `heightP` ) as wxh_In, | CONCAT( `widthIn`, ' x ', `heightP` ) as wxh_In, | ||
CONCAT( `width`, 'x', `height` ) as wxh, | CONCAT( `width`, 'x', `height` ) as wxh, | ||
</source> | </source> | ||
| + | * 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 | ||
| + | |||
| + | |||
<br /> | <br /> | ||
<br /> | <br /> | ||
Revision as of 15:54, 1 June 2018
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
