View Full Version : PHP MySQL Application Administration

08-29-2011, 09:09 PM
Hi All,

I've got a general query and I'm looking for some opinion. I'm re-designing a fairly involved registration and score reporting system for a sports league that is written predominantly in php and draws from a mysql database. I wrote the initial system (which is still in use today and much-loved) but my coding and skills have advanced a lot since that first attempt.

I'm hoping that version 2.0 will be a significantly improved version of 1.0 which is tempermental and requires a lot of direct input into the database tables.

My question is: how do you recommend that I handle front-end application administration (CRUD + Administrative functions like adding sports and changing the name of a league). That is to say, I want the owner of the sports league to be able to "administer" his application without ever having to go near the actual mysql database.

Is hard-coding my best option? Should I be using something different than PHP? What about plug-ins, 3rd party apps, or frameworks? Any advice or suggestions would be greatly appreciated.

Thanks in advance!

08-30-2011, 01:47 AM
Wordpress with some nice addons would be the best options.

08-30-2011, 07:21 AM
Almost all the modern web sites use databases. MySql is probably the most used database for web application. There are many web tools that interact with MySQL, PHPMyAdmin is a great example. But the problem is they are very complex for non expert user. That is why I decided to create user friendly web application for basic management of MySQL.

08-30-2011, 04:52 PM
Thanks for your replies.

I spent a long time looking and I believe AJAXCrud (http://www.ajaxcrud.com) is exactly what I need. Highly customizable mysql editor that allows relationships etc. Mindblowing.