Quick and dirty way to make forms for editing fields in MySQL databases

Question

Hi,

I have a seriously ridiculous deadline to meet because I'm picking up from a disgruntled developer. I have a database with a few tables and some one-to-one mappings, nothing too complicated.

I need to create a backend for searching and editing these tables in some kind of HTML form style (not necessarily web-based if there is a better solution like MS Access or something).

I suspect I'm being vague, simple example:

Customer table:

CustomerID   Name    Email

Bookings table:

BookingID    CustomerID    Departure_Date    Return_Date

I need the easiest, quickest solution that will allow a non-programmer client to create, read, update and delete records from these tables. Any suggestions?

Answer 1

If the deadline is seriously ridiculous then phpmyadmin with a bit of explanation to the client.

Answer 2

Web frameworks essentially specialize in creating very fast CRUD interfaces to databases.

What you're saying would be incredibly easy in Django, because all you need to do is define the models to match your existing database, and then turn on the Admin interface. That would be just what you asked for with zero programming, only configuration. Django is Python, however.

I suggest configuring a PHP web framework like Symfony, CodeIgniter (or it's decendants, Yii and Kohana) or CakePHP.

Answer 3

I would suggest TOAD for MySQL, or a similar IDE. That would be about the quickest, simplest way. You would just need to show the user a few simple steps.

Answer 4

I may suggest http://www.ajaxcrud.com/ if you really want to have something inside your application.

Answer 5

Check out DBKiss it's one PHP file you can just upload.