관리-도구

편집 파일: venue-style.php

<?php
$meta_title = "Arizona Wedding Venue Styles | All inclusive, Cheap, Rooftop, Moderately Priced Wedding Venue Styles";
$meta_keywords = "cheap wedding venues, all inclusivewedding venues, rooftop, moderately priced, diy";
$meta_description = "Find a venue style that suits you.  Rooftop, all inclusive, golf course, rustic and more!";
?>
<?php include_once('config/mysql_connect.php'); ?>
<?php include_once('includes/header.php'); ?>
<?php
function makeover($pass1)
    {

// replace non letter or digits by -
          $pass1 = preg_replace('~[^\pL\d]+~u', '-', $pass1);

// transliterate
          $pass1 = iconv('utf-8', 'us-ascii//TRANSLIT', $pass1);

// remove unwanted characters
          $pass1 = preg_replace('~[^-\w]+~', '', $pass1);

// trim
          $pass1 = trim($pass1, '-');

// remove duplicate -
          $pass1 = preg_replace('~-+~', '-', $pass1);

$pass1 = str_replace(" ","-",$pass1);
          $pass1 =  strtolower($pass1);

return $pass1;

}
   ?>

<?php
	$city_result = $conn->query("select distinct city from vendor where type='venue' order by city asc");
	$style_result = $conn->query("select * from vendor_style limit 8");
	$venue_result = $conn->query("select distinct company_name from vendor where type='venue' order by company_name asc");

<div id="venue_banner">
    <img src="images/venue_style.jpg" alt="Cheap Wedding Venues">
	<div class="venue_banner_inner">
		<a href="https://www.stonebridgemanor.com/pricing/wedding-pricing/" target="_blank" class="img_in1"></a>
		<a href="https://www.finestweddingsites.com/wedding-venues/az/paradise-valley/santuary-camelback-mountain-89" class="img_in2"></a>
		<a href="https://www.finestweddingsites.com/wedding-venues/az/phoenix/the-phoenician-144" class="img_in3"></a>
	</div>
	
</div>

<div id="venue_section" class="vs_new_sec">
	<div class="container">
		<div class="row">
			<div class="col-sm-12">
				<div class="venue_circle">
					<h1><img src="images/title_img.png" alt="All Inclusive Phoenix Wedding Packages"></h1>
					<h2>What's Your <span>Venue Style?</span></h2>
					<a href="#venue_style_load" class="view view_nav_arrow view_all_style">View All <span>>></span></a>
					<a href="javascript:void(0);" class="close_all_style">Close All <span>>></span></a>
					<div class="close_venue">
					<div class="home_venue_slider">
					<ul>
						<?php 
						if ($style_result->num_rows > 0){
							while($style_row = $style_result->fetch_assoc()){
								$img_res = $conn->query("select * from vendor_image where id=".$style_row['image_id']);
								if ($img_res->num_rows > 0){
									$image = $img_res->fetch_assoc();
								}
								
								?>
						<li>
							<img src="https://www.finestweddingsites.com/admin/<?php echo $image['src'];?>" alt="Cheap Wedding Venues">
							<div class="circle_blk venue_style_circle v_s_circle">
								<div class="blk_inner">
									<div class="blk_in">
										<a href="https://www.finestweddingsites.com/wedding-venues/venue-styles/<?php echo makeover($style_row['style']);?>/<?php echo $style_row['id'];?>"></i><?php echo $style_row['style'];?></a>
									</div>
								</div>
							</div>
						</li>
						<?php } }?>
					</ul>
					</div>
					<input type="hidden" name="venue_count" class="venue_count" value="<?php echo $style_result->num_rows;?>">
					<div class="venue_style_load" id="venue_style_load">
						<ul class="venue_style_load_ul">
							
						</ul>
					</div>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>

<div id="vs_real_wed_new_sec">
	<div class="container">
		<div class="row">
			<div class="col-sm-12">
			<div class="vs_title_sec">
				<h3><span>Get</span> Inspiration</h3>
				<h4>from <span>Real Weddings</span>  in Arizona</h4>
			</div>
				<ul>
				<?php

$more_real_arr = array();
				$real_wed = $conn->query("select * from real_wedding where id in(116,3,9,11) ORDER BY FIELD(id,116,3,9,11)");
				if($real_wed->num_rows > 0){
					
					while($wed_row=$real_wed->fetch_assoc()){
						$real_vendor = $conn->query("select * from real_vendors where real_wedding_id=".$wed_row['id']);
				?>
				<li>
					<div class="rw_det_more_wed_sec">
						<?php 
						$image_res = $conn->query("select * from vendor_image where real_wedding_id='$wed_row[id]' and featured='1'");
							if($image_res->num_rows > 0){
								$img_row=$image_res->fetch_assoc();
							}
						?>
						<img src="https://www.finestweddingsites.com/admin/<?php echo $img_row['src'];?>"/>
						<h2>Real Wedding</h2>
						<?php if($wed_row['id']==116){?>
						<h5>Style: Modern</h5>
						<?php } else if($wed_row['id']==3){?>
						<h5>Style: Boho Chic</h5>
						<?php } else if($wed_row['id']==9){?>
						<h5>Style: Old Hollywood</h5>
						<?php } else{?>
						<h5>Style: Dreamy Desert</h5>
						<?php }?>
						<h3><a class="prop_link" href="https://www.finestweddingsites.com/real-wedding-detail/?id=<?php echo $wed_row[id]?>"><?php echo $wed_row['name'];?></a></h3>
						<h4>Featured Venue</h4>
						<?php
						if($real_vendor->num_rows > 0){
							while($rows=$real_vendor->fetch_assoc()){

if($rows['vendor_type_id'] == 2 && $rows['vendor_id'] == 0){
									$vendor_name = $rows['vendor_name'];?>
									
									<?php echo '<a class="v_s_prop_link" href="https://www.finestweddingsites.com/real-wedding-detail/?id='.$wed_row[id].'">'.$vendor_name.'</a>';

}
								if($rows['vendor_type_id'] == 2 && $rows['vendor_id'] != 0){
									$vendor = $rows['vendor_id'];
									$row_venue = $conn->query("select * from vendor where id=".$vendor);
									if($row_venue->num_rows > 0){
										while($v=$row_venue->fetch_assoc()){
											$cities = explode(",",$v['city']);
									        if(is_numeric($cities[0]))
									            $city_id = (int)$cities[0];
									        else
									            $city_id = 6;
											$loc_query = $conn->query("select * from location where id=".$city_id."");
        									$loc_res = $loc_query->fetch_assoc();
        									$prop_link = "https://www.finestweddingsites.com/wedding-venues/".makeover($loc_res['state'])."/".makeover($loc_res['name'])."/".makeover($v['company_name'])."-".$v['id'];

$venue_val = $v['company_name'];?>
											
										<?php echo '<a class="v_s_prop_link" href="'.$prop_link.'">'.$venue_val.'</a>';
										}
									}
								}
							}
						}?>
						<a class="v_s_see_more" href="https://www.finestweddingsites.com/real-wedding-detail/?id=<?php echo $wed_row['id'];?>">See More <i class="fa fa-angle-double-right" aria-hidden="true"></i></a>
					</div>
				</li>
				<?php } }?>
				
				</ul>
			</div>
			</div>
		</div>
	</div>
</div>

<div id="venue_style_bride_hmoon">
	<div class="container">
		<div class="row">
			<div class="col-sm-8">
				<div id="finest_bride_outer" class="clearfix">
					<?php 
				$sql = "select *,blogs.id as blog_id from blogs where blogs.status = 1";
				if(isset($_GET['category']))
					$sql .=" where category='".str_replace("-"," ",$_GET[category])."'";

$sql .=" order by created desc limit 1";

$result_page = $conn->query($sql);
				if($result_page->num_rows>0){
					while($row = $result_page->fetch_assoc()){
						$blog_link = "https://www.finestweddingsites.com/blog/".makeover($row['name'])."-".$row['blog_id'];
				?>
					<div id="finest_brider_logo">
						<img id="w_logo" src="images/w_logo.jpg"/>
						<div id="finest_logo_sec">
							<h4>Blushing and <span>Bliss</span></h4>
							<h5>an Arizona Bridal Blog </h5>
						</div>
					</div>
					<?php 
						$img = "select * from vendor_image where id=".$row['image_id'];
						$img_sql = $conn->query($img);
						if($img_sql->num_rows>0){
							while($img_row = $img_sql->fetch_assoc()){
								$img_src = $img_row['src'];
							}
						}
						if(!empty($img_src)){
					?>
					<img src="https://www.finestweddingsites.com/admin/<?php echo $img_src;?>" alt=""/>
					<?php }?>
					<div id="vs_fb_cont">
						<h3>Style: Simply Serene <br/>
						<span><?php echo $row['name']; ?></span></h3>
						<p><?php echo strip_tags(html_entity_decode(substr($row['html'],0,250)));?></p>
						<a href="https://www.finestweddingsites.com/weddingblog/style-trends/modern-moody-meets-industrial-wedding-photoshoot/">Read More</a>
					</div>
					<?php } }?>
				</div>
				<div id="mag_wedding_download">
					<img id="mag_book_img" src="images/venue-styles_plan_wedding_mag.jpg"/>
					<div id="mag_wed_cont_inner">
						<img src="images/w_logo.jpg"/>
						<p> Our planning guide provides helpful tips for each stage of the wedding planning process, complete with a wedding checklist, budget sheets, Q&A for vendors, and all of the information you’ll need to plan your dream wedding!</p>
						
						<a href="plan-your-wedding">Download</a>
					</div>
				</div>
			</div>

<div class="venue_style_form" style="display: none;">
				<h2>Receive package & pricing <br>
				info directly from this venue</h2>
					<form action="" method="post" id="venue_style_lead_form">
					<div class="package_form_inner venue_style_popup">
						<input type="text" name="name" placeholder="First Name & Last Name">
						<span class="error"></span>
						<input type="email" name="email" placeholder="Email">
						<span class="error"></span>
						<input type="tel" name="phone" placeholder="Phone No">
						<span class="error"></span>
						<input type="text" name="guest" placeholder="Approx No of  Guests">
						<span class="error"></span>
						<input type="text" name="date" placeholder="Wedding Date" id="">
						<span class="error"></span>
						<select name="select1" class="dropdown1">
							<option value selected="selected">Select Unit Type</option>
							<option value="type1">Click of Option</option>
							<option value="type2">Click of Option</option>
						</select>
						<span class="error"></span>
						<input type="submit" name="send" value="Send Request"></input>
						<span class="success"></span>
						</div>
					</form>
					
					<p>Your information is secure.<br>
					Here's our <a href="#">Privacy Policy >></a></p>
			</div>
			
			<div class="col-sm-4">
				<div class="win-add">
						<img src="images/win-img1.png" alt="Scottsdale Wedding Venues"/>
						<h4>For you and one member of your bridal party!</h4>
						<a class="win-button" href="hair-and-makeup">Enter to Win!</a>
						<h5>
						<a href="see-our-winners">See our winners</a>
						</h5>
					</div>
				<div class="venue_style_forecast">
					<h3>Venue Style <br/></h3>
					<h4>Forecast for <span>2019</span></h4>
					<ul>
						<li>Industrial & Modern</li>
						<li>Luxury Ballrooms</li>
						<li>Rooftops & Museums</li>
						<li>Globally Inspired</li>
						<li>Vintage & Timeless</li>
						<li>New Age Bohemian</li>
						<li>Woodsy & Whimsical</li>
						<li>DIY & Blank Canvas</li> 
					</ul>
				</div>
			</div>
		</div>
	</div>
</div>

<?php include_once('includes/footer.php'); ?>
<script>
	var getUrlParameter = function getUrlParameter(sParam) {
    var sPageURL = decodeURIComponent(window.location.search.substring(1)),
        sURLVariables = sPageURL.split('&'),
        sParameterName,
        i;

for (i = 0; i < sURLVariables.length; i++) {
        sParameterName = sURLVariables[i].split('=');

if (sParameterName[0] === sParam) {
            return sParameterName[1] === undefined ? true : sParameterName[1];
        }
    }
};
var load_all = '<?php echo isset($_GET["load"])?$_GET["load"]:"";?>';

$(document).ready(function(){
		/*if (window.location.href.indexOf("#style") > -1) {
		
	}*/
	$('.close_all_style').hide();
	if(load_all == 'all'){
		/*$('.view').on('click',function(){*/
			var cnt = $('.venue_count').val();
			$.ajax({
				url : 'ajax/venue_load.php',
				type : 'POST',
				data : {'cnt':cnt},
				success: function (response) {
		      	$('.venue_style_load_ul').append(response.results);
		      	$('.view_all_style').hide();
		      	$('.close_all_style').hide();
		      }
			});
			
		/*});*/
	}

$('.close_all_style').click(function(){
		$.ajax({
				url : 'ajax/close_venue_load.php',
				type : 'POST',
				data : {'cnt':cnt},
				success: function (response) {
		      	$('.close_venue').html(response.results);
		      	
		      	$('.close_all_style').hide();
		      	$('.view_all_style').show();
		      	location.reload();
		      }
			});
	});
	
	$('.view_all_style').on('click',function(){
			var cnt = $('.venue_count').val();
			$.ajax({
				url : 'ajax/venue_load.php',
				type : 'POST',
				data : {'cnt':cnt},
				success: function (response) {
		      	$('.venue_style_load_ul').append(response.results);
		      	$('.view_all_style').hide();
		      	$('.close_all_style').show();
		      }
			});
			
		});

$("#venue_style_lead_form").on('submit',function(ev){

ev.preventDefault();
			var cur_url = window.location.href;
			var from = document.referrer;
			$.ajax({

url: 'ajax/venue_style_lead.php',
				type: 'POST',
				data: $(this).serialize()+"&referer="+from+"&cur_url="+cur_url+"&vendor_id="+'<?php echo $_GET['id']; ?>',
				success: function(res){

if(res.status=='error'){
								$(this).addClass('form-error');
								var error = res.error;
								if(error.name!=""){

$(this).find('input[name="name"]').next().html(error.name);

}
								if(error.name == undefined){
									$(this).find('input[name="name"]').next().html('');

}
								if(error.email!=""){

$(this).find('input[name="email"]').next().html(error.email);

}
								if(error.email == undefined){
									$(this).find('input[name="email"]').next().html('');

}
								if(error.phone!=""){

$(this).find('input[name="phone"]').next().html(error.phone);

}
								if(error.phone == undefined){
									$(this).find('input[name="phone"]').next().html('');

}
								if(error.num_of_guests!=""){

$(this).find('input[name="guest"]').next().html(error.num_of_guests);

}
								if(error.num_of_guests == undefined){
									$(this).find('input[name="guest"]').next().html('');

}
								if(error.wedding_date!=""){

$(this).find('input[name="date"]').next().html(error.wedding_date);

}
								if(error.wedding_date == undefined){
									$(this).find('input[name="date"]').next().html('');

}

}
							else{
								$(this).removeClass('form-error');
								//$(this).find('input[name="send"]').next().html('Success');
								$(this)[0].reset();
								window.location="thank-you.php?venue=1";
							}

}.bind(this),

});
			});
	});
</script>