GUI MySQL database frontend [closed]

Question

I have a slightly hopeless wish list for a piece of software, and I don't know if it exists.

What it needs:

• To be free to use (in a small business)
• To run on a php server with a MySql database
• To be a GUI database front end
• To do more that CRUD. In particular I need to be able to create custom forms, and insert and delete multiple records from multiple tables in one action. This sort of process building is the main criteria I am looking for.
• To have some ajax support so it looks good
• To deal with all the logins automatically
• To not require any proper programming. The whole project can be built in the browser
• Hopefully have some advanced features like sending email, scheduled jobs, etc.
• The end product has to be client-facing, so it can't be an administrator tool where someone who doesn't know what they are doing can break it
• To make you a cup of coffee if you want one.

Can you tell me if it does exist?

Answer 1

Well I highly doubt you are going to find any solution that does ALL of what you are asking, especially if you want it all to be free. But I will point you to phpMyAdmin.

If you haven't come across it yet, it is a web-based front end for a MySQL database (runs on a php server). It is easy to deploy and can maintain multiple user logins. It's not too strong in the ajax department and I've never heard of anything like scheduled jobs or email for it but that stuff can all be done in different ways.

Think of phpMyAdmin as a database editor on the web, it's not going to be something you're going to want to hand over to clients to mess around with though.

Answer 2

To the OP, this meets almost all of your requirements, including Ajax, Client facing, web based build, no proper coding required, etc... except it does not make coffee, and is not free, but at only $48 one-time, it's not a deal breaker:

PHP MYSQL Form Maker http://mysqlreports.com/