Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are two ways to do this. The first is to specify the header in your php code. This is great if you want to programatically adjust the expiry time. For example a wiki could set a longer expires time for a page which is not edited very often. </p> <pre><code>header('Expires: '.gmdate('D, d M Y H:i:s \G\M\T', time() + (60 * 60))); // 1 hour </code></pre> <p>Your second choice is to create an <strong>.htaccess</strong> file or modify your httpd config. In a shared hosting environment, modifying your .htaccess file is quite common. In order to do this, you need to know if your server supports <strong>mod_expires</strong>, <strong>mod_headers</strong> or both. The easiest way is simply trial and error, but some Apache servers are configured to let you view this information via the /server-info page. If your server has both mod_expires and mod_headers, and you want to set the expiry on static resources, try putting this in your .htaccess file:</p> <pre><code># Turn on Expires and set default to 0 ExpiresActive On ExpiresDefault A0 # Set up caching on media files for 1 year (forever?) &lt;FilesMatch "\.(flv|ico|pdf|avi|mov|ppt|doc|mp3|wmv|wav)$"&gt; ExpiresDefault A29030400 Header append Cache-Control "public" &lt;/FilesMatch&gt; </code></pre> <p>For other combinations and more examples see: <a href="http://www.askapache.com/htaccess/speed-up-your-site-with-caching-and-cache-control.html" rel="noreferrer">http://www.askapache.com/htaccess/speed-up-your-site-with-caching-and-cache-control.html</a></p>
    singulars
    1. This table or related slice is empty.
    1. POSetup HTTP expires headers using PHP and Apache
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USGottlieb Notschnabel
    1. USbrianegge
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSetup HTTP expires headers using PHP and Apache
      singulars
      1. PTQuestion
    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
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COSo I'm right in thinking that .flv, .ico etc will automatically have the correct headers prepended to them? very cool
      singulars
      1. PO
      1. USTom
    2. COHeader append Cache-Control "public" => This line gives me a 500 internal server error.
      singulars
      1. PO
      1. USnoobcode
    3. CO@noobcode I have the exact same problem. How did you solve this please?
      singulars
      1. PO
      1. USHouman
 

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