Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are two options for this, you could use the data protocol, which would embed the whole image into the URL of the background ( this isn't recommended if the image is bigger than a few kb. ) or you can use a script to present the image by encoding or recording a unique key for the image, eg bg.php?id=4323-34442-3432-4532 which checks a db for the id to retrieve the file path then echoes the content with the right content type.</p> <p>Some examples;</p> <p>based on the <a href="http://en.wikipedia.org/wiki/Data_URI_scheme#Inclusion_in_HTML_or_CSS_using_PHP" rel="nofollow">Data URI</a> wikipedia page</p> <h2>Data URI Method</h2> <p>Assuming a function like this;</p> <pre><code> function data_uri($fileID) { $fRecord = mysql_fetch_array( mysql_select("SELECT filePath, mimeType from fileTable WHERE fileID = " $fileID . ";") ); $contents = file_get_contents($fRecord['filePath']); $base64 = base64_encode($contents); return "data:$fRecord['mimeType'];base64,$base64"; } </code></pre> <p>Then in your html/php page you'd have the following snippet</p> <pre><code>style="background-image:url('&lt;?php echo data_uri($fileID);?&gt;' </code></pre> <h2>PHP Image Dump</h2> <p>Assuming a function like this;</p> <pre><code>// Given a filename and a mimetype; dump the contents to the screen function showDocumentContent($fileID){ $fRecord = mysql_fetch_array( mysql_select("SELECT filePath, mimeType from fileTable WHERE fileID = " $fileID . ";") ); header( 'Content-Encoding: none', true ); header( 'Content-Type: ' . $fRecord['mimeType'], true ); echo readfile( $fRecord['filePath'] ); } </code></pre> <p>Then in your html page you'd have this;</p> <pre><code>style="background-image:url('image.php?fileID=123') </code></pre> <p>In the first case, images larger than a few KB will result in equally large HTML pages, and may not be supported in browsers consistently. In the second case, you'd effectively have created a php script that is pretending to be an image. In both cases, the real path to the binary files on your server is abstracted away by storing a mapping in a database.</p>
    singulars
    1. This table or related slice is empty.
    1. POPHP: set image as background without revealing path
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USToby Jackson
    1. USToby Jackson
    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. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIndeed a good suggestion, but how would I echo the image in the right place. Using `readimage`, as suggested below makes the browser download the image right away, without placing it anywhere in the html. The code would be something like: `style="background-image:url(' <?php readfile($file);`. If you understand what I mean. Not the best place to copy code examples
      singulars
      1. PO
      1. USMatte
    2. COI've made some changes to my original answer with some more specific examples. Be warned that I'm writing this without actually running anything, so it won't work "out of the box", however, I hope it gives some clearer context to the proposed solution.
      singulars
      1. PO
      1. USToby Jackson
    3. COThat is a very comprehensive answer indeed. I must check it out a bit later! Thanks for the contribution!
      singulars
      1. PO
      1. USMatte
 

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