Entry

Database: MySql: PHPRunner: Listbox: Is it better to use a lookup table or adding the data manually?

May 7th, 2005 12:43
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 06 May 2021 - 05:14 pm ------------------------
Database: MySql: PHPRunner: Listbox: Is it better to use a lookup 
table or adding the data manually?
---
Possibly use lookup tables, as you can sort the data, edit the
SQL with your favorite text editor, ...
---
---
Steps: Overview:
 1. -Open PHPRunner
 2. -Create your project
 3. -Goto the steps
     1. In step screen 'Formatting'
     2. -Select field 'Edit as'
     3. -Select from list 'Lookup wizard'
     4. -Now you can choose to add data
         1. -Adding the list values manually
             1. -Advantage:
                 -If you add your data manually, it is rather straight
                  forward, you just click '+' and add your list data
             2. -Disadvantage
                 -If something goes wrong (so e.g. loosing your data),
                  you might have to input this data all over again,
                  costing you a lot of time (e.g. a list of all the
                  countries in the world).
         2. -Getting your data from a lookup table
             1. -Advantage
                 -The big advantage of using a lookup table (which is
                  thus some table in your MySql database) is
                  1. your list data will be stored there independent of
                     PHPRunner. So you can always change that data
                     outside of PHPRunner yourself.
                  2. you can possibly reuse that table
                     (e.g. a list of all countries in the world)
                     1. in other tables in the same project
                     2. in other projects again
                  3. your application is centered around getting
                     (all) your data from a (central) database,
                      so having to change your data only once
                      and also only in one place.
                  4. You can show your data sorted
                  5. You can edit the SQL code to create
                     your tables in your favorite text
                     editor (e.g. to automate this)
                  6. For administration purposes
                     1. You can split your tables in 2 parts
                        1. lookup tables
                        2. non lookup tables
                     2. You collect all your lookup tables in
                        a separate project and create thus
                        an administration page for it
                        (e.g. enable all this tables with
                         in the screen 'Data sourcetable,
                         and disable all other tables, then
                         build this project in a new directory
                         in PHPRunner),
                         to which you can separately log in to
                         as say an administrator.
             2. -Disadvantage
                 -The disadvantage would possibly be that you have to
                  once create this tables (e.g. using PHPMyAdmin or
                  mysql.exe) in your MySQL database (on your local
                  computer and possibly also on your website), which
                  means a bit more effort for you, at least once.
---
---
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
----------------------------------------------------------------------