[Resolved] tab delimitated .txt?

move3rd

Could anyone point me in the right direction?

I would like to export data from a MYSQL DB table as a tab delimitated file. After searching the forums here, google and hotscripts tutorials I havent managed to find any info on this.
😕

devinemke

http://www.phpmyadmin.net

move3rd

Thanks devinemke

I know phpmyadmin can do exactly what I want but I would like to put the same fuctionality (export tab deliminated) into one of my own scripts.

---- :eek: :eek: :eek: ----

Just noticed how i spelt deliminated (delimitated). Maybe thats why my seacrchs didnt give many results? :queasy:

devinemke

wouldn't be to hard to roll your own. pull the records you want. loop thru the results inserting the \t character between fields and the \n character between records then write it all to a text file. a ruff example:

$result = mysql_query('SELECT * FROM table');
$string = '';
while ($row = mysql_fetch_assoc($result))
{
	$string .= implode("\t", $row) . "\n";
}

$handle = fopen('/path/to/file.txt', 'w');
fwrite($handle, $string);
fclose($handle);

drew010

[edit] beat me by a few mins 😉[/edit]

its not hard to make a tab delimited file, a tab character is represented by a \t in php, much like a newline is \n. assuming you are looping from mysql here is an example.

$fp = fopen(...);
$result = mysql_query($somequery);

while($data = mysql_fetch_array($result)) {
  fwrite($fp, $data['row1'] . "\t" . $data['row2'] . "\t" . $data['row3'] . "\t" . $data['row4'] . "\n");
}
fclose($fp);

each row returned from sql will be on a line separated by a tab.

move3rd

Thank you both!😃