Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This uses <code>fseek</code> to read 100 lines of a file starting from a specified offset. If the offset is greater than the number of lines in the log, the first 100 lines are read.</p> <p>In your application, you could pass the current offset through the query string for <em>prev</em> and <em>next</em> and base the next offset on that. You could also store and pass the current file position for more efficiency.</p> <pre><code>&lt;?php $GLOBALS["interval"] = 100; read_log(); function read_log() { $fp = fopen("log", "r"); $offset = determine_offset(); $interval = $GLOBALS["interval"]; if (seek_to_offset($fp, $offset) != -1) { show_next_button($offset, $interval); } $lines = array(); for ($ii = 0; $ii &lt; $interval; $ii++) { $lines[] = trim(fgets($fp)); } echo "&lt;pre&gt;"; print_r(array_reverse($lines)); } // Get the offset from the query string or default to the interval function determine_offset() { $interval = $GLOBALS["interval"]; if (isset($_GET["offset"])) { return intval($_GET["offset"]) + $interval; } return $interval; } function show_next_button($offset, $interval) { $next_offset = $offset + $interval; echo "&lt;a href=\"?offset=" . $offset . "\"&gt;Next&lt;/a&gt;"; } // Seek to the end of the file, then seek backward $offset lines function seek_to_offset($fp, $offset) { fseek($fp, 0, SEEK_END); for ($ii = 0; $ii &lt; $offset; $ii++) { if (seek_to_previous_line($fp) == -1) { rewind($fp); return -1; } } } // Seek backward by char until line break function seek_to_previous_line($fp) { fseek($fp, -2, SEEK_CUR); while (fgetc($fp) != "\n") { if (fseek($fp, -2, SEEK_CUR) == -1) { return -1; } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POPHP: Read from certain point in file
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDevourant
    1. USDevourant
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPHP: Read from certain point in file
      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. COIf the number of lines in the file is not known and I want to start viewing from the end of the file, how would I use your code?
      singulars
      1. PO
      1. USdukevin
    2. COnevermind, the linux command `wc -l my_log.log` will output line numbers
      singulars
      1. PO
      1. USdukevin
    3. COI'm not sure you'll need that. If you pass an offset larger than the # of lines, this just shows the 100 lines at the beginning of the log. `fseek` returns -1 when it tries to seek past the beginning. I'll add a comment where it hits the beginning of the file.
      singulars
      1. PO
      1. USDevourant
 

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