Databases
StackOverflow2013
Postsdbo
POError in displaying an image in php mysql
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError in displaying an image in php mysql
    primarykey
    data
    text
    <p>Hey I am facing a problem in displaying images in php. The images are being stored in a table 'images' in mysql. There is another table 'restaurant' which needs to fetch those images and display respective images according to the restid. However, it is facing a problem in fetching the images and not displaying them. Please help! This is imageupload.php:</p> <pre><code>&lt;?php require 'connect.inc.php'; ?&gt; &lt;html&gt; &lt;head&gt; &lt;title&gt;Uploading image&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;?php echo "&lt;form action='imageupload.php' method='POST' enctype='multipart/form-data'&gt; Upload: &lt;input type='file' name='image'&gt;&lt;input type='submit' value='Upload' &gt; &lt;/form&gt;"; if(isset($_FILES['image']['tmp_name'])) { $image = addslashes(file_get_contents($_FILES['image']['tmp_name'])); $image_name = addslashes($_FILES['image']['name']); $image_size = getimagesize($_FILES['image']['tmp_name']); if($image_size==FALSE) echo "That's not an image"; else { $query = "INSERT INTO images VALUES ('','$image_name','$image','22')"; $result = mysqli_query($con, $query); if(!$result) { echo "Problem uploading"; } else { echo "Image uploaded "; $query2 = "SELECT * FROM images WHERE restid = '22'"; $result2 = mysqli_query($con,$query2); while($info = mysqli_fetch_array($result2)) { header("Content-type: image/jpeg"); echo $info['image']; } } } } else { "Please upload a file"; } ?&gt; &lt;/body&gt;&lt;/html&gt; </code></pre> <p>This is getimage.php (It fetches the image and displays it):</p> <pre><code>&lt;?php require 'connect.inc.php'; $id = $_REQUEST['id']; $image = "SELECT * FROM images WHERE imgid = $id" ; $image = mysqli_query($con, $image); $image = mysqli_fetch_assoc($image); $image = $image['image']; header("Content-type: image/jpeg"); echo $image; ?&gt; </code></pre> <p>connect.inc.php is a file to connect to the database. I referred to other links but did not get any solid help. Please provide help.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser2758453
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POError in displaying an image in php mysql
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POError in displaying an image in php mysql
      1. USKevin Desai
      1. VTFavorite
    3. VO
      singulars
      1. POError in displaying an image in php mysql
      1. This table or related slice is empty.
      1. VTDownMod
    1. COWhy do you neet change header to display a image? The name save in images name is normal? Why do yo doesn't use `<img src="" />`?
      singulars
      1. POError in displaying an image in php mysql
      1. USPatrick Maciel
    2. COYes yes I tried the <img src="" /> but it displays the encrypted form of the image i.e. in the text form.
      singulars
      1. POError in displaying an image in php mysql
      1. USuser2758453
    3. COYou save a custom image of image, a original name, or base64?
      singulars
      1. POError in displaying an image in php mysql
      1. USPatrick Maciel
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload