Drupal 7 中用户的图片存储在哪里?
我正在使用 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.
users 表有一列叫图片，但里面的数据只是一个整数.图片是否存储在某个 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 表中，users 表中的 picture 列包含 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'));
相关文章