Warning: file_put_contents(C:\xampp\htdocs\ecc-web/logs/access.log): Failed to open stream: No such file or directory in C:\xampp\htdocs\ecc-web\cloak.php on line 57
prepare('SELECT * FROM news ORDER BY NewsDate DESC'); $DatabaseReader->execute(); $data = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $DatabaseReader = NULL; $DatabaseReader = $pdo->prepare('SELECT * FROM events '); $DatabaseReader->execute(); $events = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $DatabaseReader = NULL; $projects = array(); $ImageArray = array(); foreach ($data as $i => $D) : if ((int)$i < 6) { $ImageArray[] = $D['NewsImage']; } endforeach; $DatabaseReader = $pdo->prepare('SELECT * FROM `projects` WHERE id=(SELECT max(id) FROM `projects` WHERE ProjectType="Water sector" )'); $DatabaseReader->execute(); $WaterSector = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $projects[] = $WaterSector; if (!empty($WaterSector[0]['ProjectImage'])) { $ImageArray[] = $WaterSector[0]['ProjectImage']; } $DatabaseReader = $pdo->prepare('SELECT * FROM `projects` WHERE id=(SELECT max(id) FROM `projects` WHERE ProjectType="Transport sector" )'); $DatabaseReader->execute(); $TransportSector = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $projects[] = $TransportSector; if (!empty($TransportSector[0]['ProjectImage'])) { $ImageArray[] = $TransportSector[0]['ProjectImage']; } $DatabaseReader = $pdo->prepare('SELECT * FROM `projects` WHERE id=(SELECT max(id) FROM `projects` WHERE ProjectType="Building sector" )'); $DatabaseReader->execute(); $BuildingSector = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $projects[] = $BuildingSector; if (!empty($BuildingSector[0]['ProjectImage'])) { $ImageArray[] = $BuildingSector[0]['ProjectImage']; } $DatabaseReader = $pdo->prepare('SELECT * FROM `projects` WHERE id=(SELECT max(id) FROM `projects` WHERE ProjectType="Housing sector" )'); $DatabaseReader->execute(); $HousingSector = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $projects[] = $HousingSector; if (!empty($HousingSector[0]['ProjectImage'])) { $ImageArray[] = $HousingSector[0]['ProjectImage']; } $DatabaseReader = $pdo->prepare('SELECT * FROM `projects` WHERE id=(SELECT max(id) FROM `projects` WHERE ProjectType="Agriculture sector" )'); $DatabaseReader->execute(); $AgricultureSector = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $projects[] = $AgricultureSector; if (!empty($AgricultureSector[0]['ProjectImage'])) { $ImageArray[] = $AgricultureSector[0]['ProjectImage']; } $DatabaseReader = $pdo->prepare('SELECT * FROM `projects` WHERE id=(SELECT max(id) FROM `projects` WHERE ProjectType="Machinery sector" )'); $DatabaseReader->execute(); $MachinerySector = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $projects[] = $MachinerySector; if (!empty($MachinerySector[0]['ProjectImage'])) { $ImageArray[] = $MachinerySector[0]['ProjectImage']; } $DatabaseReader = $pdo->prepare('SELECT * FROM `projects` WHERE id=(SELECT max(id) FROM `projects` WHERE ProjectType="CPDI sector" )'); $DatabaseReader->execute(); $CPDISector = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $projects[] = $CPDISector; if (!empty($CPDISector[0]['ProjectImage'])) { $ImageArray[] = $CPDISector[0]['ProjectImage']; } $DatabaseReader = $pdo->prepare('SELECT * FROM `projects` WHERE id=(SELECT max(id) FROM `projects` WHERE ProjectType="Input Productions sector" )'); $DatabaseReader->execute(); $InputProductionsSector = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $projects[] = $InputProductionsSector; if (!empty($InputProductionsSector[0]['ProjectImage'])) { $ImageArray[] = $InputProductionsSector[0]['ProjectImage']; } //For HomePage Image $DatabaseReader = $pdo->prepare("SELECT * FROM homepageimage"); $DatabaseReader->execute(); $HPImage = $DatabaseReader->fetchAll(PDO::FETCH_ASSOC); $DatabaseReader = NULL; $count = 0; $currentTimeECWC = strtotime(date("Y-m-d H:i:s")); foreach ($events as $i => $D) { $timeECWC = strtotime($D['Date']); if ($currentTimeECWC < $timeECWC) { $count = 1; } } ?>