php GUI MySQL 数据库前端

GUI MySQL database frontend

提问by user170

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.

• 免费使用（在小型企业中）
• 在带有 MySql 数据库的 php 服务器上运行
• 做一个GUI数据库前端
• 做更多的 CRUD。特别是我需要能够创建自定义表单，并在一个操作中从多个表中插入和删除多条记录。这种流程构建是我正在寻找的主要标准。
• 有一些ajax支持所以它看起来不错
• 自动处理所有登录
• 不需要任何适当的编程。整个项目可以在浏览器中构建
• 希望有一些高级功能，如发送电子邮件、预定作业等。
• 最终产品必须面向客户，所以它不能是一个管理员工具，不知道自己在做什么的人可以破坏它
• 如果你想要一杯咖啡，给你一杯咖啡。

Can you tell me if it does exist?

你能告诉我它是否存在吗？

回答by Matt Dodge

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.

好吧，我非常怀疑您是否会找到任何解决方案来满足您的所有要求，尤其是如果您希望一切都是免费的。但我会指向你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.

如果您还没有遇到过它，它是一个基于 Web 的 MySQL 数据库前端（在 php 服务器上运行）。易于部署，可以维护多个用户登录。它在 ajax 部门并不是很强大，我从来没有听说过像预定的工作或电子邮件之类的东西，但这些东西都可以用不同的方式完成。

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.

将 phpMyAdmin 视为网络上的数据库编辑器，但它不会是您想要交给客户处理的东西。

回答by ubersimple.brad

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:

对于 OP 来说，这几乎可以满足您的所有要求，包括 Ajax、面向客户端、基于 Web 的构建、不需要正确的编码等……除了它不煮咖啡，而且不是免费的，但一次性只需 48 美元，这不是交易破坏者：

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

PHP MYSQL 表单制作工具 http://mysqlreports.com/

回答by juacala

There's a newer tool that fits a lot of your needs. You can check it out here:

有一个更新的工具可以满足您的很多需求。你可以在这里查看：

Eliacom Enhanced SQL Portal (ESP)

Eliacom 增强型 SQL 门户 (ESP)

There is also a demo that you can use to login to any database server here (note that to use it, it will install a few extra tables into your database to hold formatting information that you set in the front end):

这里还有一个演示，您可以使用它来登录任何数据库服务器（请注意，要使用它，它会在您的数据库中安装一些额外的表来保存您在前端设置的格式信息）：

Eliacom ESP Demo

Eliacom ESP 演示

Here's how it breaks down with your criteria:

以下是它如何分解您的标准：

• It's free
• It's written in PHPTo run on a php server with a MySql database
• It is a GUIIt's basically as easy to use as Excel for inline editing. Organize your tables in trees, layout and rename columns, all from the GUI.
• It does more that CRUDThis probably its strongest point. You can create pretty much anything. For really fancy stuff you need to know a little HTML. You can definitely delete multiple records very easily. Inserting multiple records can be done via a past function (or upload).
• It's completely ajax and it looks pretty modern
• It deals with logging in and session handling (it locks sessions after a while too)With a single instance you can log into any server (that you have access to of course).
• You don't need any programming.If you want to make very snappy forms, you need to know some HTML (the forms look pretty good even without that).
• It's completely web-based and controlled via a browser
• The base system doesn't have scheduling/email, but you can purchase an add-on that has scheduling of jobs/emailing, etc.I believe they already have this if they are hosting it for you. Just not in the general release. In the general release, if you know a little PHP, you can add listeners to when tables are modified and do things like send emails (you add these from the front end).
• The base product is meant for database administration, but there are add-ons for purchase.They have an app for purchase that gives you the ability to give control to other users (with a lot of permission settings of what they can/can't do so they can't break stuff). They also have a Publisher app that you can create a link that will allow forms/tables to be published to the open internet (for public data viewing/entering).
• Coffee...They take requests from users, so if you have a feature request, you can contact them.

• 免费
• 它是用 PHP 编写的，在带有 MySql 数据库的 php 服务器上运行
• 它是一个图形用户界面它基本上和 Excel 一样容易用于内联编辑。以树的形式组织表格、布局和重命名列，所有这些都来自 GUI。
• 它比 CRUD 做得更多这可能是它的最强点。你几乎可以创造任何东西。对于真正花哨的东西，您需要了解一点 HTML。您绝对可以非常轻松地删除多个记录。插入多条记录可以通过过去的功能（或上传）来完成。
• 它完全是ajax，看起来很现代
• 它处理登录和会话处理（它也会在一段时间后锁定会话）使用单个实例，您可以登录到任何服务器（当然您可以访问）。
• 你不需要任何编程。如果您想制作非常活泼的表单，您需要了解一些 HTML（即使没有这些表单看起来也不错）。
• 它完全基于网络并通过浏览器控制
• 基本系统没有日程安排/电子邮件，但您可以购买具有作业/电子邮件等日程安排的附加组件。如果他们为您托管，我相信他们已经拥有了。只是不在一般版本中。在一般版本中，如果您了解一点 PHP，您可以在修改表时添加侦听器并执行诸如发送电子邮件之类的操作（您从前端添加这些）。
• 基本产品用于数据库管理，但有附加组件可供购买。他们有一个可供购买的应用程序，使您能够将控制权交给其他用户（有很多权限设置他们可以/不能做什么，因此他们不能破坏东西）。他们还有一个发布者应用程序，您可以创建一个链接，允许将表单/表格发布到开放的互联网（用于公共数据查看/输入）。
• 咖啡......他们接受用户的请求，所以如果你有功能请求，你可以联系他们。

回答by RolandoMySQLDBA

Believe it or not, although the products went EOL December 18, 2009, the last versions of MySQL Query Browser and MySQL Administrator are still available for download totally for free.

信不信由你，虽然产品已于 2009 年 12 月 18 日停产，但 MySQL Query Browser 和 MySQL Administrator 的最新版本仍然可以完全免费下载。

Hey, I still use them today.

嘿，我今天还在用它们。

It only fulfills a few needs

它只能满足一些需求

• To be free to use (in a small business)
• To be a GUI database front end
• To deal with all the logins automatically (sort of)

• 免费使用（在小型企业中）
• 做一个GUI数据库前端
• 自动处理所有登录（有点）

Click here and get it while Oracle isn't looking ... QUICK !!!

在 Oracle 不查找时单击此处获取它... 快！！！

回答by Pandya

What about MySQL Workbench? It is provided under GPLLicense

MySQL 工作台怎么样？它是在GPL许可下提供的

MySQL Workbench provides DBAs and developers an integrated tools environment for:

• Database Design & Modeling
• SQL Development
• Database Administration
• Database Migration

MySQL Workbench 为 DBA 和开发人员提供了一个集成工具环境，用于：

• 数据库设计与建模
• SQL开发
• 数据库管理
• 数据库迁移

It is directly available for Windows, Linux(Ubuntu, Rad Hat Enterprise, Fedora) & OS X from Downloadpage! (Source Code also).

它可从下载页面直接用于 Windows、Linux（Ubuntu、Rad Hat Enterprise、Fedora）和 OS X ！（还有源代码）。

回答by hktang

Would VFront worth a mention? I haven't used it myself but was looking for similar solutions:

VFront 值得一提吗？我自己没有使用过，但正在寻找类似的解决方案：

http://www.vfront.org/

http://www.vfront.org/

Here's an excerpt from its website:

这是其网站的摘录：

• VFront is useful for companies,brands or organizations, which use MySQL or PostgreSQL, in need of an easy consulting or modyfing access to database by their own employed whithout developing a specific client for that but simply using a web browser.
• Think about VFront as an interface tool for database, similar for some functions to MS access, but taking the lead with an easy access via web.VFront is not a database administration tool like phpMyAdmin and it's not replacing it : interface is for basic user working on data.
• VFront is created for non-expert users capable to work safely on data using an intuitive graphic interface.
• VFront is particularly useful when various and/or several users have to access to database using different privileges: a highly customizable system of groups and privileges makes access possible for various employed to specific tables or views, shows/hides specific fields, sets rules for input validation and keeps under control all the database activities.
• VFront has export data modules, statistics and report management based on xml, xsl and xsl-fo protocols.
• VFront can be useful too for those who, generically, are in need of an easy to install and configure database front-end.

• VFront 对于使用 MySQL 或 PostgreSQL 的公司、品牌或组织非常有用，他们需要自己的雇员轻松咨询或修改对数据库的访问，而无需为此开发特定客户端，而只需使用 Web 浏览器。
• 将 VFront 视为数据库的接口工具，在某些功能上类似于 MS 访问，但通过 web 轻松访问处于领先地位。VFront 不是像 phpMyAdmin 那样的数据库管理工具，它不会取代它：接口用于基本用户工作数据上。
• VFront 是为能够使用直观图形界面安全处理数据的非专家用户创建的。
• 当各种和/或多个用户必须使用不同的权限访问数据库时，VFront 尤其有用：高度可定制的组和权限系统使各种用户可以访问特定表或视图、显示/隐藏特定字段、设置输入规则验证并控制所有数据库活动。
• VFront 具有基于xml、xsl 和xsl-fo 协议的导出数据模块、统计和报表管理。
• VFront 对于那些通常需要易于安装和配置数据库前端的人来说也很有用。