D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
markniuj
/
bazmeasar.com
/
admin
/
Filename :
addaudio.php
back
Copy
<?php include "../config.php"; ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Add audio Files</title> <link rel="stylesheet" href="css.css"> </head> <body> <header> <div class="logo"><img src="logo.png"></div> </header> <div class="mainbody"> <div class="bodyarea"> <div class="dextop"> <form accept-charset="UTF-8" action="upload_audio.php" method="post" enctype="multipart/form-data"> <label for="audio">Audio:</label> <input type="file" name="audio" accept="audio/*" required><br> <label for="image">Image:</label> <input type="file" name="image" accept="image/*" required><br> <label for="urdu_title">Urdu Title:</label> <input type="text" name="urdu_title"placeholder="urdu title" required><br> <label for="english_title">English Title:</label> <input type="text" name="english_title"placeholder="English title" required><br> <label for="a_date">Date:</label> <input type="date" name="a_date" id="a_date" required> <label for="details">Details:</label> <textarea name="details" rows="4"placeholder="Full details " required></textarea><br> <label for="category">Category:</label> <select name="category" required> <?php // Database connection parameters // Query to retrieve category names from the "categories" table $category_query = "SELECT catname FROM categories"; $category_result = $conn->query($category_query); if ($category_result->num_rows > 0) { while ($row = $category_result->fetch_assoc()) { $category_name = $row['catname']; echo "<option value='$category_name'>$category_name</option>"; } } ?> <!-- Add more category options as needed --> </select><br> <label for="speaker">Speaker:</label> <select name="speaker" required> <?php // Establish a database connection // Query to retrieve speaker names from the "speakers" table $speaker_query = "SELECT spname FROM speakers"; $speaker_result = $conn->query($speaker_query); if ($speaker_result->num_rows > 0) { while ($row = $speaker_result->fetch_assoc()) { $speaker_name = $row['spname']; echo "<option value='$speaker_name'>$speaker_name</option>"; } } $conn->close(); ?> <!-- Add more speaker options as needed --> </select><br> <input type="submit" value="Upload"> </form> </div> </div> </div> <footer> <a href="https://webograph.pk/">Site BY Webograph.pk</a> </footer> </body> </html>