Link to download field from mysql database as .txt

[Meilad]

Hey there.

Setting up a lyrics website and just wondering if anyone's managed to come across any tutorials that handle downloading a value from database?

ie. click here to download this lyric as text.

Cheerssss!

[bradgrafelman]

I assume you know how to retrieve the lyrics from the database.

All you'd have to do, is make a link to.. "download.php?id=1234" or something similar, and in that script, retrieve the lyrics from the DB into a variable ($data in my code) and have these headers:

header ('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header ('Content-Type: application/octet-stream');
header ('Content-Length: ' . filesize($data));
header ('Content-Disposition: attachment; filename="lyrics.txt"');

echo $data;

That's it! Those headers will force the user's browser to actually download the page instead of just displaying it.

EDIT: By the way, welcome to PHPBuilder! Enjoy your stay, and come back soon 😃

[Meilad]

cheers gangsta.

I'll give this a go once i'm home 🙂

Cu!

[Meilad]

Yo wassup mate.

I tried it with the following variation just to test....

header ('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header ('Content-Type: application/octet-stream');
header ('Content-Length: ' . filesize($datax));
header ('Content-Disposition: attachment; filename="lyrics.txt"');

$lyricsecure = $_GET['lyric'];

$data = "SELECT * FROM lyrics LEFT JOIN artists ON lyrics.artist = artists.aid LEFT JOIN albums ON lyrics.album = albums.id WHERE lyrics.lid = '$lyricsecure'";                

$datar = mysql_fetch_row( $data );
$datax = $datar[0];

echo $datax;

no workyyyy >_<

also another thing mate is that I'm using php switch to have a base template. So yea page is like index.php?page=download&lyric=261 which i can select lyric 261 with success but when I try your method the text files just full of the html code for the page >_<!!!!

another thing mate which i forgot to mention is that I want to echo the artist id and other such details within the text file :S

Ie.

Lyric Title

Artist: asdfasdf
Album: asdfasdf
Year: asdfasdf

Lyric:

asdfasdf
asdf
asdf

Possible?

[bradgrafelman]

Just keep using echo(). Pretend you're not actually echo'ing anything, but instead echo() writes the data you tell it to into the "lyrics.txt" and at the end of your script, the "file" is sent to the browser for download.

Could you perhaps give me a URL to this script? I'd like to double check all of your headers and whatnot.

[Meilad]

gotitttttttttttttttttttt 😃 ^_

got a mate to lend a hand. finally sorted it all out.

header ('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header ('Content-Type: application/octet-stream');
header ('Content-Length: ' . filesize($datax));
header ('Content-Disposition: attachment; filename="lyric.txt"');

$lyric = $_GET['lyric'];

$data = mysql_query("SELECT * FROM lyrics LEFT JOIN artists ON lyrics.artist = artists.aid LEFT JOIN albums ON lyrics.album = albums.id WHERE lyrics.lid = '$lyric'");                


while($row = mysql_fetch_array( $data )) {

echo "".ucwords($row['title']).

"\r\n\r\nArtist: ".ucwords($row['artistname']).
"\r\nAlbum: ".$row['albumtitle'].
"\r\nYear: ", $row['year'],
"\r\n\r\n\r\nLyrics:\r\n\r\n".(stripslashes($row['lyrics']));
}