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

Each session is stored in a database and is locked to the current browser and ip address.

You can use this system to create a comments system or blog, or any system that would typically need a database with a few simple files. But don’t think of it as something for people with no MySQL access, you could also use Data File to store config information for your project such as the database username and password.

This class provides an API to work with SQLite databases. The API is almost identical to my Oracle and MySQL classes. It runs only under PHP 5 and comes with some examples and a complete API documentation.

It generates a php class-file on your server. It enables you inserting, deleting, updating and selecting records from a database table via class methods! Only select table, define class name and press button “generate class”! VERY SIMPLE !!!

You can quickly and easily create data views in your admin pages, displaying spreadsheet type datas, product listings etc…

From a given database generates a set of SQL instructions to alter a database to the new schema form. First the field is attempted to be created and then altered to the new specifications. Run against a previous version of a schema it will update the schema to the new specifications (apart from any totally new tables)

The class makes it easy to get rows from a database, display those rows on the page, and create paging by supplying the table name, and the amount of rows visible. simpleAdminPlus also makes it easy to work with forms. By initializeing simpleAdminPlus Forms, you can easily create a form and fill all the form fields by supplying the id of the row you want to edit. In addition simpleAdminPlus comes with an image class so you can resize, convert, and save an image from an upload, or an image that already exists.

With this PHP Pagination Class, adding pagination to your scripts can be done easily all over your website. The class was designed with modularity in mind. It works with any database system that integrates with PHP such as, MySQL, PostgreSQL, SQLite, etc. Features: * Quick “Jump To Page” feature * Change the colors & design in minutes * Language pack to change the language quickly & easily * Easily select how many results per page you want * Well documented PDF manual

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

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.

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

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.

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.

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.