Venez poser vos questions PHP, MySQL, HTML5, CSS, Javascript, Gestion de serveurs à la communauté PHPfrance
https://forum.phpfrance.com/
<?php
//PHP avant tout
if (!empty($_POST)) {
//la connexion
$connect = mysqli_connect("localhost", "root", "Mm101010", "smartphone");
//la requete de recherche
$query = "Select * from vu_affect_empl ";
if (!empty($_POST["query"])) {
$search = mysqli_real_escape_string($connect, $_POST["query"]);
$query .= "WHERE USER_ID LIKE '";
$query .= $search;
$query .= "%' OR USER_ID LIKE '";
$query .= $search;
$query .= "%' OR Num_SIM LIKE '";
$query .= $search;
$query .= "%' ORDER BY Nom asc";
} else {
$query .= "ORDER BY USER_ID";
}
//Lancement de la requete
$result = mysqli_query($connect, $query);
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8"/>
</head>
<body>
<?php
if(isset($result) && mysqli_num_rows($result) > 0) {
?>
<div class="table-responsive">
<table class="table table bordered">
<tr onclick="SelectLigne(this)">
<td> </td>
<th>USER ID</th>
<th>Nom</th>
<th>Prenom</th>
<th>Num SIM</th>
<th>PIN Terminal</th>
<th>PIN SIM</th>
<th>Num EMEI</th>
<th>Date Debut</th>
<th>Date Fin</th>
<th>Vitre</th>
<th>Coque</th>
<th>Support Vehicule</th>
<th>Actif</th>
<th>Or Affectation1</th>
<th>Statut</th>
</tr>
<?php
while($row = mysqli_fetch_array($result)) {
?>
<tr>
<td><input type="checkbox" name="Select[]" value="<?php echo $row['USER_ID'];?>" class="Selection"> </td>
<td><?php echo $row["USER_ID"]; ?></td>
<td><?php echo $row["Nom"]; ?></td>
<td><?php echo $row["Prenom"]; ?></td>
<td><?php echo $row["Num_SIM"]; ?></td>
<td><?php echo $row["PIN_Terminal"]; ?></td>
<td><?php echo $row["PIN_SIM"]; ?></td>
<td><?php echo $row["Num_IMEI"]; ?></td>
<td><?php echo $row["Date_Debut"]; ?></td>
<td><?php echo $row["Date_Fin"]; ?></td>
<td><?php echo $row["Vitre"]; ?></td>
<td><?php echo $row["Coque"]; ?></td>
<td><?php echo $row["Support_Vehicule"]; ?></td>
<td><?php echo $row["Actif"]; ?></td>
<td><?php echo $row["Or_Affectation1"]; ?></td>
<td><?php echo $row["Statut"]; ?></td>
</tr>
<?php
} } else { echo 'Pas enregistrement pour le moment'; }
?>
</body>
.selected > td {
background-color : pink;
font-weight : bold;
}function changeValueOfCheckbox(check) {
var tr = document.getElementById(check.value);
var cssClass = tr.getAttribute('class');
if (cssClass === null) {
cssClass = '';
}
if (check.checked) {
// add class selected
cssClass += ' selected';
} else {
// suppression class selected
var sel = ' selected';
var i = cssClass.indexOf(sel);
if (i > -1) {
var tmp = cssClass.substring(0, i);
tmp += cssClass.substring(i + sel.length);
cssClass = tmp;
}
}
tr.setAttribute('class', cssClass);
}
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8"/>
</head>
<body>
<?php
if(isset($result) && mysqli_num_rows($result) > 0) {
?>
<div class="table-responsive">
<table class="table table bordered">
<tr>
<th> </th>
<th>Operateur</th>
<th>Num SIM</th>
<th>PUK</th>
<th>Num ligne</th>
<th>Volume</th>
<th>Statut abo</th>
</tr>
<?php
while($row = mysqli_fetch_array($result)) {
?>
<tr class="selected">
<td><input type="checkbox" onchange="changeValueOfCheckbox(this)" name="Selected" value="<?php echo $row['Operateur'];?>" > </td>
<td class="ui-widget-content" name="selected"><?php echo $row["Operateur"]; ?></td>
<td class="ui-widget-content" name="selected"><?php echo $row["Num_SIM"]; ?></td>
<td class="ui-widget-content" name="selected"><?php echo $row["PUK"]; ?></td>
<td class="ui-widget-content" name="selected"><?php echo $row["Num_ligne"]; ?></td>
<td class="ui-widget-content" name="selected"><?php echo $row["Volume"]; ?></td>
<td class="ui-widget-content" name="selected"><?php echo $row["Statut_abo"]; ?></td>
</tr>
<?phpfunction changeValueOfCheckbox(check) {
var tr = document.getElementById(check.value);
var cssClass = tr.getAttribute('class');
if (cssClass === null) {
cssClass = '';
}
if (check.checked) {
// add class selected
cssClass += ' selected';
} else {
// suppression class selected
var sel = ' selected';
var i = cssClass.indexOf(sel);
if (i > -1) {
var tmp = cssClass.substring(0, i);
tmp += cssClass.substring(i + sel.length);
cssClass = tmp;
}
}
tr.setAttribute('class', cssClass);
}