 |
Sponsors |
|
|
 |
|
|
|
|
|
| |
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.
|
Free
Version: 1.0.4 Platform(s): linux, windows, freebsd, osx, sun Updated: Fri Sep 28 2007 |
|
|
|
|
  |
|
Member Reviews (0) |
|
 |
|
Visitor Ratings |
|
 |
|
|
|
|
|
|
|
| |
This script lets you dump a whole local database and load it to a remote host (or vice-versa).
The differences between this script and the others are:
* supports tables, views, Stored Procedures, triggers and constraints;
* is inter-dependency aware;
* is error tolerant;
* very easy to install -- it's a single file.
transSQL dumps the whole database: tables, views, stored procs, triggers, constraints... the works.
The script knows that a view depends on tables or other views. It is also aware that two tables can be linked to one another via a foreign key.
When loading, unless instructed otherwise, the script will continue working even if errors occur. In that case, it prints the error message and the statement that caused it (so you can correct it later).
transSQL is a single file. Just copy it to your server's webroot and everything (should) work, as long as you have a proper PHP and MySQL installation.
|
Free
Version: 1.1 Platform(s): linux, windows Updated: Wed Sep 26 2007 |
|
|
|
|
| |
|
Member Reviews (1) |
|
 |
|
Visitor Ratings |
|
 |
|
|
|
|
|
|
|
| |
This set of scripts can be used, with minor customization, to access multiple MySQL databases (hence, "DBDB"), even at different servers (if they are accessible from the web server where these scripts run), for displaying data in multiple tables of said databases. At this time, only SQL SELECT queries are supported.
But you can execute Joins, use Group By, Order By, etc.
My central purpose in writing these scripts was to be able to access my seven different databases, on 6 different servers, quickly and with a minimum of
logging in, using passwords for each database, etc.
This is a very light-weight application and responds quickly and effortlessly.
The code is not sophisticated and could no doubt be improved, using OOP and other techniques, but the fact is it works quite well, as it is, and doesn't require any special libraries and such.
|
Free
Version: 1.0 Platform(s): linux, windows, freebsd, osx, sun Updated: Mon Aug 27 2007 |
|
|
|
|
| |
|
Member Reviews (0) |
|
|
|
Visitor Ratings |
|
|
|
|
|
|
|
|
|
| |
Coding data access methods in PHP for the MySQL we very often come across the same connect, fetch, query and other methods.
Here is a php script which creates a class for DB access, called DBprocess, and in a way makes inserts, updates, selects and all that easier, and importantly from re-usable code. This script will be a basic data layer implementation.
|
Free
Version: 1.0 Platform(s): linux, windows, freebsd, osx, sun Updated: Wed Aug 8 2007 |
|
|
|
|
| |
|
Member Reviews (0) |
|
|
|
Visitor Ratings |
|
 |
|
|
|
Share |
|
