I have a table that looks like the following:
When I press the view button, I want to start another page with a stored procedure in it that will bring me the extra data.
The stored proc requires the userName to pass as a parameter,
How would I take the username from the table and pass it in my stored procedure in another class?
Or if there is a better way to do it, how would I do that?
Any help, suggestions or guidance is very appreciated.
Here is my code for the stored Proc:
$sqlForUser = "SPgetUserDetails $userName" ;
$sqlForUser = sqlsrv_query ( $connection, $sqlForUser );
if( $sqlForUser )
echo " Connection to Stored Procedure Successful ";
echo " Failed to connect with Stored Procedure " ;
die ( print_r( sqlsrv_errors( ), true ) );