This php crud application will teach you how to do basic database functions that are CREATE RETIEVE UPDATE and DELETE. using Mysql Database. The INSERT, SELECT, UPDATE and DELETE statements can be used in any database system, because this is support by all relational database systems.
we will do the php best practice for understand php programming clearly and easily.
we have to create the following pages.
<?php
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"dbcrud");
?> $connection = mysqli_connect(“localhost”,”root”,””);
this line explains how to connect with mysql and php
$db = mysqli_select_db($connection,”dbcrud”);
this line explains to select database
index.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Student Crud Application</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-9">
<div class="card">
<div class="card-header">
<h1> Student Crud Application </h1>
</div>
<div class="card-body">
<button class="btn btn-success"> <a href="add.php" class="text-light"> Add New </a> </button>
<br/>
<br/>
<table class="table">
<thead>
<tr>
<th scope="col">#</th>
<th scope="col">Name</th>
<th scope="col">Address</th>
<th scope="col">Mobile</th>
<th scope="col">Option</th>
</tr>
</thead>
<tbody>
<?php
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"dbcrud");
$sql = "select * from student";
$run = mysqli_query($connection, $sql);
$id= 1;
while($row = mysqli_fetch_array($run))
{
$uid = $row['id'];
$name = $row['name'];
$address = $row['address'];
$mobile = $row['mobile'];
?>
<tr>
<td><?php echo $id ?></td>
<td><?php echo $name ?></td>
<td><?php echo $address ?></td>
<td><?php echo $mobile ?></td>
<td>
<button class="btn btn-success"> <a href='edit.php?edit=<?php echo $uid ?>' class="text-light"> Edit </a> </button>
<button class="btn btn-danger"><a href='delete.php?del=<?php echo $uid ?>' class="text-light"> Delete </a> </button>
</td>
</tr>
<?php $id++; } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</body>
</html> Add the records into the database
add.php
<?php
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"dbcrud");
if(isset($_POST['submit']))
{
$name = $_POST['name'];
$address = $_POST['address'];
$mobile = $_POST['mobile'];
$sql = "insert into student(name,address,mobile)values(' $name',' $address',' $mobile')";
if(mysqli_query($connection,$sql))
{
echo '<script> location.replace("index.php")</script>';
}
else
{
echo "Some thing Error" . $connection->error;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Student Crud Application</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-9">
<div class="card">
<div class="card-header">
<h1> Student Crud Application </h1>
</div>
<div class="card-body">
<form action="add.php" method="post">
<div class="form-group">
<label>Name</label>
<input type="text" name="name" class="form-control" placeholder="Enter Name">
</div>
<div class="form-group">
<label>Address</label>
<input type="text" name="address" class="form-control" placeholder="Enter Address">
</div>
<div class="form-group">
<label>Mobile</label>
<input type="text" name ="mobile" class="form-control" placeholder="Enter Mobile">
</div>
<br/>
<input type="submit" class="btn btn-primary" name="submit" value="Register">
</form>
</div>
</div>
</div>
</div>
</div>
</body>
</html> edit.php
<?php
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"dbcrud");
$edit = $_GET['edit'];
$sql = "select * from student where id = '$edit'";
$run = mysqli_query($connection,$sql);
while($row=mysqli_fetch_array($run))
{
$uid = $row['id'];
$name = $row['name'];
$address = $row['address'];
$mobile = $row['mobile'];
}
?>
<?php
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"dbcrud");
if(isset($_POST['submit']))
{
$edit = $_GET['edit'];
$name = $_POST['name'];
$address = $_POST['address'];
$mobile = $_POST['mobile'];
$sql = "update student set name= '$name',address= '$address',mobile='$mobile' where id = '$edit'";
if(mysqli_query($connection,$sql))
{
echo '<script> location.replace("index.php")</script>';
}
else
{
echo "Some thing Error" . $connection->error;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Student Crud Application</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-9">
<div class="card">
<div class="card-header">
<h1> Student Crud Application </h1>
</div>
<div class="card-body">
<form action="add.php" method="post">
<div class="form-group">
<label>Name</label>
<input type="text" name="name" class="form-control" placeholder="Enter Name" value="<?php echo $name; ?>">
</div>
<div class="form-group">
<label>Address</label>
<input type="text" name="address" class="form-control" placeholder="Enter Address" value="<?php echo $address ?>">
</div>
<div class="form-group">
<label>Mobile</label>
<input type="text" name ="mobile" class="form-control" placeholder="Enter Mobile" value="<?php echo $mobile ?>">
</div>
<br/>
<input type="submit" class="btn btn-primary" name="submit" value="Edit">
</form>
</div>
</div>
</div>
</div>
</div>
</body>
</html> delete.php
<?php
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"dbcrud");
$delete = $_GET['del'];
$sql = "delete from student where id = '$delete'";
if(mysqli_query($connection,$sql))
{
echo '<script> location.replace("index.php")</script>';
}
else
{
echo "Some thing Error" . $connection->error;
}
?>
i have attached the video link below. which will do this tutorials step by step.
Introduction In this section, we will guide you step by step in the development of an image upload registration system in Java using MySQL and JDBC. In the application, users register…
The Touchable Shop POS (Point of Sale) system is a sophisticated software solution developed using…
Creating a responsive login form is a crucial skill for any web developer. In this…
In this tutorial will teach Laravel 12 CRUD API by step. Laravel 10 CRUD Application …
In this lesson we talk about laravel 12 image uploading and display the image step…
In this tutorial will teach Laravel 12 CRUD Application step by step. Laravel 12 CRUD…