$1.(4$ points$)$ Explain the difference between the object$-$oriented and procedural syntax and the libraries each uses. Explain when each might be used or why one might be preferred over another.

$2.(4$ points$)$ What is a stored procedure? Show one here using proper syntax and explain what it is doing $($example should be different from the book examples$).$ Use reference$($s$).$

$3.(3$ points$)$ Modify the code to ensure that any whitespace the user might have inadvertently entered at the beginning of his search term is stripped.

$termsearch$=\_\_\_($$$\_$POST$[\text{'}\_\_\_\_\_\_\_\_\_\_\text{'}])$;

$4.(3$ points$)$ Modify the code to instantiate the mysqli class and create a new connection to host localhost with username user$01,$ and password Bbb$123$@#eW$.$ The connection should also be set up to use the database called house.

@$db $=\_\_\_\_\_\_(\text{'}$localhost$\text{'},\text{'}\_\_\_\_\_\_\text{'},\text{'}\_\_\_\_\_\_\text{'},\text{'}\_\_\_\_\_\text{'})$;