StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POfile_get_contents and variables
primarykey
Id
9609063
data
AcceptedAnswerId
9609313
AnswerCount
3
ClosedDate
CommentCount
11
CommunityOwnedDate
CreationDate
2012-03-07T21:06:59.103
FavoriteCount
0
LastActivityDate
2012-03-07T21:29:43.583
LastEditDate
2017-05-23T11:48:02.830
LastEditorUserId
-1
OwnerUserId
871324
ParentId
0
PostTypeId
1
Score
0
ViewCount
1075
LastEditorDisplayName
text
Body
I have a text file filled with a list of IDs. Using PHP, I am trying to load a url for each of the IDs and pull something from that page (another id) For example, if I have the IDs 555, 888, 222 I want to load the URLs <a href="http://example.edu/bvl.P_Sel?facultyID=555" rel="nofollow noreferrer">http://example.edu/bvl.P_Sel?facultyID=555</a> <a href="http://example.edu/bvl.P_Sel?facultyID=888" rel="nofollow noreferrer">http://example.edu/bvl.P_Sel?facultyID=888</a> <a href="http://example.edu/bvl.P_Sel?facultyID=222" rel="nofollow noreferrer">http://example.edu/bvl.P_Sel?facultyID=222</a> I tried to get the content via <code>file_get_contents("http://example.edu/bvl.P_Sel?facultyID=$lines[0]");</code> where $lines is an array of the IDs. This returns the following error: <pre><code>Warning: file_get_contents(http://example.edu/bvl.P_Sel?facultyID=222) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 404 </code></pre> That url is an example, but the url in the error does work when I visit it manually. And if I replace the file_get_contents variable with an actual ID, like <code>?facultyID=222</code>, it works perfectly. I visited this question's answer <a href="https://stackoverflow.com/questions/2445276/how-to-post-data-in-php-using-file-get-contents/2445332#2445332">How to post data in PHP using file_get_contents?</a> and tried assigning a variable in the $postdata array to a variable, and I get the same exact error only with <code>?facultyID=XXX</code> removed from the error message's url. My implementation of the latter is <a href="http://pastebin.com/yykLAePs" rel="nofollow noreferrer">here</a>.
Tags
<php><http><post><web-scraping><file-get-contents>
Title
file_get_contents and variables
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USRob
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POfile_get_contents and variables
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POfile_get_contents and variables
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTDownMod
CommentsPostId

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.