GUI的MySQL数据库前台[英] GUI MySQL database frontend

本文是小编为大家收集整理的关于GUI的MySQL数据库前台的处理/解决方法,可以参考本文帮助大家快速定位并解决问题,中文翻译不准确的可切换到English标签页查看源文。

问题描述

我有一个软件的绝望愿望清单,我不知道它是否存在.

它需要什么:

  • 可以自由使用(在小型企业中)
  • 使用MySQL数据库在PHP服务器上运行
  • 成为GUI数据库前端
  • 做更多的事情.特别是我需要能够创建自定义表单,并在一个操作中从多个表中插入和删除多个记录.这种过程构建是我正在寻找的主要标准.
  • 拥有一些Ajax支持,所以看起来不错
  • 处理所有登录
  • 不需要任何适当的编程.整个项目可以在浏览器中构建
  • 希望有一些高级功能,例如发送电子邮件,预定工作等.
  • 最终产品必须面向客户,因此它不可能是一个管理员工具,其中一个不知道自己在做什么的人可以破坏它
  • 如果您想要一杯咖啡.

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

推荐答案

好吧,我非常怀疑您是否会找到任何解决所有问题的解决方案,尤其是如果您希望所有这些都可以免费.但是我会指向您 phpmyadmin .

如果您还没有遇到它,它是MySQL数据库的基于Web的前端(在PHP服务器上运行).它易于部署并可以维护多个用户登录.在Ajax部门不太强大,我从未听说过类似的工作或电子邮件,但是这些事情都可以以不同的方式完成.

将phpmyadmin视为网络上的数据库编辑器,这不会是您要移交给客户的东西.

其他推荐答案

对OP,这符合您几乎所有的要求,包括Ajax,客户面对面,基于Web的构建,无需适当的编码等...一次性仅$ 48,这不是一个破坏者:

php mysql形式制造商 http://mysqlreports.com/

其他推荐答案

有一个较新的工具,可满足您的许多需求.您可以在此处查看:

eliacom增强SQL Portal(ESP)

还有一个演示,您可以在此处登录任何数据库服务器(请注意,要使用它,它将在数据库中安装一些额外的表,以保留您在前端设置的格式信息):

这是您的标准分解的方式:

  • 它是免费的
  • 它是GUI 它基本上与内联编辑一样易于使用.在树木,布局和重命名列中组织桌子,全部来自GUI.
  • 它做得更多,这可能是最强的观点.您几乎可以创建任何东西.对于真正花哨的东西,您需要了解一些HTML.您绝对可以很容易地删除多个记录.插入多个记录可以通过过去的功能(或上传)完成.
  • 它完全是Ajax,看起来很现代
  • 它处理登录和会话处理(它也锁定了一段时间的会话)一个实例您可以登录任何服务器(当然您可以访问).
  • 您不需要任何编程.如果您想制作非常活泼的表格,则需要知道一些HTML(即使没有该表格看起来也很好).
  • 它是完全基于网络的,并通过浏览器控制
  • 基本系统没有时间表/电子邮件,但是您可以购买具有工作/电子邮件时间表等的附加组件.为你.只是不在一般版本中.在一般版本中,如果您知道一点PHP,则可以在修改表格并执行发送电子邮件之类的事情时添加侦听器(您可以从前端添加这些).
  • 基本产品是用于数据库管理的,但是有一些可供购买的附加产品.他们有一个可购买的应用程序,可以使您能够控制其他用户(有很多他们可以/不能做的权限设置,因此他们不能破坏东西).他们还拥有一个发布者应用程序,您可以创建一个链接,该链接将允许将表单/表发布到Open Internet(用于公共数据查看/输入).
  • 咖啡... 他们收到用户的请求,因此,如果您有功能请求,则可以与他们联系.

本文地址:https://www.itbaoku.cn/post/597545.html

问题描述

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?

推荐答案

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.

其他推荐答案

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/

其他推荐答案

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

Eliacom Enhanced SQL Portal (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

Here's how it breaks down with your criteria:

  • It's free
  • It's written in PHP To run on a php server with a MySql database
  • It is a GUI It'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 CRUD This 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.