ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:connection:updateblobfile

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:reference:connection:updateblobfile [2016/01/17 02:28] – ↷ Page moved from v5:reference:updateblobfile to v5:reference:connection:updateblobfile mnewnhamv5:reference:connection:updateblobfile [2026/03/20 01:47] (current) – mnewnham
Line 17: Line 17:
  
 ===== Description ===== ===== 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 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''. For BLOB files, the file is encoded in an appropriate manner before storage. No additional action is required.
 <WRAP tip 300px> <WRAP tip 300px>
 The physical file must be resident on the server from which the script is run, not the workstation. The physical file must be resident on the server from which the script is run, not the workstation.
 </WRAP> </WRAP>
 +===== $table =====
 +The table where the LOB is to be stored
 +===== $column =====
 +The column where the LOB is to be stored. The column should be of an appropriate type to store the data format required (see below)
 +
 ===== $where===== ===== $where=====
-The where statement must match a row, or set of rows in the table.+The $where statement should match a unique row in the table.
 ===== $type ===== ===== $type =====
 The only acceptable values for $type are ''BLOB'' or ''CLOB'' The only acceptable values for $type are ''BLOB'' or ''CLOB''
Line 37: Line 42:
 $db->updateBlob($tableName,$columnName,$fileName,"ID=140") $db->updateBlob($tableName,$columnName,$fileName,"ID=140")
 </code> </code>
 +===== Column Support For BLOB and CLOB =====
 +^Database^ CLOB ^ BLOB ^
 +^MetaType| X | B |
 +^MySQL| LONGTEXT| LONGBLOB |
 +^IBM DB2 | CLOB | BLOB(100M) |
 +^Oracle | CLOB | BLOB |
 +^SQL Server| TEXT | VARBINARY(MAX) |
 +^PostgreSQL | TEXT | BYTEA |
 +^SQLite | TEXT | BLOB |
 +
v5/reference/connection/updateblobfile.1452994114.txt.gz · Last modified: (external edit)