PHP Classes

Good and simple MySQL wrapper: What MySQL wrapper should I go with?

Recommend this page to a friend!
  All requests RSS feed  >  Good and simple MySQL wrapper  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

Good and simple MySQL wrapper

Edit

Picture of Y D by Y D - 9 years ago (2014-10-27)

What MySQL wrapper should I go with?

This request is clear and relevant.
This request is not clear or is not relevant.

+6

I'm looking for a good simple to use MySQL wrapper.

There are many here. From your experience what should I go with?

Ask clarification

5 Recommendations

MySQL Class Generator: Generate classes to access MySQL as objects

This recommendation solves the problem.
This recommendation does not solve the problem.

+3

Picture of Saro Carvello by Saro Carvello package author package author Reputation 430 - 7 years ago (2017-02-14) Comment

This package can automatically generate the classes source code for all database tables. It uses the mysqli object.

PDO4You: Access SQL databases using the PDO extension

This recommendation solves the problem.
This recommendation does not solve the problem.

+4

Picture of Giovanni Ramos by Giovanni Ramos package author package author Reputation 45 - 9 years ago (2014-10-28) Comment

Try this class which uses the power of the PDO, which offers support for MySQL and PostgreSQL, and most other popular dbs. It may be useful to you in terms of portability.

SlimDb: Access different database types using PDO

This recommendation solves the problem.
This recommendation does not solve the problem.

+3

Picture of marcelo entraigas by marcelo entraigas package author package author Reputation 40 - 9 years ago (2014-10-28) Comment

Hello, I wrote a a package with that in mind. Hope you find it useful.

PHP Mass Database Update: Update all MySQL database table records

This recommendation solves the problem.
This recommendation does not solve the problem.

+2

Picture of amani by amani package author package author Reputation 70 - 9 years ago (2014-10-28) Comment

This class can update all MySQL database table records.

It can retrieve the list of tables of a given MySQL database and generate a HTML form to let the user choose the tables and fields he wants to update.

The class takes the submitted form values and executes a SQL UPDATE query to change the table field specified by the user. With this class you can use a good interface to update and change table fields values very fast and easy via ajax. In this class you have some option to choose table records with theme value very simple.

Metabase: PHP Database abstraction layer RDBMS independent

This recommendation solves the problem.
This recommendation does not solve the problem.

+3

Picture of Manuel Lemos by Manuel Lemos package author package author Reputation 23770 - 9 years ago (2014-10-27) Comment

I have been using this package to access databases for many years.

It can work to access MySQL and other databases that you do not need, but provides also other interesting features.

For instance it can install the schema of the database tables from a file that describes the tables. Then if you need to change the tables, for instance adding, removing, renaming tables, fields or indexes, just change the definition of the schema in the same file and tell Metabase to upgrade your schema.

It is very safe, as it will tell you in advance if you want to perform a database schema change that is not supported, it will tell you in advance so it does not perform part of the changes and leave your database schema inconsistent.

Putting the database schema definition on a description file is also useful to keep your database changes under your GIT or other version control system that you use.

Recommend package
: 
: