Entry
Database: PHP: PHPRunner: How to create master/detail tables using PHPRunner+PHP+MySql+Apache?
May 6th, 2005 07:09
Knud van Eeden,
----------------------------------------------------------------------
--- Knud van Eeden --- 05 April 2021 - 02:50 am ----------------------
Database: PHP: PHPRunner: How to create master/detail tables using
PHPRunner+PHP+MySql+Apache?
---
Steps: Overview:
1. -For an overview of the steps, see e.g.
http://www.knud.info/FaqtsPHPRunnerMySqlApache.htm
2. -Create your master/detail tables
in MySql
3. -Start the PHPRunner program
1. -Start the project
1. Possibly open an already existing project
-- or --
1. Create a new project
2. -Fill in the details in the wizard
1. -Click button 'Next'
2. -Step 1: 'Connect to MySql'
1. 'Host/Server Name (or IP)'
1. If your MySql is running locally
(e.g. on your local computer)
use
e.g.
localhost
otherwise an IP address
e.g.
10.10.10.168
2. 'User'
e.g.
root
3. 'Password'
<your password>
4. -Choose your database
1. -Click button 'Connect'
1. -Select your databasename from list
3. -Click button 'Next'
4. -Step 3: 'Datasource table'
1. -Now it is really important that your enable
all tables involved (otherwise the information
of your changes will not be saved).
Thus say in your database there are 100 tables,
and for your project are 10 tables of this involved
for your project, of which 3 tables should also occur
on the resulting web pages,
then you must enable the
checkboxes [V] for all this 3 tables.
[V] table1 of my project (will be shown on web page)
[V] table2 of my project (will be shown on web page)
[V] table3 of my project (will be shown on web page)
[ ] table4 of my project
(will not be shown on web page)
[ ] table5 of my project
(will not be shown on web page)
[ ] table4 of my project
(will not be shown on web page)
...
[ ] other tables
2. -Then for all this enabled tables, you one by one
highlight the line of that table, then start going
through the remaining steps.
( 1. Do this for the first enabled table
2. Do this for the second enabled table
...
3. Do this for the last enabled table)
1. For the first to the last checkbox enabled table in
the left pane
1. Highlight the line of that table in the left
pane
2. In the right pane fill in the information
(what you fill in depends on how you have
designed your tables in MySql)
1. 'Master'
1. -Select from list 'Table'
e.g.
<your master table name>
e.g.
tableMymaster1
2. -Select from list 'Primary key'
e.g.
<name of primary key in your master table>
e.g.
primaryKeyTableMyMaster1
2. 'Detail'
you will see here by default the name
of the currently highlighted table
1. -Select from list 'Foreign key'
e.g.
<name of foreign key in your current table>
e.g.
primaryKeyTableMyMaster1
3. -Enable checkbox 'Display master table on
detail page' (then you will see a link on
which you can click on your HTML pages,
which links to and thus loads the HTML page
for that table)
3. -Click button 'Next'
4. -Step 4: 'List page'
1. -Possibly change this data
5. -Click button 'Next'
6. -Step 5: 'Edit SQL Query'
1. -Possibly change this data
7. -Click button 'Next'
8. -Step 6: 'Searchable fields'
1. -Possibly change this data
9. -Click button 'Next'
10. -Step 7: 'Key Column'
1. -Possibly change this data
11. -Click button 'Next'
12. -Step 8: 'Formatting'
1. -Possibly change this data
13. -Click button 'Next'
14. -Step 9: 'Field order and totals'
1. -Possibly change this data
15. -Click button 'Next'
16. -Step 10: 'Security'
1. -Possibly change this data
17. -Click button 'Next'
18. -Step 11: 'Miscellaneous'
1. -Possibly change this data
19. -Click button 'Next'
20. -Step 11: 'Output directory'
1. -Possibly change this data
1. -If you are using Apache,
do not change the virtual directory
(as this is mainly for Microsoft
Internet Information Server (IIS)) but
browse yourself to your output directory
(e.g. some subdirectory in your htdocs
directory)
e.g.
K:\pdrive\apache\Apache2\htdocs\MyProject1
2. -Change the URL to the current
web server URL
e.g.
http://localhost:80/MyProject1/index.htm
(note: you will have to use a forward slash
'/' in the URL, otherwise PHPRunner
might concatenate all the time
index.htm after it if you rebuild
your project again)
21. -Click button 'Build'
to generate your project
22. -Click button 'View in browser'
1. -This will load the webpage in your
browser
e.g.
http://localhost:80\MyProject1
4. -Copy the generated files to your
webbrowser directory
e.g.
md "c:\program files\Apache Group\Apache2\htdocs\PHPRunner"
copy "c:\program files\PHPRunner\output" "c:\program
files\Apache Group\Apache2\htdocs\PHPRunner"
or use a file ftp manager like
Total Commander
http://www.ghisler.com
5. -Start your Apache web server
1. -Configure your Apache for PHP
1. Check in the php.ini
file
if the variable
session.save_path
has been set,
and if the path exists
e.g.
session.save_path=C:\PHP\sessiondata
and that path
'C:\PHP\sessiondata'
must exist on your computer
Otherwise create it with e.g.
md c:\PHP\sessiondata
6. -Open your browser
1. -Open the just generated index page
1. -Type in the URL field
localhost/PHPRunner/index.htm
2. -Possibly login
1. e.g. username = test
2. e.g. password = test
7. -Do some operations on the data of the tables
1. -Change
2. -Show the master/detail (primary key/foreign key)
relations
---
---
Internet: see also:
---
Database: MySql: PHPRunner: Link: Can you give an overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35950/fid/1805
---
Database: Language: SQL: Overview: Can you give an overview of links
about SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54
----------------------------------------------------------------------
