A very good afternoon to you all. So as I said yesterday, that from today onwards I’ll start sharing my knowledge on PHP and MySql and on Website Designing with you all, so lets start.
First of all we have to understand what is PHP? Acronym for "PHP: Hypertext Preprocessor". The best things in using PHP are that it is extremely simple for a newcomer, but offers many advanced features for a professional programmer. Don't be afraid reading the long list of PHP's features. You can jump in, in a short time, and start writing simple scripts in a few hours. Although PHP's development is focused on server-side scripting, you can do much more with it. PHP is mainly focused on server-side scripting, so you can do anything any other CGI program can do, such as collect form data, generate dynamic page content, or send and receive cookies. PHP can be used on all major operating systems, including Linux, many Unix variants (including HP-UX, Solaris and OpenBSD), Microsoft Windows, Mac OS X, RISC OS, and probably others. PHP has also support for most of the web servers today. This includes Apache, Microsoft Internet Information Server, Personal Web Server, Netscape and iPlanet servers, Oreilly Website Pro server, Caudium, Xitami, OmniHTTPd, and many others. I think this much knowledge is enough, but if you want more knowledge you can ask me.
Today I’ll show you an application and tell you how it is created. So lets start. For every organization it is most important to make a record of attendance of every employee working. But how to do is the question? You can make the record on a Copy. But how many pages will you waste for this. Let us build small application for this where individual can sign in and register their attendance for the day. So, without wasting time let me show you that application.






So let’s start with login page. In this application login page is very important because in this case every individual attendance will be recorded. For creating login page you have first creating database in MySQL. Where you will store the username and password. You can name database according to your choice, but remember the name. You have to create a registration page using html, with this registration page you will register username and password.Each person should have unique username and password. You have to create three field or tupples in your database, username, password and id. You should have to allot primary key to id field and you can also make it auto increment. With username and password, user will sign in and can register for the day. Remember when he register his/her attendance he/she is recording their in time. And after registering there in time, next time when they sign in they will see the out time page, where they have to register there out time. You guys were confused, how this could happen? Yes it’s possible; you have to write small code for this. In fact you have to check from the database that the person who logged in has made registered earlier or not, a small SQL code for searching from database. So if the person has not registered earlier he/she will see the in time page and if he/she has registered earlier, then out time page will be displayed to him. One more feature is also added to it, i.e. leave application page. It’s a feature where you will get to apply for leave online.
I’ll tell you about this application tomorrow. So don’t forget to read my blog tomorrow. And if anything you didn’t understand in this section you are free to question. See you tomorrow. And please leave your comments too. Have a nice day.