New Scripts | PHP | Scripts & Programs | Database Tools

These archives include all files necessary to calculate the distance between two U.S. Zip Codes using PHP4+ and MySQL.

I find this little script very useful for web applications that need to automatically generate tables. I wrote it because I felt it was wrong to have a script execute create table SQL statements for tables that already existed.

This tool consists of two files, one to execute queries submitted by form or uploaded as a file and display the results, and another to dump the database in MySQL or MSSQL format. The scripts can be used with either MySQL or MSSQL databases. Together they can be used to migrate a database (or at least the table structures and contents) from MySQL to MSSQL or vice versa.

db_upload_file() stores a file in a database table. Make sure that the column data type is big enough for the files you will be storing. db_download_file() retrieves a file from the database and places it in the same path as the script calling it, and returns the relative URL. If the file does not exist in the database, it returns an empty string.

Script to handle your mysql database online. no installation required, just plug and play :-) features: - help - database/Table/Filed browsing - field description - table description - database description - all kind of queries - select * works also - error messages - number of affected rows - multible statements - database/table backup (via dump download) - get table/database structure (create table statement...)

phpSQLiteAdmin is a Web interface for the administration of SQLite databases. Right now the following operations are supported: Create, drop and vacuum databases; Show database information (schema, tables, indexes, file metadata); Create, browse, empty and drop tables; Show table structure and indexes; Execute sql;

You can generate database scripts to your own custom design of your database in PhpMySQL CGI-Perl and ASP Access with Add, Search, Edit and Delete functions. A user can edit and delete his own record only, protection being provided by user-selected password. Search results are paginated, the number of records per page being customisable. There are two databases, one for Matrimonial, the other for Classified Advertisements. The site also has Reciprocal Links Exchange Directory

txtSQL (pronounced "text-sequel") is a class containing a variety of functions designed to mimic a database system, using only regular text files. It is object-oriented and can be looked at as sort of a framework in creating larger scripts (such as guestbooks, polls, forums etc.) There are two levels of access; a low-level implementation that works on just function calls and the other relies on the support of SQL (a parser/lexer is currently being developed). As far as I know, txtSQL is VERY efficient in how it handles its data and the way in which it is handled has also almost never caused any major concerns (data loss is rare). txtSQL does not require any outside plugins to operate, it's in the ballpark of "plug and play" (with a few exceptions of course). But most importantly, txtSQL is an opensource project (listed under Sourceforge), licensed under the GNU, which means that it's totally free of charge and will remain as such forever.

SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4 and work fine with PHP5. Work just as well on a platform Linux as on Windows or Mac OsX. This project is in course of developpement, but it is alway very functional. The various functionality are: - Management of several database - Creation 'Connection' to several database - Property of the database. - Management of the options of the database. - Creation / update / delete tables - Management of the indices - Showing / Insert / ALter / Suppression of data in the tables - Imports data from a file - execution of manual query from 'SQLite' format or from 'MySQL' format (conversion) - Create / Update / Delete of View - create / Update / Delete of Trigger - Management of the user defined function. (usable in SQLiteManager query) - exports structure and data to the SQL format

noSQL is a small set (7kb) of SQL-like PHP functions to manage a database in an SQL-like way without a SQL-server. Everything is stored in flat .csv-formatted files, so putting data into noSQL or getting data from noSQL inside a spreadsheet program works immediately. If you are too lazy to setup an SQL-server, or you simply don't have one right now but perhaps later in the future, use noSQL.

Designed to create a daily snapshot of the dynamic data on your website. (e.g. content management systems, forums, guestbooks etc.) Some of the features include: - Backup multiple databases and servers with different users and passwords. - Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems). - Create daily, weekly and monthly snpashots of your database. - Keep the daily, weekly and monthly backups for a user-specified time. - Archive and compress the SQL files (*.tar.gz). - Creates a detailed report of everything that has been done. - Reports can be mailed to you or any other user-specified email-address, saved to disk or displayed in browser. - Generated SQL files can be mailed to you or any other user-specified email-address. - Generated SQL files can be uploaded by FTP to any user-specified FTP server. - Choose to create SQL files for each table or one for each database - No system calls, everything in 100% pure PHP.

The CSV Importer component is the only tool that offers you the shortcut to maintain your MySQL database. Using CSV format file, everything is easy to work around with data that you have updated using spreadsheet software like Microsoft Excel. Key features: import csv file wizard, specify separator, onscreen columns & data viewing, select database to import and column matching, append / replace existing records / update using primary key. To backup your valuable data, you have the options to export only fields that you need from the selected table or simply export all of them to your local computer. Best of all, Comdev CSV Importer comes with Undo Import functionality that lets you preview lastest imported data, last backup data and undo import to restore all data. Packed with web based installation wizard that eases your pain from complicated configuration. Take advantage of our FREE Installation Support, get your copy today!

doSQL() is a PHP4 script that can dump data back from a SQL text file (generated by backupDB() (also available on this site), phpMyAdmin, or similar) to a new database, or run any number of SQL commands in batch mode. Detailed progress reporting, including time remaing, processing rate (text and graph available).

backupDB() is a PHP script that backs up MySQL tables and databases to a gzip'd file for easy daily backup. Can back up a single database and/or table, or all tables. Structure-only, complete-inserts optional. Can be called interactively or run as a cron job. Works well with doSQL() (also available on this site). Faster and more robust than phpMyAdmin's backup function.

With HMS_BACKUP you can make a backup of your MySQL-database. This backup can be sent by e-mail or uploaded through FTP. This script doesn't need privileges to execute *nix commands. It's 100% pure PHP.

FX.php is a PHP class which combines the ease-of-use of FileMaker with the power of PHP. In the latest release, FX.php allows access to every version of FileMaker since version 5, and preliminary support has been added for MySQL. FX.php is designed to give FileMaker users the advantages and flexibility of using PHP. In addition, the new MySQL support adds the option of using data from multiple data sources, without knowledge of SQL.

phpMyForms is a php script which allows the user to create simple database listings (done in 3 lines of configuration), or simple dataset manipulation formulars (~10 lines) by adjusting small php config files. automatic browsing controls and optional validation scripts are included in version 0.3

Using a unique database design I have developed a php class to have a completly text file database system. Just some of the functions included in the class are for: add/edit/delete records, add/edit/delete tables, sorting a database using a given field, and many more usful functions. This class is very usful for developers wanted to make applications for servers that do not support mySQL or something similar. Tutorials are available from our site.<br><b>Update</b>: version 4.3.3 includes limiting the query() results, editfield() and removefield() were also added.

phpFriendlyAdmin is a remote database administration tool made specifically for non-technical people. After your database is set up, phpFriendlyAdmin is then configured to abstract database structure, making it easier for users to focus on manipulating content. Every field and table is given an alias and a description so as to bypass the complexity of interacting with database variables and offer a simplified form-driven approach to data entry.

A litte tool to create an alter-script for the differences between two databases. Since 1.4.0 InnoDB FOREIGN KEYS are supported. MySQLdiff 1.5.0 added support for FULLTEXT Indexes so a auto_increments. There was also added the (experimental) feature to upload sql-scripts to compare them against another script or an existing database.