$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();
