Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Your web server can not see the files outside the DocRoot, so it can not serve the files via the browser with direct links. You need to print their contents into the browser with <a href="http://php.net/manual/en/function.readfile.php" rel="noreferrer"><code>readfile()</code></a> with the headers properly set.</p> <p>To make this work, you need to change the configuration in indexer.php:</p> <pre><code>// this way it works with accentuated letters in Windows $Root = utf8_decode("G:\test"); // define the directory the index should be created for (can also be located outside the webserver root) $AllowDownload = TRUE; // enclose file items with the anchor-tag (only makes sense when the files are in the webserver root) // you need to place download.php in the same directory as indexer.php $WebServerPath = dirname($_SERVER['SCRIPT_NAME']) . "/download.php?path="; // path where the indexed files can be accessed via a http URL (only required when $AllowDownload is TRUE) </code></pre> <p>And you have to place a new file called <code>download.php</code> in the same directory as <code>indexer.php</code>, with this content:</p> <pre><code>&lt;?php // it must be the same as in indexer.php $Root = utf8_decode("G:\test"); function checkFileIsInsideRootDirectory($path, $root_directory) { $realpath = realpath($path); if (!file_exists($realpath)) die("File is not readable: " . $path); // detects insecure path with for example /../ in it if (strpos($realpath, $root_directory) === false || strpos($realpath, $root_directory) &gt; 0) die("Download from outside of the specified root directory is not allowed!"); } function forceDownload($path) { $realpath = realpath($path); if (!is_readable($realpath)) die("File is not readable: " . $path); $savename = (basename($path)); header("Pragmaes: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Cache-Control: private", false); header("Content-type: application/force-download"); header("Content-Transfer-Encoding: Binary"); header("Content-length: " . filesize($path)); header("Content-disposition: attachment; filename=\"$savename\""); readfile("$path"); exit; } if (!isset($_GET['path'])) die("Path not specified!"); $fullPath = $Root . $_GET['path']; checkFileIsInsideRootDirectory($fullPath, $Root); forceDownload($fullPath); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POPHP display/download directory files outside the webserver root
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USIstván Ujj-Mészáros
    1. USIstván Ujj-Mészáros
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPHP display/download directory files outside the webserver root
      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. COThanks for answering! This sounds promising; where would I need to put this code (and would I need to change any variable names)?
      singulars
      1. PO
      1. USJopper
    2. COEdited my answer, now it works well with [`indexer`](http://tbmnet.de/tbmnet.php?content=php_indexer).
      singulars
      1. PO
      1. USIstván Ujj-Mészáros
    3. COThanks for your ongoing support:) Where should I put the code and what does it need to replace?
      singulars
      1. PO
      1. USJopper
 

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