-
1654 total visitsClean URL is a class that implements a method to make URLs more user and search engine friendly by removing '?' and '=' symbols from URL.This class is meant to be used in conjunction with URL rewriting Web server modules that map the cleaned URLs generated by this class into common URLs with query parameters. -
1853 total visitsReport in Table is meant to generate HTML reports using tables to present MySQL database query results.It can generate an HTML report table given an SQL statement to execute, a list of query columns to display and an optional URL format to generate automatic links to an eventual detail page of each table report row.The presentation of the report table ...
-
1746 total visitsDB Web Service provides a remote interface to access a database via a Web service using the SOAP protocol.The Web service interface provides functions for retrieving, updating and deleting database data. It comes with an implementation example to access a MySQL database.
-
1527 total visitscomboBoxList builds an HTML form combo box field from values taken from a MySQL database query results. It supports specifying the initial selected value.
-
1364 total visitsDatabase access class is a class for interchanging data between databases and forms.Features of Database access class:- Inserting a new row into a database table with data from forms.- Loading form fields from database table row.- Updating database table rows from form fields.- Deleting database table rows with criteria defined by values from form field.- Building list in an array ...
-
1515 total visitsAmazonAPI can send query to Amazon Web service and returns XML.
-
1837 total visitsAnonORM can be used to retrieve and store objects in SQL database tables. It works by performing what is called object-relational mapping (ORM). This package can create generic objects which can be accessed and changed like any other Plain Old PHP Object (POPO).AnonORM loads an object by executing an SQL query that returns the values of the object variables. An ...
-
2197 total visitsADODB SQL 2 Excel can be used to generate Excel files in the XLS format from database query results.This is an altered version of of the SQL 2 Excel class that uses ADODB API instead of MySQL. It extends the GeraExcel class to generate Excel files from the results of execution of an SQL query.ADODB SQL 2 Excel takes an ...
-
1724 total visitsResult set page navigator is meant to generate navigation HTML links to browse database query results split between multiple pages.Result set page navigator generates Next, Previous, Start, End and direct page jump link from a given total number of result rows and limit number of results per page parameter. The links may include given icon images. It also generate a ...
-
1725 total visitsPaginator is a class that can help you to split MySQL database query result sets in pages. Paginator will return a number that can be used to set your start result row and a number to use as an offset.The class methods return values that you can use to create your navigation links.The values Paginator presently returns are:- First of ...
-
1097 total visitsMySQL Paging is a simple class that can return a MySQL database query results for spliting into multiple pages given the maximum number of result rows to present on each page.Usage :- Create a class object with 3 arguments: MySQL SQL query, limit of records per page, MySQL connection handle- Output the page numbers as links- Retriev the MySQL Query ...
-
2147 total visitsThis tool consists of two files, one to execute queries submitted by form or uploaded as a file and display the results, and another to dump the database in MySQL or MSSQL format. GreenLight SQLTool can be used with either MySQL or MSSQL databases. Together they can be used to migrate a database (or at least the table structures and ...
-
1845 total visitsSimple Power SQLite class is a simple class written in PHP, useful for standard operation with SQLite: database creation, connection, submit query, simple transaction mechanism, decode encode binary file, extend SQLite function, alter table.Simple Power SQLite can be integrated in any type of PHP project.
-
1982 total visitsRDQL is a language similar to SQL for querying RDF documents. This class implements a generic RDQL engine and a RDQL engine to query RDF documents from URLs or files in the l ocal file system. Almost all the good capabilities of RDQL are implemented in this class.
-
1411 total visitsAs part of the DataMan series, The Query Manager allows you to construct and test your sql queries. If you a happy with the result, you can store the query for later use. A useful tool to create and manager reports.
