I'm working on upgrading a website that I maintain, which is built in PHP with a MySQL database.
Right now I have each ad in a separate PHP file, and use Include to pull the ads into their proper pages.
It's getting to be too much to store them in PHP files, and too confusing to have to edit each file when the ads change, so I want to put them into the MySQL database.
Is there any problem with this?
Please note that I do want to store the code for the ads in MySQL, not only to make it easier, but also so I can later set up a page where the advertisers can go in and change their own ads. Also, as the site becomes more popular, I will be spreading the load out over multiple servers, so I'll need a central database to store the ads for all of the webservers.
So, continuing to use the include files, or using a flat-file won't work. This has to move to MySQL!
Thanks for your help and suggestions!