Description 2 Marks Learning Outcome(s): Build web applications using PHP and MySQL
Description
2 Marks
Learning Outcome(s):
Build web applications using PHP and MySQL
Question One
Create the following relational tables by using SQL commands.
Add screenshots of the three created tables.
Marking Criteria
1.5 mark for SQL commands
0.5 mark for the screenshot
2 Marks
Learning Outcome(s):
Describe methods and tools in designing a creative and dynamic website.
Question Two
Use the technique you have learned in the class to debug the following code and correct the error. Explain your steps in details.
<!DOCTYPEhtml>
<html>
<head>
<title>PHP Excercise</title>
<metahttp-equiv=”Content-Type”content=”text/html; charset=UTF-8″>
</head>
<body>
<styletype=”text/css”
title=”text/css”media=”all”>
.error{
font-weight: bold;
color: #C00;}
</style>
<formmethod=’POST’>
<h2>Assignment 1</h2>
<h3>Enter your first and last name</h3>
<inputtype=”text”name=”Firstname”>
<inputtype=”submit”value=”Submit”>
Font-wieght =22;
</form>
<?php
//Retrieve name from query string and store to a local variable
if(isset($_POST[‘name’]))
{
$name = $_POST[‘name’];
}
else
{
$name = NULL;
//echo ‘<p class =”error”> ‘;
}
echo”<br>”;
method(32);
echo” Hello “.$name.” in course IT405″;
?>
</body>
</html>
4 Marks
Learning Outcome(s):
Build web applications using PHP and MySQL
Question Three
You have a table called users in MySQL database called IT405. The table has the following data:
Id
Name
Address
1
Ali
Jeddah
2
Salah
Riyadh
Write a PHP code that output the following display:
3 @@@ Dammam
1 @@@ Jeddah
2 @@@ Riyadh
Note that the username is root, the password is empty string. You can insert data in the table before the display.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.