/* Check to make sure we are connected to the database before allowing access to the home page. If not connected, go connect and initialize; otherwise, welcome the user.\ */ if(!database.connected()) redirect("init.htm"); project.lock(); if (client.action == "insert") { database.execute("insert into employer (name, employer_id, control_no, suffix, account, plan_no, claim_office_code, customer_code, address, city, state, zip, phone, admin_name, admin_email) values ('" + request.name + "','" + request.employer_id + "', '" + request.control_no + "', '" + request.suffix + "', '" + request.account + "', '" + request.plan_no + "', '" + request.claim_office_code + "', '" + request.customer_code + "', '" + request.address + "', '" + request.city + "', '" + request.state + "', '" + request.zip + "', '" + request.phone + "', '" + request.admin_name + "', '" + request.admin_email + "')"); } else { database.execute("update employer set name = '" + request.name + "', employer_id = '" + request.employer_id + "', control_no = '" + request.control_no + "', suffix = '" + request.suffix + "', account = '" + request.account + "', plan_no = '" + request.plan_no + "', claim_office_code = '" + request.claim_office_code + "', customer_code = '" + request.customer_code + "', address = '" + request.address + "', city = '" + request.city + "', state = '" + request.state + "', zip = '" + request.zip + "', phone = '" + request.phone + "', admin_name = '" + request.admin_name + "', admin_email = '" + request.admin_email + "' where employer_id = '" + request.employer_id + "'"); } project.unlock(); redirect("admblank.htm");