PHP Classes

Access data base: Pre-written PHP MySQL functions class

Recommend this page to a friend!
  All requests RSS feed  >  Access data base  >  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  

Access data base

Edit

Picture of ajax by ajax - 9 years ago (2015-07-09)

Pre-written PHP MySQL functions class

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

+2

I would like a recommendation for a class with pre-written functions for accessing a MySQL database.

  • 1 Clarification request

  • 1. Picture of mryashpal by mryashpal - 8 years ago (2016-12-20) Reply

    l,

    Ask clarification

    4 Recommendations

    MySQL Class Generator: Generate classes to access MySQL as objects

    This package can automatically generate PHP classes from MySQL tables.

    It can access a given MySQL database and retrieve schema tables and fields.

    For each table, it generates a class that uses object-oriented programming logic to provide methods for accessing, reading, and writing its records.
    This recommendation solves the problem.
    This recommendation does not solve the problem.

    +1

    Picture of Saro Carvello by Saro Carvello package author package author Reputation 515 - 8 years ago (2017-02-08) Comment

    This package can generate classes to access MySQL as objects. It can access a given MySQL database, retrieve its schema of tables and fields, and generates classes to access the records of tables as objects. The generate classes have setter and getter functions for accessing record field values, as well functions to insert, update and delete table records.

    Database ORM Builder: Generate MySQL Object Relational Mapping classes

    This package can generate MySQL Object Relational Mapping classes.

    It can retrieve the list of tables and fields of a MySQL database and generates classes with functions for storing and retrieving objects in the given MySQL database tables.

    The generated code is stored in a file with the name based on the database name. For each table it generates a class for accessing fields, table data and execute SQL SELECT, INSERT, UPDATE and DELETE queries.
    This recommendation solves the problem.
    This recommendation does not solve the problem.

    +1

    Picture of Anthony Amolochitis by Anthony Amolochitis package author package author Reputation 505 - 8 years ago (2017-01-09) Comment

    This package will run a script on your database and build the basic select, update, insert, and delete methods for each table in the database. Also, a table getname method as well.

    In addition, field and data structures for the tables in the database are generated.

    Enjoy.

    Short Code CRUD: Perform CRUD operations on MySQL table records

    This class can perform CRUD operations on MySQL table records.

    It can perform several types of operations with records of a given MySQL table like:

    - InsertRecord : Insert Record to database
    - InsertMultipleRecord : Insert Multiple Records
    - GetSingleRecord : Retrieve Single Record for Edit or View Action
    - GetRecord: Get All or a limited number of Records with pagination
    - UpdateRecord : Edit or Update Record Method
    - DeleteRecord : Delete Record Method
    - GetCustom : For results for arbitrary queries

    The class can also generate HTML to display or update the table records like:

    - PagiNation : Pagination Display
    - UploadFile : Upload File
    - DeleteFile : Delete File
    - DateDifference : Date Difference
    - RedirectPage : To Redirect Specific Pages
    - EditLink : Edit Action Link
    - StatusLink : Change active or inactive status Action Link
    - DeleteLink : Delete Action Link
    - SendMail : Send Mail method
    - GetRandomString : Generate Random String
    This recommendation solves the problem.
    This recommendation does not solve the problem.

    +1

    Picture of Bharat Parmar by Bharat Parmar package author package author Reputation 455 - 9 years ago (2015-12-12) Comment

    This class has all the functions which can be used for the database iteration with very short and simple code.

    Database Manager: Connect and query several databases using PDO

    This package connect and Query several databases using PDO.

    There is a base class that can establish connections to different databases using PDO. Currently it supports MySQL, PostgreSQL, SQL Server and SQLite.

    The query sub-class extends the connection class can execute arbitrary queries and retrieve the results as an array or a string.
    This recommendation solves the problem.
    This recommendation does not solve the problem.

    +4

    Picture of Samuel Adeshina by Samuel Adeshina package author package author Reputation 1015 - 9 years ago (2015-07-10) Comment

    This class acts as wrapper for database objects using PDO. It can be used to query or retrieve information from a MySQL database or any other DB management system you could think of. It uses the PDO extension so you don't have to worry about query compatibility across db systems.

    Recommend package
    : 
    :