doupian6118 2016-10-12 18:00
浏览 23

列出文件夹中缺少图片的名称

I am trying to list the names of employees that do not have their profile pic. I use the following query to list all of the employees:

mysql_select_db($database_schedule, $schedule);
$query_Recordset7 = "SELECT DISTINCT schedule.ID, schedule.Name, schedule.Department 
FROM schedule
ORDER BY schedule.Name";
$Recordset7 = mysql_query($query_Recordset7, $schedule) or die(mysql_error());
$row_Recordset7 = mysql_fetch_assoc($Recordset7);
$totalRows_Recordset7 = mysql_num_rows($Recordset7);

I want to now only list or echo employee names that do not have their profile pic in a folder labeled pics/. The profile pics are jpg's with the filename with the same name as their employee ID. e.g. ID-5530 would have a pic file labeled 5530.jpg. I tried using the following. It still echoes all the employee names (even the names with a matching pic file):

<?php
$ID = $row_Recordset7['ID'];
$image = 'pics/' . $ID . '.jpg';

if (!file_exists($image)) {
echo $row_Recordset7['Name'];
}else{                                      
echo "";
}
?>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 微信小程序协议怎么写
    • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看