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.-
1535 total visitsThe mysqlQueryContainer-class makes it possible to create several MySQL connections to different hosts and Databases on one Object.This makes it possible to work with several databases in your script in an easy way. The code code is well documented (phpDoc compatible). -
1664 total visitsDisplay a list of 'days until' a set of events, includes a simple example and a more complex one as child classes. Could easily be extended to multi-user and notifications via email by adding a user table and owner columns. Written to MySQL but db access is simple enough to adapt.
-
1616 total visitsPGSQL_Login is a PHP/PostgreSQL 'Login' class, to control users sessions.
-
1410 total visitsMiester Search class indexes multiple tables, builds dictionaries, creates btree indexes, and creates sql queries based on user input.
-
1935 total visitsXML2DB can generate SQL queries to import data from XML files into an SQL database table.XML2DB uses the Simple XML extension of PHP 5 to parse XML files from which the data is extracted according to mappings that define which tag data and attributes are used to create the resulting SQL INSERT statements.
-
1491 total visitsKwIndex is a PHP library to do full text indexing with MySQL.
-
2197 total visitsThis class is meant to ease the generation of database queries by composing the SQL statements based on parameters passed dynamically to the class functions.SQL Query can generate SELECT, INSERT, UPDATE and DELETE SQL statements. It has functions to specify the columns involved in the queries, the column values and the conditions that will determine which database table rows will ...
-
2149 total visitsDDcomboBox is a simple PHP component that populates a listbox with data from a recordset created from a PostgresSQL database query.
-
1977 total visitsActiveDBLib is a PHP class to access MySQL or optionally other databases by using various Database Abstraction Libraries. Its primary intention is to hide the differences between the different database abstraction Libraries and to provide standard methods for the database connection, query and result operations.ActiveDBLib currently supports the ADODB, the PEAR:DB and the Metabase libraries. The only requirement to use ...
-
1847 total visitsDbQueryManager is a simple MySQL database access wrapper class. It executes SQL queries and lets the result records records be fetched iteratively with a call to the movenext function.DbQueryManager manages the opening and closing of database connection transparently when needed.After executing a query it may also retrieve the number of affected rows or the id of a auto-incremented row when ...
-
1806 total visitsSQL wrapper is a simple MySQL database access wrapper class. It provides functions to connect to a given MySQL database, execute a SQL query, retrieve the query result data and number of rows.
-
1733 total visitsTQuery is abstract database access layer for Oracle or other databases.
-
1190 total visitsOdbcSearch is an ODBC-Database search-engine for searching an ODBC interfaced database.
-
2062 total visitsPhpReportsMSSQL can generate report HTML pages from given SQL database queries. It supports either MySQL and Microsoft SQL server databases.PhpReportsMSSQL takes as parameters the database type, the database access arguments, an SQL query strings, the title of the report page, number of records to show in a page. It executes the SQL query and display the results in an HTML ...
-
2049 total visitsmysql_query class allows you to generate INSERT-, UPDATE- and DELETE-queries easily, taking a tablename and conditional statement as input.mysql_query can also translate any SELECT-statement into another query. Makes it a bit easier if you have a lot of user-editable tables in your dbase.
