-
451 total visitsNbrecs class can be used to extract and list MySQL database table information. It can query a given MySQL database to extract table status information. The script can generate an HTML table on which it displays the retrieved table status information like the table names, number of records, next increment, sizes, comment and last modified. Requirements: PHP 4.0 or higher -
443 total visitsThis script can be used to display data from MySQL, objects or arrays in HTML tables. It can generate an HTML table with cells that contain data retrieved from MySQL query result rows, arrays or objects. Objects and arrays can be traversed recursively if they contain array values. Requirement: PHP 5.0 or Higher -
436 total visitsThis class can be used to MySQL database access wrapper. It can establish connections to a MySQL, execute SQL queries, retrieve query results, retrieve the last inserted identifier, the number affected rows, retrieve the tables list and table fields and execute INSERT, UPDATE, DELETE queries from lists of parameters. Requirement: PHP 5.0 or Higher
-
419 total visitsThis class can be used to execute MySQL queries read from files. It can open a given text file and read its lines with SQL statements to be executed. Requirement: PHP5.0 or Higher
-
421 total visitsThis class can be used to compose queries to XML RDF documents using SPARQL. It can compose and generate queries for sending to a SPARQL end point that can extract semantic information from RDF documents. Requirement: PHP 5.0 or higher -
231 total visitsThis class can be used to generate XML documents from MySQL query results.It can perform MySQL SELECT queries and extract the results to generate the values of tags and values to be added to a XML document.The same XML document may include results of multiple queries. -
322 total visitsLight Query Business UnitPerforms SQL and PHP business units, all together, designed to avoid large DAOs, to increase preformance, better visibility and clarity, and improvement of development time.The unit files may also contain PHP or SQL actions to execute PRE-QUERY, POST-QUERY and POST-RECORD, and PHP or SQL actions for successfull or unsuccessfull queries.- Format pre-query variables, as conditions, limit, decoding, ... -
1709 total visitsMySQL cache class can be used to cache MySQL query results in session variables. MySQL cache script used in PHP, it is a professional PHP cache script. It can perform a given SELECT SQL query and store the result in a session variable. Next time the same query is executed it can retrieve the results from the session variable if ...
-
1917 total visitsEntire Class/Functions is a connection to a MySQL server can be established and SQL queries can be executed.Here are some key features of Entire Class/Functions:- Retrieve query results into single value variables or arrays- Execute queries to retrieve and display paginated listingsRequirements: PHP 3.0 or higher
-
1703 total visitsSort Order Class is written with the hope that it will be of use to someone, and comes "as is" without warranty of any kind. I (Serge Stepanov) do no warrant or guarantee that the code will work under any circumstances besides my own. Any damage caused by the use of this script are not the fault of the author. ...
-
1987 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.
-
1658 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 ...
-
1536 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.
-
2175 total visitsTNavigator is the view result set from queries and navigate through the result pages.
-
1742 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, ...
