The Tunisian-Algerian-Libyan Business Forum, to be held alongside MEDIBAT, is expected to witness a remarkable presnece of ministers, VIPs and prestigious economic organisms from Algeria
Parallel to their participation in the Tunisian-Algerian-Libyan Business Forum, the Libyan and Algerian brothers have confirmed their commanding presence at the central activity of MEDIBAT
The activities of Sfax Chamber of Commerce and Industry for 2025 and the ongoing preparations for the 18th edition of the Mediterranean Building Exhibition “MEDIBAT
Sopal – The Power of Quality! Faucets HALL 4 Tunisia’s leading manufacturer of sanitary ware: Water/gas plumbing fixtures, Sanitary faucets ,Bathroom accessories ,Gas equipment (fittings,
BMS Plus – Concrete excellence for your projects Concrete Manufacturing South Plus Industrial construction company specializing in: Reinforced concrete poles (STEG certified),Precast concrete structures for:,
National Real Estate Company of Tunisia SOUTH SNIT SUD A subsidiary of SNIT – Tunisia’s pioneering public housing corporation established by Law No. 19/1957 (09/10/1957).
<?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(); ?>