<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
    
    <script>
       
$(document).ready(function(){
    


    
    
//    $( "#lignebanque" ).click(function() {
//  alert( "Handler for .click() called." );
//});
    
    
   	
   
});

</script>
    <?php
    
    
    
                                $servername1 = "localhost:8889";
								$username1 = "root";
								$password1 = "root";
								$dbname1 = "banque";
      // Create connection 2
								$conn2 = new mysqli($servername1, $username1, $password1, $dbname1);
								// Check connection
								
                                if ($conn2->connect_error) {
								die("Connection failed: " . $conn2->connect_error);
								} 
         $sql1 = "UPDATE `TABLE3` SET `COL 36`='".$_POST['numfac']."' WHERE `COL 1`= '".$_POST['idxref']."'  ";
     $sql1 = "UPDATE `TABLE3` SET `COL 36`= NULL  WHERE `COL 1`= '".$_POST['idxref']."'  ";
    $sql1 = "SELECT * FROM `TABLE3` where `COL 8` LIKE '%".$_POST['bqs']."%' OR `COL 11` LIKE '%".$_POST['bqs']."%' OR `COL 14` LIKE '%".$_POST['bqs']."%' OR `COL 15` LIKE '%".$_POST['bqs']."%'  ";
								//print "<br>".$sql1;	
		 
								$result2 = $conn2->query($sql1);
    
    if ($result2->num_rows > 0) {
    // output data of each row
    while($row = $result2->fetch_assoc()) {
        //echo "Soc: " . $row["societe"]. " - Nom: " . $row["nom1"]. " - idx: " . $row["id"]. " " . $row["nom2"]. "<br>";
		//echo "Soc: " . $row["societe"]. " - Nom: " . $row["nom1"]. "  " . $row["nom2"]. "<br>";
		print "<div id='ligneid' style='font-size:10px'>".$row["COL 1"]." </div>";
	print "<div id='lignebanque' style='font-size:18px'>".$row["COL 7"]." ".$row["COL 8"].$row["COL 10"].$row["COL 11"].$row["COL 14"].$row["COL 15"]."<br>".$row["COL 30"]." Compte : ".$row["COL 12"]."</div>";
      
    } 
     // print $sql;$str[$c]= mb_convert_encoding($str[$c], "UTF-8", "Windows-1252");
	
	} else {
    echo "0 results";
}
    
    
    
    

                                $conn2->close(); 
                                    
                                    
    
    
    
    ?>

<body>
</body>
</html>