php - 如何停止将空路径存储到数据库？

Question

while(file_exists($desktop_filename_1280x800 = strtolower($desktop_dir_1280x800 . 'wall_desktop_1280x800_' .
$_FILES[$desktop_fieldname_1280x800]['name'])));

上面的代码生成类似于以下的路径:../../images/desktop_walls/1280x800/wall_desktop_1280x800_

INSERT INTO walls(d_1280x800_path) VALUES ($desktop_filename_1280x800);

上面的查询将其存储到数据库中。

我想做的是阻止它存储到数据库，因为它是一个空路径。我只想存储最后包含.jpg .png 的路径。

Answer 1

检查值是否不为空。不为空，插入。

while(file_exists($desktop_filename_1280x800 = strtolower($desktop_dir_1280x800 . 'wall_desktop_1280x800_' .
$_FILES[$desktop_fieldname_1280x800]['name'])));

if (!empty(trim($desktop_filename_1280x800))) {
  INSERT INTO walls(d_1280x800_path) VALUES ($desktop_filename_1280x800);
}