<% /** Connection to Database Variables **/ %>
<%
	String url = "jdbc:mysql://localhost:3306/biguy";
	String userid = "root";
	String passDB = "root";
%>

<% /** Register Variables **/ %>
<%
	String reg_name = request.getParameter("reg_name");
	String reg_fam = request.getParameter("reg_fam");
	String reg_email = request.getParameter("reg_email");
	String reg_user = request.getParameter("reg_user");
	String reg_pass = request.getParameter("reg_pass");
	String reg_query = "insert into user_info (Name,FamilyName,EmailAddress,Username,Password) values ('"+ reg_name +"','"+ reg_fam +"','"+ reg_email +"','"+ reg_user +"','"+ reg_pass +"')";
%>

<% /** Login Variables **/ %>
<%
	String log_user = request.getParameter("log_user");
	String log_pass = request.getParameter("log_pass");
	String log_query = "select * from user_info where Username = '"+ log_user +"' && Password = '"+ log_pass +"'";
	String passward = "";

%>

<% /** Browse Queries **/%>
<%
	String show_query = "select * from user_info";
%>

<%
	String search_here = request.getParameter("search");
	String search_query = "select * from user_info where name like '%"+ search_here +"%'";


%>

<%
	String add_right = request.getParameter("add_right");
	String select_entry = request.getParameter("select_entry");
	String rights_query = "insert into user_info (Position) values ('"+  select_entry +"')";
%>




<%
	String del_email = request.getParameter("delete");
	String del_query = "delete from user_info where EmailAddress = '"+ del_email +"'";
%>