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 updateBlobFile() updates a column specified by $columnName in an row of a table, specified by $tableName directly from a file on disk with a path specified by $fileName.

The physical file must be resident on the server from which the script is run, not the workstation.

$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';
 
$fileName = '/temp/image.jpg';
$db->updateBlob($tableName,$columnName,$fileName,"ID=140")