New Scripts | PHP | Scripts & Programs | Database Tools

DbSimple is a database abstraction library which provides an extremely laconic and handy interface for practical usage in PHP 4/5 scripts. Its usage is much easier than most of other popular abstraction libraries (like ADODB, PEAR DB, and PDO). "Query execution" and "result fetching" operations are joined thogether and complemented by powerful placeholder support (including list-based placeholders) and various fetching modes. The library supports a unique and very convenient method to build dynamic SQL queries (conditional macro-blocks).

This comes handy because you can simple edit the appropriate fields, upload it along with the csv file and call it from the web and it will do the rest. It allows you to specify the delimiter in this csv file, whether it is a coma, a tab etc. It also allows you to chose the line separator, allows you to save the output to a file (known as a data sql dump). It also permits you to include an empty field at the beginning of each row, which is usually an auto increment integer primary key. This script is useful mainly if you don't have phpmyadmin, or you don't want the hassle of logging in and prefer a few clicks solution, or you simply are a command prompt guy. Just make sure the table is already created before trying to dump the data. Kindly post your comments if you got any bug report.

JR-Backup is a php script written to automatically backup your database for you It will backup all the tables for you and send it to you via email daily , weekly or monthly as desired Easy to setup yet powerful Free Installation

Micro DB Manager is a database abstraction class written in PHP using object oriented technologies. The class realize the following functionalities: * Connectiong to the databse * Executing queries * Converting results to associative array * Get selected rows * Get affected rows * Get last insert id * Get the number of executed queries * Get the execution time of the queries * Get error messages and codes

Oracle Information Site allows DBAs to view the most important informations about all configured Oracle databases. Support for Oracle 8i, 9i and 10g (untested) is integrated. OIS gives the DBA many informations like - Instance Configuration parameter - Running processes with detail view - Redo Log and Rollback segment usage - Tablespaces - Overview of all defined DBMS_JOBs - Memory Usage - Basic tuning views - General instance statistics - Very basic schema browser In addition OIS has a small integrated management interface which allows DBAs to have an overview of all DB machines with saveable comments. Finally a basic table exporter is also integrated. To use OIS you'll need PHP4 or newer with OCI8 extension build in, and of course at least one Oracle instance. As OIS reads Oracle's internal tables it require DBA rights to access them, else OIS won't work.

This class works under PHP4/PHP5 and all MySQL Versions from V3.x and newer. It features an easy-to-learn API and an error-management which includes auto-sending of EMails in case an DB error occured. The archive comes with complete documentation and some examples to show basic usage of this class.

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 packages implements a MySQL database abstraction layer. It provides several classes. There is one for establishing connections and executing SQL queries, another for composing and executing SELECT, INSERT, UPDATE and DELETE queries from a list of parameters, and a wrapper class to simplify the usage of the other two classes.

This class can be used to create HTML forms for entering values to create new records of a MySQL database table. It identifies the list of fields of a given mysql table. Then it generates HTML for a form that includes inputs to enter values for the fields of a new record of that table. The class generates text or textarea inputs depending on whether a text field has more than 50 characters limit length. It also generates password inputs for MySQL password table fields, and select inputs for enum table fields. The class also can display the results of a query that retrieves the records of a given table.

Extracts data from MySQL. Uses a MySQL table name or SQL statement to determine what data to extract. Formats the data into comma-delimited format, csv. Automatically translates invalid characters, such as " to valid characters. Quotes columns where a field contains a comma. Starts the csv file download. Optionally you can define: A value to use if the MySQL column contains a null value. The file name for the download file. A password that is required to download the file. How quotes are used for columns with commas. Whether or not the MySQL column names are included as the first line of the csv file. A delimiter other than a comma. The following are required: Have MySQL and php installed. A text editor, like Notepad. Have a valid MySQL User Id and password with appropriate permission for the database being accessed. Ability to transfer MySQL to CSV Download to your web server with ftp or similar.

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.

This new SQL2RSS script allows users to easily convert information that is stored in a database into an RSS feed, for syndication and distribution. When using SQL2RSS the publisher has complete control over the content in the resulting RSS feed. Administrators and publishers control the database query which allows them the flexibility to determine what data is inserted into the RSS feeds from the database.

If you have a Database(s), you surelly issued overheads. Run this script once per week (i.e. every Monday at midnight) and you will get rid of it. Note: if you have huge amount of hits, then you should use it more often! HOW DOES IT WORK It uses a SQL command OPTIMIZE TABLE. You can do the same in phpMyAdmin, with one difference. This tool can optimize your database automatically. All in one, no need to optimize table-by-table. If you have any further questions visit: http://forum-grounds.com/ This initially released on: http://dev.recgr.com/ Base: http://www.recgr.com/

Webmasters, Save time on your projects ! Powerful Data Management Tool, PHPEasyData is a PHP application which allow you to manage and display on the web your dynamics data and directories . PHPEasydata will largely facilitate all steps of a classical development to put data on your website (fields definition,database creation, forms to add/update records , php process to display records, members area, comments etc.) and more classical functions ... It will fulfill the requirements of professional webmasters as well as not experts webmasters wishing a genuine tool which combines powerful and facility of installation for the realization of various part of a website or to realize a complete directory. Data Directory means Link directory for the simplest usercase as well as complete ans customized directory with your own informations.

This class wraps common MySQL database table SQL queries. It can: - Perform SELECT queries and retrieve a single value, a single row into an array and all rows into a multidimensional array. - Insert or update rows from a list of fields and values - Delete table rows that satisfy a condition - Count records in a given table - Check if a table record exists with a given field value

This handy little script allows you to fully back up a given MySQL database utilizing the command line scripts (CRON). This script will automatically email you your database contents on the schedule you set. The instructions included will walk you right through the process! It's that easy to keep your database backed-up in case disaster strikes! Perfect for mission critical databases or for simply making sure you have the latest info to reinstall the database.

Zebra_Database it is an advanced, compact (one-file only), lightweight, object-oriented MySQL database wrapper built upon PHP's MySQL extension. It provides methods for interacting with MySQL databases that are more intuitive and fun to use than PHP's default ones. The class provides a comprehensive debugging interface with detailed information about the executed queries: execution time, returned/affected rows, excerpts of the found rows, error messages, etc. It also automatically EXPLAIN's each SELECT query (so you don't miss those keys again!). It encourages developers to write maintainable code and provides a better default security layer by automatically escaping strings. Zebra_Database's code is heavily commented and generates no warnings/errors/notices when PHP's error reporting level is set to E_ALL.

This class can be used to search for data in MySQL database table text fields. It executes one or more SQL SELECT queries to search for given keywords in different text fields of the same MySQL database table. The class returns an array with the values of primary keys of the table records returned by the queries. Duplicate record entries are eliminated.

Create PDF reports from MySQL tables, using a customizable, Flash 7-based layout builder.

Backup outputs a copy of a MySQL database in sql format directly to your web browser. You can either backup all tables within the database or chose to just backup specific tables. Simply run this script, copy the output, paste it into plain text file and save it for future use. If you have access to cron or would prefer store zipped backup files on your server for later download via FTP, see the BackupZip scriptlet.