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).
HOUSING LAND AGENCY AFH As the leading public operator in urban planning and residential land development, HLA is committed to customer satisfaction in all its
Green Energy Company GEC Founded in 2018, GEC is a company specializing in the photovoltaic sector. We provide solar system installation and maintenance services for
Gypsobat – Dry and Wet Systems Gypsobat is a division within the Hammami Group, specializing in dry and wet systems.Wet Systems: Comprising a range of products (spray plasters, projection
<?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(); ?>