Description: Project is build using Angular, Node.js, Express.js, MySQL

1. This is a url shortener web app which converts the original url to short and on using the short url generated it redirects the user to the original URL.
2. User can also give his own custom name(optional) for the url which will be attached to the root url to form the full url which will be in usable form. This should be of min length of 5 characters.
3. On statistics page, on entering a valid custom url address either full url or short url id/ custom name to get the insights about it. That is, shows the total num of views of the custom url, viewer ip, generates the graph of views/month

1. git clone https://github.com/divya661/url-shortener.git
2. cd url-shortener

1. cd app-ui\url-shortener
2. npm install
3. ng serve
4. http://localhost:4200/index

1. cd app-server
2. npm install
3. Create database url_shortener using Create database url_shortener;
4. Change the password in db_config.js file to password of your database in app-server folder
5. Create the tables urls and stats in your database by running the below given DDL commands
6. npm start

create table urls(url_id int not null auto_increment,url_original varchar(5000) not null,url_short varchar(100),url_datetime datetime, url_ip varchar(16),url_num_of_views int,primary key(url_id) );

create table stats(stat_id int auto_increment, url_id int,click_date datetime,url_ip varchar(16),url_short varchar(100),primary key(stat_id),constraint fk_url_id foreign key(url_id) references urls(url_id) on delete cascade);

After running on my localhost results were obtained by me are concluded in the following below images:

1. home_page.jpg
2. result_page.jpg
3. stat_page.jpg

1. urls_mysql_table.jpg
2. stats_mysql_table.jpg

1. custom_url_name_added.jpg
2. added_new_url.jpg
3. statistics_api_result.jpg