Web based application
development with PHP
2021-22
TODO List
Submitted by
Bharat Tatya Khalate
Guided By: Priynka chanapattan
CERTIFICATE
MAHARASHTRASTATEBOARDOFTECHNICAL
EDUCATION, MUMBAI
GOVERNMENT POLYTECHNIC, SOLAPUR.
This is to certify that Bharat Khalate Roll no 86 Of 6th Semester
of Diploma in Computer Technology has satisfactory completed
Report Work in this subject Web Based Application Development
With PHP under the guidance of Ms. Priynka chanapattan the
academic year 2021-2022 as prescribed in the curriculum.
Place: Enrollmentno:1900150332
Date: Exam seat no:
Subject teacher. HOD. Principal
2
Acknowledgement
We wish to express our profound and sincere gratitude to our guide, who Priynka
chanapattan guided us in the structure of micro project as well as some main points
in that micro project also they cleared our all doubts about micro project. We are
Indebted to his constant encouragement, co-operation and help. It was his enthusiastic
support that helped us in overcoming various obstacles in the project.
We would also like to express our thankfulness to our beloved Principal as well as
HOD and other faculty members of our Second-year department for extending their
support and motivation
Finally, we completed our micro project that regarding to our syllabus as well as
department, once more thanks for all Group members, Respected Priynka
chanapattan, Principal, HOD and other Faculty Members who helped us in the micro
project completion.
Thank You...!!!
3
PART A – Micro-Project Proposal
1.0 Brief Introduction
In this Micro-Project we are going to make A
.
2.0 Aim of the Micro-Project (in about 1 to 2 Sentences)
The aim of this project to develop programming skill and make Micro-Project for
PHP
3.0 Intended Course Outcomes
a. Develop Programs using PHP .
b. Develop programs using database connectivity ,PHP embedded in html
4.0 Literature Review
We searched information for the suggested topic by our project guide.
Collected the data required for the micro –project
5.0 Proposed Methodology
1. First searched information for the suggested micro-project.
2. Collected information for the suggested topic.
3. Started for the micro-project.
4. Completed micro-project.
5. Showed to respected teacher.
6. Teacher suggested some changes.
7. Done the changes into the project as told by teacher.
6.0 Resources Required.
4
S. No. Name of Specifications Qty Remarks
Resource/material
1 Computer System Intel core2duo Processor 4th 1 -
gen
2 GB RAM ,160GB HDD
2 Notepad Version 1909 1 -
7.0 Action Plan
Sr. Details of activity Name of responsible
no team member
1 Topic selection
2 Information Collection
related to the topic
3 System Designing
1. Ganesh Kokate
4 Data collection for the
project
7 Testing
8 Error/Defect handling
10 Project report forming
Index
5
Sr.no Topic
1 Information about project
2 AIM
3 Advantages
4 Course Outcomes
5 Literature Review
6 Actual Methodology
7 Resources
8 Source Code
9 Outputs
10 Skill Developed
11 Application
12 Area of Future
11 Conclusion & Reference website
Information about project
6
This Micro-Project is based on Todo list which gives special platform to
new programmer to understand programming through different PHP program
In this micro project the to-do list is very interesting. In to-do we add work, delete
work, edit or update work.
AIM
The aim of this Micro Project is manage shedual of the user it is easy to use
And Manage Daily rutine of user.
.
Advantages
This to-do list is simple to use
You can add delete and edit or update the List
Add button for adding work in to do list
Add button for adding work in to do list
Delete button for deleting work from to do list
Edit button for edit or update List
You can see ID of the work
Course Outcomes
7
Develop website using concept of database connectivity
Develop Programs using PHP
Literature Review
In This Micro-Project we created a to-do list .We made this Micro-Project Using core
PHP Language. This Micro Project contains limited features but the essential one. The User
can get to know about the source code whichever he need.
Actual Methodology
Collected information for the suggested topic.
Started the Micro-project.
Completed Micro-project.
Showed to respected teacher.
Submitted the Micro-project.
8
Resources
1. Software-🆚 code
2. Software-Notepad ,browser
3. Windows 10
4. YouTube: Some programming
Source Code
Data.php
<?php
$title=$_POST['title'];
// echo "Name Is".$name ."Phone Number:".$phone;
include 'database.php';
$sql="INSERT INTO todos(title)VALUES('$title')";
$result=mysqli_query($conn, $sql);
if($result){
header("location: ./index.php");
}
else{
// echo "Sorry We Can't Connect";
}
Database.php
9
<?php
$host="localhost";
$user="root";
$pass="";
$dbname="todos";
$conn=mysqli_connect($host, $user, $pass, $dbname);
?>
delete.php
<?php
include 'database.php';
$id=$_GET['id'];
$sql="DELETE FROM todos WHERE id=$id";
$result=mysqli_query($conn, $sql);
if($result){
header("location: ./index.php");
}
?>
edit.php
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Bootstrap CSS -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/
bootstrap.min.css" rel="stylesheet"
integrity="sha384-
giJF6kkoqNQ00vy+HMDP7azOuL0xtbfIcaT9wjKHr8RbDVddVHyTfAAsrekwKmP1"
crossorigin="anonymous">
<title>ToDo'S List App!</title>
</head>
<body>
<h1 class="text-center py-4 my-4">Update Yout ToDo'S List</h1>
<?php
include 'database.php';
10
$id=$_GET['id'];
$sql="SELECT * FROM todos WHERE id=".$id;
$result = mysqli_query($conn, $sql);
if($result){
$row=mysqli_fetch_assoc($result);
$title=$row['Title'];
?>
<div class="w-50 m-auto">
<form action="editaction.php" method="post" autocomplete="off">
<div class="form-group">
<label for="title">Title</label>
<input class="form-control" type="text" name="title" id="title" value="<?php
global $title; echo $title ?>" placeholder="Edit Here Your ToDo'S"
Required>
<input type="hidden" name="id" id="id" value="<?php echo $id ?>">
</div><br>
<button class="btn btn-success">Update ToDo'S</button>
</form>
</div>
<!-- Optional JavaScript; choose one of the two! -->
<!-- Option 1: Bootstrap Bundle with Popper -->
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.bundle.min
.js"
integrity="sha384-ygbV9kiqUc6oa4msXn9868pTtWMgiQaeYH7/t7LECLbyPA2x65Kgf80OJFdroafW"
crossorigin="anonymous"></script>
<!-- Option 2: Separate Popper and Bootstrap JS -->
<!--
<script
src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"
integrity="sha384-q2kxQ16AaE6UbzuKqyBE9/u/KzioAlnx2maXQHiDX9d4/zp8Ok3f+M7DPm+Ib6IU"
crossorigin="anonymous"></script>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.min.js"
integrity="sha384-pQQkAEnwaBkjpqZ8RU1fF1AKtTcHJwFl3pblpTlHXybJjHpMYo79HY3hIi4NKxyj"
crossorigin="anonymous"></script>
-->
</body>
</html>
11
Editaction.php
<?php
$id=$_POST['id'];
$title=$_POST['title'];
include 'database.php';
$sql="UPDATE todos SET title='$title' WHERE id=$id";
$result=mysqli_query($conn, $sql);
if($result){
header("location: ./index.php");
?>
Index.php
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Bootstrap CSS -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/
bootstrap.min.css" rel="stylesheet" integrity="sha384-
giJF6kkoqNQ00vy+HMDP7azOuL0xtbfIcaT9wjKHr8RbDVddVHyTfAAsrekwKmP1"
crossorigin="anonymous">
<title>ToDo'S List App!</title>
</head>
<body>
<h1 class="text-center py-4 my-4">ToDo'S List</h1>
<div class="w-50 m-auto">
<form action="data.php" method="post" autocomplete="off">
<div class="form-group">
<label for="title">Title</label>
<input class="form-control" type="text" name="title" id="title"
placeholder="Type Here To Add On ToDo'S" Required>
</div><br>
<button class="btn btn-success">Add To ToDo'S</button>
12
</form>
</div><br>
<hr class="bg-dark w-50 m-auto">
<div class="lists w-50 m-auto my-4">
<h1>Your Lists</h1>
<div id="lists">
<table class="table table-dark table-hover">
<thead>
<tr>
<th scope="col" name="id">S.no</th>
<th scope="col">ToDo List</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
include 'database.php';
$sql="SELECT * FROM todos";
$result=mysqli_query($conn, $sql);
if($result){
while($row=mysqli_fetch_assoc($result)){
$id=$row['id'];
$title=$row['Title'];
?>
<tr>
<td><?php echo $id ?></td>
<td><?php echo $title ?></td>
<td>
<a class="btn btn-success btn-sm" href="edit.php?id=<?php echo
$id ?>" role="button">Edit</a>
<a class="btn btn-danger btn-sm" href="delete.php?id=<?php echo
$id ?>" role="button">Delete</a>
</td>
</tr>
<?php
}
}
?>
13
</tbody>
</table>
</div>
</div>
<!-- Optional JavaScript; choose one of the two! -->
<!-- Option 1: Bootstrap Bundle with Popper -->
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.bundle.min
.js"
integrity="sha384-ygbV9kiqUc6oa4msXn9868pTtWMgiQaeYH7/t7LECLbyPA2x65Kgf80OJFdroafW"
crossorigin="anonymous"></script>
<!-- Option 2: Separate Popper and Bootstrap JS -->
<!--
<script
src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"
integrity="sha384-q2kxQ16AaE6UbzuKqyBE9/u/KzioAlnx2maXQHiDX9d4/zp8Ok3f+M7DPm+Ib6IU"
crossorigin="anonymous"></script>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.min.js"
integrity="sha384-pQQkAEnwaBkjpqZ8RU1fF1AKtTcHJwFl3pblpTlHXybJjHpMYo79HY3hIi4NKxyj"
crossorigin="anonymous"></script>
-->
</body>
</html>
14
Skill Developed
WE learnt how to make TO-do list using html,css,PHP
WE learnt how to use compile & Run php code
WE learnt new programs concept in php
WE learnt Database connectivity in PHP
Application
The applications are as pre follows:-
This project helps to show your remaining works
You can manage your daily rutine
Area of future
We will add new function to reminder for any work.
15
Faults will be removed if found any.
As soon as possible we try to create this Programming vaccination management
system more efficient as simple to use
We will add more functinalites.
Conclusion
Hence from this Micro-Project we Learnt about how to write and compile program
And from this project we learnt different types of programming and their use in html
CSS PHP .
Reference
Srno. Reference Remark
1 tutorialspoint.com Website
2 YouTube: Some coding and programming YouTube
3 Different music player Nirali,Techmax Pub.
16
