Home/Video Courses/

Video Courses

prepare($rsql); $rstmt->execute(); $totalRatings = $rstmt->rowCount(); $fv = "SELECT * FROM module_reviews WHERE course_id='".$item_ID."' AND rate='5' AND status='active'"; $fvstmt = $DB->prepare($fv); $fvstmt->execute(); $fiveStarRatings = $fvstmt->rowCount(); $fo = "SELECT * FROM module_reviews WHERE course_id='".$item_ID."' AND rate='4' AND status='active'"; $fostmt = $DB->prepare($fo); $fostmt->execute(); $fourStarRatings = $fostmt->rowCount(); $th = "SELECT * FROM module_reviews WHERE course_id='".$item_ID."' AND rate='3' AND status='active'"; $thstmt = $DB->prepare($th); $thstmt->execute(); $threeStarRatings = $thstmt->rowCount(); $tw = "SELECT * FROM module_reviews WHERE course_id='".$item_ID."' AND rate='2' AND status='active'"; $twstmt = $DB->prepare($tw); $twstmt->execute(); $twoStarRatings = $twstmt->rowCount(); $on = "SELECT * FROM module_reviews WHERE course_id='".$item_ID."' AND rate='1' AND status='active'"; $onestmt = $DB->prepare($on); $onestmt->execute(); $oneStarRatings = $onestmt->rowCount(); $five = ($fiveStarRatings > 0) ? $fiveStarRatings/$totalRatings*100 : 0; $four = ($fourStarRatings > 0) ? $fourStarRatings/$totalRatings*100 : 0; $three = ($threeStarRatings > 0) ? $threeStarRatings/$totalRatings*100 : 0; $two = ($twoStarRatings > 0) ? $twoStarRatings/$totalRatings*100 : 0; $one = ($oneStarRatings > 0) ? $oneStarRatings/$totalRatings*100 : 0; $totalVotingCount = ($fiveStarRatings * 5) + ($fourStarRatings * 4) + ($threeStarRatings * 3) + ($twoStarRatings * 2) + $oneStarRatings; $itemRating = ($totalVotingCount > 0) ? round($totalVotingCount / $totalRatings,1) : 0; $starRating = round($itemRating,0,PHP_ROUND_HALF_UP); $rsql = "SELECT * FROM module_reviews WHERE course_id='".$item_ID."' AND status='active' AND type='both'"; $rstmt = $DB->prepare($rsql); $rstmt->execute(); $totalComments = $rstmt->rowCount(); ?>
  • <?php echo $pageH1; ?>

    Instructor:

    Language:

      = $star){ echo '
    • ★
      • '; } else { if($calc <= 0.5){ echo '
    • ★
      • '; } else { echo '
    • ★
      • '; } } } ?>
    Total Ratings :
    '.$priceOld.'
    '; } ?>
    prepare($sql); $stmt->execute(); $rowCount = $stmt->rowCount(); if($rowCount > 0){ $q = $DB->query($sql); $q->setFetchMode(PDO::FETCH_ASSOC); $status = ''; while ($row = $q->fetch()){ $status .= $row['status']; } if($status == 'active'){ echo '

    You have already purchased this course

    '; } else { echo '

    Payment details are not approved yet. Please wait

    '; } } else { echo '

    Buy Now

    '; } } else { echo '

    Buy Now

    '; } ?>
query($rsql); $cq->setFetchMode(PDO::FETCH_ASSOC); $i = 0; $comments = ''; while ($crow = $cq->fetch()){ $comments .= '

'.$crow['user_name'].' '.$crow['added_date'].'

'.$crow['comment'].'

'; $i++; } ?>

Comments

5){ ?>

Load More

Reviews

  • ★
  • ★
  • ★
  • ★
  • ★

  • User Ratings

      = $star){ echo '
    • ★
      • '; } else { if($calc <= 0.5){ echo '
    • ★
      • '; } else { echo '
    • ★
      • '; } } } ?>
    • 5 ★
    • 4 ★
    • 3 ★
    • 2 ★
    • 1 ★
    • Attach Bank Fund transfer confirmation/screenshot. Refer course outline for Bank account details

    Supported file formats are jpeg, jpg, png, pdf

    Original price'.$priceOld.'
    '; } ?>
    Discounted price
    Total

    Note - Confirmation email will be sent to your email