New 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.

This class can access different types of SQL database using PDO. It provides a common interface to access different types of database like MySQL, PostgreSQL, Microsoft SQL server, IBM DB2, SQLite, Oracle, Informix, and Firebird. The class can establish connections, execute queries, retrieve single result rows or single row columns, the number of result rows, the last inserted record identifier, the names of tables columns, and execute INSERT, UPDATE and DELETE queries from parameters. It can use prepared queries to prevent SQL injection attacks.

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.

DbFacePHP is a self service report and dashboard builder for SQL databases. With the straightforward interface, you can build tabular, summary, chart, number, google map without coding a single line of code.

Generate your database reports with this wizard in only a few minutes on any of your existing MySQL databases. Since this is a php driven application you simply upload the application files to a folder within your web site and you are ready to generate reports. Execute statistical queries such as sum a column.

Flexible PHP Pagination is a Generic Pagination Class that allows you to paginate your MySQL or otherwise results. On top of that it's easy to use, has full customization and can even be translated if you really want. Unlike other CSS and HTML predefined Pagination Classes, our Pagination class not only allows you to fully integrate this pagination with your design, but also allows you to use this with Mod Rewrite. Which means you can change the link structure however you like. Giving you FULL SEO Customization.

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

This a Free AJAX script to add comments in the website, uses PHP, MySQL, and JavaScript (with jQuery). The script paginate the comments, without affecting the rest of the page content, or page URL, and it can be included in both HTML, and PHP files (but the server must have installed PHP). The script can be used with multiple pages of a site, whatever the type of the page URL (modified or not with mod-rewrite). Can be set to allow only logged users to add comments, and has many other settings, and Admin management. Just test it.

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.

This class can execute queries from parameter lists using MySQLi. It extends the MySQLi class with functions that can compose and execute SELECT, INSERT, UPDATE, DELETE, REPLACE and HANDLER queries with parameter values that define tables, fields, field values, conditions, etc.. The class destructor function disconnects from the MySQL server.

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.