Code : Tout sélectionner
<?php require_once "PDO_connect.php";
$query="SELECT * FROM smartphone.select_nom_prenom_user";
try{
$prep = $bdd->prepare($query);
$prep->execute();
$resultats = $prep->fetchAll();
}catch(Exception $e){;
echo "Erreur ! ".$e->getMessage() ;
}
$host = "localhost";
$user = "root";
$pass = "Mm101010";
$dbn = "smartphone";
$link = mysqli_connect($host, $user, $pass, $dbn);
$type_gestion = 1;
switch ($type_gestion) {
case '1':
if (PHP_VERSION_ID < 50400) error_reporting (E_ALL | E_STRICT);
else error_reporting (E_ALL);
ini_set('display_errors', true);
ini_set('html_errors', false);
ini_set('display_startup_errors',true);
ini_set('log_errors', false);
ini_set('error_prepend_string','<span style="color: red;">');
ini_set('error_append_string','<br /></span>');
ini_set('ignore_repeated_errors', true);
break;
}
?>
<!DOCTYPE>
<html>
<head>
<title>Abonnement</title>
<script type="text/javascript" src=""quot;"quot;https://cdn.datatables.net/3.1.0/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" type="text/css" href="Select.css">
<style>
.selected{
color:red;
background-color: #EEE;}
</style>
<script type="text/javascript"></script>
<script src=""quot;"quot;https://code.jquery.com/jquery-1.12.4.js"></script>
<script src=""quot;"quot;https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
</head>
<body>
<center>
<table id="selectable" class="DataTable" >
<thead>
<tr>
<th>Operateur</th>
<th>SIM</th>
<th>PUK</th>
<th>Num ligne</th>
<th>Volume</th>
<th>Statut abo</th>
</tr>
</thead><tbody>
<?php
echo "<br>";
if(!empty($resultats)){
foreach ($resultats as $row) {
echo "<tr>";
echo "<td data-name=\"Operateur\">".$row["Operateur"]."</td>";
echo "<td data-name=\"Num_SIM\">".$row["Num_SIM"]."</td>";
echo "<td data-name=\"PUK\">".$row["PUK"]."</td>";
echo "<td data-name=\"Num_ligne\">".$row["Num_ligne"]."</td>";
echo "<td data-name=\"Volume\">".$row["Volume"]."</td>";
echo "<td data-name=\"Statut_abo\">".$row["Statut_abo"]."</td>";
echo "</tr>";
}
}else {
echo "Pas d'enregistrements dans cette table...";
}
?>
</tbody></table><br><br>
<?php
$query = "SELECT USER_ID, Nom, Num_SIM, Num_ligne FROM select_nom_prenom_user ORDER BY Nom, Num_SIM, Num_ligne ASC ";
if($result = mysqli_query($link, $query));
{
echo'<select name="select_nom_prenom_user onclick="action(val)">';
echo'<option value="" selected="selected" disabled="disabled">Selectionnée : Nom</option>';
while ($idresult = mysqli_fetch_row($result))
{
$USER_ID = $idresult[0];
$Nom = $idresult[1];
echo'<option value="' . $USER_ID . '">' . $Nom . '</option>';
}
echo'</select></p><p>';
}?>
<?php
$query = "SELECT USER_ID, Num_ligne, Nom, Num_SIM FROM select_nom_prenom_user ORDER BY Nom, Num_SIM, Num_ligne ASC";
if($result = mysqli_query($link, $query));
{
echo'<select name="select_nom_prenom_user">';
echo'<option value="" selected="selected" disabled="disabled">Selectionnée : Num ligne</option>';
while ($idresult = mysqli_fetch_row($result))
{
$USER_ID = $idresult[0];
$Num_ligne = $idresult[1];
echo'<option value="' . $USER_ID . '">' . $Num_ligne . '</option>';
}
echo'</select></p><p>';
}Code : Tout sélectionner
@en_tete= "SELECT `select_nom_prenom_user`.`USER_ID`, `select_nom_prenom_user`.`Nom`, `select_nom_prenom_user`.`Num_SIM`,`select_nom_prenom_user`.`Num_ligne` FROM select_nom_prenom_user WHERE (`select_nom_prenom_user`."
@QWhere="`" & @nomchamp & "` " & @contenuchamp & ")"
@nomchamp = "Nom"
@contenuchamp = $Nom
@query= @en_tete & @QWhere
$result = mysqli_query($link, $query)
$select = "SELECT `select_nom_prenom_user`.`USER_ID`, `select_nom_prenom_user`.`Num_SIM`, `select_nom_prenom_user`.`Num_ligne`, `select_nom_prenom_user`.`Nom`
FROM `select_nom_prenom_user`
WHERE (`select_nom_prenom_user`.`Nom` " & $ANDRE & ")"
