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); |
Partager