Get data from sql server using stored procedure php

Hi,
I need to use a stored procedure to get data from an SQL server DB, I will then put the data in an HTML table. I can call to SQL server using a query but struggle to understand how to use a stored procedure, can anyone help?
Here is my code:

/* Empty data array */
$trackData = array( );

/* Connextion to SQL Server */
$server = 'tcp:address;

$credentials = array
(
  'UID'       = 'User',
  'PWD'       = 'password',
  'Database'  = 'myDB',
  'ReturnDatesAsStrings' =1

);
$connection = sqlsrv_connect( $server, $credentials );

/* Get sql data */
global $connection;
$sqlForTrack ="StoredProc";
FROM	PAReturn
WHERE	Handle 0";
$queryForTrack = sqlsrv_query( $connection, $sqlForTrack );
/* Handle sql errors if retuned */
if( $queryForTrack === false )
{
        echo ("failed to load query");
        die( 'pre class="error"' . print_r( sqlsrv_errors(), true ) . '/pre' );
}
            /* Handle sql response for track data */
            if( sqlsrv_num_fields( $queryForTrack ) )
            {
                    echo "thead
                    tr
                    thTrack/th
                    /tr
                    /thead";

                    while( $row = sqlsrv_fetch_array( $queryForTrack, SQLSRV_FETCH_ASSOC ) )
                    {
                            echo "tbody";
                            echo "tr";
                            echo "td" . $row['Track'] . "/td";
                            echo "/tr";
                            echo "/tbody";

                    }
                    echo "/table";
            }
    sqlsrv_free_stmt( $connectoin );
    sqlsrv_close ( $connection );

?
There will be more than one track and I want them to display on my table. The problem is I don’t understand how to give the stored proc the date variable, which is the parameter it needs to give me the tracks. Then output the tracks to my table.
I really appreciate any guidance.

Thanks

Source: https://www.sitepoint.com/community/t/get-data-from-sql-server-using-stored-procedure-php/291121

software quote best quote

Contact Us Now!
We'll Give You Our Best Quote For Your Commercial Software Needs!

Contact Us