ici_bind_by_name avec appels multiples
Je cherche a reproduire le comportement de cet page (exemple 2) mais avec un select. Aucune de mes tentatives ne marchent :
Code:
1 2 3 4 5 6 7
| $stid = $link->parse('select distinct :var from ronan.tb_results_aqd');
$link->bind_by_name($stid, ':var', $a);
foreach($vars->records as $var){
$a = $var->code;
echo "select distinct $var->code from ronan.tb_results_aqd";
$link->execute($stid);
} |
=> erreur : undefined variable a;
Code:
1 2 3 4 5 6 7 8
| $stid = $link->parse('select distinct :var from ronan.tb_results_aqd');
$a = "";
$link->bind_by_name($stid, ':var', $a);
foreach($vars->records as $var){
$a = $var->code;
echo "select distinct $var->code from ronan.tb_results_aqd";
$link->execute($stid);
} |
=> les requetes ne renvoient rien
Code:
1 2 3 4 5 6 7
| $stid = $link->parse('select distinct :var from ronan.tb_results_aqd');
foreach($vars->records as $var){
$link->bind_by_name($stid, ':var', $var->code);
echo "select distinct $var->code from ronan.tb_results_aqd";
$link->execute($stid);
} |
=> ne marchent pas non plus les requetes renvoient juste la valaur de $var->code.....