问题描述
我正在使用SelectQuery对象来检索和显示用户列表,但我不知道从哪里获取用户的图片。
I'm using a SelectQuery object to retrieve and display a list of users, but I don't know where to get the user's picture from.
用户表有一个名为图片的列,但是其中的数据只是一个整数。图片是否存储在某个地点的blob字段中,或者是否有另一个表格中的图片链接?
The users table has a column called picture, but the data in there is just an integer. Is the picture stored in a blob field somewhere or is there a link to the picture in another table?
推荐答案
图像文件本身通常存储在 / sites / default / files
中的某个地方。对该图像的引用存储在 file_managed
表中,用户中的
表格包含图片的图片
列 fid
(文件ID)。
The image file itself is stored (usually) somewhere in /sites/default/files
. The reference to that image is stored in the file_managed
table, the picture
column in the users
table contains the fid
(file id) of the picture.
您可以加载文件对象,如下所示:
You can load the file object like this:
$file = file_load($fid);
并获取图像的输出如下:
And get the output for the image like this:
$image = theme('image', array('path' => $file->uri, 'alt' => 'Alt text'));
这篇关于用户的图片存储在Drupal 7中?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!