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
|
$proc = mssql_init("pda_Drum_Movement",$link);
$code = "010101";
$num_lot = "123/12/A8";
$bidon = 1;
$newEmplacement = "AB0102Z";
$societe= "A";
$PDA= "MonPDA";
$retour= 10;
// Bind the parameters
mssql_bind($proc, "@code", $code, SQLVARCHAR, FALSE, TRUE,20);
mssql_bind($proc, "@num_lot", $num_lot, SQLVARCHAR, FALSE, TRUE,10);
mssql_bind($proc, "@bidon", $bidon, SQLINT1);
mssql_bind($proc, "@newEmplacement", $newEmplacement, SQLVARCHAR, FALSE, TRUE,10);
mssql_bind($proc, "@societe", $societe, SQLVARCHAR, FALSE,TRUE,1);
mssql_bind($proc, "@PDA", $PDA, SQLVARCHAR, FALSE, TRUE,255);
//Parametre de la variable de sortie
mssql_bind($proc, "@retour", $retour, SQLINT1, TRUE, TRUE);
echo "<center><h2>av = ".$retour."</h2></center>";
mssql_execute($proc)or die("Erreur MSSQL : " . mssql_get_last_message());
echo "<center><h2>ap = ".$retour."</h2></center>";
mssql_close($link); |
