Beispiel #1
0
 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;
 }
Beispiel #2
0
     $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);