About this project:
- I worked on this project with PHP, Laravel and MySQL.
- This application performs the basic operations; Create, Read, Update and Delete.
To Do list with Laravel and MySql
Author: admin
Hitachi Homepage
I redesigned the Hitachi Homepage following the Hitachi Design guidelines and Website guidelines. This Homepage is responsive. The design and the built page was approved by the Website Team in Hitachi Japan before I made it live.
My Role:
- Designing the homepage with Photoshop
- Building a responsive homepage with HTML, JavaScript, CSS and Bootstrap
Hitachi and Bing Lee 5 year business event RSVP
A event was organized by Hitachi home appliances team to celebrate 5 years of business between Hitachi and Bing Lee. Attendance was by invitation only and not transferable. Bing Lee employees were requested to RSVP by March 18.
To meet the requirements, I built a RSVP form. The form was built with PHP, MySql, CSS and HTML.
Email addresses of Bing Lee employees were imported into a MySql database table from an Excel sheet. The email addresses were also imported into Campaign Monitor. Email invites were sent from Campaign Monitor to Bing Lee employees with a customized URL which had employees email address appended to it. To prevent uninvited guests from using fake email address in the URL, validation code was added in the form to check if the email address from the URL matched a email address in the database. Since the invitation was not transferable, employees were given one chance to respond. If they tried to access the form after responding, they were shown the message, “You have already responded. Thank you.”
Employee responses were saved in the database table and shared with Hitachi marketing team.
I have setup a demo of the PHP form with test email addresses on my website. Please click the URLs below to see the form.
Below is a link to the form before the user responds.
https://alfredkumar.com/portfolio-demo-files/websites/hitachi/bing-lee-rsvp/?email=alfred1@test1.com
Below is a link to the form after a user responds.
https://alfredkumar.com/portfolio-demo-files/websites/hitachi/bing-lee-rsvp/?email=alfred5@test5.com
Below is a link to form data. The page will show a list of users who responded. This page also has a button to download the data in Excel format.
https://alfredkumar.com/portfolio-demo-files/websites/hitachi/bing-lee-rsvp/export-db/
The People of Hitachi pages
I designed and built the people of Hitachi pages with HTML, CSS, JavaScript and Bootstrap. I also created a JavaScript animation banner and placed it on the Hitachi Homepage. The banner and pages are still active on the Hitachi website. View live pages.
My Role:
- Building responsive pages with HTML, JavaScript, CSS and Bootstrap
- Designing graphics
Hitachi product content updates
I frequently update Hitachi product information and created new product pages on the Hitachi website.
My Role:
- Updating product pages and creating new model pages
- Building responsive pages with HTML, JavaScript, CSS and Bootstrap
- Designing graphics
- Video editing
My projects
I built the frontend of this webpage with ReactJS. The ReactJS code fetches data from edamam.com API and shows the data on this webpage.
I built the frontend of this webpage with ReactJS. The ReactJS code fetches data from omdbapi.com API and shows the movie information on this webpage.
I designed and built this website with WordPress and Elementor Page builder.
Star in the car
My Role:
- PHP programming
- Database designing in MySQL
- Integrating frontend with backend
- Building related EDMs
- Graphic editing
About this screenshot
This is screenshot of the homepage. This image shows one of the carousel images on the top. At the bottom it shows the logos of different teams. Users can select logo of a team and go to a page dedicated for that team.
About this screenshot
This screenshot is of one of the teams pages. On this page users can watch players driving Hyundai’s cars. After watching the video, users can select the picture of the player who was driving and the car the player was driving. After making their selections users can go back and guess players and cars for another teams or submit the entry.
About this screenshot
This screenshot is of the page that validates the users email address. Users are requested to enter their email address and submit the form. If the email address doesn’t exist in the database users are redirected to the registration page. If email address does exist users are shown the score.
About this screenshot
This is a screenshot of the registration page. The form validation and data collection was coded with PHP.
About this screenshot
This screenshot is of the page that displays the score. It is shown only if users have already registered. If users have not registered users are redirected to the registration page.
About this screenshot
This screen was displayed after users session expired. Session was set to expire if users were inactive for one hour.
Hyundai Fanwall
My Role:
- HTML, CSS, Jquery
- PHP programming
- Database designing in MySQL
- Integrating frontend with backend
- Building related EDMs
- Graphic editing with photoshop
About this screenshot
This is screenshot of the registration page. Users who click on the CTA on the campaign’s banners and EDMs would reach this landing page. The registration page allowed users to enter their information and upload their pictures to take part in the competition to win a Hyundai i30 SR.
About this screenshot
This is screenshot of the administration page. I had secured access to the admin pages with a custom admin login page. The admin area displayed pictures and information of all the users. I have pixelated the pictures to avoid violating privacy of individuals in the pictures. The admin page also gave access for the client to export user information in CSV format.
Kia and Essendon member offer
My Role:
- Frontend coding with HTML, CSS and Javascript
- Backend coding with PHP
- Database designing in MySQL
- Integrating frontend with backend
- Building related EDMs
- Graphic editing
About this screenshot
These screenshots are of main pages for different car models. The model’s main page has the postcode input box which is the key functionality. Entering a postcode would display offers specific that postcode. I imported data from CSV files in MySQL. I coded a PHP function to filter data based on the postcode. Because it worked well, the same code was used for Hyundai Fleet sales.
About this screenshot
These screenshots are of inside pages for different car models. The inside pages for models show the offers specific to the postcode submitted by users.
Innocean ad presentation page
My Role:
- HTML, CSS and Javascript
- Graphic editing with photoshop
About this page
This page was presented as an alternate homepage for Innocean’s website. I built it as per the requirements of one of the digital producers. Clicking the images will open the TV ads.