ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== updateBlobFile ======
~~NOTOC~~
<WRAP info>
Support for this function is limited. See the [[v5:database:feature_comparison|Feature Comparison Matrix]]
</WRAP>
<WRAP right box>
== Syntax ==
  mixed updateBlobFile(
      string $tableName,
      string $columnName,
      string $fileName,
      string $whereStatement,
      optional string $type='BLOB'
  )
</WRAP>


===== 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''.
<WRAP tip 300px>
The physical file must be resident on the server from which the script is run, not the workstation.
</WRAP>
===== $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 =====
<code php>
/*
 * Connection assumed
 */
$tableName = 'images';
$columnName = 'image_data';

$fileName = '/temp/image.jpg';
$db->updateBlob($tableName,$columnName,$fileName,"ID=140")
</code>