create csv with headings

[sailu_mvn]

Hi I want to generate a csv file with has specific headings like name , email etc and when i run my php script, all the data should go on heading respectively,like name for john email for email. any suggestions?

[djjjozsi]

how about this'?

<?

$variables=array("Name","Email","Telephone");

if($_POST)
{
if (!file_exists('data.csv'))
{
 $fp = fopen('data.csv', 'w');
 foreach($variables AS $elements)
 {
 fwrite($fp, str_replace("_"," ",$elements.';'));
 }
 fwrite($fp, "\n");
}

 foreach($variables AS $elements)
 {
 fwrite($fp, $_POST["$elements"].';');
 }
 fwrite($fp, "\n");

 fclose($fp);
}

print '<form name="form" method="post" action="?">
';
foreach($variables AS $elements)
{
print str_replace("_"," ",$elements).':<input type="text" name="'.$elements.'"><br>
';
}
print '<input type="submit" name="Submit" value="Submit"> </form>
';
?>

sailu_mvn;10891981 wrote:

Hi I want to generate a csv file with has specific headings like name , email etc and when i run my php script, all the data should go on heading respectively,like name for john email for email. any suggestions?

[sailu_mvn]

Thanks alot....

But i want to be more specific..

The headings are nov,novcap,jan,jancap,....etc. In nov column, nov.txt is placed ,and in jan - jan.jpg respectively.These fields are constants will never change. The only columns that change are novcap,jancap..etc..

How do I make this happen...

P.s advice

[djjjozsi]

so, the trefixes are changing, but the postfixes are constants.

how is the method you select or set which file will printed ?

i offer you, to create a function

function make_head($var)
{
return "<img src=\"$var.jpg\"><br>
Message:". include("$var".txt);
}

and you will start the header with this:

make_head("nov");

but the cleanest way would be the mysql database...

you could store the texts, and links to the images, and that is searchable..

sailu_mvn;10892003 wrote:

Thanks alot....
But i want to be more specific..
The headings are nov,novcap,jan,jancap,....etc. In nov column, nov.txt is placed ,and in jan - jan.jpg respectively.These fields are constants will never change. The only columns that change are novcap,jancap..etc..
How do I make this happen...
P.s advice

[sailu_mvn]

am generating a csv using php code below.

$cr = "\n";

$data = "Jan" . ',' . "Jancap" . ',' . "Feb" . ',' . "Febcap" . ','."Mar".','."Marcap".','."April".','."Aprilcap".','."May".','."MayCap".','."June".',
'."Junecap".','."July".','."Julycap".','."August".','."Augustcap".','."September".','."Septembercap".','."October".','."Octobercap".','."November".','."Novembercap".','."December".','."Decembercap".$cr;

$data .= jan.jpg . ',' .$image_name_january . ',' . feb.jpg . ',' . $image_name_january .march.jpg . ',' .$image_name_january . ',' . april.jpg . ',' . $image_name_january . may.jpg . ',' .$image_name_january . ',' . june.jpg . ',' . $image_name_january .july.jpg . ',' .$image_name_january . ',' . august . ',' . $image_name_january .','.september.jpg . ',' .$image_name_january . ',' . october.jpg . ',' . $image_name_january .','.november.jpg . ',' .$image_name_january . ',' . december.jpg . ',' . $image_name_january .$cr;

$csv_contents .= $data;

function write_to_file($filename, $stringtowrite, $writetype)
{
$filesession = fopen($filename,$writetype);
fwrite($filesession,"$stringtowrite");
fclose($filesession);
}
write_to_file('exportfile.csv',$csv_contents, 'w');

Everything is working fine..but when it comes to columns in csv, from June on, they are printed in the next line. I want them as headings.How can I sort this problem?

Pls advice.

[djjjozsi]

stop 🙂
read the ######################## part.
a string is like this:

$string="A string";

$string='A string';

how to add a string into another

$string1='123123123';

$string2='1444423423123123';
$string3=$string1.$string2;

$a=1.jpg; <--- i don't know that is a good syntax friend...

##########################
to add a . or , sign into a string:
$value1="2.jpg";
$value2="1.jpg";

$string="This a string, and value1 has a value=$value1, and this is a comma delimiter,,,,";
$string3='With an apostrofe, the data entered, and the variables won't appears with its values,';

$string3.=' i mean, $value2 , so int the text you print will contain a dollar sign...and any special characters will shown as a non special character ';

[sailu_mvn]

thanks alot ..but have done it ion other way like ass.array.

Thanks truly