$servername = '.SQLSERVER';

    $username = 'databaseuser';

    $password = 'database';

    $database = 'CriticalPath';

    $table = 'Users';

 

    if (!function_exists('mssql_fetch_row'))

    {

        $output .= "MSSQL functions are not available.
n";

        exit;

    }

 

    // Connect database

    if(!$dbconnect = mssql_connect($servername, $username, $password))

    {

        $output .= "Connection failed to the host 'localhost'.";

        exit;

    } // if

        

    if (!mssql_select_db($database))

    {

        $output .= "Cannot connect to database '$database'";

        exit;

    } // if

    

    $result=mssql_query("select * from $table");

    

    $out = '';

 

    $columns = mssql_num_fields($result);    

 

    for ($i = 0; $i < $columns; ++$i) {

        // Fetch the field information

        $field = mssql_fetch_field($result, $i);

        $out .= '"'.$field->name.'",';

    }

       

    $out .= "r";

    

    // Add all values in the table to $out.

    while ($l = mssql_fetch_array($result)) 

    {

       for ($i = 0; $i < $columns; $i++) 

       {

          $out .='"'.$l[fusion_builder_container hundred_percent="yes" overflow="visible"][fusion_builder_row][fusion_builder_column type="1_1" background_position="left top" background_color="" border_size="" border_color="" border_style="solid" spacing="yes" background_image="" background_repeat="no-repeat" padding="" margin_top="0px" margin_bottom="0px" class="" id="" animation_type="" animation_speed="0.3" animation_direction="left" hide_on_mobile="no" center_content="no" min_height="none"]["$i"].'",';

       }

 

       $out .= "r";

    }

    

    // Open file export.csv.

    $f = fopen ('export.csv','w');

    

    // Put all values from $out to export.csv.

    fputs($f, $out);

    fclose($f);

    

    header('Content-type: application/csv');

    header('Content-Disposition: attachment; filename="export.csv"');

    readfile('export.csv');

 

    mssql_free_result($result);

 

?>