ADOdb

ADOdb & Oracle - [In and Out Parameters]

mnewnham (mnewnham@undisclosed.example.com) — 2026-03-25T01:21:34+00:00

This needs fixing ADOdb & Oracle Author Credit (c) 2004-2014 John Lim Description Using ADOdb with PHP and Oracle: an advanced tutorial Introduction Oracle is the most popular commercial database used with PHP. There are many ways of accessing Oracle databases in PHP. These include:

Stored Procedure Example - [Step 2: Setting Parameters] Names & Values are transposed

mnewnham (mnewnham@undisclosed.example.com) — 2026-03-24T16:52:12+00:00

Stored Procedure Example Description This example shows the creation of a basic stored procedure and accessing it using ADOdb The Procedure This procedure uses the IBM DB2 SAMPLE database. It performs the following functions: * Accepts 2 input parameters, a 6 character keyword and 20 character name

metaProcedures

mnewnham (mnewnham@undisclosed.example.com) — 2026-03-24T01:50:39+00:00

metaProcedures See Also prepareSp Syntax function metaProcedures( optional string $namePattern=null, optional string $catalog=null, optional string $schemaPattern=null ) Description The function metaProcedures() returns a list of stored procedures in a database. Some databases do not support stored procedures. The function returns an array or false if the database does not support stored procedures or there are currently no stored procedures.

Adding Comments To Tables

mnewnham (mnewnham@undisclosed.example.com) — 2026-03-22T22:45:50+00:00

Adding Comments To Tables Database support for adding comments varies from full support (IBM DB2, PostgreSQL) to none (SQLite) with differing implementation methods. Databases that support it do it via 1 of 2 methods, Either be adding the comment as part of the table creation and modification process, or by adding a comment to a previously created table. In addition, databases have varying levels of support for adding comments to tables, columns and indexes. The following matrix shows available…

updateBlobFile

mnewnham (mnewnham@undisclosed.example.com) — 2026-03-20T00:47:41+00:00

updateBlobFile Support for this function is limited. See the Feature Comparison Matrix Syntax mixed updateBlobFile( string $tableName, string $columnName, string $fileName, string $whereStatement, optional string $type='BLOB' ) Description The function

blobDecode

mnewnham (mnewnham@undisclosed.example.com) — 2026-03-20T00:27:59+00:00

blobDecode Syntax mixed blobDecode( string $blob ) Description The function blobDecode() decodes a blob field and returns the value of the field or false if the function fails. ---------- Usage $SQL = "SELECT blob_field FROM table"; $blob = $db->blobDecode($db->getOne($SQL)); file_put_contents('/temp/stored.jpg',$blob);

The MetaType - [Actual Types]

mnewnham (mnewnham@undisclosed.example.com) — 2026-03-13T17:56:31+00:00

Introduction Start Of Lesson MetaColumns The MetaType The lowest level of information that ADOdb supports is the MetaType. This object represents the type of field in a consistent, simplified format. Actual Types Data is stored in the database in fields that best represent the type of data, e.g. Integer, character, floating point. These types may be subclassed further, e.g Small,Medium,Large integers. In addition, there may be estoric field types such as geometry, points etc. ADOdb refers …

Integer MetaTypes

mnewnham (mnewnham@undisclosed.example.com) — 2026-03-12T03:47:09+00:00

Integer MetaTypes Size Table Meta TypeTypeStorage SizeSigned RangeUnsigned RangeI1TINYINT1 byte-128 to 1270 to 255I2SMALLINT2 bytes-32,768 to 32,7670 to 65,535I4MEDIUMINT3 bytes-8,388,608 to 8,388,6070 to 16,777,215IINT / INTEGER4 bytes-2,147,483,648 to 2,147,483,647

x-logo-black.png - created

dregad (dregad@undisclosed.example.com) — 2025-08-04T10:46:03+00:00

ebnf.png - created

dregad (dregad@undisclosed.example.com) — 2024-12-18T14:05:06+00:00

lego.png - removed

dregad (dregad@undisclosed.example.com) — 2024-05-01T14:27:05+00:00

performance-suspicious-sql.png - created

dregad (dregad@undisclosed.example.com) — 2024-03-21T15:06:03+00:00

performance-invalid-sql.png - created

dregad (dregad@undisclosed.example.com) — 2024-03-21T15:06:03+00:00

performance-expensive-sql.png - created

dregad (dregad@undisclosed.example.com) — 2024-03-21T15:06:03+00:00

adodb_pager_sample_output.png

dregad (dregad@undisclosed.example.com) — 2023-05-12T15:56:56+00:00

mastodon-logo.svg - created

dregad (dregad@undisclosed.example.com) — 2023-05-06T11:22:11+00:00

debug_output_styled.png - created

dregad (dregad@undisclosed.example.com) — 2023-04-08T11:06:05+00:00