<!doctype html>

<html lang="fr">
     <head>
     <title>Liste</title>
      <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
     <meta name = "format-detection" content = "telephone=no" />
     <link rel="icon" href="images/favicon.ico">
     <link rel="shortcut icon" href="images/favicon.ico" />
     <link rel="stylesheet" href="css/stylel.css">
     <script src="js/jquery.js"></script>
     <script src="js/jquery-migrate-1.1.1.js"></script>
     <script src="js/script.js"></script> 
     <script src="js/superfish.js"></script>
     <script src="js/jquery.equalheights.js"></script>
     <script src="js/jquery.mobilemenu.js"></script>
     <script src="js/jquery.easing.1.3.js"></script>
     <script src="js/jquery.ui.totop.js"></script>

		
   

<style>
body {
   	
	background-image: url("/img/examplebg.jpg");
	background-repeat: repeat;
}


</style>


</head>

 <body class="page1" id="top">

<header>
  <div class="container">
    <div class="row">
    <div class="grid_12">
    
      <div class="clear"></div>
    
<br>
<h3> Etablir un devis </h3>
<!--==============================Content=================================-->
<div class="content">
  <div class="container">
    <div class="row">


<?php
	

//*************************** carrarctéristque des lignes du tableau **********************

	//$CarTab="<div class='col-sm-4'> <h3 class='mg-md'>";

$SOC=" ";
$NOM1=" ";
$NOM2=" ";
$NOM3=" ";
$NOM4=" ";
$NOM5=" ";
$TITRE=" ";
$PUB=" ";
$AC1=" ";
$AC2=" ";
$O1=" ";
$O2=" ";
$O3=" ";
$MAIL=" ";
$GSM=" ";
$TEL=" ";

// on se connecte à notre base

$servername = "localhost:8889";
$username = "test";
$password = "test";
$dbname = "Clients";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT * FROM data";
//$sql = "SELECT * FROM data WHERE id=1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
     //   echo "Soc: " . $row["societe"]. " - Nom: " . $row["nom1"]. " - idx: " . $row["id"]. " " . $row["nom2"]. "<br>";
	
	print "<div class='grid_3'><div class='box'><div class='maxheight'>";   	
	print $row["societe"];
	print "<br>";
	
	
	print "<div class='title1'>";
	print $row["nom1"];
	print "</div><br>";
	
	print $row["nom2"];
	print "<br>";


	print $row["nom3"];
	print "<br>";

	print $row["gsm"];
	print "<br>";

	print $row["tel"];
	print "<br>";

	print $row["mail"];
	print "<br>";



	print"</div>";
	
	print "</div>";
	print "</div>";
		
		
		
		
		
		//echo "Soc: " . $row["societe"]. " - Nom: " . $row["nom1"]. "  " . $row["nom2"]. "<br>";
    } 
    
	
	} else {
    echo "0 results";
}

//$sql = "INSERT INTO data (societe,nom1,nom2,nom3,nom4,nom5,titre,ac1,ac2,o1,o2,o3,mail,tel,gsm,pub,jour)
//VALUES ('$SOC' , '$NOM1', '$NOM2', '$NOM3', '$NOM4', '$NOM5', '$TITRE', '$AC1', '$AC2', '$O1', '$O2', '$O3', '$MAIL', '$TEL', '$GSM', '$PUB', //'$today')";


$conn->close();


		
		
         





	
	

?>
</div>
   <div class="clear"></div>

    </div>
  </div>
</div>
<br>
<a href="exelvue2.php">Liste de devis</a><br>
<br>
  
</body>
</html>

