PHP Database Tool
Free and open source PHP Database Tools Scripts. These Scripts included MySQL, Oracal, Access help you to make a simplified operation on database.-
1568 total visitsThe DBI class is MySQL database access wrapper. DBI class can establish database connections, execute SQL queries, retrieve the query result set data, present SELECT query information details like the time it took to execute and the returned result rows. The comments in the code are in Spanish. -
1920 total visitsBase For PostgreSQL is a base class that can be used to wrap the access to records of tables in PostgreSQL databases. The script can query the information about the fields of a given table to be able to store and retrieve the values of the fields of the table records. Base For PostgreSQL can create new records from scratch ...
-
1991 total visitsUtilsClass for phpLib, provide 4 methods to select, insert, update and delete data from database. UtilsClass is really a simple work, but it was helpful to me, so I thought to make it available. Requirement:phpLib properly installed.
-
1685 total visitsEasySQL classes provides the same interface to compose and execute SQL queries to access several types of SQL databases: MySQL, PostgreSQL and SQLite. The script provides simple methods that will help to compose and execute SQL queries of the types: SELECT, INSERT, UPDATE, DELETE and TRUNCATE. EasySQL classes can be easily extended to implement the same interface to access other ...
-
1542 total visitsDatabase Connection is a very simple MySQL database access wrapper. The script can establish persistent and non-persistent connections, set the current database, execute an SQL query and return its result set resource handle, free the result set and close the connection. Database Connection also allows persistent setting, and saving of the result resource.
-
1718 total visitsThe FiForms PHP Classes is an application development framework for building Web-database applications in XML, powered by MySQL and PHP. AJAX-enhanced forms, sub-forms, custom reports, and dynamically generated menus create a seamless user experience. The FiForms Framework lets you rapidly prototype and develop a Web/database front end using the latest PHP and XML technologies. It currently includes data-entry classes and ...
-
1567 total visitsMySQL Model can be used as a wrapper to provide an object oriented access to MySQL database table rows. It retrieves table metadata to determine the names and other properties of table columns to map them to object properties. The script MySQL Model provides mechanisms for finding, creating, modifying and removing table records. Additionally, it allows for lazy joins of ...
-
1537 total visitsSQLm is meant to process and execute SQL queries to PostgreSQL databases using template files to define the SQL statements and the Smarty engine to process the SQL templates and assign the query parameter values. The class SQLm includes means to profile the queries that are executed keeping track of the time that they take. It may also highlight the ...
-
1970 total visitsThe class Visitation Model ADOdb can be used to manipulate and browse database table records structured as an hierarchy tree. Visitation Model ADOdb is based on another class originally developed by Khaled Al-Shamaa. It uses the ADOdb API instead of MySQL API.
-
1756 total visitsData Objects can provide an interface to access data in tables rows using objects of the class. It can access any database table without previous knowledge of the table structure. It determines automatically the fields and the primary keys. It can work with tables with one or more primary key fields. The class Data Objects provides functions for searching, inserting, ...
-
1967 total visitsSQL Revealer is a simple class for show all the data content stored in a MySQL database for when it is not possible to use a more powerful tool for this purpose like phpmyadmin or a similar application. SQL Revealer retrieves all tables of a given MySQL database and outputs the data from each database table using HTML tables with ...
-
1667 total visitsBaseDB is the excellent oo base class for mysql interaction. worth looking at. You must use this as a base class and extend your classes which map to a table name. Your tables must have a 'id', 'created' and 'modified' field to work properly and the class takes care of the rest. check it out.
-
1564 total visitsDAO classes is a SQL database access wrapper. It can establish database connections to one of several possible database server slaves. The class DAO classes can execute queries immediately or store the SQL statements in a queue file execute the queries all at once some time later. It also supports managing transactions and retrieving result sets all at once into ...
-
2101 total visitsDatamodul is a MySQL database access wrapper with metadata retrieval functions. THe script can establish MySQL database server connections, execute SQL queries, iterate over query results and retrieve its data as arrays. The class Datamodul can also retrieve metadata like the database table names and the respective fields.
-
1527 total visitsiOracleDriver is an Oracle database access wrapper. iOracleDriver comes with a class for managing Oracle database connections and execute SQL queries, and another class for retrieving query result sets.
