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();
if (!empty($result0)) {
$numOfCode = count($result0);
for ($i = 0; $i < $numOfCode; $i++) {
selectPLI($result0[$i]["Basicat"], $result0[$i]["ID_Appli"], $result0[$i]["Appli"], $result0[$i]["HostName"], ltrim($result0[$i]["Code"], '0'));
}
} else {
$stmt1->execute();
$result1 = $stmt1->fetchAll();
if (!empty($result1)) {
$numOfCode = count($result1);
for ($i = 0; $i < $numOfCode; $i++) {
selectPLI($result1[$i]["Basicat"], $result1[$i]["ID_Appli"], $result1[$i]["Appli"], $result1[$i]["HostName"], ltrim($result1[$i]["Code"], '0'));
}
} else {
$stmt2->execute();
$result2 = $stmt2->fetchAll();
if (!empty($result2)) {
$numOfCode = count($result2);
for ($i = 0; $i < $numOfCode; $i++) {
selectPLI($result2[$i]["Basicat"], $result2[$i]["ID_Appli"], $result2[$i]["Appli"], $result2[$i]["HostName"], ltrim($result2[$i]["Code"], '0'));
}
} else {
echo $input . ' NE PAS EXISTER' . '<br/>';
}
}
}
}
function selectobso($input){
error_reporting(0);
set_time_limit(0);
try {
session_start();
$conn = new PDO("mysql:host=localhost;dbname=csv", 'root', 'root',array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$input=strtoupper($input);
//echo $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();
if (!empty($result0)){
$_SESSION['obso_result']=$result0;
echo 'Il y a<code><b> '.count($result0).'</b></code> serveurs<br/>';
echo 'Input is basicat'.'<br/><br/>';
echo '<div class="btn-group">';
echo '<button class="btn btn-warning btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> Export Table Data</button>';
echo '<ul class="dropdown-menu " role="menu">';
echo '<li><a target="_blank" href="obso2csv.php"><img src=\'images/csv.png\' width=\'24px\'>CSV</a></li>';
echo '<li><a target="_blank" href="obso2pdf.php"><img src=\'images/pdf.png\' width=\'24px\'>PDF</a></li></ul>';
echo '</div>';
ob_start();
$appli_nom=explode('-',$result0[0]['Appli']);
$nom=$appli_nom[0];
echo "<table id='table_obso' border='5' width='100%' class='sortable table table-condensed table-bordered table-striped table-hover'>";
$caption="ID_Appli: ".$result0[0]['ID_Appli']."<br/>"."Appli: ".$nom."<br/>"."Basicat: ".$result0[0]['Basicat'];
echo '<caption style="color:#FF6600">'.$caption.'</caption><br/>';
echo "<thead><tr>
<th>HostName</th>
<th>Code_Serveur</th>
<th>Nom_PLI</th>
<th>Version</th>
<th>Date_maj</th>
<th>Date_fin_support1</th>
<th>Date_fin_support2</th>
<th>Status_support</th>
<th>Soumis_a_licence</th>
</tr></thead><tbody>
";
$numOfCode=count($result0);
$GLOBALS['csv']=array();
for($i=0;$i<$numOfCode;$i++){
selectPLI($result0[$i]["HostName"],ltrim($result0[$i]["Code"],'0'));
}
echo "</tbody></table>";
$obso_table=ob_get_contents();
$_SESSION['obso_pdf']=$obso_table;
$_SESSION['table_obso_csv']=$GLOBALS['csv'];
// echo 'Debug: '.$final_result_csv;
//$_SESSION["obso_sql_result"]=$result0;
//displayContentsOfObso($result0);
}
//echo $result['ID_Appli'].'<br/>';
else{
$stmt1->execute();
$result1=$stmt1->fetchAll();
if(!empty($result1)){
$_SESSION['obso_result']=$result1;
echo 'Il y a<code><b> '.count($result1).'</b></code> serveurs<br/>';
echo 'Input is ID_Appli'.'<br/><br/>';
echo '<div class="btn-group">';
echo '<button class="btn btn-warning btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> Export Table Data</button>';
echo '<ul class="dropdown-menu " role="menu">';
echo '<li><a target="_blank" href="obso2csv.php"><img src=\'images/csv.png\' width=\'24px\'>CSV</a></li>';
echo '<li><a target="_blank" href="obso2pdf.php"><img src=\'images/pdf.png\' width=\'24px\'>PDF</a></li></ul>';
echo '</div>';
ob_start();
$appli_nom=explode('-',$result1[0]['Appli']);
$nom=$appli_nom[0];
echo "<table id='table_obso' border='5' width='100%' class='sortable table table-condensed table-bordered table-striped table-hover'>";
$caption="ID_Appli: ".$result1[0]['ID_Appli']."<br/>"."Appli: ".$nom."<br/>"."Basicat: ".$result1[0]['Basicat'];
echo '<caption style="color:#FF6600">'.$caption.'</caption><br/>';
echo "<thead><tr>
<th>HostName</th>
<th>Code_Serveur</th>
<th>Nom_PLI</th>
<th>Version</th>
<th>Date_maj</th>
<th>Date_fin_support1</th>
<th>Date_fin_support2</th>
<th>Status_support</th>
<th>Soumis_a_licence</th>
</tr></thead><tbody>";
$numOfCode=count($result1);
$GLOBALS['csv']=array();
for($i=0;$i<$numOfCode;$i++){
selectPLI($result1[$i]["HostName"],ltrim($result1[$i]["Code"],'0'));
}
echo "</tbody></table>";
$obso_table=ob_get_contents();
$_SESSION['obso_pdf']=$obso_table;
$_SESSION['table_obso_csv']=$GLOBALS['csv'];
//echo 'Debug: '.$final_result_csv;
}else{
$stmt2->execute();
$result2=$stmt2->fetchAll();
if(!empty($result2)){
$_SESSION['obso_result']=$result2;
echo 'Il y a<code><b> '.count($result2).'</b></code> serveurs<br/>';
echo 'Input is Appli Nom'.'<br/><br/>';
echo '<div class="btn-group">';
echo '<button class="btn btn-warning btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> Export Table Data</button>';
echo '<ul class="dropdown-menu " role="menu">';
echo '<li><a target="_blank" href="obso2csv.php"><img src=\'images/csv.png\' width=\'24px\'>CSV</a></li>';
echo '<li><a target="_blank" href="obso2pdf.php"><img src=\'images/pdf.png\' width=\'24px\'>PDF</a></li></ul>';
echo '</div>';
ob_start();
$appli_nom=explode('-',$result2[0]['Appli']);
$nom=$appli_nom[0];
echo "<table id='table_obso' border='5' width='100%' class='sortable table table-condensed table-bordered table-striped table-hover'>";
$caption="ID_Appli: ".$result2[0]['ID_Appli']."<br/>"."Appli: ".$nom."<br/>"."Basicat: ".$result2[0]['Basicat'];
echo '<caption style="color:#FF6600">'.$caption.'</caption><br/>';
echo "<thead><tr>
<th>HostName</th>
<th>Code_Serveur</th>
<th>Nom_PLI</th>
<th>Version</th>
<th>Date_maj</th>
<th>Date_fin_support1</th>
<th>Date_fin_support2</th>
<th>Status_support</th>
<th>Soumis_a_licence</th>
</tr></thead><tbody>";
$numOfCode=count($result2);
$GLOBALS['csv']=array();
for($i=0;$i<$numOfCode;$i++){
//echo 'debug out: '.$final_result_csv;
selectPLI($result2[$i]["HostName"],ltrim($result2[$i]["Code"],'0'));
//echo count($final_result_csv);
}
echo "</tbody></table>";
$obso_table=ob_get_contents();
$_SESSION['obso_pdf']=$obso_table;
//echo count($GLOBALS['csv']);
$_SESSION['table_obso_csv']=$GLOBALS['csv'];
}else{
echo 'NE PAS EXISTER'.'<br/>';
}
}
}
}
catch(PDOException $e){
echo '<br/>' . $e->getMessage().'<br/>';
}
$conn = null;
}
