DaniWeb Forum Index > Web Development > PHP

Displaying files from database

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2009

Posts: 25

Reputation: SuntechWebsites is an unknown quantity at this point

Solved Threads: 0

SuntechWebsites SuntechWebsites is offline

Offline

Light Poster

Displaying files from database

30 Days Ago

Is there a way I can display an image, pdf or word doc that is stored in a my sql database?
I tried to pull up a word doc with this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$sql = " SELECT * FROM user WHERE username = '$_SESSION[MM_Username]' ";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result)) {
$inv=$row['invoice'];}
 ?>
 <?php echo " Your Invoice: ".$inv." ";
?>
$sql = " SELECT * FROM user WHERE username = '$_SESSION[MM_Username]' ";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result)) {
$inv=$row['invoice'];}
 ?>
 <?php echo " Your Invoice: ".$inv." ";
?>

But all I got was code from the document.

Last edited by Ezzaral; 30 Days Ago at 1:06 pm. Reason: Added [code] [/code] tags. Please use them to format any code that you post.

•

Join Date: Oct 2006

Posts: 1,004

Reputation: ardav will become famous soon enough

Solved Threads: 130

ardav

Offline

Veteran Poster

-1

30 Days Ago

I take it that your invoice field just contains the file's url and not the file itself.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$inv = $row['invoice'];
$base = basename($inv); //you don't want to display the full path in the link label
 
...in loop...
echo "<a href=\"$inv\" title=\"\">$base</a>";
$inv = $row['invoice'];
$base = basename($inv); //you don't want to display the full path in the link label

...in loop...
echo "<a href=\"$inv\" title=\"\">$base</a>";

Last edited by ardav; 30 Days Ago at 12:21 pm.

"...the woods would be a very silent place if no birds sang except for the best"
All opinions count - unless you're a serial downvoter.
F'enw i yw Mr. Blaidd. Byddwch yn ofalus - dwi'n cnoi.

•

Join Date: Oct 2009

Posts: 25

Reputation: SuntechWebsites is an unknown quantity at this point

Solved Threads: 0

SuntechWebsites SuntechWebsites is offline

Offline

Light Poster

30 Days Ago

No it is the file itself. Not a good idea?
My goal is to have it so the site owner can upload an invoice for a specific user. Then when that user loggs in, they will only be able to view their invoice or whatever via the session.