I've got a MySQL stored procedure and would like to get a list of it's parameter names and types. I'm able to get a single list of procedure parameters by doing the following MySQL SELECT:
Code: Select all
$sql = "SELECT param_list FROM mysql.proc WHERE db = '" . $dbName . "' AND name = '" . $storedProcedureName . "';";
$res = $mysqli->query( $sql );
while( $row = $res->fetch_assoc() )
{
foreach( $row as $value )
{
echo $value;
}
}
Code: Select all
IN p_name VARCHAR( 255 ),
IN p_description VARCHAR( 255 ),
OUT p_userID INT( 15 )
1. Param type ( ie. IN / OUT / INOUT )
2. Param name ( ie. p_name, p_userID, etc. )
3. Param var type ( ie. INT( 15 ), VARCHAR( 255 ), etc. )
This way I'd be able to loop through each array to get information about each parameter like so:
Code: Select all
$idx = 1;
foreach( $paramNames as $name )
{
echo "PARAM #" . $idx . " NAME: " . $name . "<br/>";
$idx = $idx + 1;
}
Any help would be great! Thanks!