What debugging steps should you take if the rendered web page doesn’t look right in your browser?

Learning Goal: I’m working on a cyber security discussion question and need a sample draft to help me learn.

ITS 345 Discussion Questions

PROVIDE A 250 WORD MINIMUM ANSWER TO EACH QUESTION AND 2 FOLLOW-UP QUESTIONS TO DISCUSS, each question also needs a min of 1 reference attached.

1. PHP has a considerable number of built-in string functions. Research a string function and post a code example of how the string function works. Show the output of your selected string function. Do not choose a string function that was posted by one of your classmates.

2. PHP has a rich array of array functions. Research a PHP array function and provide its definition along with a complete code example, which the reader can download and run. Show the output of your array function. Your function must be one that none of your classmates have already posted. Reply to at least two of your classmates’ posts by taking their array functions and running them with data that was not used in the initial posts. Only reply to posts that have the least number of replies.

3. Write a user-defined PHP function/method that has both inputs and outputs and which has not already been posted. Show the inputs and outputs of your function. Next, run at least two function examples from your classmates’ initial posts using inputs not already entered for the given functions. Reply only to those posts that have the fewest number of replies. If an initial post has an error or omission, then correct it. Point deductions will be incurred for posts that have coding errors or omissions.

4. Reply to one of the following questions that has the least number of initial post replies at the time you are entering your initial post.

• Why shouldn’t live sites show MySQL errors and the queries being run?
• What is the web root directory? Why is it preferable to store the mysqli_connect.php script outside of the web root directory?
• Why is it necessary for the PHP scripts to use the same encoding that is used to interact with MySQL as is used for storing the text in the database?
• What is the most important sequence of steps for debugging PHP-MySQL problems?
• Why is it important to use the mysqli_real_escape_string() function?
• What syntax will you almost always use to handle the results of a SELECT query? What syntax could you use if the SELECT query returns only a single row?
• After what kind of queries would you use the mysqli_num_rows() function?

Next, using the following MySQL table and table data:

Write a MySQL query that does only one of the following:

• finds the highest article number
• finds the number, dealer, and price of the most expensive article
• finds the highest price per article
• for each article, finds the dealer or dealers with the most expensive price
• finds the articles with the highest and lowest price

The choice you select should be one that has the least number of post replies at the time of your post. Point deductions will be incurred if you write a query that doesn’t meet minimum post requirement.

5. Answer all of the following questions:

1. What debugging steps should you take if the rendered web page doesn’t look right in your browser?

1. Why is enabling display errors useful on development servers?

1. Why is revealing errors a bad thing on production servers?

1. What are the benefits of using your own error-handling function?

1. What impact does the error-reporting level have when using your own error-handling function?

1. How can print or echo be used as debugging tools?

1. What is the method for fixing PHP-SQL-MySQL bugs?

6. Explain what JSON is and how it is used with PHP. Describe an application that uses JSON and PHP.

7. Suppose you have a PHP-based web form that allows select staff to transfer money from a corporate savings account to a corporate checking account. Describe the PHP code you must implement to guarantee successful transfer of funds. Assume the accounting information is kept in a MySQL database and you are using PHP 7. Use PHP pseudocode in your explanation.

8. Write PHP code for a class that contains three private variables and a method that consumes those variables and which displays an output. One of the variables must be a date/time class instance and another variable must be an array. Do not duplicate any of your classmates’ initial posts. Reply to at least two initial posts by instantiating the classes from those posts and calling the methods from those classes. Reply only to posts with the fewest number of replies. If you have to reply to a post that has broken code, then repair the code as part of your reply. Point deductions will be incurred for posting defective code.