/
/
home
/
u523034047
/
domains
/
kingsheightschool.in
/
public_html
/
admin
Server: in-mum-web1112.main-hosting.eu (62.72.28.111)
You: 216.73.216.130
PHP 8.3.16
Dir:
/home/u523034047/domains/kingsheightschool.in/public_html/admin
Edit:
/home/u523034047/domains/kingsheightschool.in/public_html/admin/update_channel.php
<?php include('conn.php'); session_start(); error_reporting(0); if (!isset($_SESSION['username'])) { header('location:index.php'); exit(); } $msg = ''; if(isset($_POST['submit'])){ $channel_id = mysqli_real_escape_string($connection, $_POST['channel_id']); // Check if record exists $check = mysqli_query($connection,"SELECT * FROM tbl_video_channel WHERE id=1"); if(mysqli_num_rows($check) > 0){ mysqli_query($connection,"UPDATE tbl_video_channel SET channel_id='$channel_id' WHERE id=1"); } else { mysqli_query($connection,"INSERT INTO tbl_video_channel (id, channel_id) VALUES (1, '$channel_id')"); } $msg = "Channel ID Updated Successfully!"; } // FETCH saved channel ID $row = mysqli_fetch_array(mysqli_query($connection,"SELECT channel_id FROM tbl_video_channel WHERE id=1")); $current_id = $row['channel_id'] ?? ""; // Delete video if (isset($_POST['del'])) { $id = $_POST['id']; $stmt = $connection->prepare("DELETE FROM tbl_video WHERE id = ?"); $stmt->bind_param("i", $id); $stmt->execute(); header('Location: video-gallery.php'); exit(); } ?> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <title>Admin</title> <!-- BOOTSTRAP STYLES--> <link href="assets/css/bootstrap.css" rel="stylesheet" /> <!-- FONTAWESOME STYLES--> <link href="assets/css/font-awesome.css" rel="stylesheet" /> <!-- CUSTOM STYLES--> <link href="assets/css/custom.css" rel="stylesheet" /> <!-- GOOGLE FONTS--> <link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' /> </head> <body> <div id="wrapper"> <div class="navbar navbar-inverse navbar-fixed-top"> <?php include ('header.php');?> </div> <!-- /. NAV TOP --> <nav class="navbar-default navbar-side" role="navigation"> <?php include ('menu.php');?> </nav> <!-- /. NAV SIDE --> <div id="page-wrapper" > <div id="page-inner"> <!-- /. ROW --> <hr /> <!-- /. ROW --> <div class="panel panel-primary" data-collapsed="0"> <div class="panel-heading"> <div class="panel-title" > <i class="entypo-plus-circled"></i> Add Video </div> </div> <div class="box"> <h2 style="text-align:center; margin-bottom:20px;">Update YouTube Channel ID</h2> <?php if($msg != "") { ?> <div class="msg"><?php echo $msg; ?></div> <?php } ?> <form method="post"> <label>Enter YouTube Channel ID:</label><br><br> <input type="text" name="channel_id" value="<?php echo $current_id; ?>" placeholder="Eg: UCxxxxxxxxxxxx" required> <br><br> <button type="submit" name="submit">Update Channel</button> </form> </div> </div> </div> </div> <!-- /. PAGE INNER --> </div> <!-- /. PAGE WRAPPER --> </div> <div class="footer"> <?php include ('footer.php');?> </div> <!-- /. WRAPPER --> <!-- SCRIPTS -AT THE BOTOM TO REDUCE THE LOAD TIME--> <!-- JQUERY SCRIPTS --> <script src="assets/js/jquery-1.10.2.js"></script> <!-- BOOTSTRAP SCRIPTS --> <script src="assets/js/bootstrap.min.js"></script> <!-- CUSTOM SCRIPTS --> <script src="assets/js/custom.js"></script> </body> </html>
Ukuran: 3.7 KB