New Scripts | PHP | Scripts & Programs | Database Tools

BackupZip creates a .gz zipped backup of a MySQL database on demand. You can either backup all tables within the database or chose to just backup specific tables. Used with cron and an automated ftp download, you can completely automate database backups! If you don't have access to cron, setup a reminder or scheduler to run this script daily or weekly via your web browser and download the zipped files via FTP when convenient. If you don't have access to cron or would prefer to output the backup file directly to your web browser, see the Backup scriptlet.

The class takes a MySQL query result handle and retrieves the query result column names and the query result data. The class generates the definition of a JavaScript object in JSON that contains an array of a rows of query result data.

This version of dm.DB adds PostgreSQL 8.0 and 8.1 support to the existing MySQL support. dm.DB provides an interface to SQL compliant databases that is independent of the underlying database API. Currently support for: MySQL PostgreSQL 8.0 PostgreSQL 8.1 is provided. Additional support has been added to allow SQLData to support all dm.DB supported databases.

Micro Database Browser is a simple PHP script which can list your available databases, tables and displays data stored in it. It's purpose to give you an easy installable product to verify your actual DB status without installing professional database management tools.

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.

Fix Collate or Collation problem on MySQL database, table and fields.

SQLData is an extension of the DB class that is meant to provide object-relational mappings to store and retrieve persistent objects in a SQL database. The class comes with additional scripts for generating classes that can be used by applications to access given database table using the SQLData class as means to store and retrieve data with SQL statements. These scripts are meant to run from the command line. They retrieve the definitions of a given database table and then the generate classes to access the table rows as objects or to manipulate them via Web forms. Experience has shown that the automatic generation handles about 80% of the repetitive work involved in building classes and forms. SQLData was designed to make it easy to automate the construction of the application specific classes interfacing to SQL tables. SQLData supports all databases supported by the DB class, currently MySQL and PostgreSQL 8.0 and up.

objSQL is a PHP based database access layer for multiple database types. Primarily designed for small to medium projects, objSQL uses an "Object Based" approach for handling general database queries. Built-in support for transactions and prepared statements allow for a common interface to all supported database types. Recordset paging is simplified by incorporating the paging method along with many helper methods for general queries. objSQL is easily extended to create your own unique classes and methods.

QLR Manager is the affordable, yet powerful, server based Report, Chart and data editor for DB2, MS SQL, MySQL, Oracle, PostgreSQL, SQLite3 and ODBC data sources. In addition to its exceptional reporting capabilities, QLR Manager provides support for integrated e-mail distribution. User Menus can be created to simplify report generation and limit user access to sensitive data. Forms can be created to add, edit and delete data in your database tables. The application is 100% HTTP server based and accessible using any newer, mainstream web browser. Accessing your databases has never been easier with its intuitive browser interface, and there is no client code to install and maintain. QLR Manager can be used as a stand alone product or as middleware to integrate Report Objects into your website. Using QLR "Widgets", you can directly embed reports and other objects into Content Management Systems, such as Drupal, simply by copying and pasting a secure link generated by QLR Manager.

This PHP class can import data from an Excel file without using COM, ODBC, etc. It will be useful in content management systems, for writting various converters (Excel to HTML, Excel to MySQL, etc.). On-line demo and trial version available for download. ExcelExplorer will work on any PHP5 platform. Supports Windows and Mac Excel files. No additional classes, modules are required. No configurations needed. Just include it in your own script and use it. With this class you can read such data as used color, fonts, rich text, asian phonetics, etc. Shapes and images also supported. What data can be imported: worksheets name, type (ordinal, chart or Visual Basic Module), visibility flag; rows and columns info; cells - type (integer and float numbers, percentage, text, formula, logical, error, date in Windows Excel and Mac Excel formats), empty, blank and merged.

This class can be used to build MySQL SQL query conditions to search for Arabic text considering Arabic lexical rules. It uses the MySQL REGEXP and LIKE functions to retrieve better results from queries for Arabic text.

This is a simple wrapper class that can be used to access SQL databases using the PDO API. It can establish connections, execute direct or prepared SQL queries, retrieve the all query results into a single array, begin, commit and rollback transactions.

This class can be use to manipulate hierarchic trees of records stored in a MySQL database using Joe Celko visitation model. It can perform the following tasks in a very effecient way mostly using one SELECT query statement: - Find out leaf nodes in the current tree (nodes have no children) - Find out nodes of a sub-tree for given node - Find out the context path of given node - Find out the level or depth of a given node - Find out how many descendants a given node has

With Form1 Builder MYSQL you can automatically have form submission data added to your MYSQL database with protection against form hijacking, email injection and email harvesting. To use the MYSQL option you must have a server based MYSQL database and it must have an existing table with field names that correspond to form field names. On form submission a new record is added to the MYSQL database table and MYSQL database table fields that have the same name as form fields will include the input values from the form field. Additional form variables can be added to the MYSQL table by including a field in the MYSQL table that has the same name as the field to be included. You can also include a range of User and Cookie Variables for automatic import into the MYSQL database. Form1 (the generated form code) runs on your web server. To run Form1 your server must support the php scripting language. Most commercial web servers support php.

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

Upload your CVS converted MS Excel or Text files to your Mysql database very easily with this simple little script. You can use it independently or integrate into your existing script. Free to download for non commercial use. Visit our site for more FREE stuff

Roundbase is a way to easily enter information into a mysql database, Features include easy install, customizable php tables, small file, stats for totals, and a small file to download. NEW IN VERSION 2.5: HTML TAG STRIPPER SECURITY HOLE IS FIXED IN THIS VERSION.

This parser will parse the contents of mysqldump file into an associative array. The array contains table definition information include primary key, table name, field name, default value and datatype. Also compatible with phpMyAdmin(structure only) export format.

Flat-file database management system written in PHP, using MySQL syntax.

xls2mysql is the first and only PHP application to perform data conversion from xls to mysql. xls2mysql is shipped with a simple but easy to understand DHTML interface : one tab enables file uploading, the other displays the list of all files in the recipient directory. As such you can try the process many times without re uploading your files.