Animations & Video: Chandra Image Collection Page "; for ($n=1; $n <= $numPage; $n++) { $pageNumber = $n; print "".$pageNumber.""; $pageNumber++; } print "
"; while ($animationsInfo = mysqli_fetch_array($result)) { $animID = $animationsInfo['animationsID']; $sql_release = "select imageRelease.imageReleaseID, imageRelease.imageReleaseYear, imageRelease.imageReleaseDirName from animationsID_imageReleaseID, imageRelease where animationsID_imageReleaseID.animationsID = $animID and animationsID_imageReleaseID.imageReleaseID = imageRelease.imageReleaseID and imageRelease.imageReleaseLive = 'yes' order by imageRelease.imageReleaseFullDate desc"; $results_release = mysqli_query($conn, $sql_release) or die("query failed image release"); $anim_lgQt = $animationsInfo['animationsLgQtPath']; $anim_smQt = $animationsInfo['animationsSmQtPath']; $anim_lgMpg = $animationsInfo['animationsLgMpgPath']; $anim_smMpg = $animationsInfo['animationsSmMpgPath']; $anim_cc = $animationsInfo['animationCC']; $anim_image = $animationsInfo['animationsImagePath']; $anim_title = $animationsInfo['animationsTitle']; $anim_caption = $animationsInfo['animationsCaption']; $anim_credit = $animationsInfo['animationsCredit']; $anim_runTime = $animationsInfo['animationsRunTime']; $anim_broadcast = $animationsInfo['animationsBroadcast']; $anim_audio = $animationsInfo['animationsAudio']; $anim_stills = $animationsInfo['animationsStills']; print "
\n"; print "\n"; //print "\n"; //print "\n"; //print "\n"; print "
\"Click
\n"; print "
".$count.". ".$anim_title."
\n"; $filesize_mov_lg = compute_size(filesize($root."/".$anim_lgQt)); $filesize_mov_sm = compute_size(filesize($root."/".$anim_smQt)); $filesize_mpg_lg = compute_size(filesize($root."/".$anim_lgMpg)); $filesize_mpg_sm = compute_size(filesize($root."/".$anim_smMpg)); $filesize_audio = compute_size(filesize($root."/".$anim_audio)); print "Quicktime"; print "
    "; print "
  • High Res (".$filesize_mov_lg.")
    • \n"; print "
  • Low Res (".$filesize_mov_sm.")
    • \n"; print "
"; print "MPEG\n"; print "
    "; print "
  • High Res (".$filesize_mpg_lg.")
    • \n"; print "
  • Low Res (".$filesize_mpg_sm.")
    • \n"; print"
\n"; if ($anim_audio) { print "Audio Only\n"; print "
    "; print "
  • Audio (".$filesize_audio.")
    • \n"; print"
\n"; } if ( $anim_cc ) {print "With closed-captions (at YouTube)

\n";} if ($anim_broadcast) { $filesize_huge_mov = compute_size(filesize($root."/resources/animations/broadcast/".$anim_broadcast.".mov")); print "Broadcast:
  • QuickTime movie (uncompressed)
  • D1 (0.9 pixel aspect ratio)
  • 720x486
  • 29.97 fps
  • file size = (".$filesize_huge_mov.")
\n"; print "Download Broadcast
\n"; print "
"; } print "$anim_caption
\n"; print "[Runtime: ".$anim_runTime."]
\n"; if ($anim_stills) { print "View Stills
\n"; } print "(".$anim_credit.")
\n"; if (mysqli_num_rows($results_release) > 0) { print "
"; print "Related Chandra Images:\n"; print "
    \n"; while ($releaseInfo = mysqli_fetch_array($results_release)) { $anim_imageReleaseID = $releaseInfo['imageReleaseID']; $anim_imageReleaseID = $releaseInfo['imageReleaseID']; $anim_imageReleaseYear = $releaseInfo['imageReleaseYear']; $anim_dirName = $releaseInfo['imageReleaseDirName']; $sql_object = "select object.objectName from image, objectImage, object where image.imageReleaseID = $anim_imageReleaseID and image.imageID = objectImage.imageID and objectImage.objectID = object.objectID"; $results_object = mysqli_query($conn, $sql_object) or die("query failed object"); $objectInfo = mysqli_fetch_array($results_object); $anim_objectName = $objectInfo['objectName']; print "
  • Photo Album: ".$anim_objectName."
    • \n"; } } print"
\n"; print "
"; print ""; //print "\n"; //print "\n"; //print "
".$count."
\n"; print "
\n"; $count++; } //print "
Page "; print "
Page "; for ($n=1; $n <= $numPage; $n++) { $pageNumber = $n; print "".$pageNumber.""; $pageNumber++; } print "
"; ?>