Question: Do not submit the HTML form's code for Prototype 2 since the assignment only asks for an image of the URL address in the browser

 Do not submit the HTML form's code for Prototype 2 sincethe assignment only asks for an image of the URL address in

Do not submit the HTML form's code for Prototype 2 since the assignment only asks for an image of the URL address in the browser address bar when the form is actually submitted like in Figure 2. My interest is in the URL and query string, not where it came from. The PHP/SQL steps are: 1. insert code insert a requested transaction with query string input as a new row in transactions table. 2. update code update recent & balance columns for existing user accounts table to reflect the transaction To access inputs, use PHP code like: Sucid = S_GET["ucid"]; You must also transform the input using the mysqli_real_escape_string function. Your program must echo the labelled inputs & SQL statements even though I am not asking for images of that. For a detailed discussion of these ideas see canvas > Module > WEEK02 > WEEK02-Detailed-Summary.doc You must have the following kinds of images to prove your code works right. The PHP script executes an SQL insert statement based on the input data from the query string and a corresponding SQL update statement changes the associated account to reflect the new transaction. The script obtains the inputs from the URL using the PHP S_GET notation. Upload your files (which includes your account.php file with your database credentials) under your public_html/download directory and execute via a browser request as usual. The query string inputs are: 1. ucid from your users table. 2. account for that ucid. 3. amount for the transaction - the time is generated using NOWO. See Figure 2 above for details. It's easier to generate the query string if you make an HTML Form to input the data and then hit the submit button on the form to generate the appropriate URL and query string as described in class. Refer to: Canvas > Modules > WEEK02 > WEEK02-Detailed-Summary.docx > Figure 5 for a sample HTML form. Do not submit the HTML form's code for Prototype 2 since the assignment only asks for an image of the URL address in the browser address bar when the form is actually submitted like in Figure 2. My interest is in the URL and query string, not where it came from. The PHP/SQL steps are: 1. insert code insert a requested transaction with query string input as a new row in transactions table. 2. update code update recent & balance columns for existing user accounts table to reflect the transaction To access inputs, use PHP code like: Sucid = S_GET["ucid"]; You must also transform the input using the mysqli_real_escape_string function. Your program must echo the labelled inputs & SQL statements even though I am not asking for images of that. For a detailed discussion of these ideas see canvas > Module > WEEK02 > WEEK02-Detailed-Summary.doc You must have the following kinds of images to prove your code works right. The PHP script executes an SQL insert statement based on the input data from the query string and a corresponding SQL update statement changes the associated account to reflect the new transaction. The script obtains the inputs from the URL using the PHP S_GET notation. Upload your files (which includes your account.php file with your database credentials) under your public_html/download directory and execute via a browser request as usual. The query string inputs are: 1. ucid from your users table. 2. account for that ucid. 3. amount for the transaction - the time is generated using NOWO. See Figure 2 above for details. It's easier to generate the query string if you make an HTML Form to input the data and then hit the submit button on the form to generate the appropriate URL and query string as described in class. Refer to: Canvas > Modules > WEEK02 > WEEK02-Detailed-Summary.docx > Figure 5 for a sample HTML form

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!