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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
<?php
session_start();
$serverName = ".";
$uid = "sa";
$pwd = "p";
$dbname = "test";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>$dbname);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
$num_EAchat=$_SESSION["num_EAchat"];
$sql = "Select * from V_ETA where N_ETA='".$num_EAchat."'";
$params = array();
$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query( $conn, $sql, $params, $options);
$num = sqlsrv_num_rows($stmt);
?>
<html></br>
<table border=3 bordercolordark="#CC0000" >
<tr>
<td>Mat Barque/VSB </td>
<td>Nom Barque/VSB</td>
<td>N°DC</td>
<td>Code Espéce </td>
<td>désignation Espéce</td>
<td>Poids acheté par ce mareyeur(kg)</td>
<td>poids vendi par Barque/VSB(kg) </td>
</tr>
<?php
while($row=sqlsrv_fetch_array($stmt)){
?>
<tr>
<td><?php echo $row ['Code_Vendeur']; ?></td>
<td><?php echo $row ['Vendeur']; ?></td>
<td width="140"><?php echo $row ['N_DC']; ?></td>
<td><?php echo $row ['Code_Espece']; ?></td>
<td><?php echo $row ['Design_Espece']; ?></td>
<td><?php echo $row ['PoidsAchate']; ?></td>
<td><?php echo $row ['PoidsVendu']; ?></td>
</tr>
<?php
}
?>
</html> |
