CODEWITHSUNDEEP
phpmysql
bcoughlan
bcoughlan

Reputation: 26627

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

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?

Upvotes: 1

Views: 1645

Answers (5)

fire
fire

Reputation: 21531

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

Upvotes: 2

Narcis Radu
Narcis Radu

Reputation: 2547

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

Upvotes: 1

northpole
northpole

Reputation: 10346

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.

Upvotes: 1

JAL
JAL

Reputation: 21563

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.

Upvotes: 2

Alberto Zaccagni
Alberto Zaccagni

Reputation: 31580

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

Upvotes: 5

Related Questions