PHP Date and Time

Using the sources provided you are to add functionality to search for all blogs written before a specific date. The framework for the assignment is set for you

      user.html                       Contains the HTML to prompt for a date

      blog_user.php               PHP code to parse the html form and call the function to search by date

     blog_db_interface.php  PHP code to perform the search

You will need to

      blog_user.php     

               Convert the date to a unix time stamp using strtotime()                         10 points

               Verify the strtotime return value. On error throw an exception              10 points

               Convert the unix time stamp to a date and time string using date()       10 points

               Verify the date functionality. On error throw an exception                      10points

               If all is OK then call the function to peform the search

     blog_db_interface.php

               Implement the SQL query to perform the search and display the results    

               Process errors from calling  “prepare”,  “execute” and “bind_results”

                            All errors should result in an exception thrown                                 10 points

               Search result should display “Blogger’s name”  “Blog Summary”                  10 points

What to turn in (as a single ZIP)

        Submit your modified source files: blog_user.php and  blog_db_interface.php       

Tags: No tags