Free Database Management and other PHP ScriptsFree Script Archive » PHP Scripts » Database Management
This abstract wrapper class provides easy and simple class methods to access the most important db function. Classes implementing the functionality for native PHP functions, PEAR, PHPLIB and METABASE enables you to switch between these db abstraction layers by changing only a single line of code. Now you are able to use a unifed abstraction layer for database access and switch between the underlaying layers. Platform: All, Price: LGPL The AutoCRUD for PHP library can handle most of the common tasks when using a MySQL database: insert, update, delete, get and select. In addition, it also provides extra functionality, like the ability to automatically handle relationships between tables or being able to set a table prefix without having to change any code. Platform: All, Price: Free (MIT licens "Debedoo" stands for "DB do" or "Database do" => do something with the database. It is a package (set of classes) that reads in the database table structure and makes the content of the tables editable. Works with MySQL. It allows you to set up a feature-rich web editor for things like phone books in minutes. Check the website for the full feature list and an example. Platform: All, Price: both Free/Commer Allows you to create databases directly from MySQL/PhpMyAdmin. Platform: Unix, Price: Free This module allows admin users to import listings with images into a Web site database from CSV files. Using this tool you can quickly and easily import large quantities of listings into multiple categories and multiple regions. This module can help dealers to have their inventory uploaded in bulk. Platform: All, Price: $324.95 All-new version of the highly popular importing script. Supports multiple languages and skins. Platform: All, Price: Donationware Create a highly customizable front-end for a database in order to search, insert, update, and delete records. All you need do is specify a few configuration parameters. MySQL, PostgreSQL, Oracle and MS SQL Server are supported. Available in several languages. Platform: All, Price: Free This software optimizes all of your tables, in all of your databases, and then goes through each table to back it up into peices that can be dumped back into the database later on, if something unfortunate were to occur. The software gives you a visual view on the progress of the tables, and gives you information on the size of tables, and whether they were so large that the software deemed that they should be broken into small pieces. VERY EASY! Platform: All, Price: 24.95 This script is designed to parse properly formatted tab-, comma-, or pipe- delimited datafeeds into a MySQL table format. It will detect errors in the feed and attempt to fix them or ignore them. Platform: All, Price: $39.99 Enhance the Macromedia Datagrid component (Flash 6 and Flash 7 versions included). Platform: All, Price: $5.00 Instead of coding complete mySQL queries to interact with the mySQL server, the programmer can simply pass several variables and this class will construct and issue the query automatically. It can add, edit, fetch, and manipulate data. It can also connect to a mySQL server, test connection speed, decrease load on a mySQL server so data loading is more faster and more efficient. Platform: Linux, freeBSD, Price: GPL dbfConverter is a PHP script that reads data from dBase files (dbf, dbt, fpt) and convert them into the MySQL tables. It does not support conversion of index files. Platform: All, Price: Free 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. Platform: Windows, Price: $99.00 Easy to use, step-by-step wizard interface; creates tables and indexes as needed; automatically converts data types to closest compatible type; save SQL as scripts. Platform: Windows 98, ME, XP, 2000, 2003, Price: Trial/$29.00 Web-based dispatch system. Without bar-code scanner and warehouse, clients management integration. Maximum stock size: 3.000; maximum number of users in next 12 month: 500. Platform: Windows NT, 2000, XP/Linux, Price: $1,900.00 Read Excel files and transport the information into a database or create an HTML file. Imported Excel data types are: hyperlink, integer, float, string (compressed Unicode,8-bits per character, or uncompressed Unicode, 16-bits per character, formats), date, time, percent, formula (returns digits only).Large files processing, Zend encrypted engine. Platform: All, Price: Trial/$80.00 This PHP class can read data from binary (XLS) Excel file without using COM, ODBC, etc. Using ExcelExplorer you can read info about worksheets, columns, rows, cells. You can even read style info such as colors, alignment, fonts, borders and more. Have build-in caching, memory-safe mode. Platform: All, Price: Demo/$129.95/$1, MyPDF allows you to do this - create PDF reports with advanced application logic from MySQL. Create summaries of your data, so-called 'sub-reports' with various levels of grouping for your data, calculations, calculations of calculations, sorts and filters, and much more - and then save your report layout and display it as a PDF. MyPDF is highly customizable using Flash 7 stylesheets. Platform: All, Price: $5 This PHP class library is designed for PHP-programmers and Web-designers to make their management of select, checkbox and radio lists easy and comfortable. Myref class library solves two main tasks: it gets lists from a database for further output on the HTML page and provides an administrative script for inputting the references into the database. Platform: All, Price: $15 Fully configurable. Features multiple database backups, different backup intervals, SQL file compression, advance reporting, secondary FTP/e-mail backup and more. Platform: Windows / Linux, Price: $450.00 This script can be used as a stand-alone script or incorporated into your own scripts. Features include; easy installation/usage; backup/restore any database; select which tables to backup; select backup/restoration of table structure, data, or both. Platform: All, Price: GPL Backup all databases in one click; pack, e-mail or FTP them all. Platform: All, Price: $14.95 This is a simple PHP class that gives you an easy way to store key-value pairs in MySQL database. Usually, you store key-value pairs in PHP array. If you want a key-value pair to be accessible within a session you will store it in the $_SESSION variable. However, to share it between different sessions you have to use MySQL database. With this PHP class it is almost as easy as using PHP array. Platform: All, Price: Free Provides a number of easy-to-use wizards for performing the required data manipulation easily and quickly. Generates PHP scripts for the selected tables and queries, convert any ADO-compatible database to the MySQL database, export data from MySQL tables and queries to most popular formats, and import data into the tables. Platform: All, Price: $59.00 MySQLdumper is a small free PHP class that lets you generate a dump of a MySQL database with just 2 lines of code. The dump can be used as a database backup. The dump is a valid MySQL-query in plain text. It doesn't depend on the 'mysqldump' command line utility, so you won't encounter a problem if this isn't available on the server. Platform: All, Price: LGPL A nice tool to synchronice a MySQL Webserver Database with a client Database without an ODBC connection between the webserver an the client. You only need FTP and php access to your webserver. Platform: Windows, Price: Free Navicat is an intuitive GUI tool lets you create, browse databases and run SQL queries. Advanced features include visual query builder, report builder, backups/ restore, batch job scheduling, remote connecting, and the ability to easily migrate data to/from Excel, Access and other data formats. Other features include a SQL Console, View Builder and Data Synchronization. The latest version supports HTTP connection. Platform: All, Price: $99.00 Search, add, and list all records. Navigate between pages. The search feature allows you to type partial text or numbers instead of the entire name, organization or phone number to make your search much faster. Platform: All, Price: $39.95 With this tool you can easily create a form to insert/update/delete data in a MySQL database. It automatically generates advanced search panel and form validation too. You can view the data in a short list view and in a detail view. You can easily change the look and feel with using css files. Platform: All, Price: Free This script extracts data from your Excel file and imports it to a MySQL database without any additional tools. Processes large Excel files up to 10 Mb. Processes hyperlink, string, integer, float, date, formula ( returned values only ),time, percent, empty, Error ( error code ) and others. Platform: All, Price: Trial/$79.00 An easy-to-use Web interface to MySQL. Create, drop, or rename tables. Alter tables structures by adding or dropping keys and indexes. Adding, removing or modify the properties of columns. Edit, add, search or delete table records. Platform: All, Price: Free This tool is very similar to phpMyAdmin, with the difference that the user interface is built using Macromedia Flash 7 technology. You may use phpFlashMyAdmin to edit MySQL table definitions and perform other common data management tasks. Since Flash is used, there are no annoying page refreshes. Platform: All, Price: $5.00 Like phpMyAdmin? Don't like page refreshes? This tool is for you! Not only can you edit mysql table structures and data, you can also *visually* create foreign key relationships among InnoDB tables. Platform: All, Price: $5 This script will allow you to maintain a database backup at any time interval you set. When you upload it to your server, you may set it up on a crontab and let it run daily, weekly or monthly. Platform: *nix, Price: Free PHPMagic helps you develop database applications rapidly. You do not need to have any programming background to use it. Just define your database, set some options, click the generate button, and ... that's it! Platform: All, Price: Trial/$35.00 A highly optimized database load balancing system written on the code level, for advance server setups. By having multiple MySQL Servers running on different machines on the same network, the PHP code will pass intensive processing SQL code to the compiled application ( in C++ ), which will then fork out into multiple processes and execute the various SQL code in parallel to the different MySQL Servers. Platform: All, Price: $49.99 An automatic tool to optimize and repair any damage tables in a given database. It should be used if you have deleted a large part of a table or if you have made changes to a table with variable-length rows(tables that have VARCHAR, BLOB, or TEXT colums). It can be run from a scheduler so that all your database tables are always optimized and in good working condition. Platform: All, Price: $400.00 Using generated PHP pages, users can search, sort, edit, delete, and add data into database. Easy to use wizard-like interface. Generates pure PHP code. Numerous search modes. Add, view, edit and delete pages. Creates password protected PHP pages. Platform: Windows 95, 98, ME, XP, NT 4.x,, Price: $199.00 Provides functionality to view data, add/drop tables, views and indexes, export data, add/delete rows, query the database. Platform: All, Price: GPL A set of Unicode compatible PHP4+ functions, that provides a simple relational database when you don't need SQL. Develop a robust database-driven Web application: anything from a guestbook, forum, poll to a full-fledged CMS or e-commerce project. Platform: All, Price: GPL For the Web application developer, who needs create recordsets from multiple tables and is not an SQL expert, QuB is the tool that allows table relation management, automating SQL query generation. QuB manages tables, relations and conditions for queries in your Web browser. Supports all Dreamweaver server models (PHP, CFM, ASP, .NET, JSP). Features: integrated Dreamweaver Recordset support; tight database integration; automate SQL query generation; visual query. Platform: Windows, Mac, Price: $99.00 This package is an OOP database abstraction layer for SQLite, MySQL, PostgreSQL and MSSQL with pagination support included. Platform: All, Price: MIT License A browser-based, user-oriented data entry and querying interface for MySQL databases implemented in PHP. Work with any database; also runs in a vast number of browsers, including Internet Explorer, Netscape, Firefox, Mozilla, Opera, Safari, Konqueror and even text-only browsers like Lynx and Links. Platform: All, Price: $147.00 SCUBA divers now can have their log book published on the Internet. This application will calculate the bottom time to date and total; divers only need to enter time in and time out. Every log also integrated with marine life gallery. This online log book will generate various statistical data based on your dive log, divers only enter all data usually entered just like in traditional paper log book. Platform: Unix, Linux / Windows XP, 2000,, Price: $39.00 Create and manage unlimited number of MySQL reports based on a table or query. Uses a wizard-style interface to select only the fields you like to view on your report. Includes the ability to export the report as a PDF, XML, or CSV file. Platform: All, Price: $38.00 An open source PHP class that can be added into any PHP file to simplify the calling of connections, queries, and closings to a MySQL database. Comes with complete instructions. Platform: All, Price: Free TVEz is a browser-based system to manage movies, shows, and clips stored on local or remote file systems. It's a front end to XINE and lets you control your player from a Web browser. The playlist is fully managable. It retrieves movie info and cover images from IMDB and stores the info in a MySQL database. The database entries are fully searchable. TVEz has a rating system, themes, multi-language support, statistics, new additions, and user login to control access levels. Platform: BSD, Linux, Price: GPL Connect to MySQL and edit your databases and tables. Upload one file to your server and start to manage your database. Platform: All, Price: GPL this php script will write data from php using text from an SQL table (MySQL, supply your own SQL query) to a microsoft excel (.xls) file. The Excel file is specified as such by a set of headers, defining content. using php's header() function, also the rows and columns of the excel file are defined by tab and new line chars. A great simple script for writing to excel from php. Platform: All, Price: Free |