StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2337053
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-02-25T19:41:11.070
FavoriteCount
0
LastActivityDate
2010-02-25T19:41:11.070
LastEditDate
LastEditorUserId
0
OwnerUserId
138475
ParentId
2336919
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
I suppose a solution would be to start by getting the timestamp that correspond to last monday, using <a href="http://php.net/strtotime" rel="nofollow noreferrer"><code>strtotime</code></a> : <pre><code>$timestampFirstDay = strtotime('last monday'); </code></pre> But if you try with today (thursday), with something like this : <pre><code>$timestampFirstDay = strtotime('last thursday'); var_dump(date('Y-m-d', $timestampFirstDay)); </code></pre> you'll get : <pre><code>string '2010-02-18' (length=10) </code></pre> i.e. last week... For strtotime, "last" means "the one before today". Which mean you'll have to test if today is "last monday" as returned by <code>strtotime</code> plus one week -- and, if so, add one week... Here's a possible (there are probably smarter ideas) solution : <pre><code>$timestampFirstDay = strtotime('last monday'); if (date('Y-m-d', $timestampFirstDay) == date('Y-m-d', time() - 7*24*3600)) { // we are that day... => add one week $timestampFirstDay += 7 * 24 * 3600; } </code></pre> And now that we have the timestamp of "last monday", we can write a simple <code>for</code> loop that loops 7 times, adding 1 day each time, like this : <pre><code>$currentDay = $timestampFirstDay; for ($i = 0 ; $i < 7 ; $i++) { echo date('Y-m-d', $currentDay) . ' '; $currentDay += 24 * 3600; } </code></pre> Which will give us this kind of output : <pre><code>2010-02-22 2010-02-23 2010-02-24 2010-02-25 2010-02-26 2010-02-27 2010-02-28 </code></pre> Now, up to you to : <ul> <li>Modify that <code>for</code> loop so it stores the dates in an array</li> <li>Decide which format you want to use for the <a href="http://php.net/manual/en/function.date.php" rel="nofollow noreferrer"><code>date</code></a> function</li> </ul> Have fun ;-)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POReturn dates of current calendar week as array in PHP5
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USPascal MARTIN
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POReturn dates of current calendar week as array in PHP5
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
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. COYou are the man!
 singulars
 PostPostId
 PO
 UserUserId
 USHunter Bridges
2. COBe careful, this method is not save for clock changes, e.g. a week may have more or less than 7*24*3600 seconds.
 singulars
 PostPostId
 PO
 UserUserId
 USTom

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.