Photography Classes";
echo "
Self-Paced Classes
";
// find all self-paced events associated with this memberID
function memberIsInAnEvent($conn, $memberID, $cID) {
$q = "SELECT * FROM CoursesSPMemberCross WHERE cID = ".$cID." AND (datePaid IS NOT NULL OR freebie = 1) AND daterefunded IS NULL AND memberID = ".$memberID;
$data = mysqli_query($conn, $q);
$tCount=mysqli_num_rows($data);
return $tCount;
}
// SELECT * FROM CoursesSPMemberCross WHERE cID = 1 AND datePaid IS NOT NULL AND daterefunded IS NULL AND memberID = 520298
// echo "
memA=".$memAuth;
/* 41 - BP101
WAS https://www.betterphotography101.com
*/
$anySelfPaced = 0;
$tCount = memberIsInAnEvent($conn, $memAuth, 1);
if($tCount > 0) {
$anySelfPaced = 1;
?>
Better Photography 101
For all course materials, go to:
Better Photography 101
0) {
$anySelfPaced = 1;
?>
Creative Photo Composition
For all course materials, go to:
Creative Photo Composition
0) {
$anySelfPaced = 1;
?>
Outstanding Photography System
For all course materials, go to:
Outstanding Photography System
0) {
$anySelfPaced = 1;
?>
Understanding Light and Exposure
For all course and bonus materials, go to:
0) {
$anySelfPaced = 1;
?>
Better Photoshop
For all course and bonus materials, log in at:
Courses page to learn more about self-paced learning options." ;
}
?>
query($cmdGetCourseWishes);
while ($courseWishInfo = $stmt->fetch_array()) {
$courseID_wish = $courseWishInfo['cspID'];
$courseName_wish = $courseWishInfo['courseName'];
$wishlistID = $courseWishInfo['memberWCID'];
// +++++++ STILL ?
if(strpos($courseName_wish,"4-Week") !== FALSE){
$courseName_wish = str_replace($courseName_wish,"4-Week Short Course: ","");
}
}
for testing
SELECT c.photoCatID, c.courseName, c.courseID, c.sessionID, cmc.datePaid, c.productID, c.sessionStartDate, c.courseASPName, cmc.courseMemberID, c.cwStartDate, cmc.freebie, c.instructorID, c.shortSessionID FROM Members m, CoursesMemberCross cmc, Courses c WHERE m.memberID = cmc.memberID AND c.courseID = cmc.courseID AND cmc.memberID = 356407 ORDER BY c.courseID
*/
// go find all course PhotoCatIDs associated with this memberID
$cmdGetCourses = "SELECT c.photoCatID, c.courseName, c.courseID, c.sessionID, cmc.datePaid, c.productID, c.sessionStartDate, c.courseASPName, cmc.courseMemberID, c.cwStartDate, cmc.freebie, c.instructorID, c.shortSessionID FROM Members m, CoursesMemberCross cmc, Courses c WHERE m.memberID = cmc.memberID AND c.courseID = cmc.courseID AND cmc.memberID = " . $memAuth . " ORDER BY c.courseID DESC ";
$data = mysqli_query($conn, $cmdGetCourses);
$tCount=mysqli_num_rows($data);
if ($tCount > 0) {
echo "
";
echo "
My Interactive Courses
";
$eligFlag = "N";
$flagNoListings = 1;
?>
";
while($courseInfo = mysqli_fetch_assoc($data)) {
$photoCatID = $courseInfo['photoCatID'];
$courseName = $courseInfo['courseName'];
if(strpos($courseName,"4-Week") !== FALSE){
$courseName = str_replace("4-Week Short Course: ","",$courseName);
}
$courseID = $courseInfo['courseID'];
$sessionID = $courseInfo['sessionID'];
$courseDatePaid = $courseInfo['datePaid'];
$courseProductID = $courseInfo['productID'];
$sessionStartDate = $courseInfo['sessionStartDate'];
if (is_null($sessionStartDate) == false){
$date1=date_create(date('Y-m-d'));
$date2=date_create(date('Y-m-d',strtotime($sessionStartDate)));
$daysLeftToSignUp=date_diff($date1,$date2);
$sessionStartDate = date('Y-m-d',strtotime($sessionStartDate));
}
$courseASPname = $courseInfo['courseASPName'];
$courseFreebie = $courseInfo['freebie'];
$shortSessionID = $courseInfo['shortSessionID'];
// get current status of sessionID
if(!empty($sessionID)){
$cmdSessionStatus = "SELECT sessionName, post FROM CourseSessions WHERE sessionID = ".$sessionID;
$stmt = $conn->query($cmdSessionStatus);
while ($sessionInfo = $stmt->fetch_array()) {
$sessionName = $sessionInfo['sessionName'];
$sessionPost = $sessionInfo['post'];
}
}elseif(!empty($shortSessionID)){
$cmdSessionStatus = "SELECT sessionName, post FROM CourseSessionsShort WHERE shortsessionID = ".$shortSessionID;
$stmt = $conn->query($cmdSessionStatus);
//echo "
course short'=".$shortSessionID;
while ($sessionInfo = $stmt->fetch_array()) {
$sessionName = $sessionInfo['sessionName'];
$sessionPost = $sessionInfo['post'];
}
}else{
$sessionName = "
BetterPhoto Combo Workshop";
$sessionPost = "Yes";
}
// if the FREE course
if($courseProductID == 1524){
echo "
";
if($courseFreebie == 1 ){
echo "" . $courseName . "
";
}else{
echo $courseName;
// unlikely to do anymore Free Course Preview
?>
either has not yet started or is ended. If you recently enrolled, note that it can take up to 24 hours to activate enrollment. You will receive an instructional email when your Free Course Preview has been activated. If it has been over 21 days since you enrolled, the preview is closed. Visit our course offerings to select your next course.
";
// if they have paid for the course and it IS live
}elseif(!empty($courseDatePaid) && $sessionPost == "Yes"){
if($photoCatID > 67220) {
echo "";
// likely - one course campus square
//also Outstanding Photography System - photoCatID 67221
if($courseID > 7500) {
echo "" . $courseName . "";
} elseif($courseID = 7500) {
echo "" . $courseName . "";
}
//if($sessionName != ""){
// echo " ". $sessionName . "";
// }
echo "";
}elseif($memAuth != 124){ // 'not me - hide for faster load time
echo "
";
// echo "" . $courseName . ""; HIDE LINK FOR NOW
echo "" . $courseName;
if(!empty($sessionName)){
echo " " . $sessionName . "";
}
echo "";
}
// if they have paid for the course and it is NOT YET live
}elseif (!empty($courseDatePaid)){
echo "
";
echo $courseName." - coming soon... ";
if(!empty($sessionName)){
echo " - ".$sessionName ;
}
echo "";
} elseif (empty($courseDatePaid)){ // if ($courseFreebie == 1)
echo "
";
echo $courseName."... '" . $courseDatePaid . "'";
if(!empty($sessionName)){
echo " ".$sessionName ;
}
echo "";
} // if a free course, coming soon course, or regular course
} // while
echo "";
} else { // if has courses or not
echo "
Interactive Courses
You have not yet taken any interactive courses. Visit the
Courses page to learn more about these results-oriented learning options." ;
}
}else{ ?>
Not Signed In
It appears you are not logged in. It may be that your session timed out due to inactivity. Log in using the button above and try again.