{"id":141,"date":"2007-10-02T15:00:07","date_gmt":"2007-10-02T19:00:07","guid":{"rendered":"https:\/\/www.thehouse.net\/2007\/10\/02\/coding-a-simple-ajax-calendar-with-a-mysql-backend\/"},"modified":"2007-10-02T16:41:07","modified_gmt":"2007-10-02T20:41:07","slug":"coding-a-simple-ajax-calendar-with-a-mysql-backend","status":"publish","type":"post","link":"https:\/\/www.thehouse.net\/?p=141","title":{"rendered":"Coding a simple Ajax Calendar with a MySQL backend"},"content":{"rendered":"<p>When doing any kind of web development, I always come across a time when I need to implement some sort of calendar; be it a small &#8216;applet&#8217; enabling the user to select a date more effectively, or something a bit &#8216;larger&#8217;, displaying something more relevant for certain days.<\/p>\n<p>Jamie over at www.nodstrum.com wrote up some code that can be used as an effective base for many &#8216;calendaring&#8217; needs most web developers come across. It&#8217;s PHP and MySQL, so it should meet the needs of most folks out of the box, but can also be easily ported to another development language.<\/p>\n<p>One word of caution; Jamie makes it clear that his priority was functionality and not security. As such, if you use his code, make sure to apply best-practices in regards to SQL injection, etc.<\/p>\n<p><a href=\"http:\/\/nodstrum.com\/2007\/08\/24\/mysql-calendar-v12-multilingual\/\">Jamie&#8217;s MYSQL Calendar code<\/a><\/p>\n<p>If you&#8217;re interested in how Jamie&#8217;s code evolved, check out these articles also on his site:<\/p>\n<p><a href=\"http:\/\/nodstrum.com\/2007\/01\/29\/phpcalendar\/\">Calendar System &#8211; Easily using PHP &amp; Script.aculo.us<\/a><br \/><a href=\"http:\/\/nodstrum.com\/2007\/06\/27\/mysql-calendar\/\">MySQL Calendar<\/a><\/p>\n<p>If all you&#8217;re looking for is a simple, elegant date &#8216;selector&#8217;, give <a href=\"http:\/\/www.eulerian.com\/en\/opensource\/datepicker-prototype-scriptaculous\">DatePicker<\/a> a look.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When doing any kind of web development, I always come across a time when I need to implement some sort of calendar; be it a small &#8216;applet&#8217; enabling the user to select a date more effectively, or something a bit &#8216;larger&#8217;, displaying something more relevant for certain days. Jamie over at www.nodstrum.com wrote up some [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":""},"categories":[19,4],"tags":[],"class_list":["post-141","post","type-post","status-publish","format-standard","hentry","category-ajaxweb-20","category-bookmarks"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pA6RZ-2h","_links":{"self":[{"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=141"}],"version-history":[{"count":0,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=\/wp\/v2\/posts\/141\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.thehouse.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thehouse.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}