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.