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

phpSQLiteAdmin is a Web interface for the administration of SQLite databases. Right now the following operations are supported: Create, drop and vacuum databases; Show database information (schema, tables, indexes, file metadata); Create, browse, empty and drop tables; Show table structure and indexes; Execute sql;

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.

This class can be used to backup large MySQL databases into multiple files. It can list the tables of a given MySQL database and generate SQL statements to create and insert records with the current values of the table rows, as if it was creating a new database. The class stores the generated SQL statements in files. A full backup process can be split in multiple iterations to not exceed PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.

A PHP5 class to simplify backing up databases remotely.

This class allows to develop applications using Oracle 8i or higher. It supports bind variables, IN/OUT variables for PL/SQL procedures and BLOB support. Additionally it features an easy-to-learn API and an error-management which includes auto-sending of EMails in case an DB error occured. The class works with PHP4 or PHP5 and requires the OCI8 extension to be enabled in your PHP. A complete documentation and some examples are included, too. V1.00 provides now separate classes for both PHP 4 and PHP 5.

This is a simple script that will create a mysqldump of your database and upload it to a ftp server. This can be configured to determine which database (or all) you want to backup, where you stock it locally and where you upload it.

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.

RedBean is a so-called -on the fly- ORM layer meaning it does not require configuration files or a pre-existing database schema to operate. Instead the library designs its own database structure based upon your interactions with so-called bean objects. Using reflection technologies that are part of the php language RedBean infers the required schema from these interaction for your code. It will create the tables and columns your code needs on the fly.

The awesome SQL database table editor and management script by PHP.

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.

The main difference between this script and other backup solutions is that the current script are splitting the backup process into more than one sub processes and each sub process is saving a small part of your database.

PHP DataGrid has been created for selecting data, displaying it as a grid, and to perform routine operations on it. It allows paging through results, editing, deleting and inserting new data. PHP DataGrid can be very helpful for you to display any complex data from database and to automatically perform any needed operations of them. By enabling or disabling its features you can turn PHP DataGrid into something very helpful for you. You know how important such a tool for creating web applications is. Really, data grid is heart of almost every web application.

SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4 and work fine with PHP5. Work just as well on a platform Linux as on Windows or Mac OsX. This project is in course of developpement, but it is alway very functional. The various functionality are: - Management of several database - Creation 'Connection' to several database - Property of the database. - Management of the options of the database. - Creation / update / delete tables - Management of the indices - Showing / Insert / ALter / Suppression of data in the tables - Imports data from a file - execution of manual query from 'SQLite' format or from 'MySQL' format (conversion) - Create / Update / Delete of View - create / Update / Delete of Trigger - Management of the user defined function. (usable in SQLiteManager query) - exports structure and data to the SQL format

This is a function to convert a user's query in boolean syntax ("hotels AND mexico NOT cockroaches) into a SQL query over the appropriate database fields.

MySQLDataManagement is a set of php scripts to manage your data for selected DBs. All your tables will be shown you for data management on them. MySQLDataManagement allows you to add / edit / delete / list records on selected table - DB. Easuy to use and install.

This script can generate forms on two tables where one index in the first table is realtionally linked to another index in the secondtable. This script can also generate a single table form. This work is an extension of earlier work on PHPFormWizard 2.0. Update (2001/12/02): Updated to get rid of the system commands such that it would be compatible with Linux, Unix and Windows OS. The PEAR libraries have been removed as it made the script litle sluggish. Forms can be generated from single upto five related tables. An example is also provided.

phpOracleAdmin is intended to be a webbased Oracle Object Manager. In many points like phpMyAdmin or the Desktoptool Objectman from orasoft.org. It supports things like browsing through the tables, triggers, and so on. It needs PHP 4 and works current only with 8i Databases.

MCM Backup is a free PHP/MySQL website backup software. It allows you to backup your files and database and save them to your PC.

Mimesis is a php4 flat file database class library. Mimesis mimics the behavior of a standard SQL database but without using SQL. Instead, using php's object oriented programming features Mimesis functions as a distinct class with various database manipulation methods.

OracleEditor.php is a standalone PHP script which allows you to browse your Oracle database tables/views and insert, update and delete rows in any table. It has two modes for SQL entry - one is wizard-like, the other one allows executing arbitrary SQL statements. It requires no installation and no configuration. It is written for situations where you quickly need to do some small data manipulation and don't have a better tool available. OracleEditor.php is free and Open Source.