Daily Diary

I started with  HTML on 27th December by understanding basic concepts like what are the things a person should know for developing and designing  a website and i also came to know about technical terms related to web like DNS, Web Hosting, Web Server  and i also explored tools like Wampserver.

I learned about What is HTML and what can i use HTML for so this class mostly covers the basic theory regarding HTML concepts.

On 28th Dec, I learned about HTML Elements and Tags that includes html headings ,comments ,heading ,image ,paragraph,body,head,title tags and i also came to know about how can i use ordered and unordered list in my web page.

On 29th Dec,I learned about formatting and concept of hyper and external  links in html.

On 31st Dec,I learned about tables in html.

Second week: From 1st Jan, 2015 to 9th Jan, 2015.

on 1st Jan, I came to know about basic concept of html layouts like divisions that is <div> tag  in html.

on 2nd Jan , My teacher has given me  an assignment to make a webpage using div and tables and other concepts which i have learned so far and i have successfully submit my assignment on 4th Jan and i have incorporated the home page of GNDEC and made a page similar to that using div tag  and in this assignment i have also explored various concepts of html  like links, formatting properties.

on 3rd Jan, I came to know about the concept of Forms in html and i also came to know about CSS(cascading style sheet) like what do you mean by CSS and how can i embed CSS in my html.

on 4th Jan , i covered different types of CSS that is internal ,external and inline css and also discover why it is more beneficial to use external  CSS in our website and i practiced  the basic syntax of CSS.

on 8 th Jan ,I learned about the different properties of CSS like background ,image ,using Gradient with CSS3 and i have also came to know about that how can i design a Horizontal and vertical menu bar in html using css.

on 9th Jan, I modified my assignment and i have  given a work of incorporating CSS to my webpage which i have made earlier as the home page of Gndec.

From 10th Jan, 2015 to 16th Jan, 2015

I started with Concepts of JavaScript  like what is JavaScript and why we use it .

In the following week i came to know about the basic syntax of javascript variables, function, object, operators ,comparisons in JavaScript.

on 16th Jan i learned about validations  in java script  that how one can include validation while including basic forms in our webpage like Sign up ,Login form and Registration Form.

on 17th Jan ,i have given an assignment to make a Registration Form in html uisng css and i have to include validation in that form also.

It takes 2 days for me to complete that part and i have successfully submitted my assignment on 19th Jan.

From 22 Jan to 31 Jan ,i made various static home pages like Gmail, yahoo etc in order to understand the concepts clearly.

I also made a static website using Html ,Css and JavaScript and this website is for a manufacturing company and it takes a lot of time for me in order to complete it as it consist of many pages.

From 1st Feb, 2015 to 17th Feb, 2015

On 1st Feb ,I started with database and in the following week i came to know about the concepts of database. I used Apache and MY SQL database. The introduction part of database covers the topics like why we need a database to store the information as compared to traditional file system. I studied concepts of DDL,DML and DCL languages and then i get myself  familiar with basic queries of SQL like insert, update, delete and create and then i tried to learn other queries of SQL that includes alter, update, rename  and i also came to know about the concept of views and different data types of MySQL.

8th Feb 2015

Basic  concept of Normalization that includes normal forms 1st,2nd,3rd and BCNF normal forms. I understand why there is need to bring a database table in a normal form and why its useful.

9th Feb 2015

Tried some basic queries  of SQL that covers basic concepts and queries of SQL and learned about different types of keys  and constraints in SQL .

11th Feb 2103

Moved to some advance concepts of MySQL and that includes JOINS. I covered Inner. Left, Right and Full JOIN.

12th Feb 2015

Tried some problems of Joins.

13th Feb 2015

Aggregate functions which includes max(),min(),sum(), avg() etc.

14th Feb 2015

Tried problems of Aggregate functions.

15th Feb 2015

Learned about Sub queries and covers problem on that concept.

16th Feb 2015

I have made a database named a database and i made some tables in it and perform operations on it like inserting a new record ,updating an existing record and retrieving  the records from the table and then also some complex queries on it using concept of foreign key and primary key ie by establishing a relation between more than one table using foreign key.

18th Feb 2015

Introduction to PHP that covers why we need PHP and why it is useful and what are its limitations.

19th Feb 2015

Basic OOPS concept of PHP.

20th Feb 2015

Basic Programs in PHP using for and while loop that includes using of basic conditional statements and also covers arrays.

21st Feb 2015

GET and POST functions in php. Perform basic validation using PHP and passed value from one page to another page using GET and POST functions, in order to perform and use this super global array functions of php I made a Login form and i used the concept of get and post functions in that.

22nd Feb 2015

Learned about database connectivity in PHP that how to maintain a database connection in php using built-in functions of php with My SQL and i also learn about CRUD (create,retrieve,update and delete) in php that how can i retrieve values on front end from database and how can i perform operations like update ,insert and delete on front end and how will those changes get reflected in my database. I used fetch functions in order to perform this functions.

23rd Feb 2015

Upload files to a directory in php and also how can we upload a file  directly to a database from front end.

25th Feb 2015

Learned Concept of Sessions in PHP and made a Login and Logout form using Session.

26th Feb 2015 to 27th Feb 2015

Assignment on making a complete Login and Registration form with proper Validations in PHP using SESSIONS.

28th Feb 2015 to 9th March  2015

After making a Log in ,log out  and registration functionality, I started working on making a profile page for a user where he/she can view his/her personal information and can edit his personal information  and also he /she has the option to reset his/her password in case he forgot his password. Learned about Cookies that how to set a cookie by setcookie()  function.

11th March 2015 to 12th March  2015

Learned about predefined functions in php and built in string functions of PHP like strtoupper(),strtolower(),strtotime().

13th March  2015 to 18th March 2015

Learned about Concept of files in php and studied different modes and operations that can be applied on the files.

20th March  2015 to 27th March 2015

Captcha and file downloading concept from predefined libraries and classes .

29th March  2015 to 3rd April 2015

Types of arrays:1)Numeric/index array,2)Associative arrays,3 ) Multidimensional arrays, Global arrays and array built in functions.

Functions in PHP,PHP from handling, PHP include and require functions, date functions in PHP like date() and learned about timestamp, PHP server variables, time() function in php.

*Functions

-void type without arguments

-void type with arguments

*Functions

-return type without arguments

-non-return type with arguments

PHP security functions md5, crypt and SHA1.

4th April  2015 to  11th April 2015

Started with my Project Total Event Management . First Of All, I begin with understanding client requirements that include understanding problem descriptions and definitions. Designing of the home page.

there is a menu bar on left side , a side bar, and worked on  a registration table on left side where user can view booked and reserved and available list of rooms according to a specific date .

Prepared service registration page where user can access for the different three types of services .

12th April  2015 to  19th April 2015

Started with making of the top of the front page i.e. Header of my website. Designed logo for the home page.

Java script Validations on the fields and the insert sql query, updating sql query and delete query, so Perform the CRUD manipulations on my database that is worked on database interaction and validations.

Session concept applied on the index page of my admin section.

20th April  2015 to  25th April 2015

Worked on print button in which once user avail the service after filling form the details of the user will get retrieved and he/she can take a print of it in order to make payment which makes this process more secure.

Coded for change password page of my admin section.

Applied session on it.

27th April  2015 to  29th April 2015

Prepare the mid term report and design the database object model diagrams for the project.

1st May  2015 to 11 May 2015

Connectivity of My Sql database with forms.

*Insert, Update, Delete, Reset button coding.

* Designing new forms for project.

* Using Session Attributes in connectivity.

12th May  2015 to 19th May 2015

Design and develop my admin panel of the website according to user requirments.

20th May  2015 to 24th May 2015

get basic introduction of OOPS in PHP.

25th May 2015

Completed with my project front end and back end.

27th May 2015

Checking complete project for Errors.

Testing codes from various parts of the project.

Validations check.

30th May 2015

Report Preparation of the project.

Report Checking with the project manager.

Final report without errors.

1st June 2015

Preparation of final presentation.

Submission of presentation.

End of the project.