Fields file in BLOB

[tom-over]

Hi,

How are encrypted fields "file" metamodel? Blob ?

Because I have to make a query in a php file and I can not display the URL of the file filled in the metamodel catalog.

$sql = "SELECT CONVERT(file USING utf8) fileutf8 FROM mm_table WHERE .....";
...
...
$data = mysql_fetch_assoc($result);
echo "File : ". $file = $data['fileutf8']; 

I have a "id".
But the "id" don't have a link with the good files in table of contao tl_files !

[Messa]

This post should help you

https://community.contao.org/de/show...l=1#post333333

For Blob:

$image = deserialize($blob);

For Uuid:

$image =  \FilesModel::findByUuid($uuid)->path;

For Id:

$image =  \FilesModel::findByPk($id)->path;

Best regards
Matthias

[tom-over]

Thank you.

But I don't understand because is not the good file is read ! ? !

echo "File : ".serialize($file); 

Result = s:2:"9";

The id '9' is a not a good file

I don't understand why...

[do_while]

Because, if there is a multiple checkbox or select field, then it is a serializied array of the checked/selected IDs.