I need a program that allows users to search an online database and returns any relevant matches. The database is approximately 5 million records. The records are pipe delimited text files.
In addition, a program will need to be written that maintains a smaller database of users who are allowed access to the database. The interface needs to automatically maintain the user's name, a password for them (automatically generated but which the user can change) and a date when access to the database will expire, along with an interface that allows me to manually update the information as needed. An automated notice which sends the user an email notice that their subscription to the database is about to expire would also be useful.
I'm planning on using MySql as the backend for the online database. Your assistance in setting up the MySql database to make certain it functions properly will also be required.
A future upgrade which allows instant access to the database after the user has paid may eventually be needed. However for now, a manually operated setup will be fine and is all that is required.
It is important for the interface to look clean and professional. I can design the web page(s), all I need is a quick and simple way to implement the the search form and the information which is returned to the web page.