StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20811904
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-12-28T06:52:26.293
FavoriteCount
0
LastActivityDate
2013-12-28T07:01:52.613
LastEditDate
2013-12-28T07:01:52.613
LastEditorUserId
1033426
OwnerUserId
1033426
ParentId
20809915
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I got it! I only had to build a Rube Goldberg Machine to do it! Thanks PHP. <pre><code>$linkroot = ascertainLinkroot(); function ascertainLinkroot(){ return makeRelativePath( getTopScriptPath(), __DIR__ ); } function getTopScriptPath(){ $backtrace = debug_backtrace( defined( "DEBUG_BACKTRACE_IGNORE_ARGS") ?DEBUG_BACKTRACE_IGNORE_ARGS :FALSE ); $top_frame = array_pop($backtrace); $top_script_path = $top_frame['file']; return $top_script_path; } function makeRelativePath($from,$to){ // Compatibility $from = is_dir($from) ?rtrim($from,'\/').'/' :$from; $to = is_dir($to) ?rtrim($to,'\/').'/' :$to; $from = str_replace('\\','/',$from); $to = str_replace('\\','/',$to); //---------------------------- $from = explode('/',$from); $to = explode('/',$to); $path = $to; foreach($from as $depth => $dir) { if ($dir === $to[$depth]) { // find first non-matching dir array_shift($path); // ignore it } else { $remaining = count($from)-$depth; // get number of remaining dirs to $from if ($remaining>1){ // add traversals up to first matching dir $padLength = -(count($path)+$remaining-1); $path = array_pad($path, $padLength, '..'); break; } else { $path[0] = './'.$path[0]; } } } return rtrim(implode('/', $path),'\/'); } </code></pre> So, basically, I use the <code>makeRelativePath</code> function to calculate a relative path from the top script's absolute path to the current script's absolute directory path (<code>__DIR__</code>). I realized that I'm actually looking for the relative path to the library from the top script, not just the parent script -- because the top script is the one where clientside assets will need to be referenced in relation to. Naturally, PHP doesn't just give you the top script's absolute path. On some environments, the top script's path can be available as a $_SERVER variable, however environment independence is important for me, so I had to find a way. <code>getTopScriptPath</code> was my solution, as it uses <code>debug_backtrace</code> to find it (creepy, I know), but it is the only environment-independent way to fetch it (to my knowledge). Still hoping for a more elegant solution, but am satisfied that this one works.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP Get Relative Path from Parent to Included File
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USChaseMoskal
UserOwnerUserId
1. USChaseMoskal
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POPHP Get Relative Path from Parent to Included File
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.