1#@!#!123s

: / home / markniuj / bazmeasar.com / admin /
Filename : details-per-record.php
back
<?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();
?>