Optic-Lens

This is an Full Stack project developed as part of the my college Full Stack Web Development lab.

This Project is developed using HTML5, CSS3, Bootstrap, JavaScript, Sass, Oracle DB, Apache tomcat.

👉 This project includes an login and logout sessions

👉 Admin access controls like user selection, updation and deletion

Required Oracle Database & Tomcat exe files

SELECT SYS_CONTEXT('USERENV','SERVER_HOST') FROM dual /* 👉 System Name */;

SELECT SYS_CONTEXT('USERENV','INSTANCE_NAME') FROM dual /* 👉 Service Name */;

Registration form table

create table registration(
username varchar(50) not null,
email varchar(255) primary key not null,
password varchar(20) not null,
cpass varchar(20) not null,
user_type varchar(5) not null
);

Subscribe table

create table subscribe(
email varchar(255) not null
);

Contact us table

create table contact(
name varchar(20) not null,
email varchar(255) not null,
mobile number(10) not null,
message varchar(200) not null
);

Payment form table

create table payment(
name varchar(50) not null,
email varchar(255) not null,
name_on_card varchar(50) not null,
address varchar(150) not null,
credit_card_number number(16) not null,
city varchar(50) not null,
expiry_month varchar(10) not null,
state varchar(30) not null,
zip_code number(6) not null,
expiry_year number(4) not null,
cvv number(3) not null
);