<h2>Edit File - gallerycategory.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u318955861/domains/brgsgreaternoida.com/public_html/brgsdash/gallerycategory.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;"> 
 &lt;?php include(&quot;header.php&quot;); ?&gt;
 &lt;?php
 //error_reporting(0);
 $edit=$_REQUEST['edit'];
  $oldssn=$_REQUEST['oldssn'];
 ?&gt;
 
&lt;div class=&quot;main-panel&quot;&gt;        
        &lt;div class=&quot;content-wrapper&quot;&gt;
          &lt;div class=&quot;row&quot;&gt;
            &lt;div class=&quot;col-md-12 grid-margin stretch-card&quot;&gt;
              &lt;div class=&quot;card&quot;&gt;
                &lt;div class=&quot;card-body&quot;&gt;
                  &lt;div class=&quot;App&quot;&gt;
		&lt;h3&gt; PHOTO GALLERY&lt;/h3&gt;
		
 &lt;form name=&quot;form1&quot; method=&quot;post&quot; action=&quot;gallerycategory.php&quot;&gt;
 &lt;table width=&quot;100%&quot; border=&quot;1&quot;&gt;
 &lt;input type=&quot;hidden&quot; name=&quot;hidden_nm&quot; value=&quot;&lt;?php  echo $edit;    ?&gt;&quot;  /&gt;
  &lt;input type=&quot;hidden&quot; name=&quot;hidden_nm1&quot; value=&quot;&lt;?php  echo $oldssn;    ?&gt;&quot;  /&gt;
  &lt;tr&gt;
    &lt;td height=&quot;47&quot;&gt;&lt;strong&gt;ADD NEW CATEGORY &lt;span style=&quot;color:red;&quot;&gt;(* Before Delete Cateogry, First Delete Cateogry Images- Go to image bank and delete images )&lt;/span&gt;&lt;/strong&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td height=&quot;124&quot;&gt;&lt;strong&gt;Category 
        
    &lt;?php
	$hidden_nm=$_REQUEST['hidden_nm'];
	$name=$_REQUEST['name'];
	//$name11=mysqli_real_escape_string($nm);
	//$name=htmlspecialchars($name11, ENT_QUOTES);
	$name2=$_REQUEST['session'];
	$nm1=$_REQUEST['name1'];
	
	
	$query1 = $conn-&gt;query(&quot;SELECT * FROM `category_image` where category_name='$hidden_nm'&quot;);
	//$query1=mysqli_query(&quot;SELECT * FROM `category_image` where category_name='$hidden_nm'&quot;);
		$res1=mysqli_fetch_array($query1);			
		$cname1=$res1['category_name'];
		$ssn1=$res1['session'];

	
	if($_REQUEST['add'])
	{
	if($name==&quot;&quot; || $name2==&quot;&quot;)
	{
	echo &quot;&lt;script&gt; alert('Please insert data ') &lt;/script&gt; &quot;;
	}
	else
	{	
	$b=$_SESSION[&quot;saveid&quot;];
	$sql = &quot;INSERT INTO category_image (category_name, session)VALUES ('$name', '$name2')&quot;;
	if ($conn-&gt;query($sql) === TRUE) {
  echo &quot;&lt;h4 class='text-success'&gt;New record created successfully&lt;/h4&gt; &lt;meta http-equiv='refresh' content='0'&gt;&quot;;
} else {
  echo &quot;Error: &quot; . $sql . &quot;&lt;br&gt;&quot; . $conn-&gt;error;
}
	$_SESSION[&quot;saveid&quot;]=mysqli_insert_id();
	
	}
		
	}
		if($_REQUEST['update'])
	{

	mysqli_query($conn, &quot;UPDATE category_image SET category_name='$nm1',session='$oldssn' where category_name='$cname1' AND session='$ssn1'&quot;);
	mysqli_query($conn, &quot;UPDATE image_category SET category_name='$nm1',session='$oldssn' where category_name='$cname1'&quot;);
		echo &quot;&lt;script&gt; alert('Category Sucessfully Updated ') &lt;/script&gt; &quot;;
	}
	
	if($edit)
	{
	?&gt;
 	&lt;input type=&quot;text&quot; name=&quot;name1&quot;  value=&quot;&lt;?php echo $edit;  ?&gt;&quot;&gt;
 	&lt;input type=&quot;text&quot; name=&quot;oldssn&quot;  value=&quot;&lt;?php echo $oldssn;  ?&gt;&quot;&gt;
	&lt;?php 

	
	}
	else
	{
?&gt;
&lt;select name=&quot;session&quot;&gt;
	&lt;option value=&quot;&quot;&gt;--Select Session--&lt;/option&gt;
	&lt;option value=&quot;2025-26&quot;&gt;2025-26&lt;/option&gt;
	&lt;option value=&quot;2024-25&quot;&gt;2024-25&lt;/option&gt;
	&lt;option value=&quot;2023-24&quot;&gt;2023-24&lt;/option&gt;
	&lt;option value=&quot;2022-23&quot;&gt;2022-23&lt;/option&gt;
	&lt;option value=&quot;2021-22&quot;&gt;2021-22&lt;/option&gt;
	&lt;option value=&quot;2020-21&quot;&gt;2020-21&lt;/option&gt;
	&lt;option value=&quot;2019-20&quot;&gt;2019-20&lt;/option&gt;
	&lt;option value=&quot;2018-19&quot;&gt;2018-19&lt;/option&gt;
	&lt;option value=&quot;2017-18&quot;&gt;2017-18&lt;/option&gt;
	&lt;option value=&quot;2016-17&quot;&gt;2016-17&lt;/option&gt;
	&lt;option value=&quot;2015-16&quot;&gt;2015-16&lt;/option&gt;
&lt;/select&gt;
&lt;input type=&quot;text&quot; name=&quot;name&quot;&gt;
&lt;?php

}
?&gt;
      
      	&lt;input type=&quot;submit&quot; name=&quot;add&quot; value=&quot;Add&quot;&gt;
		&lt;input type=&quot;submit&quot; name=&quot;update&quot; value=&quot;Update&quot;&gt;
		&lt;input type=&quot;reset&quot; name=&quot;new&quot; value=&quot;New&quot;&gt;
	  &lt;/strong&gt;&lt;/td&gt;
	  
	
  &lt;/tr&gt;
   &lt;tr&gt;
    &lt;td height=&quot;246&quot; valign=&quot;top&quot; align=&quot;left&quot;&gt;
&lt;/form&gt;

&lt;div class=&quot;table-responsive pt-3&quot;&gt;
         &lt;table class=&quot;table&quot; id=&quot;table-1&quot;&gt;
		
		&lt;thead&gt;
		&lt;tr&gt;
			&lt;th width=&quot;37%&quot; scope=&quot;col&quot; align=&quot;center&quot;&gt; Category Name&lt;/th&gt;
			&lt;th width=&quot;37%&quot; scope=&quot;col&quot; align=&quot;center&quot;&gt; Session&lt;/th&gt;
			&lt;th width=&quot;54%&quot; scope=&quot;col&quot; align=&quot;center&quot;&gt;Action&lt;/th&gt;

		&lt;/tr&gt;
		&lt;/thead&gt;
                      &lt;tbody&gt;
					&lt;?php
       $query = $conn-&gt;query(&quot;SELECT DISTINCT * FROM category_image order by id DESC&quot;);
		//$query=mysqli_query(&quot;SELECT DISTINCT * FROM category_image&quot;);
		if($query-&gt;num_rows &gt; 0){
		while($row = $query-&gt;fetch_assoc())
		//while($res=mysqli_fetch_array($query))
			{
				$id = $row[&quot;id&quot;];
							$s_no = $row[&quot;s_no&quot;];
							$category_name = $row[&quot;category_name&quot;];
							//$category_name = $row[&quot;category_name&quot;];
							$session = $row[&quot;session&quot;];
			//$res1=count($res['s_no']);
			//$c_name=$res['category_name'];
			//$c_id=$res['id'];
			//$cname=urlencode($res['category_name']);
			//$c_session=$res['session'];

?&gt;
			&lt;tr&gt;
		
			
			&lt;td&gt;
            &lt;?php echo $category_name; ?&gt;	
		      &lt;/td&gt;
			&lt;td&gt;
            &lt;?php echo $session; ?&gt;	
		      &lt;/td&gt;
			&lt;td align=&quot;center&quot;&gt;
			 &lt;a href=&quot;gallerycategory.php?edit=&lt;?php echo $category_name;   ?&gt;&amp;oldssn=&lt;?php echo $session; ?&gt;&quot; onClick = &quot;javascript: return confirm('Are you SURE you wish to do this?');&quot; class=&quot;btn btn-sm btn-info&quot;&gt;&lt;i class=&quot;fa fa-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt; 
			 &lt;a href=&quot;delete_gallerycategory.php?value=delete&amp;name=&lt;?php echo $id; ?&gt;&quot; class=&quot;btn btn-sm btn-danger&quot;  onClick = &quot;javascript: return confirm('Are you SURE you wish to do this?');&quot;&gt;&lt;i class=&quot;fa fa-trash&quot;&gt;&lt;/i&gt;&lt;/a&gt;			  &lt;/td&gt;
		
            
	&lt;/tr&gt;
			&lt;?php
		} }
		?&gt;	
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/div&gt; 
&lt;/td&gt;
	
  &lt;/tr&gt;
&lt;/table&gt;

&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;



	
	

                
                 
            &lt;/div&gt;
			 &lt;/div&gt;
            &lt;/div&gt;
			 &lt;/div&gt;
            &lt;/div&gt;

&lt;?php  include(&quot;footer.php&quot;); ?&gt;
 </textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/brgsdash/upload/slider/56491754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>