PHP CURD BOOTSTRAP
<!DOCTYPE html>
<html>
<head>
<title>CRUD Operations</title>
<!-- Add Bootstrap CSS -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.4.1/dist/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
</head>
<body>
<div class="container">
<h2>Create User</h2>
<form action="" method="post">
<div class="form-group">
<label for="create-name">Name:</label>
<input type="text" class="form-control" id="create-name" name="name">
</div>
<div class="form-group">
<label for="create-email">Email:</label>
<input type="email" class="form-control" id="create-email" name="email">
</div>
<div class="form-group">
<label for="create-password">Password:</label>
<input type="password" class="form-control" id="create-password" name="password">
</div>
<button type="submit" class="btn btn-primary" name="create">Create</button>
</form>
<hr>
<h2>Update User</h2>
<form action="" method="post">
<div class="form-group">
<label for="update-id">User ID:</label>
<input type="text" class="form-control" id="update-id" name="id">
</div>
<div class="form-group">
<label for="update-name">New Name:</label>
<input type="text" class="form-control" id="update-name" name="name">
</div>
<div class="form-group">
<label for="update-email">New Email:</label>
<input type="email" class="form-control" id="update-email" name="email">
</div>
<button type="submit" class="btn btn-primary" name="update">Update</button>
</form>
<hr>
<h2>Delete User</h2>
<form action="" method="post">
<div class="form-group">
<label for="delete-id">User ID:</label>
<input type="text" class="form-control" id="delete-id" name="id">
</div>
<button type="submit" class="btn btn-danger" name="delete">Delete</button>
</form>
<hr>
<h2>Select Users</h2>
<table class="table">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
</tr>
</thead>
<tbody>
<?php
// Your PHP code for database operations here...
$conn = new mysqli("localhost", "root", "", "USER_DATABASE");
if (isset($_POST["create"])) {
$name = $_POST['name'];
$email = $_POST['email'];
$password = $_POST['password'];
$sql = "INSERT into TABLE_NAME(name, email,password) values ('$name','$email','$password')";
if (mysqli_query($conn, $sql)) {
echo "created";
} else {
echo "not";
}
}
if (isset($_POST['update'])) {
$id = $_POST['id'];
$Name = $_POST['name'];
$email = $_POST['email'];
$querry = "UPDATE TABLE_NAME set name='$Name',email='$email' where id='$id'";
if (mysqli_query($conn, $querry)) {
echo "updated";
} else {
echo "Not Updated";
}
}
if (isset($_POST['delete'])) {
$id = $_POST['id'];
$querry = "DELETE from ad where id='$id'";
if (mysqli_query($conn, $querry)) {
echo "deleted";
} else {
echo "not Delete";
}
}
$select = "SELECT * from TABLE_NAME";
$action = mysqli_query($conn, $select);
while ($row = mysqli_fetch_assoc($action)) {
echo "<tr><td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['email']}</td></tr>";
}
?>
</tbody>
</table>
</div>
<!-- Add Bootstrap JavaScript (jQuery and Popper.js required) -->
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
</body>
</html>
Comments
Post a Comment