Study+Questions

=Study Questions=

Week 1
1.  What are some common operating systems used for web servers? 2.  Explain the process of displaying a PHP page from request to page display in a browser. 3.  What are Apache and IIS, and what is their purpose? 4.  Describe the results of the phpinfo function. 5.  Write the PHP code used to display the date on a web page. 6.  What is an HTTP header? 7.  Define the term //middleware//. 8.  Define the term //database//. 9.  What is meant by an //n//-tier web application? 10. What are key features of a CMS? **additional resource:** · http://us2.php.net/tut.php · http://hudzilla.org/phpwiki/index.php?title=Introducing_PHP · http://hudzilla.org/phpwiki/index.php?title=Sending_custom_HTTP_headers

Week 2
11. Identify the various categories of operators? 12. What is a PHP page template? 13. Write the PHP in include external files into the current document. 14. How is concatenation different than with JavaScript? 15. What are the differences in the use of single quotes vs double quotes? 16. What is a switch statement? Write an example. 17. Define the operation of the keywords //exit// and //break//? 18. What happens if an //exit// or //break// statement are used before the close of the template? 19. What are the benefits of using parameters with functions? 20. What is the syntax for declaring a variable? **additional resources:** · http://hudzilla.org/phpwiki/index.php?title=Simple_variables_and_operators

Week 3
21. What are regular expressions and how are they used? 22. How would you use a //conditional// to check the success or failure of the mail function? 23. What output is generated when $_SERVER[“PHP_SELF”] is echoed to a page? 24. How can you use $_GET and $_POST to catch content passed from forms? 25. What is URL-encoding? 26. How do GET and POST differ? 27. What does the //register_globals// flag do? Why is it so important for security, forms, and variables? 28. Why are hidden form fields helpful when sending content to a PHP script? 29. What are SQL, and mySQL, and what are their roles in dynamic web applications? 30. What is //phpMyAdmin//, and what is it's purpose? **additional resources:** · [] · http://wiki.cihar.com/pma/Welcome_to_phpMyAdmin_Wiki

Week 4
31. Define the Acroynm //C.R.U.D//. and how does it relate to content management? 32. What are the steps to //insert// content into a database? 33. What programming flow control structure allows us to display the contents of a database table? 34. Explain how //fields// are related to //rows//, and how //rows// are related to database //tables//. 35. Write the code to submit a //query// to a database and to display the requested data. 36. What is the difference between a //database// and a //table//? 37. Identify the PHP code used to connect to a database. 38. Why is it best to keep database connection code //included// rather than internal to the script? 39. Why is a unique //index (key)// important for all database tables? 40. What is a //foreign key//? **additional resources:** · [] · []

Week 6
41. Identify how SQL and PHP could be used together to modify database content. 42. Identify how you could display the contents of a database table in an HTML table. 43. How could you limit the number of records retrieved from a database? 44. How could you use SQL to order the records retrieved from a database? 45. What is a SQL //Join//? 46. Explain the nature of a one-to-one data relationship. 47. Explain the nature of a one-to-many data relationship. 48. Explain the nature of a many-to-many data relationship. 49. Why are unique identifiers so important to proper database structures and management? **additional resources:** · []

Week 7
50. What does it mean that HTTP is a stateless protocol? 51. What is a cookie? How do you set and delete a cookie? 52. What is a session? How do you set and delete session variables? 53. What is user authentication? 54. Draw a flow chart showing how a user might log into a Content Management System. 55. What are the critical components of user authentication? 56. How could you ensure that users cannot access admin pages without signing in first? ** additional resources:** · [] · [] · []

Week 8
57. Identify the HTML form element needed to upload files to a server. 58. What is the $ _FILES and how is it used? 59. Describe key information we test //before// uploading a file with PHP? 60. Describe the steps to store (in a database) the title, file name, and comments for a file. 61. Describe the steps to dynamically display all files that have been uploaded? 62. What security issues must you consider when incorporating a file upload system? **additional resources:** · http://www.onlamp.com/pub/a/php/2003/02/06/php_foundations.html · [] · []