Lancio di store procedures MYSQL da PHP

[davidl77]

Grazie! Tra l'altro su forum americano ho trovato questo esempio, che ricalca quanto hai detto.

Ciao e grazie.

$qry="call proc_name"; 
mysql_query($qry); 
//here your procedure is called now if you have set an value in procedure 
//(i.e. using character @) e.g. @var_name; 
//Now simply write down following lines 
//plz don't use select clause in procedure this will create an problem in php 

$qry1="select @var_name"; 

//this var name is set in procedure 
//e.g. set @var_name=some_value; 

$res=mysql_query($qry); 
while($rec=mysql_fetch_array($res)) 
{ 
$val=$rec[0]; 
echo "$val"; 
}