New Scripts | PHP | Scripts & Programs | Database Tools

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

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`

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

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.

This database management script is a great basis for writing code for using a database. It includes error catching and sanitation.

This class can be used to generate backups of PostgreSQL. It accesses a given database and generates SQL statements that can be used to recreate the database tables and the values stored on their rows. The generated SQL is stored in a given file. The class can also restore a database from a previously generated backup by executing the SQL statements stored in a backup file.

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.

Flat File Database Manager will allow you to manage (update/delete/add) records in your flatfile database. Features include user defined delimiter (usually pipe, colon, or comma), customizable presentation of different data types. Following data types supported: (List) - Rendered as list box or combo box; (String) - Rendered as regular input field; (Logical) - Rendered as check box; (Text) - Rendered as text area.

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.

Micro DB Installer is a small PHP script which helps you to automate MySQL database creation. If you don't want to use web your existing web admin interface or you want to extend your script with easy DB installation then you can use this tool.

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.

Search, Modify, Add, and Delete online Records. Using ASAP you connect to your Access, SQL or MySQL database, choose necessary fields, design the color scheme and then generate PHP pages and upload those pages to your ISP within the program. Features include DropDown Lists, Relational Capabilities, Password Protection, Image & Hyperlink Support. Template feature allows you to use a pre-existing look from your website to maintain that look in your generated page. *** New HTML area feature allows you to add or edit fields using user friendly HTML tags (content manager) ***. Shopcart Version will allow you to turn your database into an online shopcart.

This class can be used to manage MySQL database tables. It extends the MySQLi base class to add new functionality like: - Inserting, updating and retrieving MySQL table rows from a list of parameters - Creating and dropping databases, tables and triggers - Adding table columns - Retrieving table comments

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.

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