advertiserprofile.php

<?php
include("header.php");
if(isset($_POST['submit']))
{
	//Update statement starts here
	$sql = "UPDATE advertiser SET advertisername='$_POST[advertisername]',emailid='$_POST[emailid]',address='$_POST[address]',city='$_POST[city]',pincode='$_POST[pincode]',contactno='$_POST[contactno]' WHERE advertiserid ='$_SESSION[advertiserid]'";
	$qsql = mysqli_query($con,$sql);
	echo mysqli_error($con);
	if(mysqli_affected_rows($con) ==1)
	{
		echo "<script>alert('Advertiser profile Updated successfully..');</script>";
	}
	//Update statement ends here
}
//2  - Selecting the record starts here..
if(isset($_SESSION['advertiserid']))
{
	$sqledit = "SELECT * FROM  advertiser WHERE advertiserid='$_SESSION[advertiserid]'";
	$qsqledit = mysqli_query($con,$sqledit);
	$rsedit = mysqli_fetch_array($qsqledit);
}
// 2 - Select the record ends here..
?>
 
  <!--  catg header banner section -->
  <section id="aa-catg-head-banner">
    <div class="aa-catg-head-banner-area">
     <div class="container">
      <div class="aa-catg-head-banner-content">
        <h2>Checkout Page</h2>
      </div>
     </div>
   </div>
  </section>
  <!--  / catg header banner section -->

 <!--  Cart view section -->
 <section id="checkout">
   <div class="container">
     <div class="row">
       <div class="col-md-12">
        <div class="checkout-area">
          <form action="" method="post" name="frmform" onsubmit="return validateform()">
            <div class="row">
			
		
			
              <div class="col-md-12">
                <div class="checkout-left">
                  <div class="panel-group" id="accordion">

<!--  Billing Details -->
<div class="panel panel-default aa-checkout-billaddress">
  <div class="panel-heading">
	<h4 class="panel-title">
	  <a  data-parent="#accordion" >
		Advertiser
	  </a>
	</h4>
  </div>
  <div id="collapseThree">
	<div class="panel-body">
	  <div class="row">
		<div class="col-md-12">
		  <div class="aa-checkout-single-bill">
			Advertiser Name:<span id="idadvertisername" class="errmsg"></span>
			<input type="text" name="advertisername" value="<?php echo $rsedit['advertisername']; ?>" placeholder="Advertiser Name">
		  </div>                             
		</div>
	  </div> 
	  
	  <div class="row">
		<div class="col-md-12">
		  <div class="aa-checkout-single-bill">
			Email ID:<span id="idemailid" class="errmsg"></span>
			<input type="text" name="emailid" value="<?php echo $rsedit['emailid']; ?>" placeholder="Email ID">
		  </div>                             
		</div>
	  </div> 
	  
	 
	  
	  <div class="row">
		<div class="col-md-12">
		  <div class="aa-checkout-single-bill">		
			Address:<span id="idaddres" class="errmsg"></span>
			<textarea placeholder="Address" name="address"><?php echo $rsedit['address']; ?></textarea>
		  </div>                             
		</div>
	  </div> 
	  
	  <div class="row">
		<div class="col-md-6">
		  <div class="aa-checkout-single-bill">
			City:<span id="idcity" class="errmsg"></span>
			<input type="text" placeholder="City" value="<?php echo $rsedit['city']; ?>" name="city">
		  </div>                             
		</div>
		<div class="col-md-6">
		  <div class="aa-checkout-single-bill">
			Pin code:<span id="idpincode" class="errmsg"></span>
			<input type="text" placeholder="Pin code" value="<?php echo $rsedit['pincode']; ?>" name="pincode">
		  </div>                             
		</div>
	  </div>
	  
	  <div class="row">
		<div class="col-md-6">
		  <div class="aa-checkout-single-bill">
			Contact No.:<span id="idcontactno" class="errmsg"></span>
			<input type="text" placeholder="Contact No." value="<?php echo $rsedit['contactno']; ?>" name="contactno">
		  </div>                             
		</div>
	  </div>
	  
	
	 
	  
	  <div class="row">
		<div class="col-md-6">
		  <div class="aa-checkout-single-bill col-md-6">
			<input type="submit" name="submit" value="Click here to Submit" class="aa-browse-btn">
		  </div>
		</div>		
	  </div>                                    
	</div>
  </div>
</div>
                   
				   </div>
                </div>
              </div>
             </div>
          </form>
         </div>
       </div>
     </div>
   </div>
 </section>
 <!--  / Cart view section -->

 <?php
 include("footer.php");
 ?>
 
 <script>
 function validateform()
 {	  
     $('.errmsg').html('');
	 var checkcondition = "true";
	 var emailExp = /^[\w\-\.\+]+\@[a-zA-Z0-9\.\-]+\.[a-zA-z0-9]{2,4}$/;
	 var alphaspaceExp = /^[a-zA-Z\s]+$/;
	 var numericExpression = /^[0-9]+$/;
	  if(!document.frmform.advertisername.value.match(alphaspaceExp))
	 {
		 document.getElementById("idadvertisername").innerHTML = "Advertiser name should not contain digits and special characters..";
		 checkcondition = "false";
	 }
	 if(document.frmform.advertisername.value=="")
	 {
		 document.getElementById("idadvertisername").innerHTML = "Advertiser name should not be empty..";
		 checkcondition = "false";
	 } 
	  if(!document.frmform.emailid.value.match(emailExp))
	 {
		 document.getElementById("idemailid").innerHTML = "Entered EMail ID is not valid..";
		 checkcondition = "false";
	 }
	 if(document.frmform.emailid.value=="")
	 {
		 document.getElementById("idemailid").innerHTML = "Email ID should not be empty..";
		 checkcondition = "false";
	 }
	 if(document.frmform.address.value=="")
	 {
		 document.getElementById("idaddres").innerHTML = "address should not be empty..";
		 checkcondition = "false";
	 }
	  if(document.frmform.city.value=="")
	 {
		 document.getElementById("idcity").innerHTML = "city should not be empty..";
		 checkcondition = "false";
	 }
	  if(document.frmform.pincode.value=="")
	 {
		 document.getElementById("idpincode").innerHTML = "pincode should not be empty..";
		 checkcondition = "false";
	 }
	 if(!document.frmform.pincode.value.match(numericExpression))
	 {
		 document.getElementById("idpincode").innerHTML = "pincode should not contain characters..";
		 checkcondition = "false";
	 }
	 if(document.frmform.contactno.value.length != 10 )
	 {
		 document.getElementById("idcontactno").innerHTML = "Contact Number should contain 10 digits.."; 
		 checkcondition = "false";
	 }
	 if(document.frmform.contactno.value=="")
	 {
		 document.getElementById("idcontactno").innerHTML = "Contact Number should not be empty..";
		 checkcondition = "false";
	 }
	  if(checkcondition == "true")
	 {
		 return true;
	 }
	 else
	 {
		 return false;
	 }
 }
 </script>