ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:updateblob

updateBlob

Support for this function is limited. See the Feature Comparison Matrix

Syntax
mixed updateBlob(
    string $tableName,
    string $columnName,
    string $blobValue,
    string $whereStatement,
    optional string $type='BLOB'
)

Description

The function updateBlob() updates a column specified by $columnName in an row of a table, specified by $tableName with a value specified by $blobValue.

$where

The where statement must match a row, or set of rows in the table.

$type

The only acceptable values for $type are BLOB or CLOB


Usage

/*
 * Connection assumed
 */
$tableName = 'images';
$columnName = 'image_data';
 
$fd = file_get_contents('/temp/test.jpg');
$blob = $db->blobEncode($fd);
 
$db->updateBlob($tableName,$columnName,$blob,"ID=140")
v5/reference/connection/updateblob.txt · Last modified: 2016/01/17 01:58 by mnewnham