$Code=strtoupper($Code); $sql_select_code_obso1="SELECT * FROM obso1 WHERE UCASE(Code_Serveur)='$Code'"; $stmt_obso1 = $conn->prepare($sql_select_code_obso1); $stmt_obso1->execute(); $result_obso1=$stmt_obso1->fetchAll(); if(!empty($result_obso1)){ //echo "debug: ".$result_obso1[0]["Code_Serveur"]; foreach($result_obso1 as $record1){ $Nom_PLI_obso1=$record1['Nom_PLI']; $Version_obso1=$record1['Version']; $sql_select_obso2="SELECT * FROM obso2 WHERE Nom_PLI='$Nom_PLI_obso1' AND Version='$Version_obso1'"; $stmt_obso2=$conn->prepare($sql_select_obso2); $stmt_obso2->execute(); $result_obso2=$stmt_obso2->fetchAll(); foreach ($result_obso2 as $record2) { echo '<tr><td>'.$HostName.'</td><td>'.$Code.'</td><td>'.$record1['Nom_PLI'].'</td><td>'.$record1['Version'].'</td><td>'.$record1['Date_maj'].'</td><td>'.$record2['Date_fin_support1'].'</td><td>'.$record2['Date_fin_support2'].'</td><td>'.$record2['Status_support'].'</td><td>'.$record2['Soumis_a_licence'].'</td></tr>'; $final_result_csv_row=$HostName.';'.$Code.';'.$record1['Nom_PLI'].';'.$record1['Version'].';'.$record1['Date_maj'].';'.$record2['Date_fin_support1'].';'.$record2['Date_fin_support2'].';'.$record2['Status_support'].';'.$record2['Soumis_a_licence']."\n"; array_push($GLOBALS['csv'], $final_result_csv_row); } } } } if($_GET["input"]){ selectobso($_GET["input"]); } ?>
<?php set_time_limit(0); $input = array(); $input = $_GET["elements_Of_Selected_List2"]; try { $conn = new PDO("mysql:host=localhost;dbname=csv", 'root', 'root', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "<table id='table_groupe_obso' border='5' width='100%' class='sortable table table-condensed table-bordered table-striped table-hover'>"; echo "<thead><tr><th>Basicat</th>\n\t\t\t\t\t\t<th>ID_Appli</th>\n\t\t\t\t\t\t<th>Appli</th>\n \t<th>HostName</th>\n <th>Code_Serveur</th>\n <th>Nom_PLI</th>\n <th>Version</th>\n <th>Date_maj</th>\n <th>Date_fin_support1</th>\n <th>Date_fin_support2</th>\n <th>Status_support</th>\n <th>Soumis_a_licence</th>\n </tr></thead><tbody>"; foreach ($input as $app) { selectobso($app); } echo "</tbody></table>"; } catch (PDOException $e) { echo '<br/>' . $e->getMessage() . '<br/>'; } $conn = null; function selectobso($input) { $conn = new PDO("mysql:host=localhost;dbname=csv", 'root', 'root', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $input = strtoupper($input); $sql_select_basicat = "SELECT HostName,Code,Basicat,ID_Appli,Appli FROM ressources WHERE UCASE(Basicat)='{$input}'"; $sql_select_id = "SELECT HostName,Code,Basicat,ID_Appli,Appli FROM ressources WHERE ID_Appli='{$input}'"; $sql_select_name = "SELECT HostName, Code,Basicat,ID_Appli,Appli FROM ressources WHERE UCASE(Appli) LIKE '{$input}%'"; $stmt0 = $conn->prepare($sql_select_basicat); $stmt1 = $conn->prepare($sql_select_id); $stmt2 = $conn->prepare($sql_select_name); $stmt0->execute(); $result0 = $stmt0->fetchAll();