CIS 627 (Web Database Services Development) Week 5

validation, dates & Times, PDF and more

1. Review JSON files ansd SESSION variables
   
   

   Possible resources:

   • json_Beatles.php and json_Beatles.zip
   • InsideOut/InsideOut.php and InsideOut.zip
2. Some validation
   
   

   Possible resources:

   • SomeValidation.php and SomeValidation.php
   • ValidationDemo.html and ValidationDemo.zip
   • Demo of htmlspecialchars method HTMLspecialcharsDemo.htm HTMLspecialcharsDemo.zip
3. The maketime() and getdate() methods
   
   

   Possible resources:

   • FirstFriday.php and FirstFriday.zip
   • PHP Tut 019 Showing off mktime
   • http://php.net/manual/en/function.mktime.php
   • http://php.net/manual/en/function.getdate.php
4. Having PHP make a PDF
   
   

   Possible resources:

   • Programming PHP (Tatroe, MacIntyre & Lerdorf) p. 251-266
   • Creating pdf in PHP
   • jack.php and jack.zip
   • jack_footer.php and jack_footer.zip adds a footer with the page number
   • jack_footer_header.php and jack_footer_header.zip adds a header that alternates between author and title on different pages
   • jack_footer_header_image.php and jack_footer_header_image.zip adds an image
   • MakeStateCapitalTable_PDF.zip takes the results of a query on the state-capital database and displays the results in a table in a landscape-oriented PDF (the comment field is unsatisfying)
5. PHP generating Images
   
   

   Possible resources:

   • Programming PHP (Tatroe, MacIntyre & Lerdorf) p. 230-249
   • PHP Graphics Creation PHP_create_image.php PHP_create_image.zip
     Uses: imagecreate, imagecolorallocate,imagefilledrectangle, and imagepng($image).
   • All Work and No Play AllWork.php AllWork.zip
     Uses imagestring
   • Demo of imagefilledellipse, imagesetthickness, imagearc Inchworm.php Inchworm.zip
   • Demo of imagecreatefromjpeg, imagesx, imagecolorat, imagejpeg Face.php Face.zip
   • Demo of imagettftext (ttf -- true type font) Font.php Font.zip
   • Demo of str_split, sin, cos and imagettftext Font_2.php Font_2.zip
6. Assignment
   
   

   Parts:

   • Make a PHP page that will calculate and display the date of Labor Day (the first Monday in September) for the next 10 years.
   • Make a page or pages that use FILTER_VALIDATE_URL to determine if the user has entered a correctly formed URL.
   • Make a PHP page that generates a PDF displaying a table of the Customer data (at least six fields) in the Northwind database. There should be a header explaining the content of the table. There should be a footer that includes the date and the page number.
   • Make some personal logo (don't make it too hard) that includes your name and/or initials . Other than the methods to create and then finally display the images, use at least three different image methods to generate this logo.