 <?php $sqlc = "SELECT * FROM banner_master  WHERE slider_type='banner' ORDER BY rowId ASC";
   
    $myq=$conn->query($sqlc);
  $mydar= $myq->fetchAll()  ;
  
  $rows_fou = $myq->rowCount();


  $sqlc_ban = "SELECT * FROM banner_master  WHERE slider_type='discount_banner' ORDER BY rowId ASC";
   
    $myq_ban=$conn->query($sqlc_ban);
  $mydar_ban= $myq_ban->fetchAll()  ;
  
  $rows_fou_ban = $myq_ban->rowCount();
  ?>
<div class="tab-content">
                                 <div class="tab-pane active" id="banner">
                                    <div class="row">
                                       <div class="col-md-6">
                                          <div class="card border-0  shadow mb-4">
                                             <div class="card-header bg-white border-bottom py-3">
                                                <h6 class="m-0 fw-bold text-inherit">Upload pre-design banner</h6>
                                             </div>
                                             <div class="card-body">
                                                <form action="./backend/activate_banner.php" method="post">
                                                <div class="row">
                                                 <?php  foreach( $mydar as $rowcon ) {
      
       
            $banner_path = $rowcon['banner_path'];
              $activestatus = $rowcon['activestatus'];
               $banner = $rowcon['banner'];
             $activestatus_ch='';
              if($activestatus==1){
                $activestatus_ch='checked';
              }

             ?>
          
        
 
                                                   <div class="col-md-6">
                                                      <div class="form-check mb-5">
                                                         <input class="form-check-input" type="checkbox" value="<?=$banner?>" name="<?=SESS_MASTER?>banner<?=$banner?>" <?=$activestatus_ch?>>
                                                         <img src="./../<?=$banner_path?>" class="img-fluid rounded-3">
                                                      </div>
                                                   </div>
                                                      

                                                        <?php     } ?>
                                                    
                                                      
                                                  
                                                      

                                                   <div class="col-md-12">
                                                    
                                                      <!--Important message Begin-->
                                                      <div class="alert alert-primary fs-14" role="alert">
                                                         <strong>Important message:</strong> We have pre-design banners you can use it. if you donot want pre-design banner click on the uncheck box.
                                                      </div>
                                                      <!--Important message End-->
                                                        <input name="<?=SESS_MASTER?>type" type="hidden"
                                                        value="slider" class="form-control" >
                                                      <button type="submit" class="btn btn-primary my-2">save</button>
                                                   </div>
                                                </div>
                                             </form>
                                             </div>
                                          </div>
                                       </div>
                                       <div class="col-md-6">
                                          <div class="card border-0  shadow mb-4">
                                             <div class="card-header bg-white border-bottom py-3">
                                                <h6 class="m-0 fw-bold text-inherit">Custom upload banner</h6>
                                             </div>
                                             <div class="card-body">
                                                <form action="./backend/upload_banner.php" method="post" enctype="multipart/form-data">
                                                <div class="row">
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                         
                                                         <input type="file"  name="<?=SESS_MASTER?>upload_banner1" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                        
                                                         <input type="file" name="<?=SESS_MASTER?>upload_banner2" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                        
                                                         <input type="file" name="<?=SESS_MASTER?>upload_banner3" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                        
                                                         <input name="<?=SESS_MASTER?>upload_banner4" type="file" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                         
                                                         <input name="<?=SESS_MASTER?>upload_banner5" type="file" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                         
                                                         <input name="<?=SESS_MASTER?>upload_banner6" type="file" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-12">
                                                      <!--Important message Begin-->
                                                      <div class="alert alert-primary fs-14" role="alert">
                                                         <strong>Important message:</strong>  if you want custom upload banner choose image. We recommend you that the size of the image will be <strong>1920x500</strong> and its format will be jpg and png formate.
                                                      </div>
                                                      <!--Important message End-->
                                                       <input name="<?=SESS_MASTER?>type" type="hidden"
                                                        value="slider" class="form-control" >
                                                      <button type="submit" class="btn btn-primary my-2">save</button>
                                                   </div>
                                                </div>
                                             </form>
                                             </div>
                                          </div>
                                       </div>
                                    </div>
                                 </div>
                                 <div class="tab-pane fade" id="cdslider">
                                    <div class="row">
                                       <div class="col-md-6">
                                          <div class="card border-0  shadow mb-4">
                                             <div class="card-header bg-white border-bottom py-3">
                                                <h6 class="m-0 fw-bold text-inherit">Upload Pre-design coupon discount carousel</h6>
                                             </div>
                                             <div class="card-body">
                                                 <form action="./backend/activate_banner.php" method="post">
                                                <div class="row">
                                                 <?php  foreach( $mydar_ban as $rowcon ) {
      
       
            $banner_path = $rowcon['banner_path'];
              $activestatus = $rowcon['activestatus'];
               $banner = $rowcon['banner'];
             $activestatus_ch='';
              if($activestatus==1){
                $activestatus_ch='checked';
              }

             ?>
          
        
 
                                                   <div class="col-md-6">
                                                      <div class="form-check mb-5">
                                                         <input class="form-check-input" type="checkbox" value="<?=$banner?>" name="<?=SESS_MASTER?>banner<?=$banner?>" <?=$activestatus_ch?>>
                                                         <img src="./../<?=$banner_path?>" class="img-fluid rounded-3">
                                                      </div>
                                                   </div>
                                                      

                                                        <?php     } ?>
                                                    
                                                      
                                                  
                                                      

                                                   <div class="col-md-12">
                                                    
                                                      <!--Important message Begin-->
                                                      <div class="alert alert-primary fs-14" role="alert">
                                                         <strong>Important message:</strong> We have pre-design coupon discount carousel you can use it. if you donot want pre-design coupon discount carousel click on the uncheck box.
                                                      </div>
                                                      <!--Important message End-->
                                                        <input name="<?=SESS_MASTER?>type" type="hidden"
                                                        value="discount" class="form-control" >
                                                      <button type="submit" class="btn btn-primary my-2">save</button>
                                                   </div>
                                                </div>
                                             </form>
                                             </div>
                                          </div>
                                       </div>
                                       <div class="col-md-6">
                                          <div class="card border-0  shadow mb-4">
                                             <div class="card-header bg-white border-bottom py-3">
                                                <h6 class="m-0 fw-bold text-inherit">Custom upload carousel</h6>
                                             </div>
                                             <div class="card-body">
                                                 <div class="card-body">
                                                <form action="./backend/upload_banner.php" method="post" enctype="multipart/form-data">
                                                <div class="row">
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                         
                                                         <input type="file"  name="<?=SESS_MASTER?>upload_banner1" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                        
                                                         <input type="file" name="<?=SESS_MASTER?>upload_banner2" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                        
                                                         <input type="file" name="<?=SESS_MASTER?>upload_banner3" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                        
                                                         <input name="<?=SESS_MASTER?>upload_banner4" type="file" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                         
                                                         <input name="<?=SESS_MASTER?>upload_banner5" type="file" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-6">
                                                      <div class="mb-5">
                                                         
                                                         <input name="<?=SESS_MASTER?>upload_banner6" type="file" class="form-control" >
                                                      </div>
                                                   </div>
                                                   <div class="col-md-12">
                                                      <!--Important messageBegin-->
                                                      <div class="alert alert-primary fs-14" role="alert">
                                                         <strong>Important message:</strong>  if you want custom upload carousel choose image. We recommend you that the size of the image will be <strong>350x200</strong> and its format will be jpg and png formate.
                                                      </div>
                                                      <!--Important messageEnd-->
                                                       <input name="<?=SESS_MASTER?>type" type="hidden"
                                                        value="discount" class="form-control" >
                                                      <button type="submit" class="btn btn-primary my-2">save</button>
                                                   </div>
                                                </div>
                                             </form>
                                             </div>
                                             </div>
                                          </div>
                                       </div>
                                    </div>
                                 </div>
                              </div>