StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17166753
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-06-18T10:37:08.020
FavoriteCount
0
LastActivityDate
2013-06-18T11:44:18.983
LastEditDate
2017-05-23T12:30:02.927
LastEditorUserId
-1
OwnerUserId
155077
ParentId
17165658
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>Make 3 fields for day, month and year, like almost any site online.<br /> Fill the fields up with values.<br /> Then you can populate the year dropdown according to your wishes.<br /> And you can simply use the change event to validate the other fields.<br /> Plus you can simply use day + month + year, make a date value, and compare with your_date <= new date() <br /> Otherwise, you will have to worry about all the different dateformats a string can have, which makes it impossible to validate it.</p> <p>See here:<br /> <a href="https://stackoverflow.com/questions/6961007/birthday-form-using-html-php">Birthday form using HTML/PHP</a></p> <p>Something like this:</p> <pre><code><!doctype html> <html itemscope="itemscope" itemtype="http://schema.org/WebPage"> <head> <title>Hello</title> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js" ></script> <script type="text/javascript"> function isLeapYear(iYear) { return (new Date(iYear, 1, 29).getMonth() == 1); } function getMonthLength(month, year) { month = month - 1; var monthStart = new Date(year, month, 1); var monthEnd = new Date(year, month + 1, 1); var monthLength = (monthEnd - monthStart) / (1000 * 60 * 60 * 24); return monthLength; } function PopulateDayDropdown(iMonth, iYear) { for (i = 1; i < getMonthLength(iMonth, iYear) + 1; i++) { $('<option/>').val(i).html(i).appendTo('#selDay'); } } function PopulateMonthDropdown() { var months = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"]; for (i = 0; i < months.length; i++) { $('<option/>').val(i + 1).html(months[i]).appendTo('#selMonth'); } } function PopulateYearDropdown() { var iCurYear = new Date().getFullYear(); for (i = iCurYear - 100; i <= iCurYear; i++) { $('<option/>').val(i).html(i).appendTo('#selYear'); } //$('select option[value="' + iCurYear + '"]').html(); $('#selYear option[value="' + iCurYear + '"]').attr("selected", "selected") } $(document).ready(function () { // Handler for .ready() called. PopulateDayDropdown(1, new Date().getFullYear()); PopulateMonthDropdown(); PopulateYearDropdown(); //$('select[name="month"]').change(function() $('select').change(function () { //alert("2012 leap year? " + isLeapYear(2012) + "\n" + "2013 leap year? " + ); var iDay = $("#selDay").val(); var iMonth = $("#selMonth").val(); var iYear = $("#selYear").val(); if (this.id == "selMonth" || this.id == "selYear") { $('#selDay').empty(); PopulateDayDropdown(iMonth, iYear); $('#selDay option[value="' + iDay + '"]').attr("selected", "selected") } if (iDay > getMonthLength(iMonth, iYear)) { var months = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"]; alert("There is no " + iDay + "th " + months[iMonth - 1] + "."); } var d = new Date(iYear, iMonth - 1, iDay, 0, 0, 0, 0); if (d > new Date()) { $('#selDay option[value="' + 1 + '"]').attr("selected", "selected") $('#selMonth option[value="' + 1 + '"]').attr("selected", "selected") alert("Future dates are not allowed (values have been reset to January 1st)."); return; } alert("New date of birth: " + d); }); }); </script> </head> <body> <form action="registration.php" method="post"> <p>Select date:</p> <select id="selDay" name="day"> </select> <select id="selMonth" name="month">  </select> <select id="selYear" name="year"> </select> <br/><br/> <input type="submit" value="Submit" /> </form> </body> </html> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PORegular expression that validate future date
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USStefan Steiger
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. 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.