<div class="Objective_card card-content-body"><p>You will be creating a full-stack website that uses the student information from a database as input and generates his/her result in PDF format as output which can then be downloaded and shared.</p></div>

Objective

<div class="Project_Context_card card-content-body"><p>In our day-to-day life, we come across various examination results such as school exam results, competitive exam results, college semester exam results, etc. How efficiently it produces someone's result by just filling in student details! But, have you ever thought of creating one? The ones who did basically went through the hectic job of perfecting their database and then using the knowledge of front-end and back-end to do so.
<br/>
<br/></p><p>Developers are known for doing stuff automatically and efficiently. Thus we can have an easier take on it, by creating a system that accepts the student details as input and generates the desired result as output.</p></div>

Project Context

Project Stages

<div class="High-Level_Approach_card card-content-body"><ul>
<li>We will be following a <strong>Top Down Approach</strong> throughout this project i.e. starting from the end goal, back tracing to the starting point.</li>
<li>This project is having 3 sections that we have to implement namely <strong>Result Section</strong> for student's purpose, <strong>Database</strong> for storage purpose and <strong>Admin Section</strong> for administrative purpose.</li>
<li>Firstly, we will be understanding the end goal of this project i.e. <strong>Result Section</strong>.</li>
<li>Thereafter, we move towards the <strong>Database</strong> part starting from naive queries to optimizing it.</li>
<li>Then, we will jump to the <strong>Admin Section</strong> for performing various activities that previously were done manually i.e. data addition and modification.</li>
<li><strong>Authentication</strong> for admin section will then take place.</li>
<li>Then, we will <strong>Club</strong> things all together into our system.</li>
</ul></div>

High-Level Approach

<div class="Primary_goals_card card-content-body"><ul>
<li>Performing normalization of the database.</li>
<li>Performing various database queries.</li>
<li>Automating the addition and modification of student data.</li>
<li>Implement an authentication system for admin.</li>
<li>Generate the result in PDF format and download it.</li>
</ul></div>

Primary goals

<div class="Applications_card card-content-body"><ul>
<li>Create and manage school or institute result portal.</li>
<li>Create other types of management system.</li>
</ul></div>

Applications

<div class="Understanding_system_workflow_card card-content-body"><p>Our project is going to be a full stack application. A full stack application primarily comprises of 3 things - front-end, back-end and database.
<br/>
<br/></p><p>So, this project is also divided into 3 parts:</p><ul>
<li><strong>Result Section</strong> (front-end)</li>
<li><strong>Database</strong></li>
<li><strong>Admin Section</strong> (back-end)
<br/></li>
</ul><p>We start by settings things up for the front-end, then for database and then move towards to the back-end part.</p></div>

Understanding system workflow

<div class="Requirements_card card-content-body"><ul>
<li>A code editor like SUBLIME for writing code for the front-end and back-end.</li>
<li>An Apache distribution like XAMPP for handling server and database. Go download it, if not available to your system.</li>
<li>Head over to the <code>htdocs</code> folder of XAMPP and create a new folder by your preferred name for this project. Mine is <code>SRMS</code>.</li>
<li>All the folders/files will be created in this folder.</li>
<li>Execute XAMPP and open the <code>apache</code> and <code>mysql</code> in new tabs.</li>
<li>All the data creation/deletion/modification will take place at <code>mysql tab</code>. Go ahead and create a database with the same name as project folder. For my case it will be <code>SRMS</code>.</li>
<li>phpmyadmin tab will show you the output from your project. By default it starts with <code>index.php</code>  file, you can change it in settings.</li>
<li>Instead of <code>dashboard</code> in the URL change it to your project folder name i.e. <code>SRMS</code> then put a forward slash and type your file name that you want to open. Ex. <code>SRMS/homepage.html</code>.</li>
<li>Go ahead and create landing page for this project using HTML. Make it stylish using CSS. Make it responsive using Bootstrap.</li>
</ul><div class="References"><h3>References</h3><ul>
<li><a href="https://www.apachefriends.org/index.html" target="_blank">Link to download XAMPP</a></li>
<li><a href="https://www.sublimetext.com/3" target="_blank">Link to download SUBLIME</a></li>
<li><a href="https://youtu.be/X0_pthMQPMM" target="_blank">How to use XAMPP</a></li>
<li><a href="https://www.studentstutorial.com/php/how-to-create-table-in-phpmyadmin" target="_blank">How to create database in MySQL using XAMPP</a></li>
</ul></div><div class="Note"><h3>Note</h3><ul>
<li>Here I am using HTML + CSS + JavaScript for front-end, MySQL for database and PHP for back-end.</li>
<li>Feel free to choose your preferred language for front-end, back-end and follow accordingly.</li>
</ul></div></div>

Requirements

<div class="Expected_Outcome_card card-content-body"><p>The main objective of this milestone is to make sure that you understand the basic overflow of the project. Also, you should have a code editor and apache distribution in place. With this you should be able to access the MySQL, phpmyadmin home page and your project files.</p></div>

Expected Outcome

<div class="Dig_into_the_result_section_card card-content-body"><p>Let's start ourselves from the result section!!</p><p>What exactly we want from our system? Yes, you are thinking it right. We want from our system that it should take student details as input such as <code>roll no</code>, <code>class</code>, <code>dob</code> (for hiding it from other students, if required) and produce his/her result as output. Make a <code>.php</code> file with some convenient name and make a form which takes <code>roll no</code> and <code>class</code> as input. On submit, it should perform required SQL query(s) to obtain the result as output.
<br/>
<br/></p><p>But wait! From which table are we going to fetch the required data? Did we create any table in the <code>srms</code> database? Yes, you are right, we don't have any table yet. Go ahead and create a table called <code>students</code>. But what should be the attributes in the table? The simplest table should have at least these following attributes -</p><ul>
<li><code>StudentId</code> =&gt; unique key for each student</li>
<li><code>StudentName</code> =&gt; student name</li>
<li><code>RollId</code> =&gt; roll number</li>
<li><code>ClassName</code> =&gt; class name</li>
<li><code>ClassSection</code> =&gt; section of class (if needed)</li>
<li><code>SubjectName</code> =&gt; all subjects name in separate tuple</li>
<li><code>Marks</code> =&gt; marks of that particular subject<br/>
<br/></li>
</ul><p>Apart from that you can add attributes if you want such as gender, mail, contact number, etc. But this should be there for proper data storing and fetching. Shouldn't it?</p></div>

Dig into the result section

<div class="Requirements_card card-content-body"><ul>
<li>Fill some data into your <code>students</code> table on your own for now.</li>
<li>Connect your database <code>srms</code> to your PHP page.</li>
<li>Store the filled form data in separate variables.</li>
<li>Perform a SQL search query in the <code>students</code> table where <code>roll no</code> and <code>class</code> matches with your database entries.</li>
<li>Extract each and every row which matches to your search query.</li>
<li>Output only selected data such as subject name and corresponding marks.</li>
</ul><div class="References"><h3>References</h3><ul>
<li><a href="https://www.studentstutorial.com/php/how-to-create-table-in-phpmyadmin" target="_blank">Create Table and attributes in MySQL using XAMPP server</a></li>
<li><a href="https://www.w3schools.com/php/php_mysql_create_table.asp" target="_blank">Create Table and attributes in MySQL using PHP</a></li>
<li><a href="https://www.w3schools.com/php/php_mysql_select.asp" target="_blank">Hopw to select and output data using PHP MySQL</a></li>
</ul></div></div>

<div class="Bring_it_On!_card card-content-body"><ul>
<li>Go ahead and print some additional details on the result page such as student name, class, total marks obtained, percentage, etc.</li>
<li>Make it stylish by aligning the result properly.</li>
</ul></div>

Bring it On!

<div class="Expected_Outcome_card card-content-body"><p>You should be able to make a database, table and attributes with some data into it. You should also be able to get student data as input, parse it, perform search queries and output it to the user.</p></div>

<div class="Play_around_with_the_database_card card-content-body"><p>Let's analyze our previous database from various DBMS perspectives.
<br/></p><ol>
<li>Is our database consistent?</li>
<li>Is our database efficient?</li>
<li>Is our database scalable?</li>
<li>Is our database usable?</li>
<li>Is our database manageable?
<br/>
<br/></li>
</ol><p>The answer to all the questions is <strong>NO</strong>, why? Think about it.
<br/>
<br/></p><p>Let's suppose if some student data is changed like address, contact number, etc. Then, we have to reflect that change at all the entries in the database because there are many entries for a single unique student depends on number of subjects.
<br/>
<br/></p><p>Also, it is not looking great if we have to scale it for various classes, schools, etc. Because at the end data will become more and more redundant. Also, we can't perform other high level operations on this current database due to its not so good looking structure.</p></div>

Play around with the database

<div class="Requirements_card card-content-body"><ul>
<li>Understand each term that's mentioned above.</li>
<li>Read about data normalization in database.</li>
<li>Think why is it true.</li>
</ul><div class="References"><h3>References</h3><ul>
<li><a href="https://blog.paessler.com/key-considerations-when-choosing-a-dbms" target="_blank">Considerations during database creation</a></li>
<li><a href="https://www.geeksforgeeks.org/introduction-of-database-normalization/" target="_blank">Intro to normalization</a></li>
<li><a href="https://www.geeksforgeeks.org/normal-forms-in-dbms/" target="_blank">Different normal forms</a></li>
</ul></div></div>

<div class="Bring_it_On!_card card-content-body"><ul>
<li>Head over to the database and try to split it so that it will follow above properties.</li>
</ul></div>

<div class="Expected_Outcome_card card-content-body"><p>You should be able to justify why this database will not be a good fit in terms of various purposes that are mentioned above. You should be able to understand what normalization is and why there is need to normalize.</p></div>

<div class="Time_to_normalize_our_database_card card-content-body"><p>Let's split our original table <code>students</code> into various usable and manageable tables. The tables are split in a manner such that data will remain consistent.</p><p><img alt="task_4_table_1" src="https://storage.googleapis.com/crio-content-container-assets/ME_ME_PROJECT_STUDENT_RESULT_MODULE_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_task_4_table_1.png" style="max-width:750px;"/></p><p><img alt="task_4_table_2" src="https://storage.googleapis.com/crio-content-container-assets/ME_ME_PROJECT_STUDENT_RESULT_MODULE_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_task_4_table_2.png" style="max-width:750px;"/></p><p><img alt="task_4_table_3" src="https://storage.googleapis.com/crio-content-container-assets/ME_ME_PROJECT_STUDENT_RESULT_MODULE_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_task_4_table_3.png" style="max-width:750px;"/></p><p><img alt="task_4_table_4" src="https://storage.googleapis.com/crio-content-container-assets/ME_ME_PROJECT_STUDENT_RESULT_MODULE_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_task_4_table_4.png" style="max-width:750px;"/></p><p><img alt="task_4_table_5" src="https://storage.googleapis.com/crio-content-container-assets/ME_ME_PROJECT_STUDENT_RESULT_MODULE_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_task_4_table_5.png" style="max-width:750px;"/></p></div>

Time to normalize our database

<div class="Requirements_card card-content-body"><ul>
<li>Go to MySQL from XAMPP server and create all these tables and corresponding attributes.</li>
<li>Delete the previous <code>students</code> table after updating the data according to the new tables.</li>
<li>Add other attributes in each table as your wish such as you can add <code>status</code> attribute in each table which can be a boolean variable storing 0/1 depending upon that particular entry is currently in work or not.</li>
</ul><div class="References"><h3>References</h3><ul>
<li><a href="https://www.guru99.com/dbms-keys.html" target="_blank">What is Keys in DBMS and its types</a></li>
<li><a href="https://youtu.be/S-JG1z6Bp3U" target="_blank">How to make an attribute foreign key using phpmyadmin</a></li>
<li><a href="https://www.w3schools.com/sql/sql_foreignkey.asp" target="_blank">How to make an attribute foreign key using MySQL code</a></li>
</ul></div><div class="Tip"><h3>Tip</h3><ul>
<li>You can go ahead and try your own database structure.</li>
</ul></div><div class="Note"><h3>Note</h3><ul>
<li>Don't forgot to make attributes in a table as a foreign key which are from other tables.</li>
<li>Primary keys are must to have in a table. Don't forget that too.</li>
</ul></div></div>

<div class="Bring_it_On!_card card-content-body"><ul>
<li>Try to fetch the result of a student now using this updated database structure.</li>
</ul></div>

<div class="Expected_Outcome_card card-content-body"><p>You should be able to make various tables for this database and its corresponding attributes.</p></div>

<div class="Let's_fetch_the_result_now!!_card card-content-body"><p>Now, as we have our new database structure, we definitely have to rewrite the SQL queries for student result fetching.
<br/>
<br/></p><p>Start from what your user will type at the front-end. We can safely assume that your user will know at least his/her Roll Id, Class Name and Section. But our user doesn't know that how the class name and section is stored in the database. Also, we as developers don't know that how users will type his/her class name and section because there are many possibilities.
<br/>
<br/></p><p>So, to make it clear for both the user and you, we should give them a drop-down menu of all the classes in our database. From which table of our database we will do it? Yes, you are right from <code>tblclasses</code> table. User will see his/her class name along with section and in return we will store the class id.
<br/>
<br/></p><p>Here's the code for your reference.</p><pre><code>&lt;select name="class" class="form-control" id="default" required="required"&gt;
&lt;option value=""&gt;Select Class&lt;/option&gt;
&lt;?php $sql = "SELECT * from tblclasses";
$query = $dbh-&gt;prepare($sql);
$query-&gt;execute();
$results=$query-&gt;fetchAll(PDO::FETCH_OBJ);
if($query-&gt;rowCount() &gt; 0) {
foreach($results as $result) { ?&gt;
&lt;option value="&lt;?php echo htmlentities($result-&gt;id); ?&gt;"&gt;&lt;?php echo htmlentities($result-&gt;ClassName); ?&gt;&amp;nbsp; Section-&lt;?php echo htmlentities($result-&gt;Section); ?&gt;
&lt;/option&gt;
&lt;?php }} ?&gt;
&lt;/select&gt;
</code></pre><p>Store the roll id and class id in some variables on the redirected page after user click submit.</p><pre><code>$rollid=$_POST['rollid'];
$classid=$_POST['class'];
$_SESSION['rollid']=$rollid;
$_SESSION['classid']=$classid;
</code></pre><p>Now, coming to the query part where we bind our above parameters and fetch student result. Result should at least contains his/her subject name (not subject id because user don't know about subject id at all), corresponding marks.
<br/>
<br/></p><p>Here's the query for the same.</p><pre><code>"select t.StudentName, t.RollId, t.ClassId, t.marks, SubjectId, tblsubjects.SubjectName from 
(select sts.StudentName, sts.RollId, sts.ClassId, tr.marks, SubjectId from 
tblstudents as sts join tblresult as tr on tr.StudentId=sts.StudentId) as t 
join tblsubjects on tblsubjects.id=t.SubjectId where (t.RollId=:rollid and t.ClassId=:classid)"
</code></pre></div>

Let's fetch the result now!!

<div class="Requirements_card card-content-body"><ul>
<li>Make required number of PHP files and add relevant code as per your understanding.</li>
<li>Design your web page as you like.</li>
<li>Perform above SQL queries to take input from user and then use it to fetch student result.</li>
</ul><div class="References"><h3>References</h3><ul>
<li><a href="https://www.geeksforgeeks.org/nested-queries-in-sql/" target="_blank">What is nested and complex queries in MySQL</a></li>
<li><a href="https://www.guru99.com/sub-queries.html" target="_blank">How nested or sub query works</a></li>
<li><a href="https://youtu.be/wR8LAOsUt0A" target="_blank">How to write nested queries</a></li>
</ul></div></div>

<div class="Bring_it_On!_card card-content-body"><ul>
<li>Go ahead and add another input parameter such as DOB so that one student can't see other's result without that knowledge.</li>
<li>Try to make result page more illustrative and attractive by adding school logo, student name, class name, total marks obtained, percentage, etc.</li>
</ul></div>

<div class="Expected_Outcome_card card-content-body"><p>You should be able to fetch and output student result accurately by taking input as per your willingness.</p></div>

<div class="It's_admin_time_now_card card-content-body"><p>As said earlier this project is divided into 3 parts:
<br/>
<br/></p><ul>
<li>[x] <strong>Result Section</strong> (front-end)</li>
<li>[x] <strong>Database</strong></li>
<li>[ ] <strong>Admin Section</strong> (back-end)
<br/>
<br/></li>
</ul><p>We settled up things for the front-end and database, it's time to move towards the back-end part.
<br/>
<br/></p><p>But is there any need to develop a back-end part separately? Why this is required?
<br/>
<br/></p><p>Till now we have been doing our back-end part with the database. But this is not looking convenient for adding, deleting and modifying data. That's why there is a need to make a separate back-end portal where we can add/update student details like class, subject, subject combination, result and other details through a proper UI.</p></div>

It's admin time now

<div class="Requirements_card card-content-body"><ul>
<li>Make a separate PHP file for this admin portal.</li>
<li>Design your page accordingly.</li>
<li>Make a sidebar menu for various options.</li>
<li>Make a dedicated page for each options.</li>
<li>Attach this sidebar to each of the page.</li>
<li>In the sidebar menu following options are must to have, rest you can add on your own interest -
<ol>
<li>Add and Update Class</li>
<li>Add and Update Students</li>
<li>Add and Update Subjects</li>
<li>Add and Update Subject Combinations</li>
<li>Add and Update Result</li>
</ol>
</li>
</ul><div class="References"><h3>References</h3><ul>
<li><a href="https://www.w3schools.com/howto/howto_css_fixed_sidebar.asp" target="_blank">How to create a fixed sidebar</a></li>
<li><a href="https://www.w3schools.com/howto/howto_css_sidebar_responsive.asp" target="_blank">How to create a responsive sidebar</a></li>
<li><a href="https://stackoverflow.com/questions/16543038/same-sidebar-across-webpages" target="_blank">How to display same sidebar on multiple pages</a></li>
</ul></div></div>

<div class="Bring_it_On!_card card-content-body"><ul>
<li>Go ahead and try to bind each of the options with the back-end with required database queries.</li>
</ul></div>

<div class="Expected_Outcome_card card-content-body"><p>The main motive of this milestone is to understand the concept behind making an admin portal. You should be able to design basic outline of the admin portal.</p></div>

<div class="Building_each_module_card card-content-body"><p>Let's try to build each module (renamed option to module).
<br/>
<br/></p><p>Here, I will explain 2 functionalities - add and update classes. Rest all are similar in nature just the SQL query changes.
<br/>
<br/></p><p><em>Add Class</em></p><ol>
<li>
<p>Make a form which takes all the input corresponding to each attribute in <code>tblclasses</code> table.</p>
</li>
<li>
<p>On submitting the form it should perform a MySQL insert query into the <code>tblclasses</code> of same database.</p>
</li>
<li>
<p>Your back-end code should resemble below code -</p>
<pre><code>$classname=$_POST['classname'];
$section=$_POST['section'];
$sql="INSERT INTO tblclasses(ClassName, Section) VALUES(:classname, :section)";
$query = $dbh-&gt;prepare($sql);
$query-&gt;bindParam(':classname', $classname, PDO::PARAM_STR);
$query-&gt;bindParam(':section', $section, PDO::PARAM_STR);
$query-&gt;execute();
$lastInsertId = $dbh-&gt;lastInsertId();
if($lastInsertId) {
$msg="Class Created successfully";
} else {
$error="Something went wrong. Please try again";
}
</code></pre>
</li>
</ol><p><em>Update Class</em></p><ol>
<li>
<p>Make a table which shows all the classes details such as serial number, class name, class section, etc. depending on your table structure.</p>
</li>
<li>
<p>Make an extra column for each row for editing that entry in the database, attach the class id with that value.</p>
</li>
<li>
<p>Print the existing details in form format for that class id to user using MySQL select command which user can change.</p>
</li>
<li>
<p>After submitting form, the back-end of that page should perform MySQL update query as follows -</p>
<pre><code>$classname=$_POST['classname'];
$section=$_POST['section'];
$cid=intval($_GET['classid']);
$sql="update tblclasses set ClassName=:classname, Section=:section where id=:cid";
$query = $dbh-&gt;prepare($sql);
$query-&gt;bindParam(':classname', $classname, PDO::PARAM_STR);
$query-&gt;bindParam(':section', $section, PDO::PARAM_STR);
$query-&gt;bindParam(':cid',$cid, PDO::PARAM_STR);
$query-&gt;execute();
$msg="Data has been updated successfully";
</code></pre>
</li>
</ol></div>

Building each module

<div class="Requirements_card card-content-body"><ul>
<li>Perform above mentioned steps for each module.</li>
<li>Test each module by cross checking it in <code>phpmyadmin</code> database server.</li>
</ul><div class="References"><h3>References</h3><ul>
<li><a href="https://www.w3schools.com/sql/sql_insert.asp" target="_blank">How to perform sql insert query</a></li>
<li><a href="https://www.w3schools.com/sql/sql_update.asp" target="_blank">How to perform sql update query</a></li>
</ul></div></div>

<div class="Bring_it_On!_card card-content-body"><ul>
<li>Try to make an <code>enable</code>/<code>disable</code> button in admin portal for taking DOB also as input during result checking by user.</li>
</ul></div>

<div class="Expected_Outcome_card card-content-body"><p>You should able to design, code and test each module using your admin portal and <code>phpmyadmin</code> database server.</p></div>

<div class="Securing_admin_section_card card-content-body"><p>Now, the need arises to secure this admin section. Why? Because otherwise students will change theirs and others results and details which in turn becomes a very serious issue.
<br/>
<br/></p><p>There are two ways to secure this admin section - first is to separate this portal completely with new location and project while the second is to make it password protected. First is not actually a full proof solution. Why? Because if anyone gets to know about this portal and its location then eventually the same problem still persists. So, we will go with the second approach.</p></div>

Securing admin section

<div class="Requirements_card card-content-body"><ul>
<li>
<p>Make a new table into database with attributes - <code>UserName</code> and <code>Password</code>.</p>
</li>
<li>
<p>Fill these values depending on the administrative team.</p>
</li>
<li>
<p>Make a form which accepts user name and password as an input and in turns verifies from this table data.</p>
</li>
<li>
<p>If the entries filled are correct then store these values in the session for future reference and land him to the actual admin section.</p>
<pre><code>$uname=$_POST['username'];
$password=md5($_POST['password']);
$sql ="SELECT UserName, Password FROM admin WHERE UserName=:uname and Password=:password";
$query= $dbh -&gt; prepare($sql);
$query-&gt; bindParam(':uname', $uname, PDO::PARAM_STR);
$query-&gt; bindParam(':password', $password, PDO::PARAM_STR);
$query-&gt; execute();
$results=$query-&gt;fetchAll(PDO::FETCH_OBJ);
if($query-&gt;rowCount() &gt; 0) {
$_SESSION['alogin']=$_POST['username'];
echo "&lt;script type='text/javascript'&gt; document.location = 'dashboard.php'; &lt;/script&gt;";
} else {
echo "&lt;script&gt;alert('Invalid Details');&lt;/script&gt;";
}
</code></pre>
</li>
</ul><div class="References"><h3>References</h3><ul>
<li><a href="https://phppot.com/php/user-authentication-using-php-and-mysql/#:%7E:text=In%20PHP%20code%2C%20it%20executes,to%20enter%20into%20the%20application." target="_blank">How to make a login system using PHP and MySQL</a></li>
<li><a href="https://www.informit.com/articles/article.aspx?p=31690" target="_blank">Understand different methods of authentication in PHP</a></li>
</ul></div><div class="Note"><h3>Note</h3><ul>
<li>Password is stored in an encrypted format i.e. MD5.</li>
<li>Try to understand it why it is required and how to do it.</li>
</ul></div></div>

<div class="Bring_it_On!_card card-content-body"><ul>
<li>Check session is expired or not at each page which contains some serious information or which can affect some serious information.</li>
<li>If session expires then redirect him to the login page again.</li>
</ul></div>

<div class="Expected_Outcome_card card-content-body"><p>The main motive of this milestone is to make admin section secure. You should be able to authenticate the person before sending him to the admin section.</p></div>

<div class="End_Game_card card-content-body"><p>Now, we are at the end stage of this project. We will try to put all things together and test it. Additionally you will learn how to generate PDF with required content so that one can download and share it wherever he/she wants.</p></div>

End Game

<div class="Requirements_card card-content-body"><ul>
<li>Make a homepage, design it with school logo, vision, faculty information, contact details.</li>
<li>With that make 2 more sections - result and admin.</li>
<li>On clicking result section, it should redirect it to result page which will ask user to fill his/her details and get the result.</li>
<li>On clicking admin section, it should redirect it to admin authentication page which asks for username and password. On successful verification, it should redirect the user to the admin portal where students details can be added and modified.</li>
<li>Make a logout button as well inside admin portal. Upon clicking, it should delete current session details and ask for re-login.</li>
<li>For the <em>PDF</em> thing, refer to the references.</li>
</ul><div class="References"><h3>References</h3><ul>
<li><a href="https://www.geeksforgeeks.org/php-fpdf-pdf-generator/" target="_blank">How to generate PDF from PHP code</a></li>
<li><a href="http://www.fpdf.org/" target="_blank">FPDF official website for download and documentation purpose</a></li>
</ul></div><div class="Note"><h3>Note</h3><ul>
<li>You can use other PDF generator methods as well.</li>
<li>I used PHP throughout this project, you can adjust according to your preferred back-end language.</li>
</ul></div></div>

<div class="Bring_it_On!_card card-content-body"><ul>
<li>Host this project publicly, share it with your friends and school/college.</li>
<li>Try to add 2 factor authentication using SMS or Mail for admin verification purpose.</li>
<li>Try to add more functionalities in this project.</li>
<li>Go ahead and make other types of management system using similar logic and structure.</li>
</ul></div>

<div class="Expected_Outcome_card card-content-body"><p>The main motive of this milestone is to make every cluster club together and test it's functionalities.</p></div>

CONTAINER_REGULAR_TASK_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_TASK_1

CONTAINER_REGULAR_TASK_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_TASK_2

CONTAINER_REGULAR_TASK_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_TASK_3

CONTAINER_REGULAR_TASK_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_TASK_4

CONTAINER_REGULAR_TASK_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_TASK_5

CONTAINER_REGULAR_TASK_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_TASK_6

CONTAINER_REGULAR_TASK_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_TASK_7

CONTAINER_REGULAR_TASK_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_TASK_8

CONTAINER_REGULAR_TASK_ME_PROJECT_STUDENT_RESULT_MODULE_STUDENT_RESULT_TASK_9

Realtime Video Processing using ChromaKey (GreenScreen) Effect

Companion App: A mental health tracker built using Flutter and Firebase.

Exploratory Analysis of Geolocational Data

Learn to create apps on Kubernetes - for beginners.

OurApp - a social media web app in NodeJS