$crid = (int) $_GET['crid']; //echo "pavi123 "; if($crid == "1715" ) $product_url = "/product/aws-tech-essentials/"; if($crid == "1719" ) $product_url = "/product/aws-cloud-practitioner/"; if($crid == "1720" ) $product_url = "/product/aws-business-essential/"; if($crid == "1721" ) $product_url = "/product/solution-architect-associate/"; if($crid == "1723" ) $product_url = "/product/developing-on-aws-deveops-associate/"; if($crid == "1724" ) $product_url = "/product/sysops-associate/"; if($crid == "1726" ) $product_url = "/product/solution-architect-professional-aws/"; if($crid == "1727" ) $product_url = "/product/devops-engineering-on-aws/"; if($crid == "1728" ) $product_url = "/product/microsoft-azure-fundamentals-az-900t01/"; if($crid == "1729" ) $product_url = "/product/microsoft-azure-for-it-professional-m10979/"; if($crid == "1730" ) $product_url = "/product/azure-solutions-architect-technologiesaz-300/"; if($crid == "1732" ) $product_url = "/product/microsoft-azure-administrator-az-103/"; if($crid == "1733" ) $product_url = "/product/azure-administrator-of-aws-sysops-az-010t00/"; if($crid == "1734" ) $product_url="/product/developing-solutions-for-microsoft-azure-az-203/"; if($crid == "1736" ) $product_url = "/product/azure-solutions-architect-design-az-301/"; if($crid == "1738" ) $product_url = "/product/microsoft-azure-devops-solutions-az-400/"; if($crid == "1739" ) $product_url = "/product/fundamentals-of-cloud-computing/"; if($crid == "1740" ) $product_url = "/product/associate-cloud-engineer/"; if($crid == "1741" ) $product_url = "/product/architecting-with-google-compute-engine/"; if($crid == "1743" ) $product_url = "/product/professional-cloud-architect/"; if($crid == "1744" ) $product_url = "/product/professional-data-engineer/"; if($crid == "1746" ) $product_url = "/product/professional-cloud-developer/"; if($crid == "1748" ) $product_url = "/product/professional-cloud-network-engineer/"; if($crid == "1750" ) $product_url = "/product/professional-cloud-security-engineer/"; if($crid == "1753" ) $product_url = "/product/professional-collaboration-engineer/"; if($crid == "1754" ) $product_url = "/product/g-suite-certification/"; if($crid == "1849" ) $product_url = "/product/cloud-expert/"; //echo "product_url: $product_url"; $cond = ''; if(isset($_GET['btval'])) { $btval = (int) $_GET['btval']; if($btval>0) $cond .= " and location_id = $btval "; } $sortval1 = "asc"; if(isset($_GET['sortval'])) $sortval1 = $_GET['sortval']; //echo "testing".$cid; //$cond = " and ("; if(isset($_GET['clval'])) { $clval = (int) $_GET['clval']; if($clval==0) $cond .= " and delivery_format != 'Classroom' "; } if(isset($_GET['onval'])) { $onlineval = (int) $_GET['onval']; if($onlineval==0) $cond .= " and delivery_format != 'Online' "; } global $woocommerce; $product = new WC_Product($crid); $thePrice = $product->get_price(); $batch_result = $seconddb->get_results( "SELECT batches.*,(select locationname from locations where locations.id=batches.location_id) as locationname FROM u973167318_cloudad.batches WHERE course_id=$crid and to_date >CURRENT_TIMESTAMP $cond order by from_date $sortval1 "); /*echo "SELECT * FROM adepttes_adminclouddb.batches WHERE course_id=$crid and to_date >CURRENT_TIMESTAMP $cond order by from_date $sortval1 ";*/?> /* echo "

";
	 print_r($batch_result);
	 echo "
"; */ if(count($batch_result)>0) { foreach($batch_result as $batch_results) { $batch_id = $batch_results->id; $delivery_format = $batch_results->delivery_format; $locationname = $batch_results->locationname; $from_date = $batch_results->from_date; $to_date = $batch_results->to_date; $from_time = $batch_results->from_time; $to_time = $batch_results->to_time; $batch_type = $batch_results->batch_type; //$from_mon = date_format($from_date,"Y/m/d H:i:s"); $from_mon = date_format(date_create($from_date),"M"); $from_mon_th = date_format(date_create($from_date),"d").date_format(date_create($from_date),"S"); $from_date_1 = date_format(date_create($from_date),"M d"); $to_date_1 = date_format(date_create($to_date),"M d,Y"); $from_time = date_format(date_create($from_time),"H:i A"); $to_time = date_format(date_create($to_time),"H:i A"); $class_css = "yellowcolor"; if($batch_type=="Weekend") $class_css = "yellowcolor"; else if($batch_type=="Night") $class_css = "greencolor"; else if($batch_type=="Day") $class_css = "bluecolor"; ?>
13

Jan

Date,time and Location:
-
-
if($delivery_format=="Classroom") echo $locationname; else echo $delivery_format; ?>

Delivery Format:

Quantity:

Cost:

$ USD
or

Starting at $37/mo with
Prequalify now

}} ?>