PHP DB_pgsql Examples

Example #1

File: db_Wrap.class.php Project: BackupTheBerlios/sotf-svn

 /** UPDATE $table SET $field = '$binary' WHERE $idKey = '$id' */
 function setBlob($table, $id, $idKey, $field, $binary)
 {
     debug("DB", "setBlob: Table: {$table}, ID: {$id}, IDKey: {$idKey}, Field: {$field}");
     parent::query("UPDATE {$table} SET {$field} = '" . $this->escape_bytea($binary) . "' WHERE {$idKey} = '{$id}'");
 }

Example #2

File: db_Wrap.class.php Project: BackupTheBerlios/sotf-svn

 /** Stores a binary object in database. UPDATE $table SET $field = '$binary' WHERE $idKey = '$id' */
 function setBlob($table, $id, $idKey, $field, $binary)
 {
     parent::query("UPDATE {$table} SET {$field} = '" . $this->escape_bytea($binary) . "' WHERE {$idKey} = '{$id}'");
 }