Students Registration System

Students Registration System

LTCE Students Registration System

Personal Comment: Students Registration System is based on HTML, CSS, Bootstrap, PHP, MYSQL Languages are used I have provided the main code link in the bottom of this All information.

TABLE OF CONTENTS

Abstract

Introduction

Statement of the problem

System Design

Database Design-ER Diagram

Relational-Databases

Results & Snapshots of the system

Code

ABSTRACT

Today all the work at the time of admission of the students is done manually by ink and paper, which is very slow and consuming much efforts and time. It is required to Design of a Computerized Automated Student Admission System, to speed up and make it easy to use the system. Student admissions are a vital part of any university’s running because students are what keep a University alive. The student admission is one of the most important activities within a university as one cannot survive without students. A poor admissions system can mean fewer students being admitted into a university because of mistakes or an overly slow response time. The process begins with a potential student completing an application form through the Universities and Colleges Admissions Service, the first step for students is to apply directly to the university through a custom online form. This project’s aim is to automate the system, rechecking the inclusion of all required material and automatically ranking each student’s application based on a number of criteria. These criteria include the ranking of their university, their grade at said university and their language grade Certificate. The data used by the system is stored in a database that will be the centre of all information held about students and the base for the remainder of the process after the initial application has been made. This enables things to be simplified and considerably quickened, making the jobs of the people involved easier. It supports the current process but centralizes it and makes it possible for decisions to be made earlier and easier way.

Introduction-Background

SQL

SQL is a standard language designed for managing data in a relational database management system.

SQL stands for Structured Query Language. SQL is a standard programming language specifically designed for storing, retrieving, managing or manipulating the data inside a relational database management system (RDBMS). SQL became an ISO standard in 1987.

SQL is the most widely-implemented database language and supported by the popular relational database systems, like MySQL, SQL Server, and Oracle. However, some features of the SQL standard are implemented differently in different database systems.

SQL was originally developed at IBM in the early 1970s. Initially, it was called SEQUEL (Structured English Query Language) which was later changed to SQL (pronounced as S-Q-L).

What You Can Do with SQL

There are a lot more things you can do with SQL:

• You can create a database.

• You can create tables in a database.

• You can query or request information from a database.

• You can insert records in a database.

• You can update or modify records in a database.

• You can delete records from the database.

• You can set permissions or access control within the database for data security.

• You can create views to avoid typing frequently used complex queries.

The list does not end here, you can perform many other database-related tasks with SQL.

What is MySQL?

MySQL is one of the most popular relational database system being used on the Web today. It is freely available and easy to install, however, if you have installed Xampp server is already there on your machine. MySQL database server offers several advantages:

• MySQL is easy to use, yet extremely powerful, fast, secure, and scalable.

• MySQL runs on a wide range of operating systems, including UNIX or Linux, Microsoft Windows, Apple Mac OS X, and others.

• MySQL supports standard SQL (Structured Query Language).

• MySQL is an ideal database solution for both small and large applications.

• MySQL is developed, and distributed by Oracle Corporation.

• MySQL includes data security layers that protect sensitive data from intruders.

MySQL database stores data into tables like other relational databases. A table is a collection of related data, and it is divided into rows and columns.

Each row in a table represents a data record that is inherently connected to each other such as information related to a particular person, whereas each column represents a specific field such as id, first_name, last_name, email, etc. The structure of a simple MySQL table that contains a person's general information may look something like this:

+----+------------+-----------+----------------------+

+----+------------+-----------+----------------------+

+----+------------+-----------+----------------------+

PHP

PHP is the most popular server-side scripting language for creating dynamic web pages.

PHP stands for Hypertext Pre-processor. PHP is a very popular and widely-used open-source server-side scripting language to write dynamically generated web pages. PHP was originally created by Rasmus Lerdorf in 1994. It was initially known as Personal Home Page.

PHP scripts are executed on the server and the result is sent to the web browser as plain HTML. PHP can be integrated with the number of popular databases, including MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Sybase, and so on. The current major version of PHP is 7. All of the code in this tutorial has been tested and validated against the most recent release of PHP 7.

PHP is a very powerful language yet easy to learn and use. So bookmark this website and continued on.

What You Can Do with PHP

There are a lot more things you can do with PHP.

• You can generate pages and files dynamically.

• You can create, open, read, write and close files on the server.

• You can collect data from a web form such as user information, email, phone no, etc.

• You can send emails to the users of your website.

• You can send and receive cookies to track the visitor of your website.

• You can store, delete, and modify information in your database.

• You can restrict unauthorized access to your website.

• You can encrypt data for safe transmission over the internet.

The list does not end here, there are many other interesting things that you can do with PHP.

HTML

HTML is the main markup language for describing the structure of web pages.

HTML stands for HyperText Markup Language. HTML is the basic building block of the World Wide Web.

Hypertext is the text displayed on a computer or other electronic device with references to other text that the user can immediately access, usually by a mouse click or keypress.

Apart from text, hypertext may contain tables, lists, forms, images, and other presentational elements. It is an easy-to-use and flexible format to share information over the Internet.

Markup languages use sets of markup tags to characterize text elements within a document, which gives instructions to the web browsers on how the document should appear.

HTML was originally developed by Tim Berners-Lee in 1990. He is also known as the father of the web. In 1996, the World Wide Web Consortium (W3C) became the authority to maintain the HTML specifications. HTML also became an international standard (ISO) in 2000. HTML5 is the latest version of HTML. HTML5 provides a faster and more robust approach to web development.

What You Can Do with HTML

There are a lot more things you can do with HTML.

• You can publish documents online with text, images, lists, tables, etc.

• You can access web resources such as images, videos or other HTML documents via hyperlinks.

• You can create forms to collect user inputs like name, e-mail address, comments, etc.

• You can include images, videos, sound clips, flash movies, applications and other HTML documents directly inside an HTML document.

• You can create an offline version of your website that works without the internet.

• You can store data in the user's web browser and access later on.

• You can find the current location of your website's visitor.

The list does not end here, there are many other interesting things that you can do with HTML.

CSS

CSS is the key presentational technology that is used in website design.

CSS stands for Cascading Style Sheets. CSS is a standard style sheet language used for describing the presentation (i.e. the layout and formatting) of the web pages.

Prior to CSS, nearly all of the presentational attributes of HTML documents were contained within the HTML markup (specifically inside the HTML tags); all the font colours, background styles, element alignments, borders and sizes had to be explicitly described within the HTML.

As a result, the development of the large websites became a long and expensive process, since the style information was repeatedly added to every single page of the website.

To solve this problem CSS was introduced in 1996 by the World Wide Web Consortium (W3C), which also maintains its standard. CSS was designed to enable the separation of presentation and content. Now web designers can move the formatting information of the web pages to a separate style sheet which results in considerably simpler HTML mark-up, and better maintainability.

CSS3 is the latest version of the CSS specification. CSS3 adds several new styling features and improvements to enhance web presentation capabilities.

What You Can Do with CSS

There are a lot more things you can do with CSS.

• You can easily apply same style rules on multiple elements.

• You can control the presentation of multiple pages of a website with a single style sheet.

• You can present the same page differently on different devices.

• You can style dynamic states of elements such as hover, focus, etc. that isn't possible otherwise.

• You can change the position of an element on a web page without changing the markup.

• You can create animations and transitions effects without using any JavaScript.

• You can create a print-friendly version of your web pages.

The list does not end here, there are many other interesting things that you can do with CSS.

Statement of the problem

The file-based student Application system has for many years been very effective. However, with the increase in the number of applicants, the system wastes a lot of time in terms of searching for the applicant record, in addition to requiring a large number of human resources which has led to the high cost of operation. It is because of the above that an online Application system was developed to allow the organization to save time and reduce the cost of operation.

o User-Friendly Application Form can reduce admission form related queries by 50%.

o User-Friendly application form reduces the time required to fill the form.

o Manual Errors of form filling are also reduced.

o, Student, Satisfaction level increases due to the user-friendly admission form.

Database Design- ER Diagram