bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
ob_start();
session_start();
header('Content-Type: application/json');
//CONFIGARATIONS - /////////////////////////////////////
//ini_set('display_errors',1);
define("SITE_PATH","https://www.bmse.net/");
define("DOCUMENT_ROOT","/home/w0yxy4bjb020/public_html/bmse.net/bmseweb/");
//include ("fpconfig.php");
$name1 = mysqli_connect('localhost','bmsebro','4rfvbhu8','bmse');

$valuelist=array();

# Getting list of feature events
	$query2 = mysqli_query($name1,"SELECT `id`, `name` as 'eventname', `city` as 'eventcity', DATE(`start_dttm`) as 'eventstartdate', DATE(`end_dttm`) as 'eventenddate', `event_custom_title` as 'eventcustomtitle', `eventheroimage`, `expo_hall_id` as `eventhallname`  FROM bmse_expos where status=1 and remove=1 and `featured`='ON' and `start_dttm`>='".date('Y-m-d  00:00:00')."'  order by start_dttm ASC limit 3");
	
	
	
	while($row2 = mysqli_fetch_assoc($query2)){
		# Getting hall name
		$expohall = mysqli_query($name1,'select `name` FROM `bmse_halls` WHERE `id`='.$row2['eventhallname'].'');
		$expohallinfo=mysqli_fetch_assoc($expohall);
		
		if ($row2['eventheroimage']!='' AND file_exists(DOCUMENT_ROOT.'hfm/'.$row2['eventheroimage'])) {
			$row2['eventheroimage']=SITE_PATH.'hfm/'.$row2['eventheroimage'];
		} else {
			$row2['eventheroimage']='';
		}
		
		$row2['eventhallname']=$expohallinfo['name'];
		$row2['buyticketurl']=SITE_PATH.'event/vendor_tickets.php?eid='.$row2['id'].'';
		$row2['buyboothurl']=SITE_PATH.'floorplan/index.php?eid='.$row2['id'].'';
		$row2['eventurl']=SITE_PATH.'event/eventhome.php?eid='.$row2['id'].'';
		
		# getting social media links
		$rowsocial=array();
		$query21 = mysqli_query($name1,"SELECT `id`, `community_name` as 'socialmedianame', `logo` as 'socialmedialogo', `website` as 'socialmediaurl' FROM `bmse_expo_social_networks` where  `expo_id`=".$row2['id']." and status=1 and remove=1 ");
		while($row21 = mysqli_fetch_assoc($query21)){
		
			if ($row21['socialmedialogo']!='' AND file_exists(DOCUMENT_ROOT.'admin/images/socialnetworks/'.$row21['socialmedialogo'])) {
				$row21['socialmedialogo']=SITE_PATH.'admin/images/socialnetworks/'.$row21['socialmedialogo'];
			} else {
				$row21['socialmedialogo']='';
			}
			$rowsocial[]=$row21;;
		}
		
		$row2['socialmedia']=$rowsocial;
		
		
		$feature_values[]=$row2;
	}
	$valuelist['Header']=$feature_values;
	
# Getting list of spotlight events

$query1 = mysqli_query($name1,"SELECT `id`, `name` as 'eventname', `city` as 'eventcity', DATE(`start_dttm`) as 'eventstartdate', DATE(`end_dttm`) as 'eventenddate',`eventspotimage` FROM bmse_expos where status=1 and remove=1 and `spotlight`='ON' and `start_dttm`>='".date('Y-m-d  00:00:00')."' order by start_dttm ASC limit 3");
	
	
	
	while($row1 = mysqli_fetch_assoc($query1)){
		# Getting hall name
		
		
		if ($row1['eventspotimage']!='' AND file_exists(DOCUMENT_ROOT.'hfm/'.$row1['eventspotimage'])) {
			$row1['eventspotimage']=SITE_PATH.'hfm/'.$row1['eventspotimage'];
		} else {
			$row1['eventspotimage']='';
		}
		
		
		$row2['eventurl']=SITE_PATH.'event/eventhome.php?eid='.$row1['id'].'';
		$spotlightvalues[]=$row1;
	}
	$valuelist['spotlight']=$spotlightvalues;
	
# Getting list of upcoming events

$query3 = mysqli_query($name1,"SELECT `id`, `name` as 'eventname', `city` as 'eventcity', DATE(`start_dttm`) as 'eventstartdate', DATE(`end_dttm`) as 'eventenddate' , `expo_hall_id` as `eventhallname` FROM bmse_expos where status=1 and remove=1  and `start_dttm`>='".date('Y-m-d  00:00:00')."' order by start_dttm ASC limit 2");
	
	
	
	while($row3 = mysqli_fetch_assoc($query3)){
		# Getting hall name
	
		$expohall = mysqli_query($name1,'select `name` FROM `bmse_halls` WHERE `id`='.$row3['eventhallname'].'');
		$expohallinfo=mysqli_fetch_assoc($expohall);
		
	
		
		$row3['eventhallname']=$expohallinfo['name'];
		$row3['eventurl']=SITE_PATH.'event/eventhome.php?eid='.$row3['id'].'';
		$upcomingevents[]=$row3;
	}
	$valuelist['upcomingevents']=$upcomingevents;
	
	# Getting social media
	$query4 = mysqli_query($name1,"SELECT `id`, `community_name` as 'socialmedianame', `logo` as 'socialmedialogo', `website` as 'socialmediaurl' FROM `bmse_expo_social_networks` where status=1 and remove=1   limit 3");
    while($row4 = mysqli_fetch_assoc($query4)){
		
		if ($row4['socialmedialogo']!='' AND file_exists(DOCUMENT_ROOT.'admin/images/socialnetworks/'.$row4['socialmedialogo'])) {
			$row4['socialmedialogo']=SITE_PATH.'admin/images/socialnetworks/'.$row4['socialmedialogo'];
		} else {
			$row4['socialmedialogo']='';
		}
		
		
		$socialmedia[]=$row4;
	}
	$valuelist['socialmedia']=$socialmedia;
	
	# Getting sponsors
	$query5 = mysqli_query($name1,"SELECT `id`, `sponsor_name` as 'sponsorname', `filename` as 'sponsorlogo', `website` as 'sponsorwebsite' FROM `bmse_admin_level_sponsors` where status=1 and remove=1   limit 5");
    while($row5 = mysqli_fetch_assoc($query5)){
		
		if ($row5['sponsorlogo']!='' AND file_exists(DOCUMENT_ROOT.'admin/images/admin_sponsors/'.$row5['sponsorlogo'])) {
			$row5['sponsorlogo']=SITE_PATH.'admin/images/admin_sponsors/'.$row5['sponsorlogo'];
		} else {
			$row5['sponsorlogo']='';
		}
		
		
		$sponsorslist[]=$row5;
	}
	$valuelist['sponsors']=$sponsorslist;

echo json_encode($valuelist);