Photo Exporter

From 730b7cb0141e010ce91152420645ab0f55b452a2 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 25 Nov 2015 11:22:18 -0500 Subject: [PATCH 1/1] new sources for photo exporter --- index.php | 7 +++ mediaLibrary.php | 128 +++++++++++++++++++++++++++++++++++++++++++++++ photoGallery.php | 123 +++++++++++++++++++++++++++++++++++++++++++++ 3 files changed, 258 insertions(+) create mode 100644 index.php create mode 100644 mediaLibrary.php create mode 100644 photoGallery.php diff --git a/index.php b/index.php new file mode 100644 index 0000000..995fc18 --- /dev/null +++ b/index.php @@ -0,0 +1,7 @@ + +Photo Exporter + +Photo Gallery +Media Library + + diff --git a/mediaLibrary.php b/mediaLibrary.php new file mode 100644 index 0000000..d1a0567 --- /dev/null +++ b/mediaLibrary.php @@ -0,0 +1,128 @@ + PDO::FETCH_ASSOC, + ); + $dbh = new PDO($dsn, null, null, $driverOptions); + $dbh->setAttribute( + PDO::ATTR_ERRMODE, + PDO::ERRMODE_EXCEPTION + ); + $WHERE = (PHOTO_CATEGORY) ? "WHERE id IN (". PHOTO_CATEGORY .")" : ""; + $sql = " + SELECT * + FROM " . PHOTO_SCHEMA . ".photo_category + $WHERE + ORDER BY category"; + + $stmt = $dbh->query($sql); + + //echo '

'.print_r($stmt->fetchAll(), true).'

'; + //exit; + + $photoSql = " + SELECT p.* + FROM " . PHOTO_SCHEMA . ".photo p, + " . PHOTO_SCHEMA . ".photo2category p2c + WHERE p2c.category = :catid + AND p2c.photo = p.id + ORDER BY p2c.pos"; + echo '

' . print_r($photoSql, true) . '

'; + $photoStmt = $dbh->prepare($photoSql); + + $data = array(); + while ($category = $stmt->fetch(PDO::FETCH_ASSOC)) { + $folderName = cleanFileName($category['category']); + var_dump($folderName); + mkdir("images/{$folderName}", 0770); + $photoStmt->bindParam(':catid', $category['id']); + $photoStmt->execute(); + while ($photo = $photoStmt->fetch(PDO::FETCH_ASSOC)) { + echo '

'.print_r($photo, true).'

'; + $category['photos'][] = $photo; + // get the file extension for this image + $fileInfo = pathinfo($photo['image']); + //echo '

' . print_r($fileInfo, true) . '

'; + $fileName = ($photo['title']) ? cleanFileName($photo['title']) . '.' . $fileInfo['extension'] : $photo['image']; + var_dump($fileName); + $saveAsFileName = wp_unique_filename( "images/{$folderName}", $fileName); + var_dump($saveAsFileName); + //$saveAsFileName = "./images/{$folderName}/{$fileName}"; + grabImage(IMG_BASE_URL . $photo['image'], 'images/' . $folderName . '/' . $saveAsFileName); + //$fileName = $fileName . '.' . $fileInfo['extension']; + echo "

{$fileName}

"; + echo "

" . $folderName . '/' . $saveAsFileName . "

"; + //exit; + } + $data[] = $category; + } + //echo '

'.print_r($data, true).'

'; +} catch(PDOException $e) { + echo '

'.print_r($e, true).'

'; +} +umask($oldMask); diff --git a/photoGallery.php b/photoGallery.php new file mode 100644 index 0000000..794641c --- /dev/null +++ b/photoGallery.php @@ -0,0 +1,123 @@ + PDO::FETCH_ASSOC, + ); + $dbh = new PDO($dsn, null, null, $driverOptions); + $dbh->setAttribute( + PDO::ATTR_ERRMODE, + PDO::ERRMODE_EXCEPTION + ); + $WHERE = (PHOTO_CATEGORY) ? "WHERE id IN (". PHOTO_CATEGORY .")" : ""; + $sql = " + SELECT * + FROM " . PHOTO_SCHEMA . ".photo_category + $WHERE + ORDER BY category"; + + $stmt = $dbh->query($sql); + + //echo '

'.print_r($stmt->fetchAll(), true).'

'; + //exit; + + $photoSql = " + SELECT * + FROM " . PHOTO_SCHEMA . ".photo + WHERE catid = :catid"; + $photoStmt = $dbh->prepare($photoSql); + + $data = array(); + while ($category = $stmt->fetch(PDO::FETCH_ASSOC)) { + $folderName = cleanFileName($category['category']); + mkdir("images/{$folderName}", 0770); + $photoStmt->bindParam(':catid', $category['id']); + $photoStmt->execute(); + while ($photo = $photoStmt->fetch(PDO::FETCH_ASSOC)) { + echo '

'.print_r($photo, true).'

'; + $category['photos'][] = $photo; + // get the file extension for this image + $fileInfo = pathinfo($photo['image']); + //echo '

' . print_r($fileInfo, true) . '

{$fileName}

"; + echo "

" . $folderName . '/' . $saveAsFileName . "

"; + //exit; + } + $data[] = $category; + } + //echo '

'.print_r($data, true).'

'; +} catch(PDOException $e) { + echo '

'.print_r($e, true).'

'; +} +umask($oldMask); -- 2.17.1