*************

PHP code: Copy Format Clear

<?php // Step 1: Connect to the database // Assuming $mysqli is predefined // Step 2: Handle form submission to insert data if ($_SERVER["REQUEST_METHOD"] == "POST") { $first_name = $_POST['first_name']; $last_name = $_POST['last_name']; $email = $_POST['email']; $stmt = $mysqli->prepare("INSERT INTO students (first_name, last_name, email) VALUES (?, ?, ?)"); $stmt->bind_param("sss", $first_name, $last_name, $email); $stmt->execute(); $stmt->close(); } // Step 3: Retrieve student data from the database $result = $mysqli->query("SELECT id, first_name, last_name, email FROM students"); ?> <!DOCTYPE html> <html> <head> <title>University Student Management</title> </head> <body> <h1>Student Management</h1>  <form method="POST"> <label>First Name:</label> <input type="text" name="first_name" required><br><br> <label>Last Name:</label> <input type="text" name="last_name" required><br><br> <label>Email:</label> <input type="email" name="email" required><br><br> <button type="submit">Add Student</button> </form>  <h2>Student List</h2> <table border="1"> <tr> <th>ID</th> <th>First Name</th> <th>Last Name</th> <th>Email</th> </tr> <?php // Display all student records while ($row = $result->fetch_assoc()) { echo "<tr>"; echo "<td>" . htmlspecialchars($row['id']) . "</td>"; echo "<td>" . htmlspecialchars($row['first_name']) . "</td>"; echo "<td>" . htmlspecialchars($row['last_name']) . "</td>"; echo "<td>" . htmlspecialchars($row['email']) . "</td>"; echo "</tr>"; } $result->free(); ?> </table> </body> </html>

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online