|
ADOdb Database Library for PHP
|
| Link ID |
2238 |
| Title |
ADOdb Database Library for PHP |
| Url |
http://adodb.sourceforge.net/ |
| Description |
A PHP4 and PHP5 database abstraction library. Supports MySQL, PostgreSQL, Interbase/Firebird, Oracle (Oci8), MS SQL 7, ADO, Foxpro, Access, Sybase, Sybase SQL Anywhere, DB2, Informix, Frontbase, SQLite, LDAP, Netezza, SAPDB, generic ODBC/ODBTP, etc. ADOdb provides code to handle inserts and updates that can be adapted to multiple databases quickly. A basic paginated grid is also provided, and support for database-backed session variables. Support for PHP5 iterators and exceptions included.Methods are provided for date handling, string concatenation and string quoting characters for differing databases. A metatype system is built in so that you can figure out that types such as CHAR, TEXT and STRING are equivalent in different databases. Able to create databases, tables, indexes portably using an xml schema or programatically. Also has sql performance monitoring and schema creation using XML. |
| Category |
PHP > Scripts and Programs > Database Tools |
| Date |
Jun 30, 2006 |
| Contact Name |
|
| Email |
|
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
|
Official Review
NULL
|
Other links at PHP > Scripts and Programs > Database Tools |
| 1. |
Appgini PHP Generator For MySQL
|
|
|
Instantly create PHP web database applications that let users view, sort, search and edit data of a MySQL database easily from a single web page. You can customize the look of the generated files using CSS. You can define foreign key fields that let you e
|
| 2. |
Simple SQL
|
|
|
DESCRIPTION:Simple SQL provides functions to retrieve single fields or rows of a table, insert rows given arrays of column names and values, update single fields of a given table row, delete given table rows and many other common needs.ADVANTAGES:- This PHP class file will eliminate nearly all code from the built in std mysql PHP functions.- Speed, it will dramatically decrease development and execution time.- Extremely easy to use; one hardly has to understand the MySQL syntax.- It automatically determines whether or not there is an open connection to the MySQL server. It will connect and reconnect automatically.- The built in debugging functions make it easy to solve syntax error and logic error.- Supports arrays for arguments and returns ASSOC arrays from the DB with indexes.- Stores resource links and common variables such as the last table used.
|
| 3. |
QuB PHP :: Visual SQL Queries for Dreamweaver
|
|
|
For a dynamic 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. Unlike other tools, QuB manages tables, relations and conditions for queries in your web browser. Features: --Integrated Dreamweaver Recordset support; --Ease of use; --Increased productivity; --Tight database integration; --Automate SQL query generation; --Visual Query Editing; --All Dreamweaver server models support (PHP, CFM, ASP, .NET, JSP); --Support for various database servers.
|
| 4. |
MySQL Database Optimizer
|
|
|
MySQL Database Optimizer is a PHP script that allows you to optimize all tables of a given MySQL database.
|
| 5. |
table exists
|
|
|
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.
|
|
|
