Suppose you have access to a remote database server with the following information

Design a book title search form and implement server$-$side logic to search for books in the

books table $($id$,$ isbn, title, author, price, stock$)$ using a partial author name as input, and

display the results on a webpage.

What are the advantages of using prepared statements in PDO? Rewrite the code below

so that it uses PDO prepare statement.

$$db=$ new PDO$(dots)$;

$suthor $=$ 'Adam Smith';

Srow $=$ $db$->$query$("$SELECT $*$ FROM book where author $="".$$suthor."";"$)$;

What is PDO? Distinguish between query and exec method in PDO.