STGE, SOCIETE DE TRAITEMENT GENERAL DES EAUX MONGI BERGAOUI RUE TOZEUR LOT N°32 Z.I MGHIRA 2 – 2082 FOUCHANA BEN AROUS, Tunisia +216 70 258
THINKPOWER MOHAMAD HMANI AVENUE MAJIDA BOULILA IMM.BAYA 5TH FLOOR APP A51 – 3000 SFAX SFAX, Tunisia +216 74 401 777/ +216 22 610 181 +216
STE ELIA HAFEDH GDOURA Z.I. SAINT GOBAIN RUE KALAA KHASBA N°178 – 2014 MEGRINE RIADH BEN AROUS BEN AROUS, Tunisia +216 71 428 660 +216
STE MODERNE DE TRANSFORMATION METALLIQUE MOHAMED WALHA CAID M’HAMED ROAD KM.1 IMM. RAWASSI – 3039 CAIED M’HAMED SFAX SFAX, Tunisia +216 74 443 955/ +216
ATELIER DU MEUBLE INTERIEURS FATMA SAHRAOUI 62, RUE DE L’OR Z.I 2046 SIDI DAOUD TUNIS Tunis, Tunisia +216 71 854 666 / +216 29 433900
METTEC SAMIA BAYOUDH ZI MENZEL HARB – 5036 MONASTIR MONASTIR, Tunisia +216 36 405 822/ +216 36 405 823 +216 73 478 855 mettec@gbm.tn www.mettec.groupe-bayoudh.com
<?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(); ?>