PHP - Connecting to and executing a stored procedure in an SQL server.

SQL - Stored Procedure.php

$serverName = "value.cloudapp.net";
    $connectionInfo = array( "Database"=>"value", "UID"=>"value", "PWD"=>"value");
    $conn = sqlsrv_connect( $serverName, $connectionInfo);
    if( $conn === false )
    {
        echo "Could not connect.\n";
        print('<pre>');
        die( print_r( sqlsrv_errors(), true));
        print('</pre>');
    }



    /*--------- The next few steps call the stored procedure. ---------*/

    /* Define the Transact-SQL query. Use question marks (?) in place of
    the parameters to be passed to the stored procedure */
    $tsql_callSP = "{call InsertUser(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";

    /* Define the parameter array. By default, the first parameter is an
    INPUT parameter. The second parameter is specified as an INOUT
    parameter. Initializing $vacationHrs to 8 sets the returned PHPTYPE to
    integer. To ensure data type integrity, output parameters should be
    initialized before calling the stored procedure, or the desired
    PHPTYPE should be specified in the $params array.*/

    //$date = date_create('2000-01-01');
    $date = '01-01-2000';

    echo $date;

    $Title = 'value';
    $FirstName = 'value';
    $MiddleName = 'value';
    $LastName = 'value';
    $Gender = 'value';
    $DOB = $date;
    $Email = 'value';
    $Phone = 'value';
    $Mobile = 'value';
    $ResidentialAddress = 'value';
    $ResidentialPostCode = 'value';
    $ResidentialSuburb = 'value';
    $ResidentialState = 'value';
    $ResidentialCountry = 'value';
    $PostalAddress = 'value';
    $PostalPostCode = 'value';
    $PostalSuburb = 'value';
    $PostalState = 'value';
    $PostalCountry = 'value';
    $BrowserDetails = 'value';
    $IsActive = 1;
    $Password = 'value';
    $Salt = 'value';
    $LastLogin = $date;
    $CompanyID = null;
    $Created = $date;
    $CreatedBy = 'value';
    $LastModified = $date;
    $LastModifiedBy = 'value';
    $Username = 'value';
    $UserRole = 'value';

    $params = array(
        array($Title, SQLSRV_PARAM_IN),
        array($FirstName, SQLSRV_PARAM_IN),
        array($MiddleName, SQLSRV_PARAM_IN),
        array($LastName, SQLSRV_PARAM_IN),
        array($Gender, SQLSRV_PARAM_IN),
        array($DOB, SQLSRV_PARAM_IN),
        array($Email, SQLSRV_PARAM_IN),
        array($Phone, SQLSRV_PARAM_IN),
        array($Mobile, SQLSRV_PARAM_IN),
        array($ResidentialAddress, SQLSRV_PARAM_IN),
        array($ResidentialPostCode, SQLSRV_PARAM_IN),
        array($ResidentialSuburb, SQLSRV_PARAM_IN),
        array($ResidentialState, SQLSRV_PARAM_IN),
        array($ResidentialCountry, SQLSRV_PARAM_IN),
        array($PostalAddress, SQLSRV_PARAM_IN),
        array($PostalPostCode, SQLSRV_PARAM_IN),
        array($PostalSuburb, SQLSRV_PARAM_IN),
        array($PostalState, SQLSRV_PARAM_IN),
        array($PostalCountry, SQLSRV_PARAM_IN),
        array($BrowserDetails, SQLSRV_PARAM_IN),
        array($IsActive, SQLSRV_PARAM_IN),
        array($Password, SQLSRV_PARAM_IN),
        array($Salt, SQLSRV_PARAM_IN),
        array($LastLogin, SQLSRV_PARAM_IN),
        array($CompanyID, SQLSRV_PARAM_IN),
        array($Created, SQLSRV_PARAM_IN),
        array($CreatedBy, SQLSRV_PARAM_IN),
        array($LastModified, SQLSRV_PARAM_IN),
        array($LastModifiedBy, SQLSRV_PARAM_IN),
        array($Username, SQLSRV_PARAM_IN),
        array($UserRole, SQLSRV_PARAM_IN)
    );

    /* Execute the query. */
    $stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params);
    if( $stmt3 === false )
    {
        echo "Error in executing statement 3.\n";
        die( print_r( sqlsrv_errors(), true));
    }

    /*Free the statement and connection resources. */
    sqlsrv_free_stmt($stmt3);
    sqlsrv_close($conn);