适用于MySQL和PHP的CRUD [英] CRUD for MySQL and PHP

问题描述

我必须在MySQL数据库上使用PHP发出一些数据库请求.

I have to make some database requests with PHP on a MySQL database.

问题:什么是最好的(最简单的)框架来正确完成CRUD(创建读取更新删除)?

Question : What is the best (simpliest) framework to get thing done right CRUD (Create Read Update Delete)?

我还必须填充数据库，这是一个很好的工具.我所知道的唯一一个是SqlMyAdmin，看起来不太好.在线工具会很棒.

I also have to populate the database, what is a good tool to do that. The only one I know is SqlMyAdmin, wich does not look good. An online tool would be great.

您的经验很宝贵:告诉我您使用什么以及为什么使用?

Your experience is valuable: tell me what do you use and why ?

我看过CodeIgniter，看起来不错，您认为...过大了吗?

I have taken a look at CodeIgniter, looks nice, what do you think... overkill ?

推荐答案

对于许多操作(尤其是CRUD，一旦编写了模式文件，它们即开即用)，ORM框架

For lots of operations (especially CRUD, which work out of the box once you've written the schema files), the ORM Framework Doctrine is really great.

如果您不仅想访问数据库，还可以看看PHP框架 symfony symfony ，它提供了一个管理员生成器(甚至还有关于该用户的屏幕快照 ). (并且具有出色的文档，例如 jobeet教程) (顺便说一句，symfony使用Doctrine作为ORM ^^)

If you want to go farther than just DB access, you might take a look at the PHP FRamework symfony, which provides an admin generator (there is even a screencast about that one). (And has great documentation, such as the jobeet tutorial) (BTW, symfony uses Doctrine as ORM ^^ )

但是，如果您需要一些简单的东西，可能有点矫kill过正(并且学习曲线太大).

But maybe it's a bit overkill (and requires a too big learning curve) if you need something simple...

要将数据加载到MySQL， LOAD DATA INFILE ，(引自文档)以很高的速度将文本文件中的行读取到表中".

To load data to MySQL, what about LOAD DATA INFILE, which (quote from the docs) "reads rows from a text file into a table at a very high speed".

这篇关于适用于MySQL和PHP的CRUD的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！