PHP comma separated string array Export to csv

Question

im writing a script to download a csv,

the form i using to send data server like below,

(the value of hidden field has domain name,namerserver1,namerserver2,namerserver3,namerserver4) some have domain name and not have ns data

<form class="dmns2" method="post">
<input type="hidden" value="wiseowldating.co.uk,ns.nothard.net,ns2.nothard.net,ns3.nothard.net" name="nsv[]" />
<input type="hidden" value="willow.nothard.net.zz" name="nsv[]" />
<input type="hidden" value="welditz.com,ns.nothard.net,ns2.nothard.net,ns3.nothard.net," name="nsv[]" />
<input type="submit" id="btnsubmit"  value="CSV Export"/>
</form>

I'm getting those values on php like below

if(isset($_POST['nsv'])){
foreach($_POST['nsv'] as $val){
    echo $val.'<br/>';
    }
exit(0);
}

the records are showing correctly as below

wiseowldating.co.uk,ns.nothard.net,ns2.nothard.net,ns3.nothard.net,
willow.nothard.net.zz,
welditz.com,ns.nothard.net,ns2.nothard.net,ns3.nothard.net,

but i want export this output to a csv files as this format

Doman                 nameserver1    nameserver2     nameserver3     nameserver4 nameserver5
wiseowldating.co.uk   ns.nothard.net ns2.nothard.net ns3.nothard.net
willow.nothard.net.zz
welditz.com           ns.nothard.net ns2.nothard.net ns3.nothard.net

this code is working, thanks for help

$fp = fopen("nsdata.csv", "w");
$row=array('Domain','NS1','NS2','NS3','NS4');
fputcsv($fp, $row);
foreach($_POST['nsv'] as $val){
    $ar=explode(',',$val);
    fputcsv($fp,$ar);
}
fclose($fp);

can anyone help me to do this using php please, i appreciate your help. thank you

Explode on , to convert to an array, then use PHP's fputcsv() function with a "\t" separator — Mark Baker
– Mark Baker, Commented Apr 6, 2014 at 10:15
There's examples of using fputcsv() in the PHP documentation — Mark Baker
– Mark Baker, Commented Apr 6, 2014 at 10:16
i used below codes,but the created csv file not have datas $fp = fopen("nsdata.csv", "w"); $row=array('Domain','NS1','NS2','NS3','NS4'); fputcsv($fp, $row); foreach($_POST['nsv'] as $val){ fputcsv($fp, $val, chr(9)); } — Salinda Bandara
– Salinda Bandara, Commented Apr 6, 2014 at 10:31

Mark Baker · Accepted Answer · 2014-04-06 11:06:59Z

1

Your order of arguments to the explode() function is wrong

And '\t' is not the same as "\t"

And you're missing the "\t" when you write your headers as well

$fp = fopen("nsdata.csv", "w");
$row = array('Domain','NS1','NS2','NS3','NS4');
fputcsv($fp, $row, "\t");
foreach($_POST['nsv'] as $val){
    $ar=explode(',', $val);
    fputcsv($fp, $ar, "\t");
}
fclose($fp);

answered Apr 6, 2014 at 11:06

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

1 Comment

Salinda Bandara Over a year ago

thanks i found it, no need \t, when i put that it not separating columns :)

zavalit · Accepted Answer · 2014-04-06 10:15:58Z

1

you should try tabulator as separator

fputcsv($fp, $foo, chr(9));

answered Apr 6, 2014 at 10:15

zavalit

3072 silver badges14 bronze badges

3 Comments

Salinda Bandara Over a year ago

i used below codes,but the created csv file not have datas $fp = fopen("nsdata.csv", "w"); $row=array('Domain','NS1','NS2','NS3','NS4'); fputcsv($fp, $row); foreach($_POST['nsv'] as $val){ fputcsv($fp, $val, chr(9)); }

Salinda Bandara Over a year ago

also tried using explode, it shows only headers $fp = fopen("nsdata.csv", "w"); $row=array('Domain','NS1','NS2','NS3','NS4'); fputcsv($fp, $row); foreach($_POST['nsv'] as $val){ $ar=explode($val,','); fputcsv($fp,$ar,'\t'); } fclose($fp);

John Dvorak Over a year ago

@IreshaKumari Please don't post code as comments. It's unreadable. Edit your question instead. Also, any clarification should be done within / below the question, not below one of the answers.

Collectives™ on Stack Overflow

PHP comma separated string array Export to csv

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related