function getProject($project_id) { $project = []; $ConnectionManager = new ConnectionManager(); $conn = $ConnectionManager->getConnection(); $stmt = $conn->prepare("SELECT * FROM project WHERE project_id=?"); $stmt->bind_param("s", $project_id); $stmt->execute(); $stmt->bind_result($project_id, $project_name, $type, $year, $country, $location, $size, $completion_date, $description); while ($stmt->fetch()) { $project['project_id'] = $project_id; $project['project_name'] = $project_name; $project['type'] = $type; $project['year'] = $year; $project['country'] = $country; $project['location'] = $location; $project['size'] = $size; $project['completion_date'] = $completion_date; $project['description'] = $description; } $ConnectionManager->closeConnection($stmt, $conn); $photoMgr = new PhotoManager(); $photo_arr = $photoMgr->getPhotosByProject($project_id); $project['photo_arr'] = $photo_arr; return $project; }
$type = strstr($hdPicname, '.'); if ($type != ".gif" && $type != ".jpg" && $type != ".png") { echo 'invalid image type'; exit; } $rand = rand(1000, 9999); $pics = date("YmdHis") . $rand . "hd" . $type; if (!file_exists("public_html/img/projectImg/" . $edit_id)) { mkdir("public_html/img/projectImg/" . $edit_id, 0777, true); } $pic_path = "public_html/img/projectImg/" . $edit_id . "/" . $pics; move_uploaded_file($_FILES[$hdId]['tmp_name'], $pic_path); if ($photoMgr->getSpecificPhotoURL($edit_id, "hd" . strval($x)) !== '') { $photoMgr->updateSpecificPhoto($edit_id, "hd" . strval($x), $pic_path); } else { $photoList = $photoMgr->getPhotosByProject($edit_id); $index = intval(sizeof($photoList) / 2) + 1; $photoMgr->AddPhoto($edit_id, "hd" . strval($index), $pic_path); } } $thumbnailPicname = $_FILES[$thumbnailId]['name']; if ($thumbnailPicname != "") { $type = strstr($thumbnailPicname, '.'); if ($type != ".gif" && $type != ".jpg" && $type != ".png") { echo 'invalid image type'; exit; } $rand = rand(1000, 9999); $pics = date("YmdHis") . $rand . "thumbnail" . $type; if (!file_exists("public_html/img/projectImg/" . $edit_id)) { mkdir("public_html/img/projectImg/" . $edit_id, 0777, true);