D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
self
/
root
/
proc
/
self
/
root
/
home
/
markniuj
/
bazmeasar.com
/
admin
/
Filename :
details-per-record.php
back
Copy
<?php include "../config.php"; // Retrieve the audio file's ID from the query string if (isset($_GET['id']) && is_numeric($_GET['id'])) { $audio_id = $_GET['id']; // Query to select the specific audio file $query = "SELECT * FROM audio_files WHERE id = $audio_id"; $result = $conn->query($query); if ($result && $result->num_rows > 0) { // Display the audio file's full details $row = $result->fetch_assoc(); echo "<h1>Full Details</h1>"; echo "<p>Audio Filename: " . $row["audio_filename"] . "</p>"; echo "<p>Image Filename: " . $row["image_filename"] . "</p>"; echo "<p>Urdu Title: " . $row["urdu_title"] . "</p>"; echo "<p>English Title: " . $row["english_title"] . "</p>"; echo "<p>Details: " . $row["details"] . "</p>"; echo "<p>Category: " . $row["category"] . "</p>"; echo "<p>Speaker: " . $row["speaker"] . "</p>"; // Implement a hit counter (update the database to record hits) $update_hit_counter_query = "UPDATE audio_files SET hits = hits + 1 WHERE id = $audio_id"; $conn->query($update_hit_counter_query); } else { echo "Audio file not found."; } } else { echo "Invalid audio file ID."; } // Close the database connection $conn->close(); ?>