Q$7.$ Given the following PHP program:

cdots. $.$

print FORM method $=$ "post" action $="$$;

$...$

$allresult $=$ $d$->$getAll$(\text{'}$SELECT Pnumber, Pname FROM PROJECT, DEPARTMENT WHERE

Dname $=?$ AND Plocation $=?$ AND Dnum $=$ Dnumber',

$(1)$

print "projects controlled by department $\_(2),$ and project location is located at $(3)$ : In$"$

foreach $($

$(4)$

print "project number:

$($a$)(6\%)$ Fill in the blanks of $(1),(2)$ and $(3).$

$($b$)(6\%)$ Fill in the blanks of $(4),(5)$ and $(6).$

Q$8.$ Assume that the array variable $advising is associative, and each element in $advising associates a student name $($key$)$ with the advisor of the student $($value$).$ Suppose that the associations of students and advisors are as follows. 'John' is the advisor of 'Kevin'; 'Darrel' is the advisor of 'Tim'; 'Jack' is the advisor of 'Mary'.

$($a$)(3\%)$ Write a PHP statement to assign the student$-$advisor associations to the array variable $advising.

$($b$)(5\%)$ Write a PHP program looping through all the elements in Sadvising using the foreach construct, and printing the employee name and supervisor name of each element on a separate line.