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

Phlat makes it easy to work with flatfiles in PHP. You have all basic and some not so basic operations available with very simple commands, like, add, delete, modify, truncate, and more.

Engine for importing Microsoft Excel and OpenOffice created comma delimited CSV files directly to your desired database. You can specify the desired table name as well as fields' names to import data into. Also, you can skip certain columns from CSV data to import to multiple tables. Supproted SQL Engines are MySQL Server, Microsoft SQL Server, Postgre SQL Server.

Product Description This simple customizable PHP script comes with a database of over 6000 Hymns. Features: List All Songs List songs by starting letter SEO Optimized URLs with .htaccess Fast lightweight operation Complete with installation script. Database of over 6000 hymns Database complete with authors and composers Demo: http://obolynx.com/hymnal

Script allows to do all main operations with Sqlite databases - add, modify, view and delete data. Also is possible to view tables structure, search with certain properties and configuration file allows to set up user accounts with privileges for example just adding and viewing permissions.

Add-Edit-Delete records in a database table. Quick simple configuration and installation Has the ability to deal with different types of fields including dates, tree relationships, many to many relationships. Some support for image fields. Neutral colors mean it can be added to any website without clashing. Simple installation and configuration.

Simple interface to save your database into files. This is not intended to clone phpmyadmin interface. Administrators might not want to let other users access to all phpmyadmin functionalities, so that this little interface might be enough to them. However, MyBackup also provides the chance of extracting part of tables data as the result of a SELECT query filtering the output results.

This class can be used to display database query results split in multiple pages. It can perform queries to a MySQL database table and retrieve a range of results to display in the current page given the page number and the limit of results to display per page. The class can display the results as a listing of articles or as photo gallery.

This code will take a csv file and create or, insert or update, the data into a MySQL database. It assumes the first line contains the field names and uses that to build the SQL query for the following data lines. There's a download button for pulling in the csv file. A CREATE button will create a simple database using VARCHAR() with all the fields length set to the longest length of any field. The INSERT button will insert the data. The BUILD FIELD LIST button does just that so you can select the field if you're doing an UPDATE operation. Index fields in the database are shown. There are few checks to ensure that an operation will succeed. INSERT into a table that doesn't exist for example will error etc. The code is heavily commented and should be ewasy to follow/amend.

This is a mySQL database class, that allows you to run queries faster and supports prepared statements, just like PHP 5's PDO, but working for PHP 4. It supports: - persistent connections; - raw query, just like mysql_query; - select function; - insert function; - delete function; - update function; - lastInsertId function; - rowCount() function (for select resources); - prepare function like in PDO; And many other usefull functions. I work very efficient with this. Hope you like it :). Also, I've included 2 bonus classes as a gift: an Email sending class (with attachment support) and a FileSystem class (with unzip/zip/list functions). All classes are very well commented. Good luck!

This script allows you to run MySQL dump on any server even if phpMyAdmin is not installed.

This is a PHP class that will allow web application developers to speed up the development process. All that is needed is a configuration file where you will include the database information for connection such as database name, user, password and so on. Supports MySQL

Has 3 Part Process instructions to automatically provide our Database application created with Javeline Framework over an open MySQL db to your website. Free ppContact widget available for interacting with database from web page. Upload to a website and execute by hyperlinking to the (pp dash index dot php) file in the publicpim subdirectory.

DBForms from MS Access to PHP+PostgreSQL is an application which allows you to convert mdb (MS Access forms) to AJAX based WEB page. Now you can easily convert forms and their elements to php and PostgreSQL driven Web pages, filling form fields with data from the fields of your Access tables. During conversion elements' position, color pallet and fields type are converted accurately. Unicode support, Primary keys and indexes conversion available.

This class can be used to build and execute MySQL database queries. It can build SELECT, INSERT, UPDATE and DELETE queries from lists of parameters and values. The class can also execute the generated queries and retrieve the SELECT query results into associative arrays.

T3 DB Tools is a seditio database management plugin. Features: -- Backup all or selected tables of your seditio DB. -- Table information and schema. -- Browse tables (experimental) -- Drop, truncate tables. -- Option to export data, structure or both. -- Support for gzip, bzip2 compression of the backups. -- Restore database backup. -- Run custom sed queries. -- Extra security rights. -- Check, analyze, repair and optimize tables. -- Auto create the backup folder and the directory blocker protection. -- 100% ability to translate. -- Easy navigation and event reports.

PHP Database scripts presented here are generated by NuSphere DB-Form Wizard in NuSphere PhpED (PHP IDE). This particular set of scripts provides the form that can be used to browse, insert, update and delete the data records in MySQL server table "items". Table "items" belongs to the database "shopcart" and has the following fields: Itemno - [char] (4) NOT NULL, Description - [varchar] (30), offered_by - [char] (3), start_date - [date], end_date - [date], reserve_price - [decimal] These scritps rely on generic db utilities include files provided for MySQL connection. Implementations for other databases can be downloaded from NuSphere web site as well

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

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

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.

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.