AOU حل جميع الواجبات ومشاريع التخرج لجميع الفروع والتخصصات AOU
حلول مضمونة وغير مكررة لجميع الواجبات
 
مدرسين خصوصيين – ملخصات هامة مجانية لجميع المواد
خدماتنا لجميع فروع الجامعة ولجميع الأقسام الدراسية
 
واتس اب 00963957547725
mustafaalbeda@hotmail.com

AOU حل جميع الواجبات ومشاريع التخرج لجميع الفروع والتخصصات AOU

AOU حلول مضمونة وغير مكررة لجميع الواجبات ومشاريع التخرج AOU
 
الرئيسيةالرئيسية  س .و .جس .و .ج  مكتبة الصورمكتبة الصور  بحـثبحـث  قائمة الاعضاءقائمة الاعضاء  المجموعاتالمجموعات  التسجيلالتسجيل  دخولدخول  
واتس اب-موبايل 00963957547725 -mustafaalbeda@hotmail.com

Instagram


شاطر | 
 

  Faculty of Computer Studies Course Code: M275 Course Title: Web Development Using PHP and MySQL Tutor Marked Assignment – First Semester 2015/2016 Cut-Off Date: TBA Total Marks: 100 Contents Question 1 ……………………..………………………………………..

استعرض الموضوع السابق استعرض الموضوع التالي اذهب الى الأسفل 
كاتب الموضوعرسالة
WhatsApp-00963951432013
Admin


عدد المساهمات : 2348
نقاط : 156631
السٌّمعَة : 4
تاريخ التسجيل : 20/09/2008
العمر : 46
الموقع : www.aoua.123.st

مُساهمةموضوع: Faculty of Computer Studies Course Code: M275 Course Title: Web Development Using PHP and MySQL Tutor Marked Assignment – First Semester 2015/2016 Cut-Off Date: TBA Total Marks: 100 Contents Question 1 ……………………..………………………………………..   الأربعاء نوفمبر 11, 2015 3:10 am




Faculty of Computer Studies
Course Code: M275
Course Title: Web Development Using PHP and MySQL
Tutor Marked Assignment – First Semester 2015/2016

Cut-Off Date: TBA Total Marks: 100

Contents
Question 1 ……………………..………………………………………..……… 2
Question 2 ……………………………..………………..……………………… 2
Question 3 ………………………………..………………..…………………… 3


Plagiarism Warning:
As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The AOU has implemented sophisticated techniques for plagiarism detection. You must provide all references in case you use and quote another person's work in your TMA. You will be penalized for any act of plagiarism as per the AOU's rules and regulations.

Declaration of No Plagiarism by Student (to be signed and submitted by student with TMA work):
I hereby declare that this submitted TMA work is a result of my own efforts and I have not plagiarized any other person's work. I have provided all references of information that I have used and quoted in my TMA work.

Name of Student:
Signature:
Date:


Question 1 [20 marks]

Using the AOU e-Library, go to the “Emerald Journals” sub-library and search for the term PHP. Among the first few results you should find a link to the case study “Database‐backed library websites: a case study of the use of PHP and MySQL at the University of Nottingham.”

Open/Download the article and write a brief summary on why it was decided to use Apache, MySQL and PHP. Note: write in your own words as many reasons as you like, but make sure to limit your answer to a maximum of 300 words.

Hint: you can write your answer as short bullet points.
[20 marks]

Question 2 [50 marks]

This question is based on the “guessing machine” (Chapter 11) that was discussed during the tutorials.
You are asked to create a matching game, where the user will try to guess the correct order of the numbers {1, 2, 3, 4}.
a- Create using HTML a form similar to the following:

Note: You need to provide value for the name attribute of each of the 4 textboxes.
[10 marks]

b- Make sure to set the action attribute of the form to submit the data to the file itself, just as we did with the “guessing machine”.
[5 marks]

c- Add the following PHP section to the beginning of your file and complete it in a way to be able to provide hints to the user until he is able to guess the correct order such as the preview below.
$val1 = 2; //You can change the order of the numbers as you wish
$val2 = 1;
$val3 = 4;
$val4 = 3;
If ( /* Add the proper condition here */ )
{
$message = "Welcome to the matching game!";
$prev = "";
}
else
{
$prev = $_POST['prev'];

//Add your code below and make sure to store the proper
//data in $prev and add it to a hidden HTML element
//in your form





}
?>

Sample run

[35 marks]

Question 3 [30 marks]

Writing SQL queries:

Read the section “Using Join” of Chapter 16 in the book (pages 312 -> 314 in the fifth edition) then answer the following:

a- Create the master_name and email tables using proper types for the fields.
[10 marks]

b- Write the proper insert queries to add all the data as the 2 tables in the book.
[10 marks]

c- Update the LEFT JOIN query so that it will return the Fullname as a single column instead of 2 columns. Hint: you need to use a member of the CONCAT family of functions.
[10 marks]


End of the Questions

_________________
AOU
حلول جميع الواجبات
موبايل – واتس أب
00963951432013
mustafaalbeda@hotmail.com

حلول مضمونة لجميع الواجبات ومشاريع التخرج
حلول الواجبات غير مكررة ونسبة التشابه أقل من 10%
الرجوع الى أعلى الصفحة اذهب الى الأسفل
معاينة صفحة البيانات الشخصي للعضو http://www.aoua.123.st
 
Faculty of Computer Studies Course Code: M275 Course Title: Web Development Using PHP and MySQL Tutor Marked Assignment – First Semester 2015/2016 Cut-Off Date: TBA Total Marks: 100 Contents Question 1 ……………………..………………………………………..
استعرض الموضوع السابق استعرض الموضوع التالي الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1
 مواضيع مماثلة
-
» kaspersky anti virus 9.0.0736+code d activation arjo arade
» برنامجréussire son code de la route رائع لمن يريد تعلم السياقة ألي مش راح يدخل لن يستطيع قيادة
» كل ما يتعلق بكارت التيستر بالصورة
» لفتح الرقم السرى لاى جهاز نوكيا !!!!
» جميع اكود ارقام هواتف دول العالم

صلاحيات هذا المنتدى:لاتستطيع الرد على المواضيع في هذا المنتدى
AOU حل جميع الواجبات ومشاريع التخرج لجميع الفروع والتخصصات AOU :: حلول واجبات 2016 الفصل الصيفي AOU(يشاهدة الآن 3537 زائر)-
انتقل الى: