1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
| div class="panel-body">
<table width="100%" class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th>Utilisateur</th>
<th>Sender</th>
<th>Date(s)</th>
<th>Destinataire</th>
<th>Message</th>
</tr>
</thead>
<?php
$sql = " select login_utilisateur , upper(sender_id) as sender,date_envoie,destinataire,left(message,15) as message from sms_detail_transactions ";
$result = $conn->query($sql);
while ($donnee=mysqli_fetch_array($result,MYSQLI_ASSOC))
{
$login_utilisateur = $donnee["login_utilisateur"];
$sender = $donnee["sender"];
$date_envoie = $donnee["date_envoie"];
$destinataire = $donnee["destinataire"];
$message = $donnee["message"];
?>
<tbody>
<tr class="odd gradeX" >
<td><?php echo $login_utilisateur; ?></td>
<th><?php echo $sender;?></th>
<td><?php echo $date_envoie; ?></td>
<th><?php echo $destinataire;?></th>
<th><?php echo $message;?></th>
</tr>
</tbody>
<?php
}
mysqli_close($conn);
?>
</table>
<!-- /.table-responsive --> |
