1#@!#!123s

: / home / markniuj / bazmeasar.com / admin /
Filename : list_mp4.php
back
  <meta content="width=device-width, initial-scale=1.0" name="viewport">
<?php
include '../config.php';

// Retrieve MP4 data from the database


$sql = "SELECT * FROM mp4 ORDER BY mp4_id DESC";


$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data in a table
    echo "<table border='1'>
            <tr>
                <th>ID</th>
                <th>Urdu Text</th>
                <th>Actions</th>
            </tr>";

    while ($row = $result->fetch_assoc()) {
        echo "<tr>
                <td>" . $row['mp4_id'] . "</td>
                <td>" . $row['urdu'] . "</td>
                <td>

                    <a href='delete_mp4.php?mp4_id=" . $row['mp4_id'] . "'><button>Delete</button></a>
                </td>
            </tr>";
    }

    echo "</table>";
} else {
    echo "No MP4 files found.";
}
$conn->close();
?>
<style>
    /* styles.css */
table {
    width: 100%;
    border-collapse: collapse;
}

th, td {
    border: 1px solid #ddd;
    padding: 8px;
    text-align: left;
}

th {
    background-color: #f2f2f2;
}

tr:nth-child(even) {
    background-color: #f9f9f9;
}

tr:hover {
    background-color: #f1f1f1;
}

button {
    padding: 5px 10px;
    cursor: pointer;
    border: none;
    border-radius: 3px;
    background-color: #007bff;
    color: white;
    text-align: center;
    text-decoration: none;
    display: inline-block;
}
</style>