name;
$code = $execute_external_procedure->sql;
$commentaire = $execute_external_procedure->comment;
}
else {
$row = mysql_fetch_row($res);
$idp = $row[0];
$name = $row[2];
$commentaire = $row[4];
if (!$code)
$code = $row[3];
$commentaire = $row[4];
}
if (!$is_external)
print pmb_bidi("
$msg[procs_execute] \" $name \"
$name : $commentaire
");
else
print "
".$msg["remote_procedures_executing"]." $name
$commentaire
";
$linetemp = explode(";", $code);
for ($i=0;$i$msg[procs_ligne] $cle : $valeur
";
if ( (pmb_strtolower(pmb_substr($valeur,0,6))=="select") || (pmb_strtolower(pmb_substr($valeur,0,6))=="create") ) {
} else {
echo "rqt=".$valeur."=
" ;
error_message_history("Requête invalide","Vous ne pouvez tester que des requêtes de sélection",1);
exit();
}
$res = @mysql_query($valeur, $dbh);
$nbr_lignes = @mysql_num_rows($res);
$nbr_champs = @mysql_num_fields($res);
if($nbr_lignes) {
echo "";
for($i=0; $i < $nbr_champs; $i++) {
// ajout de liens pour trier les pages
$fieldname = mysql_field_name($res, $i);
$sortasc = "asc";
$sortdesc = "desc";
print("| ${fieldname} | ");
}
for($i=0; $i < $nbr_lignes; $i++) {
$row = mysql_fetch_row($res);
echo "";
foreach($row as $dummykey=>$col) {
if(!$col) $col=" ";
print pmb_bidi("| $col | ");
}
echo "
";
}
echo "
";
} else {
print "$msg[admin_procs_lignes_affectees] : ".mysql_affected_rows($dbh);
$err = mysql_error($dbh);
if($err)
print "
$err";
}
print "
";
}
} // fin while
} else {
print $msg["proc_param_query_failed"];
}