Save Query Results

This script can be used to split MySQL query results displayed in pages retrieved using AJAX.It takes a MySQL query and computes the total number of rows it returns to generate HTML links in order to browse different pages of the query results.Each page displays up to a given limit number of... Platforms: PHP

Statistics about the connection and variable values can also be gathered by Best MySQL Class.Key Features of Best MySQL Class:- Connect to a given MySQL server and access given database- Execute SQL queries- Retrieve any errors, the number of affected rows, last inserted identifier, number of... Platforms: PHP

Report generating and drawing can compose the definition of report tables that display data retrieved from given SQL query results.The report table definitions include the SQL query, query result grouping fields, result columns to be used as report fields, callback functions to format field... Platforms: PHP

KG MySQL Class can connect to a specified MySQL server and select the database to access.Key Features of KG MySQL Class:- Execute SQL queries eventually returning the last inserted record identifier- Retrieve query results into objects or whole result sets into array Platforms: PHP

Data Grid Object can be used to display MySQL query results in HTML tables. It is based on another class originally written by Carlos Miguel Guevara.This version includes several enhancements:- The code no longer issues warnings with E_STRICT error reporting enabled- Produces XHTML compliant... Platforms: PHP

Connection PDO Class is a simple wrapper class that can be used to access SQL databases using the PDO API.It can establish connections, execute direct or prepared SQL queries, retrieve the all query results into a single array, begin, commit and rollback transactions. Platforms: PHP

show page is meant to be used to do pagination of information, like for instance database query results. Platforms: PHP

SDB simple MySQL script implements a wrapper to access MySQL databases. This script allows easy data control from PHP to MySQL.Here are some key features of "SDB simple MySQL class":- Create tables- Lock tables- Optimize all database tables- Truncate tables- Establish database connections-... Platforms: PHP

Reduced MySQLi is composed by two classes:- one class is handling the MySQL database access and makes sure that only one connection is active during the script execution.- Another class implements other database access functions like executing queries with prepared queries, measuring the time the... Platforms: PHP

mysql_driver aims at simplifying the execution of common types of SQL queries and database access tasks.Key Features of mysql_driver:- Establish connections to a MySQL database server- Setup transactions- Executing SQL queries checking first if the database connection is still valid- Retrieve... Platforms: PHP

Paging Class with AJAX or HREF can be used to browse database query results split between pages using AJAX to switch between the listing without page reloading. It can execute an SQL query using the PEAR DB API and return records to be displayed in the page.Paging Class with AJAX or HREF also... Platforms: PHP

13 in a dozen db class can be used to access MySQL database servers and display query results in HTML tables.13 in a dozen db class can establish database connections to a given MySQL host, retrieve server database information, execute SQL queries, retrieve the inserted identifier by the last... Platforms: PHP

TPaginatedData can be used to generate listings split in multiple pages of data from MySQL database query results. It takes a query string and determines the number of result rows to calculates the total number of pages.Then TPaginatedData can execute the query to to get the data for the current... Platforms: PHP

Fox filter is meant to filter redundant MySQL database query results that be returned when querying three tables that establish many-to-many relationships.The class' function named out_put returns an associative a two dimenstional array of records. It may either return a list of the filtered... Platforms: PHP

Simple Paging can be used to show navigation links to browse MySQL SELECT query results split in multiple pages. It can calculate the total number of pages to display the results of a given MySQL select query.Simple Paging generates a navigation bar made of HTML links to go to the next, the... Platforms: PHP

MsSQL Database Functions is a wrapper class to access Microsoft SQL server databases.It can establish database connections, execute SQL queries, retrieve the number of result set rows, retrieve SELECT query results into arrays, prepare and execute stored procedures. Platforms: PHP

This is a PHP script that returns database query results inside an HTML table. Currently it supports MySQL only, but can easily be modified for other data sources and even for PHP 4 (PHP 5 is supported by default).Option names are not case sensitive.Some option names have aliases/shortcuts, as... Platforms: PHP

rsmysql is a simple MySQL database access wrapper class that can measure the time spent executing the database queries.rsmysql can establish persistent and non-persistent connection to a given MySQL database server, execute SQL queries and return the query results in arrays.The total number of... Platforms: PHP

Get available SQL Servers Get/Set default data or log file locations Get server version and attributes Get database file sizes Get query results using a T-SQL script in a file Get available SQL Servers Get/Set default data or log file locations Get available SQL Servers Get/Set default data or... Platforms: Windows, Windows 8, Windows 7

A MySQL query gets executed and the results are extracted into a single array.Query To JSON calls the PHP function json_encode to return a string with the whole result set data in the JSON format. Platforms: PHP