Never used it. Is it a CMS?

Hi all,

Still working on this, but have made some decent progress. I’m trying to give the admin the ability to export certain users out of the DB into a CSV. I’m not on a php5 box (I know…boooo!), so the csv functions are not available. I found a little snippet online, but it’s messing up the data.

$result = mysql_query($sql) or die(mysql_error()); $csv_output = ""; while($row=mysql_fetch_assoc($result)) { foreach($row as $key=>$value) { if($key = "welcomepack"){$csv_output .= " '". $value ."'";}else{$csv_output .= " '". $value ."',";} } if($key = "welcomepack") { $csv_output .= "\n"; } } header("Content-type: application/vnd.ms-excel"); header("Content-disposition: attachment; filename=csvRide.csv"); print $csv_output; exit;

http://ridering.net/csv-dir/csvDL.php

that link will take you to the download.

If anyone has any thoughts as to why the data is being separated like that, please let me know. I’ve had help from some of the users at Sitepoint, but still no luck.

Thanks!

Thanks,

I don’t know why there’s only one equals sign in those conditionals…
$sql = "SELECT * FROM user WHERE type = '6' "; //echo $sql; $result = mysql_query($sql) or die(mysql_error()); $csv_output = ""; while($row=mysql_fetch_assoc($result)) { foreach($row as $key=>$value) { if($key = "welcomepack"){$csv_output .= " '". $value ."'";}else{$csv_output .= " '". $value ."',";} } if($key = "welcomepack") { $csv_output .= "\n"; } } header("Content-type: application/vnd.ms-excel"); header("Content-disposition: attachment; filename=csvRide.csv"); print $csv_output; exit;

I have the values encased in single quotes so that if there are commas in the data, it doesn’t cause it to separate by those commas in the csv. “welcomepack” is the last field, so that’s why i have that conditional there to check…if it is, don’t put a comma after it. if it isn’t, then put a comma.

When I print it out on the screen, without the prompt to download, all the data looks fine. It doesn’t cut it up and put it in places it shouldn’t be.

edit: dammit, the php formatting wipes extra equals signs away…they’re there.

Another thing I noticed is that your strings have to be in double quotes in order for the commas contained within them to be ignored.
Here is what I did.

@<?php
$con = mysqli_connect("localhost", "root", "", "products");

$result = $con->query("SELECT * FROM products");

$csv_output = "";
$headers = true;
while($row = mysqli_fetch_array($result))
{
if($headers)
{
foreach($row as $key=>$values)
{
if(is_string($key))
{
$csv_output .= "<b>".$key."</b>";
$csv_output .= ($key == "model") ? "\r\n" : ","; // model is the last column
}
}
$headers = false;
}
$count = 10;
for($i=0; $i<$count; $i++)
{
$csv_output .= "\"".$row[$i]."\"";
$csv_output .= ($i == ($count-1)) ? "\r\n" : ",";
}
}

header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename=csvRide.csv");

print $csv_output;

exit;
?>@

Hmm, the formatting doesn't seem to like me.

Good call. That would be a rather large string.

Not to sound like a killjoy, but couldn’t you just use phpMyAdmin for this? It has excellent CSV support built-in, preventing you from having to reinvent the wheel… Also, with a quick glance at this page in the mySQL 4.1.x Reference Manual, I discovered that ‘mysqldump’ accepts the following flags:

--fields-terminated-by=..., --fields-enclosed-by=..., --fields-optionally-enclosed-by=..., --fields-escaped-by=...

So there’s really no need to even bother with PHP. ^_

Most business owners wedding invitations know well their business preferences as evidenced in wedding invitation their choices of logos,letterhead and exhibits for trade shows. Often, these preferences don’t translate to creative bridesmaid dresses designs of wedding invitation a high professional quality when attempted in-house.