Quick and dirty way to make forms for editing fields in MySQL databases
I have a seriously ridiculous deadline to me开发者_C百科et 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?
If the deadline is seriously ridiculous then phpmyadmin with a bit of explanation to the client.
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.
Check out DBKiss it's one PHP file you can just upload.
I may suggest http://www.ajaxcrud.com/ if you really want to have something inside your application.
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.
精彩评论