<?php
/*
Template Name: liste exposants
*/



get_header(); 

get_template_part( 'template-parts/banner/content', 'banner-page' ); 

$blog_sidebar = exhibz_option('blog_sidebar',3); 

$column = ($blog_sidebar == 1 || !is_active_sidebar('sidebar-1')) ? 'col-md-12' : 'col-lg-8 col-md-12';





?>
<link rel="stylesheet" type="text/css" href="<?php bloginfo('template_url'); ?>/assets/css/style_medibat.css">
<div>
<?php /*?>  <div class="titre-exposant-2019" style="display:none;"><a href="<?php echo get_permalink( '5855' ); ?>" target="_blank">Liste des exposants 2019</a></div>
<?php */?>  <?php



/*$login=$_REQUEST['Login'];
$password=$_REQUEST['Password'];
$_SESSION['login']=$login;
$badge=$_SESSION['login'];*/
$_SESSION['num_badge'];
//$_SESSION['Password'];

//$_SESSION['lang'] = qtrans_getLanguage();
//require_once('traduction.php');
 $dbhost = "localhost";
$dbuname = "medibat_demo23";
$dbpass = "2_h3Pe8d6";
$dbname = "salonmedibat_demo23";

$connexion = mysqli_connect($dbhost, $dbuname, $dbpass,$dbname);
mysqli_set_charset($connexion, "utf8");
		function query($sql){
    GLOBAL $connexion;
    $res=mysqli_query($connexion,$sql);
    return $res;
}

$wh1="";
$wh2="";
$wh3="";
if(isset($_POST["mot_rech"]) && $_POST["mot_rech"]!="")
{ 
$mot_rech=mysqli_escape_string($_POST["mot_rech"]);
$wh1.=" and (`nom` like '%$mot_rech%' or `nom_ang` like '%$mot_rech%' or `nom_ar` like '%$mot_rech%' or `activite` like '%$mot_rech%' or `activite_ang` like '%$mot_rech%' or `activite_ar` like '%$mot_rech%')";
}

if(isset($_POST["sect_rech"]) && $_POST["sect_rech"]!="")
{ 
$sect_rech=mysqli_escape_string($_POST["sect_rech"]);
$wh2.=" and (`secteur` = '$sect_rech' or `secteur_ang` = '$sect_rech' or `secteur_ar` = '$sect_rech' ) ";
}

if(isset($_POST["pays_rech"]) && $_POST["pays_rech"]!="")
{ 
$pays_rech=mysqli_escape_string($_POST["pays_rech"]);
$wh3.=" and (`pays` = '$pays_rech' or `pays_ang` = '$pays_rech' or `pays_ar` = '$pays_rech' ) ";
}

?>
  <input type='hidden' id='current_page' />
  <input type='hidden' id='show_per_page' />
  <div class="exposantframe">
    <div class="container">
      <div class="titre-exposant"><img decoding="async" src="<?php bloginfo('template_url'); ?>/images/puce.png"> Exposants MEDIBAT 2023 :</div>
      <form name="rech" id="rech" action="<?php echo get_page_link(5857); ?>" method="post">
        <div class="recherche-exposant">
          <div class="select-exposant">
            <select name="select1" id="select1" class="select-exposant">
              <option value="" selected>Recherche par secteur</option>
              <?php 
								  $req26=mysqli_query("select id,(secteur) from secteur order by secteur asc");
								  while($res26=mysqli_fetch_array($req26)) {
								  ?>
              <option value="<?php echo $res26['id']; ?>" <?php if($res26['id']==$sect_rech) echo 'selected="selected"'; ?>><?php echo $res26['1']; ?></option>
              <?php } ?>
            </select>
          </div>
          <div class="select-exposant">
            <select name="pays_rech" id="pays_rech" class="select-exposant">
              <option  value="" selected>Recherche par pays</option>
              <?php 
                                              $req27=mysqli_query("select distinct(pays) from p_exposant where annee='2023' order by pays asc");
                                              while($res27=mysqli_fetch_array($req27)) {
                                              if($res27['0']!=''){
                                              ?>
              <option value="<?php echo $res27['0']; ?>" <?php if($res27['0']==$pays_rech) echo 'selected="selected"'; ?>><?php echo $res27['0']; ?></option>
              <?php } } ?>
            </select>
          </div>
          <div class="select-exposant">
            <input type="text" name="mot_rech" id="mot_rech" value="" placeholder="<?php echo mot_rech; ?>"  class="style-mot"/>
          </div>
          <div class="boutton-envoyer-rech">
            <input type="submit" name="Envoyer" value="ok" class="input-envoyer">
          </div>
        </div>
      </form>
      <!--recherche-exposant-->
      <div class="ekit-wid-con detail-exposant">
        <div id="content" class="row">
                      <?php
					  	 
                        
                        //echo "select * from p_exposant where annee='2023' $wh1 $wh2 $wh3 order by nom ASC";

                    $req54=query("select * from p_exposant where annee='2023' $wh1 $wh2 $wh3 order by nom ASC");

                    while($res54=mysqli_fetch_array($req54)) {
                    ?>
                      <div class="col-lg-4 col-md-4 col-sm-4 col-xs-12 bloc-exposant">
                      <a href="<?php echo get_page_link(426); ?>?societe=<?php echo $res54['id'];?>">
                        <div class="exposant">
                          <div class="logo-exposant">
                            <?php $path_h="https://www.salon-medibat.com"; ?>
                            <?php if($res54['logo']!='') {?>
                            <img decoding="async" src="<?php echo $path_h."/wp-content/uploads/logo/".$res54['logo']; ?>" />
                            <?php } else { ?>
                            <img decoding="async" src="<?php bloginfo('template_url'); ?>/assets/images/no_image.png" />
                            <?php } ?>
                          </div>
                         
                          <?php /*?><div class="titreliste-exposant">
                            <?php echo $res54['nom']; ?>
                          </div>
                          <div class="hr_exposant">
                            <hr>
                          </div><?php */?>
                          <div class="donne-exposant">
                            <div class="icone-expo"><img decoding="async" src="<?php bloginfo('template_url'); ?>/assets/images/icone1.png"></div>
                            <div class="donne-icone">
                              <?php $var_sect=$res54['secteur']; $re=query("select * from secteur where id='$var_sect'");
                              $row1=mysqli_fetch_array($re);
                              echo $row1['secteur']; ?>
                            </div>
                            <div class="clear"></div>
                          </div>
                          <div class="donne-exposant">
                            <div class="icone-expo"><img decoding="async" src="<?php bloginfo('template_url'); ?>/assets/images/icone2.png"></div>
                            <div class="donne-icone"><?php echo $res54['tel'];?> </div>
                            <div class="clear"></div>
                          </div>
                          <div class="donne-exposant">
                            <div class="icone-expo"><img decoding="async" src="<?php bloginfo('template_url'); ?>/assets/images/icone3.png"></div>
                            <div class="donne-icone"><?php echo $res54['fax'];?> </div>
                            <div class="clear"></div>
                          </div>
                          <div class="donne-exposant">
                            <div class="icone-expo"><img decoding="async" src="<?php bloginfo('template_url'); ?>/assets/images/icone4.png"></div>
                            <div class="donne-icone"><?php echo $res54['email'];?></div>
                            <div class="clear"></div>
                          </div>
                          <div class="lien-exposant"></div>
                          </div></a> 
                      </div>
                      <?php } ?>
                    </div>
      </div>
      <div class="clear"></div>
      
      
     <div class="paginator style_pag"></div>
                  <!--paginator style_pag--> 
                  <script>
                       jQuery(function ($) {  
                          
                              pagination(6,'.bloc-exposant','.paginator',3);
                          
                        });
                        
                      </script>

<script src="<?php bloginfo('template_url'); ?>/js/pagination.js"></script>

<?php 
get_footer(); ?>