Q. 1) Create employee table as follows EMP (eno, ename, designation, salary). Write Ajax program to
select the employees name and print the selected employee’s details. [Marks 15]
CREATE TABLE EMP (
eno INT PRIMARY KEY,
ename VARCHAR(255),
designation VARCHAR(255),
salary DECIMAL(10, 2)
);
INSERT INTO EMP (eno, ename, designation, salary) VALUES
(1, 'John Doe', 'Manager', 50000.00),
(2, 'Jane Smith', 'Developer', 40000.00),
(3, 'Alice Johnson', 'Designer', 45000.00),
(4, 'Bob Williams', 'Tester', 38000.00),
(5, 'Eve Brown', 'Analyst', 48000.00);

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Employee Details</title> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script> $(document).ready(function(){ $("#employeeName").change(function(){ var ename = $(this).val(); $.ajax({ url: 'get_employee_details.php', method: 'POST', data: {ename: ename}, success: function(response) { $("#employeeDetails").html(response); } }); }); }); </script> </head> <body> <h2>Select Employee:</h2> <select id="employeeName"> <option value="">Select Employee</option> <?php // Fetch employee names from the database and populate the dropdown $conn = mysqli_connect("localhost", "username", "password", "database"); if ($conn) { $sql = "SELECT ename FROM EMP"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { echo "<option value='{$row['ename']}'>{$row['ename']}</option>"; } } mysqli_close($conn); } ?> </select> <div id="employeeDetails"></div> </body> </html> <?php $ename = $_POST['ename'];

// Fetch employee details from the database
$conn = mysqli_connect("localhost", "username", "password", "database"); if ($ conn) {
$sql = "SELECT * FROM EMP WHERE ename = '$ ename'";
$result = mysqli_query($ conn, $sql); if (mysqli_num_rows($ result) > 0) {
$row = mysqli_fetch_assoc($ result);
echo "<h2>Employee Details:</h2>";
echo "<p><strong>Employee Number:</strong> { $row['eno']}</p>"; echo "<p><strong>Name:</strong> {$ row['ename']}</p>";
echo "<p><strong>Designation:</strong> { $row['designation']}</p>"; echo "<p><strong>Salary:</strong> {$ row['salary']}</p>";
} else {
echo "No employee found with the selected name.";
}
mysqli_close($conn);
}
?>

Q. 2 )Consider text paragraph. """Hello all, Welcome to Python Programming Academy. Python
Programming Academy is a nice platform to learn new programming skills. It is difficult to get enrolled
in this Academy.""" Preprocess the text to remove any special characters and digits. Generate the
summary using extractive summarization process
import re
from gensim.summarization import summarize

Text paragraph

text = "Hello all, Welcome to Python Programming Academy. Python Programming Academy is a nice platform to learn new programming skills. It is difficult to get enrolled in this Academy."

DS26

Text paragraph

Preprocess the text to remove special characters and digits

Generate summary using extractive summarization