New Scripts | PHP | Scripts & Programs | Database Tools

This is a single script administrator for SQLite databases (PHP 5.x required with SQLite and GD support). Fully working!

The categories hierarchy is stored in a MySQL table that keeps the information about each category including the identifier of its parent category record. The script provides functions to add a new category, edit, delete and retrieve the details of an existing category. Cross-Browser Compatible (IE6+, FF, Safari and more).

ADOdb4PHP is a database abstraction layer with pagination support, written in OOP style, providing exceptions support, for PHP 5.1+ running on Windows machines.

The class was designed with modularity in mind. It works with any database system that integrates with PHP such as, MySQL, PostgreSQL, SQLite, etc.

This script is the ajax version of our Advanced tables script. The result is that this script can work with much more data. It even can handle a database with more than 300,000 records.

Pandra (PHP-Cassandra) is a light weight, flexible PHP based CRUD extension for Cassandra / Thrift suitable for object relational models or factory design patterns. Pandra objects can be created on the fly from existing keyspaces or dynamic user data without requiring any kind of schema. However, it will happily enforce ColumnFamily/SuperColumn schemas and validate column values where needed with minimal overhead.

MADAL is an Ajax based database access layer for MySQL written in PHP and Javascript. It generates PHP and Javascript/jQuery source code that is well documented, so you can use your IDE's auto-completion against database tables and fields. The documentation was designed with PHP Eclipse in mind, but should work for any IDE that recognizes PHP doc. Features: * PHP Model - generates a set of PHP classes that mirror your database schema * Javascript Model - generates a set of javascript/jQuery classes allowing for simple client side display and modification * MADAL Web Service - generates an easy to use web-service for accessing your database (includes security) * Easy ajax - simply print the input field and you've got an ajax enabled field * Field validation - input fields are validated for their type * jQuery ui themes - MADAL includes the whole set of default jQuery ui themes for styling of your pages. * Optimistic concurrency

This class can be used to create an Excel spreadsheet from data in a MySQL table. It performs a query to a given MySQL table and creates an Excel spreadsheet file using the PEAR Spreadsheet_Excel_Writer package. The class can add multiple worksheets in a single Excel file. Several parameters may be used to configure details like from which table fields map to spreadsheet columns, field sorting, etc..

This class can be used to execute MySQL queries and get paginated results. It can insert, update and delete MySQL database table records with eventual prior validation of the field values according to given rules. The class can also execute SELECT queries with support to retrieve results to show in paginated listings.

PHP Admin Panel (PHP AP) provides you access to the control features of your site as creating static or dynamical pages and allows your easily manage database tables with embedded PHP DataGrid. It includes Creating, Reading, Updating and Deleting (CRUD) records in database tables on your existing site. You can edit menu options "on fly" and create new menu just in a few clicks.

This class can be used to call PostgreSQL stored procedures. It defines the __call function to accept calls to PostgreSQL stored procedures by the name of function of the class that is called. The class takes the function arguments and converts them to parameters that are passed when the stored procedure is called.

Renders a dynamic menu from a database table. Is able to highlight the current page automagically and on the fly without any kind of user input! You can have a special class appended to a link in the menu. Everything is customizable, from the css classes to the way the HTML itself is printed.

Features: A preview mode is provided to make sure your output are correct. Only certain SQL queries are allowed, configured through a blacklist array. Comma separated, tab separated, all configurable by the user. Easy HTML /CSS customization, code and view are within separate files.

Sypex Dumper is a PHP-script, which can help you create a backup (dump) of a MySQL database, and also restore the database from the backup if needed. Unlike many similar programs (scripts), is optimized for maximum performance, as well as for working with large databases of hundreds or thousands of megabytes. Key features, briefly - backup and restore of MySQL database without using third-party programs, just pure PHP; - impressive performance; - support for two formats, file compression (Gzip and Bzip2); - friendly Web 2.0 interface with AJAX; - work in several stages (to bypass the restrictions about time); - special file format with the meta-information; - MySQL service functions (check, optimize, repair); - smart backup with post-processing;

Features: -Easily integrated into any web application (live demo required no modifications to template) -Simplifies building admin panels for web developers -Handles one-to-many relationships with a dropdown select menu -Features a blacklist for both databases and database tables -You can either leave all databases open or specify only one database -Handles Creation, Updating, and Deleting (CRUD) -Works with tables the developer defines (user cannot create or modify) -All PHP is included in one single file and URLs do not require a specific filename

This script will allow a user (with no MySQL knowledge) to display results from a database on their web site. This is also simple to customise and is completely free. If you do anything really cool, then send me a copy back so I can include it next time.

When it comes to web DataGrids, fast loading of large data combined with advanced Excel-like operations has been always a challenge. Having a solid experience in web technologies, we designed our AJAX powered PHP Grid to eliminate this tradeoff. Easy-to-use, rich client-side API, myriad of features topped with an unbeatable performance is what we call KoolGrid. Key features: Very easy to use, simple PHP code. (1) Rich client-side API and events (2) AJAX Capability (3) State persistence through postback and ajax callback (4) Support Auto CRUD (5) Scrolling with position persistence (6) Sorting (7) Filtering (8) Grouping (9) Row Selecting (10) Form and Inline Editing (11) Localization (12) Many skins are available to choose. (13) Skin can be all customized as wished. View and Download Now!

This class can be used to query MySQL using values passed pragmatically. It can connect to a MySQL database and execute SELECT, INSERT, UPDATE and DELETE queries from arguments that define tables, fields, field values, conditions and order clauses. The class can also display HTML tables with data from SELECT query results, count the rows of a table, insert or update a table record depending on whether the record that matches a condition already exists, and get information about the table.

RedBean is a so-called -on the fly- ORM layer meaning it does not require configuration files or a pre-existing database schema to operate. Instead the library designs its own database structure based upon your interactions with so-called bean objects. Using reflection technologies that are part of the php language RedBean infers the required schema from these interaction for your code. It will create the tables and columns your code needs on the fly.

RedBeanPHP is a zero config ORM layer meaning no XML, YAML or JSON configuration or schema mapping file is required to get started. Instead the library designs its own database structure based upon your interactions with so-called bean objects. Using reflection technologies that are part of the php language RedBean infers the required schema from these interaction for your code.