Program 8
a. Develop a PHP program (with HTML/CSS) to keep track of the number of visitors visiting the web
page and to display this count of visitors, with relevant headings.
b. Develop a PHP program (with HTML/CSS) to sort the student records which are stored in the
database using selection sort
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Visitor Counter</title>
<style>
body {
font-family: Arial, sans-serif;
text-align: center;
margin-top: 50px;
}
.counter {
font-size: 24px;
color: #333;
}
.heading {
font-size: 28px;
color: #007BFF;
}
</style>
</head>
<body>
<h1 class="heading">Welcome to <b style="color:red;, font-size:35px;" >V</b><b style="color:black;">tudeveloper !</b></h1>
<?php
// File to store visitor count
$file = "visitor_count.txt";
// Check if file exists, if not create and initialize with 0
if (!file_exists($file)) {
file_put_contents($file, 0);
}
// Read current visitor count
$visitorCount = (int)file_get_contents($file);
// Increment visitor count
$visitorCount++;
// Update the file
file_put_contents($file, $visitorCount);
echo "<p class='counter'>Total Visitors: $visitorCount</p>";
?>
</body>
</html>
Output :-
students_db
CREATE DATABASE student_db;
USE student_db;
CREATE TABLE students (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
grade INT NOT NULL
);
INSERT INTO students (name, grade) VALUES
('Abhishek', 85),
('Basava', 92),
('Santosh', 78),
('Aaditya', 88),
('Dileep', 95);
3.student_records.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Student Records Sorting</title>
<style>
body {
font-family: Arial, sans-serif;
text-align: center;
margin-top: 50px;
}
table {
margin: 20px auto;
border-collapse: collapse;
width: 50%;
}
th, td {
border: 1px solid #ccc;
padding: 10px;
text-align: center;
}
th {
background-color: #f4f4f4;
}
</style>
</head>
<body>
<h1>Sorted Student Records</h1>
<?php
// Database connection
$conn = new mysqli('localhost', 'root', '', 'student_db');
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Fetch student records
$result = $conn->query("SELECT * FROM students");
$students = [];
while ($row = $result->fetch_assoc()) {
$students[] = $row;
}
// Selection Sort Function
function selectionSort(&$arr) {
$n = count($arr);
for ($i = 0; $i < $n - 1; $i++) {
$minIdx = $i;
for ($j = $i + 1; $j < $n; $j++) {
if ($arr[$j]['grade'] < $arr[$minIdx]['grade']) {
$minIdx = $j;
}
}
// Swap
$temp = $arr[$minIdx];
$arr[$minIdx] = $arr[$i];
$arr[$i] = $temp;
}
}
// Sort the records
selectionSort($students);
// Display sorted records
echo "<table>";
echo "<tr><th>ID</th><th>Name</th><th>Grade</th></tr>";
foreach ($students as $student) {
echo "<tr><td>{$student['id']}</td><td>{$student['name']}</td><td>{$student['grade']}</td></tr>";
}
echo "</table>";
$conn->close();
?>
</body>
</html>
Replay !
Share Your Thoughts