1#@!#!123s

: / home / u935876328 / domains / ggcp.org.in / public_html / admin /
Filename : youtubeGallary.php
back
<?php 
include('config.php');
include('header.php');

$youtubeFile = "upload/youtube/";
//Insert details
if (isset($_POST['submitinsert'])) {
	
	if (!isset($_POST['cateid']))
	{
		$catname = $_POST['catnameinsert'];
		$catdesc = $_POST['catdescinsert'];
		
		$sql = "insert into youtube_link_master (category_name, category_desc) values('$catname','$catdesc')";
		$result = mysqli_query($db, $sql);	
		echo '<script type="text/javascript">alert("Data Inserted!")</script>';
	}
	else
	{
		echo '<script type="text/javascript">alert("Existing data can not be inserted!")</script>';
	}
}

//Update details
if (isset($_POST['submitcat'])) {
	
	if (isset($_POST['cateid']))
	{
		$catid = $_POST['cateid'];
		$upcatname = $_POST['catnameedit'];
		$upcatdesc = $_POST['catdescedit'];
		
		$sql = "UPDATE youtube_link_master SET category_name='$upcatname', category_desc='$upcatdesc' WHERE id='$catid'";
		$result = mysqli_query($db, $sql);
		
	}
	else
	{
		echo '<script type="text/javascript">alert("Invaild data, please try again!!")</script>';
	}
}

//delete details
	if(isset($_GET['delete'])){
		if(isset($_POST['btndelete'])){
			$catId = $_GET['delete'];
			$sql = "DELETE FROM youtube_link_master WHERE id='$catId'";
			//echo '<script type="text/javascript">alert("' . $sql . '")</script>';
			$result = $db->query($sql);
			echo '<script type="text/javascript">alert("Record Deleted!")</script>';
		}
	}


//Edit details
	if(isset($_GET['edit'])){
		if(isset($_POST['btnedit'])){
			$catId = $_GET['edit'];
			$sql = "SELECT id, category_name, category_desc FROM youtube_link_master WHERE id='$catId'";
			//echo '<script type="text/javascript">alert("' . $sql . '")</script>';
			$result = $db->query($sql);
			$arr_category = [];
			if ($result->num_rows > 0) {
				$arr_category = $result->fetch_all(MYSQLI_ASSOC);
				//echo ($arr_category);
				//echo '<script type="text/javascript">alert("' . $arr_category . '")</script>';
			}
		}
	}

	$arr_aboutPageBannerSql = [];
	$aboutPageBannerSql = mysqli_query($db, "SELECT * FROM youtube_page_banner order by id DESC LIMIT 1");
	$arr_aboutPageBannerSql = $aboutPageBannerSql->fetch_all(MYSQLI_ASSOC);

	if (isset($_POST['upload'])) {

		$filename = $_FILES["uploadfile"]["name"];
		$tempname = $_FILES["uploadfile"]["tmp_name"];
		$ext = pathinfo($filename, PATHINFO_EXTENSION);
		$newfilename = date('dmYHis') . "." . $ext;
		$folder = $youtubeFile . $newfilename;

		$youtube_id = $_POST["youtube_id"];
		$title = $_POST["title"];

		if (!empty($arr_aboutPageBannerSql)){ 
			// Get field information for all fields
			$hbid = "0";

				$hbid = $arr_aboutPageBannerSql[0]['id'];
				if($filename == null){
					$newfilename = 	$arr_aboutPageBannerSql[0]['filename'];
				}
			

			$result = mysqli_query($db, "UPDATE youtube_page_banner SET title=\"$title\", filename=\"$newfilename\", youtube_id=\"$youtube_id\" WHERE id=\"$hbid\"");

		} else {
			mysqli_query($db, "INSERT INTO youtube_page_banner (title,filename,youtube_id) VALUES (\"$title\",\"$newfilename\",\"$youtube_id\")");
		}

		// Now let's move the uploaded image into the folder: image 
		if (move_uploaded_file($tempname, $folder)) {
			$msg = "Image uploaded successfully";
		} else {
			$msg = "Failed to upload image";
		}

		$aboutPageBannerSql = mysqli_query($db, "SELECT * FROM youtube_page_banner order by id DESC LIMIT 1");
		$arr_aboutPageBannerSql = $aboutPageBannerSql->fetch_all(MYSQLI_ASSOC);
	}

	$arr_youtubeDescription = [];
	$youtubeDescriptionSql = mysqli_query($db, "SELECT * FROM youtube_description order by id");
	$arr_youtubeDescription = $youtubeDescriptionSql->fetch_all(MYSQLI_ASSOC);

	if (isset($_POST['youtubeDescription'])) {

		$title = $_POST["title"];
		$subscriber  = $_POST["subscriber"];
		$description  = $_POST["description"];
		

		if (!empty($arr_youtubeDescription)){ 
			// Get field information for all fields
			$id = $arr_youtubeDescription[0]['id'];

			$result = mysqli_query($db, "UPDATE youtube_description SET title=\"$title\", subscriber=\"$subscriber\", description=\"$description\" WHERE id=\"$id\"");

		} else {
			mysqli_query($db, "INSERT INTO youtube_description (title,subscriber,description) VALUES (\"$title\",\"$subscriber\",\"$description\")");
		}

		$youtubeDescriptionSql = mysqli_query($db, "SELECT * FROM youtube_description order by id");
	$arr_youtubeDescription = $youtubeDescriptionSql->fetch_all(MYSQLI_ASSOC);
	}

?>

<!-- End Navbar -->
      <div class="content">
        <div class="container-fluid">
		<h2>Youtube Gallary</h2>


          <div class="row">
            <div class="col-md-5">
              <div class="card">
                <div class="card-header card-header-primary" style="background: #0A5788;">
                  <h4 class="card-title">Add & Edit Youtube Master</h4>
                  <p class="card-category">Here you can Add Or Edit exist youtube video(s)</p>
                </div>
                <div class="card-body">
					<form action="" method="post">
					<input type="hidden" name="id" value="<?php echo $id; ?>">
                    <div class="row">
					
                      <div class="col-md-12">
                        <div class="form-group">
                          <label class="bmd-label-floating">Youtube Id</label>
                          <!--<input type="text" class="form-control" value="<?php //echo $catname ?>" required>-->
						  <?php 
							if (!empty($arr_category)) 
							{
								foreach ($arr_category as $cat)
								{
							?>
									<input type="hidden" name="cateid" class="form-control" value="<?php echo $cat['id'] ?>">
									<input type="text" name="catnameedit" class="form-control" value="<?php echo $cat['category_name'] ?>" required>
							<?php 
								}
							}
							else 
							{
							?>
								<input type="text" name="catnameinsert" class="form-control" required>
							<?php 
							}
							?>
                        </div>
                      </div>
                      <div class="col-md-12">
                        <div class="form-group">
                          <label class="bmd-label-floating">Video Name</label>
                          <!--<input type="text" class="form-control" value="<?php //echo $catdesc ?>"  required>-->
						  <?php 
							if (!empty($arr_category)) 
							{
								foreach ($arr_category as $cat)
								{
							?>
									<input type="text" name="catdescedit" class="form-control" value="<?php echo $cat['category_desc']?>" required>
							<?php 
								}
							}
							else 
							{
							?>
								<input type="text" name="catdescinsert" class="form-control" required>
							<?php 
							}
							?>
						  
                        </div>
                      </div>
					  
					  <div class="col-md-6">
					<input name="submitinsert" type="submit" value="Insert" class="btn btn-primary btn-md btn-block waves-effect text-center m-b-20" />
					</div>
					<div class="col-md-6">
                    <input name="submitcat" type="submit" value="Update" class="btn btn-primary btn-md btn-block waves-effect text-center m-b-20" />
					</div>

					</div>
					
					<div class="clearfix"></div>
                  </form>
				  
                </div>
              </div>
            </div>
            <div class="col-md-7">
              <div class="card">
				<div class="card-header card-header-primary" style="background: #0A5788;">
				  <h4 class="card-title">Youtube Master</h4>
				  <p class="card-category">Find Here all listed youtube video(s)</p>
                </div>
                <?php $results1 = mysqli_query($db, "SELECT * FROM youtube_link_master order by id DESC"); ?>
				
				<div class="card-body">
				<div class="col-md-12">
				<table class="table table-responsive" style="width: 100%;display: table;">
					<thead class=" text-primary">
						<tr>
							<th><b>Youtube Id</b></th>
							<th><b>Name</b></th>
							<th colspan="2"><b>Action</b></th>
						</tr>
					</thead>
					
					<tbody>
					<?php while ($row = mysqli_fetch_array($results1)) { ?>
						<tr>
							<td><?php echo $row['category_name']; ?></td>
							<td><?php echo $row['category_desc']; ?></td>
							<td>
							 <form method="post" action="?edit=<?php echo $row['id']; ?>">
								<input name="btnedit" type="submit" value="Edit" class="btn btn-primary btn-sm btn-block waves-effect text-center" />
							 </form>
							</td>
							<td>
							<form method="post" action="?delete=<?php echo $row['id']; ?>" onsubmit="return confirm('Sure you want to delete?')">
								<input name="btndelete" type="submit" value="Delete" class="btn btn-danger btn-sm btn-block waves-effect text-center" />
							</form>
							</td>
						</tr>
					<?php } ?>
					</tbody>
				</table>
				</div>
				</div>
				
              </div>
            </div>
          </div>
        </div>
      </div>
	<script>
		function show_alert() {
		  alert("Are you sure want to delete this?");
		}
	</script>  

<?php 
include('footer.php');
?>