Hi all
I am trying to create an application where the user adds new mySQL tables to an all ready existing mySQL database.
The user launch a setup file where he/she enters the database name, host name, user name and password into a form. That form runs a script that establishes the needed mySQL tables.
That all fine and dandy, but next time a script in the application needs to contact the database it will need the same login information again. The user shouldnt have to type in the database login information each time a script need to contact the database. So how do I get a script to connect to the database with the correct login information?
Do I store the database login information in a flat file, and then read the login information in to the various scripts that need to contact the database? Or are there a method to this I have been too stupid to figure out?