
    	
      <table border="0" cellspacing="0" cellpadding="0">
  
		  
		  
        <tbody>
			
<?php
			
       	

// on se connecte à notre base pour devis

$servername = "localhost:8889";
$username = "root";
$password = "root";
$dbname = "devis";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
								
//$sql = "SELECT * FROM tete WHERE ( etat='0' OR etat='4' ) AND num like'%".$_POST['client']."%' ";
$sql = "SELECT * FROM tete WHERE ( etat='0' OR etat='4' ) AND num like'%".$_POST['client']."%' ";

            // print "<br>".$sql;	
	 
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
   // print "resultats";
    while($row = $result->fetch_assoc()) {
				
		$NUM=$row["num"];
$IDX=$row["idx"];
$DATE=$row["date"];
$OBJET=$row["objet"];
$IDXCLI=$row["idxcli"];
$MEMO=$row["memo"];
$NumeroIdxClient=$row["idxcli"];;
$CHANTIER=$row["chantier"];
$TVA=$row["tva"];
$BANQUE=$row["banque"];
$REMARQUE=$row["remarque"];
		
		// *********************    connection clients *************************
		
								$servername1 = "localhost:8889";
								$username1 = "root";
								$password1 = "root";
								$dbname1 = "Clients";

								// Create connection
								$conn1 = new mysqli($servername1, $username1, $password1, $dbname1);
								// Check connection
								if ($conn1->connect_error) {
								die("Connection failed: " . $conn1->connect_error);
								} 

			
								$sql1 = "SELECT * FROM data WHERE id=".$NumeroIdxClient." ";
								//print "<br>".$sql1;	
		 
								$result1 = $conn1->query($sql1);
		
								if ($result1->num_rows > 0) {
    							// output data of each row
								while($row1 = $result1->fetch_assoc()) {
								//print "<br>".$row1['societe']."  ".$row1['nom1'];
									$tempsoc=$row1['societe'];
									$tempnom1=$row1['nom1'];
									    } 
    
	
									} else {
										// echo "0 results";
									}




$conn1->close();
									
									
		
		
            
		    print "<tr>";
            print "<td class='no'>". $NUM."</td>";
      
         print "<td class='desc'><form method='post' action='textedit.php' name='demande'><button name='dnumdevis' id='liensubmit' type='submit' value='".$IDX."'>".$tempsoc."  ".$tempnom1." <br> ". $OBJET. " <br> ".$DATE."</button></form></td>";
        
        //print "<td class='desc'>".$tempsoc."  ".$tempnom1." <br> ". $OBJET. " <br> ".$DATE;
        //    print"</td>";
		//	print 
           print "<td class='unit'><form method='post' action='textedit.php' name='offrechif'><button name='dnumdevis' id='liensubmit2' type='submit' value='".$IDX."'>Offre chiffrée</button></form>";
            print "<form method='post' action='texteditconcat.php' name='textecon'><br><button name='dnumdevis' id='liensubmit2' type='submit' value='".$IDX."'>Offre complète</button></form></td>";
          //  print "</td>";
            print "</tr>";

    } 
    
	
	} else {
 //print "resultats 2";
    // Recherhce par nom
    $sql = "SELECT * FROM tete WHERE ( etat='0' OR etat='4' )  ";
	// $sql = "SELECT * FROM tete WHERE  etat>'0'  ";
	
    //print "<br>".$sql;	
	 
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    
    
 while($row = $result->fetch_assoc()) {
				
		$NUM=$row["num"];
$IDX=$row["idx"];
$DATE=$row["date"];
$OBJET=$row["objet"];
$IDXCLI=$row["idxcli"];
$MEMO=$row["memo"];
$NumeroIdxClient=$row["idxcli"];;
$CHANTIER=$row["chantier"];
$TVA=$row["tva"];
$BANQUE=$row["banque"];
$REMARQUE=$row["remarque"];
		
		// *********************    connection clients *************************
		
								$servername1 = "localhost:8889";
								$username1 = "root";
								$password1 = "root";
								$dbname1 = "Clients";

								// Create connection
								$conn1 = new mysqli($servername1, $username1, $password1, $dbname1);
								// Check connection
								if ($conn1->connect_error) {
								die("Connection failed: " . $conn1->connect_error);
								} 

			
								$sql1 = "SELECT * FROM data WHERE ( societe LIKE '%".$_POST['client']."%' OR nom1 LIKE '%".$_POST['client']."%') AND id=".$NumeroIdxClient." ";
								//print "<br>".$sql1;	
		 
								$result1 = $conn1->query($sql1);
		
								if ($result1->num_rows > 0) {
    							// output data of each row
								while($row1 = $result1->fetch_assoc()) {
								//print "echo <br>".$row1['societe']."  ".$row1['nom1'];
									$tempsoc=$row1['societe'];
									$tempnom1=$row1['nom1'];
                                    
       //nom afficher    
                                 	
		
            
		    print "<tr>";
            print "<td class='no'>". $NUM."</td>";
      
         print "<td class='desc'><form method='post' action='textedit.php' name='demande'><button name='dnumdevis' id='liensubmit' type='submit' value='".$IDX."'>".$tempsoc."  ".$tempnom1." <br> ". $OBJET. " <br> ".$DATE."</button></form></td>";
        
        //print "<td class='desc'>".$tempsoc."  ".$tempnom1." <br> ". $OBJET. " <br> ".$DATE;
        //    print"</td>";
		//	print 
           print "<td class='unit'><form method='post' action='textedit.php' name='offrechif'><button name='dnumdevis' id='liensubmit2' type='submit' value='".$IDX."'>Offre chiffrée</button></form>";
            print "<form method='post' action='texteditconcat.php' name='textecon'><br><button name='dnumdevis' id='liensubmit2' type='submit' value='".$IDX."'>Offre complète</button></form></td>";
          //  print "</td>";
            print "</tr>";   
                                    
                                    
									    } 
    
	
									} else {
										// echo "0 results";
									}




$conn1->close();
									
									
		
		
            
		 

    } 
    
    
    
    
    
    
    }
    
}




$conn->close();
		

		?>	
			
     
        </tbody>
        
      </table>
     
      <div id="notices">
        <div><br>&nbsp;<br>
          
          <form action="index.html">
               <input class="form-control" id="btst" type="submit" value="HOME" />
	            </form>
          </div>
       
      </div>
    </main>
  
  </body>
</html>