switched database to mysql and updated controllers with mysql syntax