Databases
StackOverflow2013
Postsdbo
POHow do I script a php file to display an image like <img src="/img.php?imageID=32" />?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I script a php file to display an image like <img src="/img.php?imageID=32" />?
    primarykey
    data
    text
    <p>I'm storing banner ads in a mysql table or I should say just the file name e.g: 'imagename.jpg' or 'banner3.gif'. </p> <p>Obviously I am wanting to track when these banners are loaded so I'm thinking to create a php file called img.php and call it like so</p> <pre><code>&lt;img src="/img/img.php?imageID=3" /&gt; </code></pre> <p>And that would pull out the image with the id 3 along with updating my hits table etc.</p> <p>I know how to update my hits table... but what I'm trying to work out is how to code the img.php file so that it simply retrieves the file name and prints it to screen so it works like a regular image.</p> <p>So far I've got...</p> <pre><code>&lt;?php header("Content-Type: image/jpeg"); // insert my db connect file // update the hits table etc $sql = 'SELECT * FROM ads WHERE id="' . $_GET['imageID'] . '" '; $res = mysql_query($sql); $row = mysql_fetch_array($res); $image = '/img/' . $row['file']; imagejpeg($image); // and this is where I'm at... ?&gt; </code></pre> <p>I have some problems with the above code which i've extracted from various places to get here. The images could be png/gif/jpg while the header content-type seems to only have space for one type.</p> <p>Is there a way to have this one file work ok for multiple image types? I'm thinking I should query the table firstly, work out the file extension and then insert the header function based off that.</p> <p>But what do I actually do when I've got that right and I want the image to then just appear?</p> <p>thanks to your help here is the final working file</p> <pre><code>&lt;?php // make sure we're only getting a number for the query b4 doing stuff if(is_numeric($_GET['imid'])) { include('thedbfile.php'); $types['jpg'] = 'image/jpeg'; $types['png'] = 'image/png'; $types['gif'] = 'image/gif'; $sql = 'SELECT file FROM ads WHERE id="' . $_GET['imid'] . '" '; $res = mysql_query($sql); $row = mysql_fetch_array($res); $image = 'img/banners/' . $row['file']; $extension = end(explode('.', $row['file'])); header('Content-Type: ' . $types[$extension]); echo file_get_contents($image); } ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USwilldanceforfun
    1. USwilldanceforfun
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow do I script a php file to display an image like <img src="/img.php?imageID=32" />?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow do I script a php file to display an image like <img src="/img.php?imageID=32" />?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou must need to read about code injection, especially SQL injections!
      singulars
      1. POHow do I script a php file to display an image like <img src="/img.php?imageID=32" />?
      1. USGumbo
    2. COi will, thanks gumbo...
      singulars
      1. POHow do I script a php file to display an image like <img src="/img.php?imageID=32" />?
      1. USwilldanceforfun
    3. COfarout... so with my sql above somebody could load up this file with like /img.php?imid=1';Drop table ' etc etc??????? what the
      singulars
      1. POHow do I script a php file to display an image like <img src="/img.php?imageID=32" />?
      1. USwilldanceforfun
 

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