New Scripts | PHP | Scripts & Programs | Database Tools

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.

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

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 a simple script that will create a mysqldump of your database and upload it to a ftp server. This can be configured to determine which database (or all) you want to backup, where you stock it locally and where you upload it.

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.

The page navigation (pagination) of lists with records from a (MySQL) database is often used on a lot of dynamic websites. This class is extremely easy to use in your existing application: just use your own SQL statement and voila you get information like the result set (you need this for later output, page navigation links and the (current) number of records. While using this class all other query string parts are included inside the page links. An example database table (with data) is included. New in Version 1.03: There is a new variable $max_rows, this variable is used to limit the maximum of results during a query. That will say if there are more rows then the number of $max_rows only the last one will show up. Use the new variable $outstanding_rows if you need to inform the user about that.

This is a function to convert a user's query in boolean syntax ("hotels AND mexico NOT cockroaches) into a SQL query over the appropriate database fields.

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.

LabStoRe is a modular, optionally account-based, inventory or LIMS system that provides a way to collect, maintain, present and archive information on laboratory stocks and records. A laboratory with a good inventory, or better, information system, saves time, reduces errors, prevents wastage, and occasionally even provides insights. The interface to this system is web-based, making it conveniently accessible and even though it is web-based, embedded security measures make it secure. Being PHP/MySQL-based, the system is very flexible (imagine making Excel behave in a way that you want). The database (MySQL-based) is kept separate from the interface (web, i.e., PHP/HTML-based), which gives it a significant advantage over, say, an Excel- or Filemaker-based system. MySQL and PHP are very stable, widely-used and supported (and free) platforms. If required, the database can be exported for use in more-traditional application based systems (Excel, Access, Filemaker, etc.).

A class for very basic MySQL database connectivity. Written to reduce redundant code in my own projects aswell as aid in debugging and error reporting during the developement phase. Currently connects to a database, execute external files containing SQL commands, insert and update from an array of key => value pairs, insert and update with sql command, query (one result), query (multiple rows), and dump a select query to a table. The zip file contains the class aswell as a demonstration script.

AbstractDB is a PHP database abstraction layer, objected oriented and extensible via driver implementations which extend from a common base class. This package encapsulates all of the basic functions required by most developers without the complexity and/or utter simplicity of many other abstraction packages. Incorporating AbstractDB into your applications is as easy as including a single file. AbstractDB is currently only distributed with a driver for MySQL but can easily be extended for use with other database servers or even other abstraction libraries.

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'

The Flatfile package is a simple, light method of storing and retrieving data in tables with SQL-like features. All data is stored in tab-delimited text flat files. It supports a very powerful and extensible WHERE clause mechanism, which can be used with SELECT, UPDATE or DELETE statements. It can do ORDER BY on any number of fields, and includes full documentation with examples that should have you up and running in a couple of minutes.

MyCSV� is a PHP Library for fast and simple text databases that no require anything more that PHP 4.0.0. Library include API, Blueprint and Front-End Application to understand the utility of the tool. MyCSV use csv standart format.

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.

This is a Simple CSV Upload script that makes use of the 'LOAD INFILE' Query of MySQL. This is a script which can upload CSV (Comma separated values) file to the database, provided that the the fields in the file match the fields of the database provided in the configuration, irrespective of the database structure. Features * Upload Files and retain them * Loads data irrespective of the database structure

A simple PHP class to manage all sqlite database related operations, including database creation, queries, etc.

ezSqliteAdmin is a tool written in PHP & XUL intended to handle the administration of SQLite over the Web. It requires PHP >= PHP5.0.0 & Mozilla platform to run.

MySQL Dialog is a simple MySQL database access wrapper class to execute SQL queries and display the results in HTML tables. The class connects to a MySQL server, sends SQL statements, and gets the results as an array. A table with the data from the result sets can also be displayed. The class may optionally return error messages on failure based on the mysql_error() and user defined error messages.

Now includes detailed reporting - phpMySQLAutoBackup the simple way to backup MySQL databases - automates the backup of your MySQL databases. Exports your database (data and structures), compresses it into gzip format and emails it to you. Schedule it to run every day/week by adding it to a cron job, or use phpJobScheduler. New features include the ability to select separate tables for backup, and limit the backup to start and stop at pre-set table row numbers, this will now allow a section of a large table (with millions of records) to be selected for backup. Features: * option to ftp backup file to remote server * email zipped database to your specified address * option to save to backup folder * backup limited to once per hour (easily changed) prevents malicious attempts at bringing down your server * specify specific tables to include or exclude, or backup the whole database * set ranges to backup - from start row number to last specified row number