| | |
display image file from mysql databse using php
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jun 2008
Posts: 2
Reputation:
Solved Threads: 0
I'm having a problem with displaying my profile images from a database .the upload works fine,but no image is displayed:Could you please help!
I have the following code which cant work:
1. main profile page has the following script:
<?php echo '<img src="XXXXX_XXX.php?id=$Current_Person_Id">';
---------------------------------------------------------------------------------
2.the image page has the following script:
$result = mysqli_query($link,"select * from person where Person_Id='1
$result = mysqli_query($link,"select * from XXX where Person_Id='$Current_Person_Id'");
////starting the inner validation
//else if($result){
$row_count=0;
while($row = mysqli_fetch_array($result))
{
//$row_color = ($row_count % 2) ? $color1 : $color2;
$content=$row['Photo_Content'];
$name=$row['Photo_Name'];
$type=$row['Photo_Type'];
$size=$row['Photo_Size'];
$row_count++;
}
header("Content-length
size");
header("Content-type
type");
header("Content-Disposition: inline; filename=$name");
//header('filename=$name');
//Content-Disposition: attachment;
echo $content;
Note:
The variables
size,$type,$name are stored in database too.
I'm able to print all of them except the content.
Could it be my php configuration orsomething to do with images?
I've attached the image icon displayed..here....
I have the following code which cant work:
1. main profile page has the following script:
<?php echo '<img src="XXXXX_XXX.php?id=$Current_Person_Id">';
---------------------------------------------------------------------------------
2.the image page has the following script:
$result = mysqli_query($link,"select * from person where Person_Id='1
$result = mysqli_query($link,"select * from XXX where Person_Id='$Current_Person_Id'");
////starting the inner validation
//else if($result){
$row_count=0;
while($row = mysqli_fetch_array($result))
{
//$row_color = ($row_count % 2) ? $color1 : $color2;
$content=$row['Photo_Content'];
$name=$row['Photo_Name'];
$type=$row['Photo_Type'];
$size=$row['Photo_Size'];
$row_count++;
}
header("Content-length
size");header("Content-type
type");header("Content-Disposition: inline; filename=$name");
//header('filename=$name');
//Content-Disposition: attachment;
echo $content;
Note:
The variables
size,$type,$name are stored in database too.I'm able to print all of them except the content.
Could it be my php configuration orsomething to do with images?
I've attached the image icon displayed..here....
![]() |
Similar Threads
- display image from databse (MySQL)
Other Threads in the PHP Forum
- Previous Thread: Would the file size affect the upload?
- Next Thread: help, the browser gives an error
| Thread Tools | Search this Thread |
ajax apache api array back basic beginner binary broken cakephp checkbox class cms code computing cron curl database date delete display dynamic echo email error external file files filter folder form forms function functions gc_maxlifetime google host href htaccess html iframe image include insert integration ip java javascript joomla limit link login loop mail memmory memory menu mlm multiple mysql navigation oop parsing paypal pdf php problem query question radio random recursion regex remote script search server sessions sms snippet soap source space sql syntax system table thesishelp trouble tutorial update upload url validation validator variable video web xml youtube





