Create comma delimited .csv file with php

Question

I am trying to:

create comma delimited .csv file with php code.
Insert column name in the first line of the .csv file.

Please advise how can I make this happen.

    <?php

    header("Content-type: text/csv");
    header("Content-Disposition: attachment; filename=".$batch_id.".csv");
    header("Pragma: no-cache");
    header("Expires: 0");   

    $conn_sp = mssql_connect("SQLServer", "user", "password"); 
    $db_sp = mssql_select_db("databaseName", $conn_sp); 
    $stmt = mssql_init("[StoredProcedureName]",$conn_sp);       
    mssql_bind($stmt, "@BatchNo", $batch_id, SQLVARCHAR, FALSE, FALSE, 20);     
    $result = mssql_query("SET ANSI_NULLS ON"); 
    $result = mssql_query("SET ANSI_WARNINGS ON");      
    $result = mssql_execute($stmt);
    $record="";
    $comma=",";
    $record_end="\n";
    while ($row = mssql_fetch_array($result, MSSQL_ASSOC)){ 

    foreach ($row as $key => $value) {      

          echo $value;      
        }
        echo "\n";  

    }?>

!

I tried these articles but didn't work. Not sure but I am doing wrong, so please if you can advise on the above code, I will appreciate. Thank you! — Paul
– Paul, Commented Sep 30, 2016 at 15:38
First thing first, if you remove the headers, then you got something right?...can you post the output you are getting? — Hackerman
– Hackerman, Commented Sep 30, 2016 at 15:41

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

Well just look at how a .csv-file is created.

Usually like this:

Delimiter: ,

New line: \n

Enclose entry by: "

e.g.

"r1a","r1b","r1c"

"r2a","r2b","r2c"

etc...

This is how your code should work (untested):

         echo '"colname1","colname2",...';

         while ($row = mssql_fetch_array($result, MSSQL_ASSOC)){ 
        
            $first = true;
            foreach ($row as $key => $value) {      
    
                if(!$first) {
                     echo ",";
                }
        
                  echo '"'.$value.'"';      
                }
                echo "\n";  
                $first=false;
            }

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Sep 30, 2016 at 16:24

Blackbam

19.7k31 gold badges112 silver badges167 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

chris85 Over a year ago

Don't make your own CSV parser. What if $value has double quotes, commas?

Paul Over a year ago

So, what's the best way to go, Chris? Can u please share example? Thank you!

chris85 Over a year ago

@Paul Please use the @ to tag users, notifications aren't sent otherwise. You should use the built in option, php.net/manual/en/function.fputcsv.php. There are examples on that page. If you are having issues with that post your usage and what happens.

Blackbam Over a year ago

@chris85 In most cases this own .csv parser will do perfectly well. The only issue I can think of is with double quotes - it can be solved like here: stackoverflow.com/questions/17808511/…

Collectives™ on Stack Overflow

Create comma delimited .csv file with php

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related