rework controller page to fix Warning: pack(): Type H: illegal hex digit mysql

http://3.66.82.212/hotelfront/tv/5 it is 1 controller page you need to fix and rework 700 lines of code. but it are only the MySQL queries you need to rework , budget around 100. bonus for fast service