FreeTurnkeyScript.com

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.

Visit this Script

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.

Visit this Script

MyDatabase is a PHP class that offers standard functions needed to navigate a database, but hides the implementation specifics. Works with both Access and MySQL. If you use both types of databases, this class is your answer. Easily switch between databases without changing your code or queries, simply change construction parameters. All results are held internally to the class, so no extra resources to manage. Methods include query, execute, next, move, eof, and close. Includes a debug feature and auto-shutdown, so resources are cleaned up when the script ends, even on error.

Visit this Script

PhpmyExport is a quick and powerful script which allows you to dump a MySQL database in two steps only. PhpmyExport has been designed to be simple and tidy, its interface is clear and accessible. You may dump your database in two steps. - first you connect to the MySQL server. An option allows you to save your authentication details on the server. - then you choose your options and you submit the form. A download box pops up instantly. PhpmyExport is a multi-language (en, fr, es) platform. It is very easy to add a new language since you just need to add a translation file into the lang folder. PhpmyExport automatically lists your MySQL databases (if the server allows that action). PhpmyExport generates a clean and commented backup file. Most importantly, PhpmyExport has been tested on a 350Mo database. The script doesn’t crash and the download dialog box appears in two seconds. This script needs to be tried. Enjoy… Axel

Visit this Script

Manage data in multiple MySQL or PostgreSQL databases from the same web interface. Simple, no server installs setup that automatically reconfigures web interface in response to database tables modifications. Miltiuser permission based access, automatic form input validation based on datatype, field sorting, advanced searches, smart navigation, support for many to many and one to many relations. Multilingual extendable user interface, mass update and delete operations. Links to live demos with sample database scripts are available at dbpal.com under `Manuals`

Visit this Script

This package can be used to display and edit data from a database in a grid using the Zend Framework. It features: * Simplified grid data presentation just by specifying the source database table, array, XMl, CSV, JSON file. * User interface controls to perform operations to insert, update and delete table records with support for data validation and filtering * Template based presentation * Support for joining tables * Filter data by user selected fields * Data validation (when performing CRUD operations) * Automatic pagination of results * Support for extra listing column fields * List sorting by field * Configurable field titles * Support for SQL aggregation expressions (MAX, COUNT, MIN, AVG, etc…) * Internationalization support * Export results in multiple formats: XML, HTML table, PDF, Excel, Word, etc.. * Zend Framework Route support * Cache support * Plug-ins to format content: date, bool, etc..

Visit this Script

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

Visit this Script

Free PHP DataGrid script is a simple, innovative and powerful tool for generating data-bound grid control. It’s free and it was specially designed for web developers. The PHP DataGrid is excellent for all PHP database-driven web site and online-based data administration. Also it useful for dynamic content management and PHP-based hosting providers. The goal of this script is to make free PHP DataGrid generating and editing as simple as possible for web developers.

Visit this Script