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

Question

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?

Alberto Zaccagni · Accepted Answer · 2010-07-14 14:57:54Z

5

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

answered Jul 14, 2010 at 14:57

Alberto Zaccagni

31.8k11 gold badges75 silver badges108 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bcoughlan Over a year ago

It is a truly ridiculous deadline :) I'll keep that in mind as a last resort

JAL · Accepted Answer · 2010-07-14 14:58:36Z

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.

answered Jul 14, 2010 at 14:58

JAL

21.6k1 gold badge50 silver badges67 bronze badges

2 Comments

bcoughlan Over a year ago

Good idea. The site I'm working on runs a pretty dreadful custom CMS. Is it possibly to generate the code with CakePHP and extract it somehow or does it have to be integrated with CakePHP?

JAL Over a year ago

I'd say anything you write with a framework will require the framework libraries to run... they're not meant to generate stand alone code. It might be possible, I guess... you could extract all the SQL and rewrite or something after you had it set up, but that sounds like more work. I'm not that familiar with Cake specifically. I'd imagine it wouldn't be too hard to integrate the Cake system with your current CMS.

fire · Accepted Answer · 2010-07-14 15:43:48Z

2

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

answered Jul 14, 2010 at 15:43

fire

21.5k18 gold badges82 silver badges116 bronze badges

Comments

Narcis Radu · Accepted Answer · 2010-07-14 15:29:37Z

1

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

answered Jul 14, 2010 at 15:29

Narcis Radu

2,54722 silver badges33 bronze badges

1 Comment

bcoughlan Over a year ago

That thing is really really awesome!

northpole · Accepted Answer · 2010-07-14 14:59:22Z

1

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.

answered Jul 14, 2010 at 14:59

northpole

10.3k7 gold badges38 silver badges60 bronze badges

Collectives™ on Stack Overflow

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

5 Answers 5

1 Comment

2 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

2 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related