PDO stored procedures

[powerblade]

Hi, I'm working with

-MySql 5.1.11

-PHP 5.2.6

-local server windows IIS 5

 

When I use a stored procedure without parameter, it works.

When I use a stored procedure with an input parameter, I have no error message but nothing happens.

And when I use a stored procedure with an output paameter, I have no message error but the parameter keeps the value 0.

 

here is my source:

 

echo "<b> viewallclient() Liste tous les clients existants</b><br /><hr />";

$tabresult= $id_base->prepare('CALL viewallclient()');

$tabresult->execute();

foreach ($tabresult as $valeur)

{

  echo ($valeur[0]),"<br />";

}

echo "<b>view1client(p) Liste un client dont le code est donné en paramètre d'entrée</b><br /><hr />";

$par1='B112';

  $tabresult= $id_base->prepare('CALL view1client(?)');

// $tabresult->bindParam(1, $par1);

$tabresult->execute();

foreach ($tabresult as $valeur)

{

  echo ($valeur[0]),"<br />";

}

  echo "<b>maximumprice() Affiche le prix maximum d'un produit en paramètre de retour</b><br /><hr />";

$res=0;

  $tabresult= $id_base->prepare('CALL maximumprice(?)');

  $tabresult->bindParam(1, $res, PDO::PARAM_INT, 5);

  $tabresult->execute(); 

    echo "valeur max = $res";

    $id_base = null;

 

How can I do to use stored pocedures with parameters?