Php Crud operation with html bootstrap and mysql
In this blog we will discuss about php crud operation using php crud operation with html bootstrap and mysql database.In this tutorials we will complete details knowledge about the php operation with mysql.
We will create data in database using php and Update data in database using php and read data from database using php and delete data from database.
Dashboard
.png "Php Crud operation with html bootstrap and mysql") |
| Php Crud operation with html bootstrap and mysql |
.png "Php Crud operation with html bootstrap and mysql") |
| Php Crud operation with html bootstrap and mysql |
Database Image of Tables
 |
| Php Crud operation with html bootstrap and mysql |
Connection.php
<?php
/* Database credentials. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "crudoperation";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
Create.php
<?php
require_once "connection.php";
if(isset($_POST['save']))
{
$name = $_POST['name'];
$email = $_POST['email'];
$number = $_POST['mobile'];
$sql = "INSERT INTO record (id,name,email,number1)
VALUES ('', '$name', '$email' ,'$number')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Create Record</title>
<?php include "head.php"; ?>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-lg-12">
<div class="page-header">
<h2>Create Record</h2>
</div>
<p>Please fill this form and submit to add employee record to the database.</p>
<form action="create.php" method="post">
<div class="form-group">
<label>Name</label>
<input type="text" name="name" class="form-control" value="" maxlength="50" required="">
</div>
<div class="form-group ">
<label>Email</label>
<input type="email" name="email" class="form-control" value="" maxlength="30" required="">
</div>
<div class="form-group">
<label>Mobile</label>
<input type="mobile" name="mobile" class="form-control" value="" maxlength="12" required="">
</div>
<input type="submit" class="btn btn-primary" name="save" value="submit">
<a href="index.php" class="btn btn-default">Cancel</a>
</form>
</div>
</div>
</div>
</body>
</html>Delete
<?php
include_once 'connection.php';
$sql = "DELETE FROM record WHERE id='" . $_GET["id"] . "'";
if (mysqli_query($conn, $sql)) {
header("location: index.php");
exit();
} else {
echo "Error deleting record: " . mysqli_error($conn);
}
mysqli_close($conn);
?>head.php
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.js"></script>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Retrieve Or Fetch Data From MySQL Database Using PHP With Boostrap</title>
<?php include "head.php";
include "connection.php"
?>
<script type="text/javascript">
$(document).ready(function(){
$('[data-toggle="tooltip"]').tooltip();
});
</script>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-lg-12 mx-auto">
<div class="page-header clearfix">
<h2 class="pull-left">Users List</h2>
<a href="create.php" class="btn btn-success pull-right">Add New User</a>
</div>
<table class='table table-bordered table-striped'>
<tr>
<td>Name</td>
<td>Email id</td>
<td>Mobile</td>
<td>Action</td>
</tr>
<?php
$sql = "SELECT * FROM record";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
?>
<tr>
<td><?php echo $row["name"]; ?></td>
<td><?php echo $row["email"]; ?></td>
<td><?php echo $row["number1"]; ?></td>
<td><a href="update.php?id=<?php echo $row["id"]; ?>" title='Update Record'><span class='glyphicon glyphicon-pencil'></span></a>
<a href="delete.php?id=<?php echo $row["id"]; ?>" title='Delete Record'><i class='material-icons'><span class='glyphicon glyphicon-trash'></span></a>
</td>
</tr>
<?php
}
} else {
echo "0 results";
}
?>
</table>
</div>
</div>
</div>
</body>
</html>Update.php
<?php
// Include database connection file
require_once "connection.php";
if(isset($_POST['update']))
{
$name = $_POST['name'];
$email = $_POST['email'];
$mobile = $_POST['mobile'];
$id = $_POST['id'];
$sql = "UPDATE record SET name='$name', email = '$email' ,number1='$mobile' WHERE id='$id'";
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
}
if (isset($_GET['id'])) {
$id = $_GET['id'];
echo $id;
$sql = "SELECT * FROM record WHERE id='$id'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$id =$row['id'];
$name = $row['name'];
$email = $row['email'];
$number = $row['number1'];
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Update Record</title>
<?php include "head.php"; ?>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-lg-12">
<div class="page-header">
<h2>Update Record</h2>
</div>
<p>Please edit the input values and submit to update the record.</p>
<form action="update.php" method="post">
<div class="form-group">
<label>Name</label>
<input type="text" name="name" class="form-control" value="<?php echo $name; ?>" maxlength="50" required="">
</div>
<div class="form-group ">
<label>Email</label>
<input type="email" name="email" class="form-control" value="<?php echo $email; ?>" maxlength="30" required="">
</div>
<div class="form-group">
<label>Mobile</label>
<input type="mobile" name="mobile" class="form-control" value="<?php echo $number; ?>" maxlength="12"required="">
</div>
<input type="hidden" name="id" value="<?php echo $id; ?>"/>
<input type="submit" class="btn btn-primary" value="Submit" name="update">
<a href="index.php" class="btn btn-default">Cancel</a>
</form>
</div>
</div>
</div>
</body>
</html>I hope You really enjoyed this blog . I try my best to make every thing is easy and helpfull to provide to public .You will get more blog about the Programing project and code . Thanks for visiting my blog if you have any querry related to this you can comment here i will try my best to response you back
.png&description=Php Crud operation with html bootstrap and mysql ){kind=link}
0 Comments