Top Rated Scripts | PHP | Scripts & Programs | Database Tools

ext_shapelib provides access to Shapefiles (.shp/.shx/.dbf) as used in GIS applications. Currently, creating of new files and adding shapes to those files is supported, however, full shapelib support is planned for upcoming releases.

Using Galistudio's db_driver, you can easily interface your MySQL database to connect or run queries, and you can also alter your database structure. By providing routines for more than the basics, you use less SQL, thus enabling your code to interface more DBMS'

Datafeed - to - MySQL is designed to parse properly formatted tab, comma, pipe, semi-colon, colon, tilde, and star delimited datafeeds into MySQL table format. It will detect errors in the feed and attempt to fix them or ignore them. Excellent to transform affiliate datafeeds into a MySQL table. Online demo available.

CSV Import module allows admin users to load / import listings with images into website database from Comma Separated Value (CSV) files. Using this tool you can quickly and easily import large quantities of listings into multiple categories (as long as they use the same fieldset) and multiple regions. This module can help dealers to have their inventory uploaded in bulk. It is well-known that dealers and power sellers can fill your website with a lot of listings, but they can't waste time placing one ad at a time. With administrator's assistance dealers can prepare their stock for mass upload into your system. You can provide them with a template (CSV file or Excel form), they fill it in and send to you. If you got it as Excel speadsheet, you export the data from Excel to CSV file. CSV file can be imported in Admin Area, where you can specify user ID, target category (or categories), set imported listings expiration time and assign them to certain price plan.

vpSQL is a small set of functions (under 13k) that interacts with a flat file database through a subset of sql instructions. vpSQL accepts the the following sql statements: SELECT fields FROM table[WHERE][ORDER BY][lLIMIT] INSERT fields,data INTO table UPDATE table fields/data WHERE DELETE from table WHERE Features of vpSQL: An autoinc field named vpid which is transparently created with each table. This gives the advantage of having a unique field for searches. Uses character substitution for semi colons and linefeeds which allows you to store full page texts. It is small and uses only one file which can be included anywhere in your script. The functions mimic php mysql functions so they are scalable.

This is like Table Indexing compared to MySQL's column indexing. Complete Documentation included

I use three class vars and five methods to connect, query, insert and update a MySql database. This cleans up your source code and decreases script development time. The focus was on displaying MySql data so I could take advantage of Dynamic webpages. This class has scripts written to work with it too. The only thing lacking is a complex input validation. I used strip tags and special chars for basic protection. I included directions on how to add and use your own validation method.

xls2mysql is the first and only PHP application to perform data conversion from xls to mysql. xls2mysql is shipped with a simple but easy to understand DHTML interface : one tab enables file uploading, the other displays the list of all files in the recipient directory. As such you can try the process many times without re uploading your files.

Flat-file database management system written in PHP, using MySQL syntax.

This parser will parse the contents of mysqldump file into an associative array. The array contains table definition information include primary key, table name, field name, default value and datatype. Also compatible with phpMyAdmin(structure only) export format.

With Form1 Builder MYSQL you can automatically have form submission data added to your MYSQL database with protection against form hijacking, email injection and email harvesting. To use the MYSQL option you must have a server based MYSQL database and it must have an existing table with field names that correspond to form field names. On form submission a new record is added to the MYSQL database table and MYSQL database table fields that have the same name as form fields will include the input values from the form field. Additional form variables can be added to the MYSQL table by including a field in the MYSQL table that has the same name as the field to be included. You can also include a range of User and Cookie Variables for automatic import into the MYSQL database. Form1 (the generated form code) runs on your web server. To run Form1 your server must support the php scripting language. Most commercial web servers support php.

This is a simple wrapper class that can be used to access SQL databases using the PDO API. It can establish connections, execute direct or prepared SQL queries, retrieve the all query results into a single array, begin, commit and rollback transactions.

SQLData is an extension of the DB class that is meant to provide object-relational mappings to store and retrieve persistent objects in a SQL database. The class comes with additional scripts for generating classes that can be used by applications to access given database table using the SQLData class as means to store and retrieve data with SQL statements. These scripts are meant to run from the command line. They retrieve the definitions of a given database table and then the generate classes to access the table rows as objects or to manipulate them via Web forms. Experience has shown that the automatic generation handles about 80% of the repetitive work involved in building classes and forms. SQLData was designed to make it easy to automate the construction of the application specific classes interfacing to SQL tables. SQLData supports all databases supported by the DB class, currently MySQL and PostgreSQL 8.0 and up.

Fix Collate or Collation problem on MySQL database, table and fields.

This version of dm.DB adds PostgreSQL 8.0 and 8.1 support to the existing MySQL support. dm.DB provides an interface to SQL compliant databases that is independent of the underlying database API. Currently support for: MySQL PostgreSQL 8.0 PostgreSQL 8.1 is provided. Additional support has been added to allow SQLData to support all dm.DB supported databases.

The class takes a MySQL query result handle and retrieves the query result column names and the query result data. The class generates the definition of a JavaScript object in JSON that contains an array of a rows of query result data.

Create PDF reports from MySQL tables, using a customizable, Flash 7-based layout builder.

This class can be used to search for data in MySQL database table text fields. It executes one or more SQL SELECT queries to search for given keywords in different text fields of the same MySQL database table. The class returns an array with the values of primary keys of the table records returned by the queries. Duplicate record entries are eliminated.

This handy little script allows you to fully back up a given MySQL database utilizing the command line scripts (CRON). This script will automatically email you your database contents on the schedule you set. The instructions included will walk you right through the process! It's that easy to keep your database backed-up in case disaster strikes! Perfect for mission critical databases or for simply making sure you have the latest info to reinstall the database.

This class wraps common MySQL database table SQL queries. It can: - Perform SELECT queries and retrieve a single value, a single row into an array and all rows into a multidimensional array. - Insert or update rows from a list of fields and values - Delete table rows that satisfy a condition - Count records in a given table - Check if a table record exists with a given field value