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

Do you ever get tired of having to open phpMyAdmin or something of the sort to edit your database records? With this script you simply edit a couple fields (database server, db name, db user, and db password) and you are ready to go. The you simply type your sql query into the text area, click submit, and you have changed your database. You will want to add your own security though or someone will be able to change your databae too!

Sql dump utility for MySQL and PostgreSQL Databases

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.

Pagination just means numbering pages. In the project that I was working on, I was retrieving large amounts of data from a MySQL database and realized that I would have to break the data up into pages for two main reasons, 1) there was so much data that it could hang the browser when it was loading and 2) from a user perspective (we still care about that right?) it was unruly to say the least. If I was returning 50,000 rows from a database query, I knew that I would need to slice that up into more manageable chunks. Now in the past, I had written basic pagination functions to handle this type of issue and sometimes copied and pasted functions from older scripts to cut down on development time, fixing and re-coding where necessary. But I realized that for this new project I could try to write a pagination class that I would be able to just plug into any script and have it do the pagination for me.

phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2. Following in the spirit of the flat-file system used by SQLite, phpLiteAdmin consists of a single source file, phpliteadmin.php, that is dropped into a directory on a server and then visited in a browser. There is no installation required. The available operations, feature set, interface, and user experience is comparable to that of phpMyAdmin.

LudoDB is a simple PHP Web Service framework. It makes it create PHP models of your database tables and to offer them to your users as a Web Service.

The central management of master data and product information (PIM/MDM) in a consistent way is key to your omni-channel success. Open source Pimcore provides the needed flexible master data management of product information to efficiently enable this process - for any domain and industry and for any master data management implementation style (registry style, consolidated style, coexistence style and transaction style). Pimcore provides the tooling both for operational MDM and analytical MDM and follows a multidomain and multivector approach. Manage any digital data.

eSKUeL is a MySQL database managment tool written in PHP. It's fully compatible with MySQL: drop, create, insert, etc. It's also fully skinnable.

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 or execute SQL queries on your data.

doSQL() is a PHP4 script that can dump data back from a SQL text file (generated by backupDB() (also available on this site), phpMyAdmin, or similar) to a new database, or run any number of SQL commands in batch mode. Detailed progress reporting, including time remaing, processing rate (text and graph available).

AED is a revolutionary script allowing you to easily create administration tools for your MySQL database. Don't waste your time re-coding every admin tool you create, and don't spend hundreds of dollars to get simple administration pages created for you. With AED, you have the power to create professional-strength admin pages for your website in minutes. AED generates add, edit, and delete administration scripts for you in a fraction of the time it would take you to even modify some of your pre-existing code. Requires PHP4.1.x (or higher) and MySQL Database.

Create dynamic-easy-to-use data grid controls for your web site in seconds

This is a Simple CSV Upload script that makes use of the 'LOAD INFILE' Query of MySQL. This is a script which can upload CSV (Comma separated values) file to the database, provided that the the fields in the file match the fields of the database provided in the configuration, irrespective of the database structure. Features * Upload Files and retain them * Loads data irrespective of the database structure

DB-RSE is a PHP program intended to be a very simplified MySQL database record selector and editor. Having only two files, it is simple to install and setup. Just put both files in a folder (preferably either secure or obscure), modify the dbconnect.php file, and load the main file in your browser. It also acts as a back-end to its parent program, "Form-a-Form -- Quick and Simple Form Creator for PHP".

phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite2 and SQLite3. Following in the spirit of the flat-file system used by SQLite, phpLiteAdmin consists of a single 100KB source file that is dropped into a directory on a server and then visited in a browser. Setup is as simple as specifying which databases to manage and creating a password. The available operations, feature set, interface, and user experience is comparable to that of phpMyAdmin for MySQL. If you know how to use phpMyAdmin, then you know how to use phpLiteAdmin. Even if you have no experience with database managers, the intuitive interface makes it easy to learn. The password for the demo is "admin".

Script to handle your mysql database online. no installation required, just plug and play :-) features: - help - database/Table/Filed browsing - field description - table description - database description - all kind of queries - select * works also - error messages - number of affected rows - multible statements - database/table backup (via dump download) - get table/database structure (create table statement...)

This is a dynamic query generator for MySQL and PHP4. It can create a new query or run an existing query. Several tables can be selected from a single database for relational queries. The query can be edited, saved and run dynamically. <br> <br> <b>Update (2001-06-18)</b>: The browser related bugs have been fixed. The query results are presented in a tabular form.

XCloner is a Backup and Restore component designed for PHP/Mysql websites, it can work as a native plugin for WordPress and Joomla!. XCloner design was specifically created to Generate custom backups of any LAMP website through custom admin inputs, and to be able to Restore the clone on any other location with the help of the automatic Restore script we provide, independent from the main package! XCloner Backup tool uses Open Source standards like TAR and Mysql formats so you can rest assured your backups can be restored in a variety of ways, giving you more flexibility and full control. Features: * Backup and Restore any PHP/Mysql application * Create custom backups * Generate automatic backups based on cronjobs * Restore your backups anywhere * Share your custom backups with your clients

phpDataMapper is a project to add the power and flexibility of a full-featured DataMapper to any PHP project in a very easy and portable way. It is an implementation of the Data Mapper pattern written in object-oriented PHP5. Work with native PHP objects as rows for saving updating, and displaying information. Easy finder methods, Simple and automated table relations, and much more.

This class works only under PHP 5.x and requires the MySQLi (MySQL improved) extension to work. It is designed as a 1:1 replacement of my old MySQL class. As the PHP devs decided to drop the mysql extension in the near future it was necessary to provide a replacement for that old class. This archive provides documented examples and a phpdocumentor based documentation.