-
1502 total visitsThe activity can optionally be logged to a class variable.Key Features of PDO wrapper singleton:- Setup database connections- Execute prepared queries- Retrieve result sets into arrays- Retrieve the last inserted identifier valueRequirements: PHP 5.0 or higher -
1704 total visitsManageSQL can send an e-mail notification to a specified address when ManageSQL encounters an error.Key Features of ManageSQL:- Connect to a given MySQL database server- Execute SQL queries- Retrieve the query result rows into objects or whole result sets into arrays- Retrieve the number of rows in a result set- Retrieve the last inserted identifierRequirements: PHP 4.0 or higherLimitations: The ...
-
1640 total visitsObject Manager serializes and unserializes objects to store and retrieve it in a given table. It can also query, update and delete an object given the identifier used to store it in the MySQL table.The tables necessary in order to store objects of different classes are also created.Requirements: PHP 5.0 or higher
-
1532 total visitsgsmysql can compose and execute several types of SQL queries to a MySQL database table given a list of parameters. Currently gsmysql can compose and execute SQL queries for SELECT, INSERT, UPDATE and DELETE.HTML form GET values can also be generated to insert or update the records of the specified MySQL database tables.Requirements: PHP 4.0 or higher
-
1929 total visitsConnection base de donnée avec PDO establishes a database connection to a MySQL database. It automatically sets the connection to use buffered queries. It can also execute SQL queries that are automatically encapsulated in transactions.Connection base de donnée avec PDO can execute SQL SELECT queries and return the results into a single array within the same call. It can also ...
-
2001 total visitsPDO Connection Factory can setup a PDO object to access a database of a given type, host and database name.The username, password and whether the connection will be persistent or not, need to be specified.Requirements: PHP 5.0 or highr
-
1637 total visitsMySQL DB Manager can establish a connection to a MySQL server. Several functions for executing different types of SQL queries, such as SELECT, UPDATE, INSERT and DELETE, are provided.There are also functions for traversing query result sets of SELECT queries or determining the number of affected rows for other types of SQL queries.
-
2040 total visitsA class handles the process of establishing a connection to the database and manages the transactions.Another class can execute SQL queries and retrieve the SELECT query results into array variables, and obtains the identifier of the last inserted row.Requirements: PHP 4.0 or higher
-
1443 total visitsThere is one class for establishing connections and executing SQL queries and another for composing and executing SELECT, INSERT, UPDATE and DELETE queries from a list of parameters.A wrapper class is provided in order to simplify the usage of the other two class.Requirements: PHP 5.0 or higher
-
1609 total visitsDG calls the sqlExec class to execute an SQL query that retrieves data from a given table. It displays the values of a given list of table fields in an HTML table.DG also displays links to navigate between the multiple pages on which the listing is split. The listing can be styled using CSS.Requirements: PHP 5.0 or higher
-
1645 total visitsPHPMafia SQL is a SQL database abstraction. It provides a common API to retrieve access SQL databases. Currently it supports MySQL and PostgreSQL.PHPMafia SQL also comes with a class that can generate XML documents from database query results.
-
2099 total visitsPDO_EXT provides one class that extends the PDO database access abstraction class to simplify the execution of SELECT, INSERT, UPDATE and DELETE queries. Another class can be used to execute an SQL query and generate an XML document from the results.Requirements: PHP 5.2 or higherLimitations: The code and comments are in Portuguese.
-
1798 total visitsSplit SQL Selected results can execute a given query and retrieve the results to display in the current page, given the limit number of results to display per page.The HTML code to display linked page numbers that allow browsing to different pages of the listing, can also be returned.Requirements: PHP 4.0 or higher
-
1729 total visitsThe configuration can be read from a file.
-
1903 total visitsRegin's Pager can execute a given SQL query limiting the range of rows that are retrieved according to the limit number of results to show page, total number of rows in the result set, and the number of the listing page that is being displayed.Links for navigating to the next, previous, first, last and middle pages, are displayed.Requirements: PHP 5.0 ...
