-User registers ( via "Get's started" button) , then select preferences for events and that's it. Email gets sent based on his/her chosen frequency - all this is stored in the mySQL.
-When user returns he/she logs in and then based on his "profile" a query is sent to database which displays his events.
You click on "My Events" - doGet requests is sent to servlet :
[url removed, login to view]
which sends the following SQL:
select event_name,group_name,event_time,venue,location,city,url,topics,price from events where event_time >=current_date() and event_time <= DATE_ADD(current_date(),INTERVAL 7 DAY) and topics in ( select tags from eventtags where username='[url removed, login to view]@[url removed, login to view]' )
Currently this is on Tomcat and I don't know how to do "mod_rewrite" to mask url . -That's why request is displayed in the browser..
Please convert above functionality to PHP