StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5677324
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-04-15T13:14:03.233
FavoriteCount
0
LastActivityDate
2011-04-15T13:14:03.233
LastEditDate
LastEditorUserId
0
OwnerUserId
338665
ParentId
5669631
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
Ok, so the way I would suggest doing this is with a file <a href="http://us2.php.net/manual/en/class.streamwrapper.php" rel="noreferrer">stream wrapper</a>. Let me whip up a quick example: <pre><code>class staticStreamWrapper { public $context; protected static $data = array(); protected $path = ''; protected $pointer = 0; protected $writable = false; public function stream_close() {} public function stream_eof() { return $this->pointer >= strlen(static::$data[$this->path]); } public function stream_flush() {} public function stream_open($path, $mode, $options, &$opened_path) { switch ($mode[0]) { case 'r': if (!isset(static::$data[$path])) return false; $this->path = $path; $this->writable = isset($mode[1]) && $mode[1] == '+'; break; case 'w': static::$data[$path] = ''; $this->path = $path; $this->writable = true; break; case 'a': if (!isset(static::$data[$path])) static::$data[$path] = ''; $this->path = $path; $this->writable = true; $this->pointer = strlen(static::$data[$path]); break; case 'x': if (isset(static::$data[$path])) return false; $this->path = $path; $this->writable = true; break; case 'c': if (!isset(static::$data[$path])) static::$data[$path] = ''; $this->path = $path; $this->writable = true; break; default: return false; } $opened_path = $this->path; return true; } public function stream_read($count) { $bytes = min(strlen(static::$data[$this->path]) - $this->pointer, $count); $data = substr(static::$data[$this->path], $this->pointer, $bytes); $this->pointer += $bytes; return $data; } public function stream_seek($offset, $whence = SEEK_SET) { $len = strlen(static::$data[$this->path]); switch ($whence) { case SEEK_SET: if ($offset <= $len) { $this->pointer = $offset; return true; } break; case SEEK_CUR: if ($this->pointer + $offset <= $len) { $this->pointer += $offset; return true; } break; case SEEK_END: if ($len + $offset <= $len) { $this->pointer = $len + $offset; return true; } break; } return false; } public function stream_stat() { $size = strlen(static::$data[$this->path]); $time = time(); return array( 0 => 0, 'dev' => 0, 1 => 0, 'ino' => 0, 2 => 0777, 'mode' => 0777, 3 => 1, 'nlink' => 1, 4 => 0, 'uid' => 0, 5 => 0, 'gid' => 0, 6 => '', 'rdev' => '', 7 => $size, 'size' => $size, 8 => $time, 'atime' => $time, 9 => $time, 'mtime' => $time, 10 => $time, 'ctime' => $time, 11 => -1, 'blksize' => -1, 12 => -1, 'blocks' => -1, ); } public function stream_tell() { return $this->pointer; } public function stream_write($data) { if (!$this->writable) return 0; $size = strlen($data); $len = strlen(static::$data[$this->path]); if ($this->stream_eof()) { static::$data[$this->path] .= $data; } else { static::$data[$this->path] = substr_replace( static::$data[$this->path], $data, $this->pointer ); } $this->pointer += $size; return $size; } public function unlink($path) { if (isset(static::$data[$path])) { unset(static::$data[$path]); } return true; } } </code></pre> Now, you would then need to register the wrapper: <pre><code>stream_wrapper_register('static', 'staticStreamWrapper'); </code></pre> So you now can treat it like a file even though it never actually leaves PHP (it's stored as a static variable)! <pre><code>file_put_contents('static://foo.txt', 'this is my data'); file_get_contents('static://foo.txt'); // "this is my data" $f = fopen('static://foo.txt', 'r'); // should return a resource // etc... </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POShared memory file in PHP
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USircmaxell
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThanks for the stream info. I understand that PHP supports custom stream wrapper implementation. However, the OpenSSL extension is most likely be written with OS APIs, and the functions do not utilize the PHP streams. Calling `openssl_pkcs7_encrypt` with `static` stream results in the following error message: `error:02001002:system library:fopen:No such file or directory`.
 singulars
 PostPostId
 PO
 UserUserId
 USCrend King

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.