Access Table Query

MySQL Object provides a few classes that execute several types of queries and extend the ArrayObject class to access the query results as if that was an array.Additional classes are used to traverse generic query result rows, traverse query result row columns, traverse the query result columns...

Pagination class takes as parameters the names of MySQL table, query fields, the first result row to display, the number of rows to display per page, and the base URL of the navigation link.HTML links that allow navigating forward and backward between listing pages, are generated.

Database Copier can access a MySQL server, list its tables, query the table record data, connect to another MySQL server and recreate the database tables with data copied from the first database.If there are destination tables with the same name, the class can drop them.


Platforms: PHP

Smart Table Editor is a powerful database editor for free designed to work in asp.net with IIS. Supports Microsoft Access 2003/2007 and Microsoft SQL Server databases. Allows you to view all the tables in any database and lets you edit, delete, insert new record by handling the validation of...


Platforms: Windows

This class Small MySQL Connection is a very simple wrapper to access a MySQL database.Functions of Small MySQL Connection:- Establish database connections- Execute manipulation queries and return the number of affected table rows- Execute an SQL SELECT queries and return the result set data in a...


Platforms: PHP

DBIx::XHTML_Table is Perl module for SQL query result set to XML-based HTML table. SYNOPSIS use DBIx::XHTML_Table; # database credentials - fill in the blanks my ($data_source,$usr,$pass) = (); my $table = DBIx::XHTML_Table->new($data_source,$usr,$pass); $table->exec_query(" select...


Platforms: *nix

Require Access to Excel sheet converter program which is easily migrate every records from MS Access to Excel Speradsheet? Get PDS Microsoft Access to Excel converter software and performing the best Access to Excel export opertion. PDS Access to Excel Spreadsheet conversion tool effectively...


Platforms: Windows

This class can be used to connect and query Microsoft Access databases from PHP. It takes the path of a Microsoft Access database file and computes suitable a DSN string to establish a connection to the database using ODBC extension on Windows.It can also execute a given SQL query on a connected...


Platforms: PHP

QDataObject can take a MySQL query result set resource handle as parameter and provides several types of functions to access the data from the result set.The script provides check or retrieve the result set data positions, as well retrieve the type and length of the respective columns.The regular...


Platforms: PHP

Tabela script can be used to show MySQL query results in an HTML table. It can build an SQL query from a list of table fields and executes it.The script creates an HTML table to display the database query results. It also displays links to browse results split in multiple pages, showing up to a...


Platforms: PHP

Simple Data Grid can be used to display MySQL database query result data in an HTML table grid.There are classes to define details of the headers and body of table grid. There is also a class for executing MySQL database queries and return the results in a bi-dimensional array.The data grid...


Platforms: PHP

Navicat Lite is an ideal solution for MySQL, SQLite, SQL Server, Oracle and PostgreSQL administration and development. This is an all-inclusive database front end provides a powerful graphical interface for databases management and maintenance. Easy installation and intuitive interface make it an...


Platforms: Windows

SQLeo is a free open source SQL Graphical Query builder based on SQLeonardo.2009.03.rc1, that permits to create complex sql queries easily as Access (Microsoft query) do. This GUI with multi connections, supports virtually all JDBC drivers, including ODBC bridge, has been mainly tested with...


Platforms: Windows, Mac, Linux

CGI::Application::Plugin::Authorization is an authorization framework for CGI::Application. SYNOPSIS use base qw(CGI::Application); use CGI::Application::Plugin::Authentication; use CGI::Application::Plugin::Authorization; # default config for runmode authorization...


Platforms: *nix

picoSQL project is the first Italian Open Source relational database management system. The project of picoSQL was born in 1995. It was an ODBC driver for COBOL indexed files. It consisted of a DLL written in C++ on Windows 3.1 operating system. In the beginning the main effort was made in...


Platforms: *nix

It can establish a connection to a MySQL database server host, execute SQL queries and retrieve the results into arrays. The identifier of the last inserted record can also be retrieved, and whether a given table exists can be checked. Requirements: - PHP 4 or higher


Platforms: Windows, Mac, *nix, PHP, BSD Solaris

DBLX is built and developed as and accessible and complete XML-based relational database. Unlike other XML-based databases, DBLX supports ANSI SQL and does not require learning a different grammar like XQuery or XPath. DBLX utilizes lightweight clients to send SQL queries and statements to a...


Platforms: Windows

Already includes SQLite, so there s no need to download and to configure. It provides the developer with a SQL database without running a separate RDBMS process. QuickLite is not a client library used to connect to a big database server. QuickLite is the server, reading and writing directly to...


Platforms: Mac

homepage can prevent email address harvesters and comment spammers from visiting your site by using a centralized DNS blacklist.Features - homepage lookups for visitor IPs - Blocking of requests coming from blacklisted IPs - Database caching, decreasing the number of DNS lookups - Honeypot link...


Platforms: Windows, Mac, *nix, PHP, BSD Solaris

This module allows you to give a "moderate nodes" permission to a user role. Users with this permission may see a list of content (restricted using the node access table via db_rewrite_sql so they cannot see content they are normally prohibited) at /admin/content_moderator. Within this list they...


Platforms: PHP