Most Popular Scripts | PHP | Scripts & Programs | Database Tools

This class can be used to display paginated MySQL query results updated using AJAX requests. It can execute a given MySQL query and generate a response to update a page that shows different pages of query results using AJAX to avoid page reloading.

Our Research shows that there is a huge market / need for such application which can manage the business enquires and handle them effectively. Companies are making huge losses as their enquires go unattended or not properly responded. Our IEM takes care of the complete requirement and provides Total solution for such need from any quarter of business segment. The specifications are as under: The enquiry management system is a web based application using latest PHP technologies and MYSQL database.

MySQL is undoubtedly one of the most-used relational database management systems out there, but many web developers and website owners have paid closer attention to its proper configuration, which is vital to achieving fast-loading and good-working websites. As websites grow, they often start experiencing issues like slow loading times due to the results from database queries being delayed or due to a growing number of queries failing, because the server is overloaded and cannot process them. All these issues can usually be fixed by tweaking the configuration of your MySQL server, but the harder part is to discover exactly which configuration variables need tweaking.

With Peek you are able to interact with tables and run queries all from within a web browser. You can View, Export and Drop Tables. You can Export to CSV or XML . Peek uses AJAX so all changes are done live in the browser window. Features: Easy to configure View, Edit, Export and Drop SQLite Tables Export to CSV or XML Run Raw Queries from within the browser Uses AJAX for fast and seamless editing

MySQL caching class is a lightweight PHP 5 class that allows individual query file caching without the need of server extensions. Features: Easy to install Lightweight single file (8kb) PHP 5 OOP makes it easy to extend Only connects to the database when the cache has expired or doesn’t exist Caches query data to json encoded files Set cache lifespan and filename individually Ability to manually delete cache files

The Excel format is most noteworthy as people will appreciate being able to download a native Excel document of data from your site, it will also make you look more professional by allowing a download of a file that people do not expect to be dynamic. Key Features: Easily export any kind of data. Data can be exported as any of: Excel JSON XML PHP serialize CSV Robust code base. Lightweight system. Object Orientated. Well documented.

It enables you to avoid writing and re-writing all the repetitive SQL queries and all the fetch arrays, help protect you against SQL injections, and offer you a very robust, but simple way to interact with your SQLite2 databases. This Framework is inspired from our MySQL framework, that have been used and improved for years. Features: - Uses SQLite databases (no MySQL database required). - Fully object oriented (uses classes) - Uses one class file per database table - Automatically generate the class files related to your database tables. - Prevent SQL injections by escaping bad characters. - All functions are centralized in one single file. - Fully documented. - Open only one connection per page.

Features: - Fully object oriented (use classes) - Use one class file per database table - Automatically recognize your database tables and fields. - Automatically generate the tables class files. - Prevent SQL injections my escaping bad characters. - All functions are centralized in one single file. - Supports MySQL 5 and uses MySQLi. - Fully documented. - Open only one MySQL connection per page, and close it at the end.

Butterfly Query Admin (BQA) is a drop-in, plug-and-play, paste-and-use alternative for phpMyAdmin, faster, lighter and skinnable. It is a database management tool with all required options, without the bulkiness and hassle of other tools. This script is entirely written in PHP . It does not need a MySQL database, and can be dropped in without prior installation. You can use this script on any PHP -enabled server, by simply placing the “bqa” or “butterfly-query-admin” directory inside your server root or admin folder. If you want to change the colours, fonts, or other styles, Butterfly Query Admin comes with skinning features. It also supports multiple languages.

It is very handy if you want to show client your database data or you just want to give yourself an quick view of your database data.

All you need to do is to follow three simple steps, CSV2MySQL will do all backend stuff for you. Features: User friendly three steps wizard. Auto detect available tables in your database, zero coding knowledge is required. Easy setup, simply drop the folder to a directory on your server.

SQLite PHP Admin (SPA) is a web based interface to administering SQLite3 or SQLite2 databases. It allows you to manage your SQLite databases version 2 or 3 which your current configuration of PHP supports. It includes almost full SQLite databases administration support - you can add,drop and modify any tables in database, create and drop indexes. Also you can conveniently browse any data in any table and modify it.

Key features: easy to implement and use (include one file). export data from MySQL queries. create documents in formats such as CSV , XML, DOC , HTML, XLS , PDF.

DBConvert FormWizard for MySQL is an efficient and helpful PHP Web Form Creator which allows you to build simple and clean WEB Interface for your local or remote MySQL databases. FormWizard features: PHP-based (driven) forms creation and edition for MySQL database, Three form types support: Single, Continuous and Table, Update, Insert and Delete functionality in WEB pages available, Flexible field placement, WYSIWYG GUI editor, etc.

This project provides a minimal extension for PHP's PDO (PHP Data Objects) class designed for ease-of-use and reducing development time/effort. This is achived by providing methods - delete, insert, select, and update - for quickly building common SQL statements, handling exceptions when SQL errors are produced, and automatically returning results/number of affected rows for the appropriate SQL statement types.

TbsSQL makes it pleasant and easy to use your Databases with your PHP applications. Its most interesting feature is that it can protect and format values before merging them into the SQL statement. TbsSQL is available for MySQL, MySQLi, Microsoft SQL Server, Oracle and PostgreSQL. It is compatible with TBS. It's only one file to install. It has also a cache feature and a debug console.

All done in ajax, which means fast performance and less traffic!

It isolates database layer from the business logic. It will help you to store database queries in simple xml files and it isolates database api from your application code. You code will be more readable, more beautifull, object oriented, more easy to support. it is very easy to connect with the database, just simple setup in an ini file. The tool’s code is readable and easy to modify and extend. This is a great tool if you want to work with the database tables and queries in terms of class instances. No limitations in comparison to the database api usage. You still have all the facilities but in more elegant and beautifull way. If some day you plan to migrate to another database it will be more easely.It is a simple ORM tool for php and mysql. You write queries in SQL not some special limitet language. it doesnt support relation between class instances like they are in the datbase. It is because i call it object mapping(mapper).

Features: Support for multiple languages, easy to modify text label on the button pages, display rows range on the button pages (tooltip), ability to scroll through pages, very easy to configure, 7 style examples (CSS3) with gradients, rounded corners etc.