StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCreating 2D-array from array with foreach-loops
primarykey
Id
2191398
data
AcceptedAnswerId
2191516
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-02-03T11:09:01.763
FavoriteCount
0
LastActivityDate
2010-02-03T11:31:10.470
LastEditDate
LastEditorUserId
0
OwnerUserId
265204
ParentId
0
PostTypeId
1
Score
0
ViewCount
683
LastEditorDisplayName
text
Body
sorry for the vague title. I'm extracting some data from a table with the setup as specified below, using simple_html_dom. What I want to do is insert the data into a 2D-array (?), where the value of the first -field is the name of a subscription and the rest is data relevant to that subscription. <pre><code><td><a href="/subname/index.jsp">SubName</a></td>  <td>Comment regarding the subscription</td> <td>0,-</td> <td>0,49</td> <td>0,49</td> <td>1,99</td> </code></pre> What I have so far, is working okay, but it puts all the values into a regular array. I've tried reading up on arrays and trying different solutions that've come to mind, but I just can't seem to wrap my head around it. What I want is something like: <blockquote> Array ( [SubName1] => Array ( [0] => Comment [1] => Monthly fee [2] => Price per minute [3] => Price per SMS [4] => Price per MMS ) [SubName2] => Array ( .. ) </blockquote> This is my code: <pre><code>function getData($uri) { try { $html = file_get_html($uri); // Fetch source code $data = array(); foreach($html->find('td') as $td) { // Fetch all <td>-elements foreach($td->find('a') as $a) { // Fetch all <a>-elements to remove links $data[] = $a->innertext; // This returns the names of the subscriptions } foreach($td->find('strong') as $strong) { // Fetch all -elements to remove bold text $data[] = $strong->innertext; } if(!preg_match('//', $td->innertext) && !preg_match('/<a/', $td->innertext)) { // Skip all <td>-elements that contains and <a>, since we already have them $data[] = $td->innertext; } } /* Logic for database insertion goes here */ unset($data); // Deletes array $html->clear(); // Clear to free up memory unset($html); } catch (Exception $e) { echo 'Failed to fetch prices from'.$uri.'. '.$e->getMessage(); } } </code></pre> Thanks in advance.
Tags
<php><foreach><multidimensional-array>
Title
Creating 2D-array from array with foreach-loops
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USTom
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COIs the HTML document XHTML? If it is you could use the PHP DOM extensions to parse the code and build an array. See: http://php.net/manual/en/book.dom.php
 singulars
 PostPostId
 POCreating 2D-array from array with foreach-loops
 UserUserId
 USCamsoft

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.