Student CRUD

Create Student

<!DOCTYPE html>
<html>
<head>
	<title>Add Student</title>
	<style>
		label, input {
			display: block;
			margin-bottom: 10px;
		}
	</style>
</head>
<body>
	<h1>Add Student</h1>
	<form method="post" action="add_student.php">
		<label>Name:</label>
		<input type="text" name="name" required>

		<label>Email:</label>
		<input type="email" name="email" required>

		<label>Phone:</label>
		<input type="tel" name="phone" required>

		<label>Address:</label>
		<textarea name="address"></textarea>

		<input type="submit" value="Add Student">
	</form>
</body>
</html>

<?php
// Include the database connection file
require_once 'db_connect.php';

// Get the form data
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$address = $_POST['address'];

// Prepare the SQL statement
$sql = "INSERT INTO students (name, email, phone, address) VALUES (?, ?, ?, ?)";

// Bind the parameters and execute the statement
$stmt = $conn->prepare($sql);
$stmt->bind_param("ssss", $name, $email, $phone, $address);
$stmt->execute();

// Redirect back to the form
header("Location: add_student_form.php");
exit;
?>

Display Students

<!DOCTYPE html>
<html>
<head>
	<title>View Students</title>
	<style>
		table {
			border-collapse: collapse;
			width: 100%;
		}
		th, td {
			padding: 8px;
			text-align: left;
			border-bottom: 1px solid #ddd;
		}
	</style>
</head>
<body>
	<h1>View Students</h1>
	<table>
		<thead>
			<tr>
				<th>Name</th>
				<th>Email</th>
				<th>Phone</th>
				<th>Action</th>
			</tr>
		</thead>
		<tbody>
			<?php
			// Include the database connection file
			require_once 'db_connect.php';

			// Prepare the SQL statement
			$sql = "SELECT * FROM students ORDER BY id DESC";
			$result = $conn->query($sql);

			// Loop through the result and output the data
			while ($row = $result->fetch_assoc()) {
				echo "<tr>";
				echo "<td>" . $row['name'] . "</td>";
				echo "<td>" . $row['email'] . "</td>";
				echo "<td>" . $row['phone'] . "</td>";
				echo "<td>";
				echo "<a href='edit_student_form.php?id=" . $row['id'] . "'>Edit</a> ";
				echo "<a href='delete_student.php?id=" . $row['id'] . "' onclick='return confirm(\"Are you sure?\")'>Delete</a>";
				echo "</td>";
				echo "</tr>";
			}

			// Close the database connection
			$conn->close();
			?>
		</tbody>
	</table>
</body>
</html>

Edit Student

<!-- edit_student_form.php -->
<!DOCTYPE html>
<html>
<head>
	<title>Edit Student Form</title>
	<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
	<h1>Edit Student</h1>
	<?php
	  // Retrieve the ID from the URL parameter
	  $id = $_GET['id'];
	  // Connect to the database
	  require_once 'db_connect.php';
	  // Check connection
	  if (!$conn) {
	    die("Connection failed: " . mysqli_connect_error());
	  }
	  // Query to retrieve the row with the specified ID from the 'users' table
	  $sql = "SELECT * FROM students WHERE id=$id";
	  $result = mysqli_query($conn, $sql);
	  // Fetch the row as an associative array
	  $row = mysqli_fetch_assoc($result);
	  // Close the database connection
	  mysqli_close($conn);
	  ?>

	<form method="POST" action="edit_student.php">
		<input type="hidden" name="id" value="<?php echo $id; ?>">
		<label for="name">Name:</label>
		<input type="text" name="name" value="<?php echo $row["name"]; ?>">

		<label for="email">Email:</label>
		<input type="email" name="email" value="<?php echo $row["email"]; ?>">

		<label for="phone">Phone:</label>
		<input type="tel" name="phone" value="<?php echo $row["phone"]; ?>">

		<label for="address">Address:</label>
		<textarea name="address"><?php echo $row["address"]; ?></textarea>

		<input type="submit" name="submit" value="Update Student">
	</form>

	<a href="view_students.php">Back to List</a>
</body>
</html>

<?php 
	// Include the database connection file
	require_once 'db_connect.php';

	// Get the form data
	$id = $_POST['id'];
	$name = $_POST['name'];
	$email = $_POST['email'];
	$phone = $_POST['phone'];
	$address = $_POST['address'];
	// Update the student record in the database
	$sql = "UPDATE students SET name='$name', email='$email', phone='$phone', address='$address' WHERE id=$id";
	if (mysqli_query($conn, $sql)) {
	    echo "Student record updated successfully!";
	} else {
	    echo "Error updating student record: " . mysqli_error($conn);
	}

Previousworkflow NextCRUD code for subjects

Last updated 2 years ago