I$\text{'}$m using the sakila database. I need help with my viewCustomer function $($listed below$).$ Here is a description for what it needs to do: This function should run a query that gets the customer information for all customers in the database and uses that to display a menu of options containing the id $-$ last name, first name to the user. Based on the user choice the function should print the customer's name, phone number, and address including city, email address, if they are active, and last update for the record. You should use prepared statements to run the queries. Here is the code: "void viewCustomer$($sqlite$3*$ db$)$

$\{$

string query $=$ "SELECT customer$\_$id$,$ last$\_$name, first$\_$name FROM customer";

sqlite$3\_$stmt$*$ stmt;

int rc $=$ sqlite$3\_$prepare$\_$v$2($db$,$ query.c$\_$str$(),-1,$ &stmt$,$ NULL$)$;

if $($rc $!=$ SQLITE$\_$OK$)\{$

cerr $<<$ "Error preparing statement: $"<<$ sqlite$3\_$errmsg$($db$)<<$ endl;

sqlite$3\_$close$($db$)$;

exit$(1)$;

$\}$

cout $<<$ "Please choose the customer you want to see:" $<<$ endl;

int pageNum $=1$;

int rowsPerPage $=10$;

int choice;

while $($true$)\{$

$//$ Execute the prepared statement

for $($int i $=0$; i $<$ rowsPerPage; $++$i$)\{$

if $($sqlite$3\_$step$($stmt$)==$ SQLITE$\_$ROW$)\{$

cout $<<$ pageNum $*$ rowsPerPage $+$ i $<<"."$;

cout $<<$ sqlite$3\_$column$\_$int$($stmt$,0)<<"-"$;

cout $<<$ sqlite$3\_$column$\_$text$($stmt$,2)<<""$;

cout $<<$ sqlite$3\_$column$\_$text$($stmt$,1)<<$ endl;

$\}$ else $\{$

$//$ No more rows

break;

$\}$

$\}$

cout $<<$ "Please choose the customer you want to see $($enter $0$ to go to the next page";

cout $<<"$ or $-1$ to go to the previous page$)$: $"$;

cin $>>$ choice;

if $($choice $==0)\{$

pageNum$++$;

$\}$ else if $($choice $==-1)\{$

pageNum $=$ max$(1,$ pageNum $-1)$;

$\}$ else $\{$

$//$ Invalid choice

cout $<<$ "Invalid choice. Please try again." $<<$ endl;

$\}$

$\}$

sqlite$3\_$finalize$($stmt$)$;

$\}"$