<h2>Edit File - diamond_action.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u548619843/domains/indusjewellery.com/public_html/Old-Site/admin/diamond_action.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php

include &#039;Config.php&#039;;

include &#039;common.php&#039;;





$type=$_REQUEST[&#039;type&#039;];





if($type==&quot;insert&quot;)
{



$time=time();



$title=trim($_POST[&#039;title&#039;]);



$position=trim($_POST[&#039;position&#039;]);



$diamond_diamondcategory=trim($_POST[&#039;diamondsubcategory1&#039;]);
if($diamond_diamondcategory==&quot;&quot;)
{
	$diamond_diamondcategory=trim($_POST[&#039;maindiamondcategory&#039;]);
}
//echo $diamond_diamondcategory;exit;

$title=specialchar($title);



$desc=trim($_POST[&#039;desc&#039;]);

$product_code=trim($_POST[&#039;product_code&#039;]);

$desc=specialchar($desc);

$price=$_POST[&#039;prod_price&#039;];

$image=$_FILES[&#039;image&#039;][&#039;name&#039;];



$filesize=$_FILES[&#039;image&#039;][&#039;size&#039;];






//$price=specialchar($price);


//echo &#039;image=&#039;.$image.&#039;,&#039;.&#039;title=&#039;.$title.&#039;,&#039;.&#039;desc=&#039;.$desc.&#039;,&#039;.&#039;price=&#039;.$price;

/* if($image==&quot;&quot; || $title==&quot;&quot; )

 {

	 header(&#039;location:add_diamond.php?error=1005&#039;);

  	 exit;

 }

*/

	

		

	$path=DATA_FOLDER.&quot;/diamonds/original_image&quot;;

	$path1=DATA_FOLDER.&quot;/diamonds/thumb_image&quot;;

	                           

	$file_ext=imageTypeCheck($image);

	$file_size=imageSizeCheck($image,$filesize);

	if($file_ext!=1)

	{

			header(&#039;location:add_diamond.php?error=1016&#039;);

		exit;

	

	}

	

	

	$ext=file_extension($image);

	$image=str_replace(&#039;.&#039;,&#039;&#039;,md5($image.$time)).&quot;.&quot;.$ext;

	$filesize=$_FILES[&#039;image&#039;][&#039;size&#039;];

			 



	if($position!=&quot;&quot;)

	{

		$serpos=$position;

		

	}

	

	else

	{

	

	$result=mysql_query(&quot;SELECT MAX(position) FROM tb_diamonds&quot;);

 	$row=mysql_fetch_row($result);

	$serpos=$row[0]+1;

	}




	

								$obj=mysql_query(&quot;INSERT INTO `tb_diamonds` (`diamondcategory_id`,

								                     `diamonds_name`,
													 
													 `diamonds_price`,
													 
													 `product_code`,

													 `diamonds_image`,

													 `diamonds_desc`,
													 
													 `status`,

													 `diamonds_addedon`,

													 `position` ) VALUES 

													                       (&#039;$diamond_diamondcategory&#039;,

																		    &#039;$title&#039;,
																			
																			&#039;$price&#039;,
																			
																			&#039;$product_code&#039;,

																		    &#039;$image&#039;,

																			&#039;$desc&#039;,
																			
																			&#039;2&#039;,

																			&#039;$time&#039;,

																			&#039;$serpos&#039;);&quot;);

																			

	

	

	

	$id=mysql_insert_id();

	$res=mysql_query($obj);



						

					if(!is_dir($path.&quot;/&quot;.$id)){

						mkdir($path.&quot;/&quot;.$id,0777);

						

					}

					if(!is_dir($path1.&quot;/&quot;.$id)){

						mkdir($path1.&quot;/&quot;.$id,0777);

						

					}

					

					

					$pic2=$_FILES[&quot;image&quot;][&#039;tmp_name&#039;];

					move_uploaded_file($pic2,$path.&quot;/&quot;.$id.&quot;/&quot;.$image);   

					

			  



					

		////////////////////////////////////thumb image///////////////////////////////////////////////////	               

					include(&#039;SimpleImage.php&#039;);

					$imag = new SimpleImage();

					$imag-&gt;load($path.&quot;/&quot;.$id.&quot;/&quot;.$image);

					$org_width=&quot;202&quot;;

					$org_height=&quot;150&quot;;

					$actual_width = $imag-&gt;getWidth($path.&quot;/&quot;.$id.&quot;/&quot;.$image);

					$actual_height = $imag-&gt;getHeight($path.&quot;/&quot;.$id.&quot;/&quot;.$image);

					 if($actual_width &gt;$org_width){

						 $imag-&gt;resizeToWidth($org_width);

					 }else if($actual_height &gt;$org_height){

						 $imag-&gt;resizeToHeight($org_height);

					 }

					$imag-&gt;save($path1.&quot;/&quot;.$id.&quot;/&quot;.$image);

					

					

	//////////////////////////////////////thumb image///////////////////////////////////////////////////	

	

	$path11=DATA_FOLDER.&quot;/multiple_image/diamonds/original_image&quot;;
	//$path22=DATA_FOLDER.&quot;/multiple_image/diamonds/thumb_image&quot;;

//echo $path11.&quot;checkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk&quot;; exit;	

			if(!is_dir($path11.&quot;/&quot;.$id)){
			mkdir($path11.&quot;/&quot;.$id,0777);
					}
		
if(isset($_FILES[&#039;file&#039;][&#039;tmp_name&#039;]))
  {
        //* loop through the array of files ***/
       for($i=0; $i &lt; count($_FILES[&#039;file&#039;][&#039;tmp_name&#039;]);$i++)
   {
	   
						
						
						
						$finalimage=$_FILES[&#039;file&#039;][&#039;name&#039;][$i];
						$ext=file_extension($finalimage);
						//$finalimage=str_replace(&#039;.&#039;,&#039;&#039;,md5($finalimage.$time)).&quot;.&quot;.$ext;
						$pic2=$_FILES[&quot;file&quot;][&#039;tmp_name&#039;][$i];
						copy($pic2,$path11.&quot;/&quot;.$id.&quot;/&quot;.$finalimage); 

		  
			

$obj=mysql_query(&quot;INSERT INTO tb_gallery (gallery_id,gallery_name,gallery_image,gallery_added,mapping_id,type,position) VALUES(&#039;&#039;,&#039;&#039;,&#039;$finalimage&#039;,$time,&#039;$id&#039;,&#039;diamonds&#039;,&#039;$serpos&#039;)&quot;);

		}
	}


 

	header(&#039;location:add_diamond.php?sucess=1006#manage&#039;);

		exit;

		

}











if($type==&quot;edit&quot;)



{

	

$time=time();



$update_title=trim($_POST[&#039;title&#039;]);



$update_desc=trim($_POST[&#039;desc&#039;]);



$update_image=$_POST[&#039;editimage&#039;];



$update_id=trim($_POST[&#039;editid&#039;]);

$update_code=trim($_POST[&#039;product_code&#039;]);



$update_position=trim($_POST[&#039;position&#039;]);



$update_title=specialchar($update_title);



$update_desc=specialchar($update_desc);



$image=$_FILES[&#039;image&#039;][&#039;name&#039;];



$filesize=$_FILES[&#039;image&#039;][&#039;size&#039;];



$update_diamondcategory=$_POST[&#039;diamondsubcategory&#039;];

if($update_diamondcategory==&quot;&quot;)
{
$update_diamondcategory=$_POST[&#039;maindiamondcategory&#039;];	
}
//echo $update_diamondcategory;exit;
$update_price=$_POST[&#039;prod_price&#039;];





/* if($update_title==&quot;&quot; || $update_code==&quot;&quot;)

 

 {

	 

	 header(&#039;location:edit_diamond.php?diamonds_id=&#039;.$update_id.&#039;&amp;error=1005&#039;);

	 exit;

	 

 }



*/







if($image!=&quot;&quot;)



	{

	

	$path=DATA_FOLDER.&quot;/diamonds/original_image&quot;;

	$path1=DATA_FOLDER.&quot;/diamonds/thumb_image&quot;;

	

	unlink(&quot;$path/$update_id/$update_image&quot;);

	unlink(&quot;$path1/$update_id/$update_image&quot;);



	

	$file_ext=imageTypeCheck($image);

	$file_size=imageSizeCheck($image,$filesize);

	if($file_ext!=1)

	{

		

		header(&#039;location:edit_diamond.php?error=1016&#039;);

		

		exit;

	

	}



	

	

	$ext=file_extension($image);

	$image=str_replace(&#039;.&#039;,&#039;&#039;,md5($image.$time)).&quot;.&quot;.$ext;

	$filesize=$_FILES[&#039;image&#039;][&#039;size&#039;];

	

     

	 

		mysql_query(&quot;UPDATE `tb_diamonds` SET 

											 `diamondcategory_id`=&#039;$update_diamondcategory&#039;,

											 `diamonds_name`=&#039;$update_title&#039;,
											 
											 `diamonds_price`=&#039;$update_price&#039;,
											 
											 `product_code`=&#039;$update_code&#039;,

											 `diamonds_image`=&#039;$image&#039;,

											 `diamonds_desc`=&#039;$update_desc&#039;,

											 `position`=&#039;$update_position&#039;

					                          WHERE  `diamonds_id`=&#039;$update_id&#039;;&quot;);

		

	

             $id=$update_id;

              

						if(!is_dir($path.&quot;/&quot;.$id)){

						mkdir($path.&quot;/&quot;.$id,0777);

						}

						if(!is_dir($path1.&quot;/&quot;.$id)){

						mkdir($path1.&quot;/&quot;.$id,0777);

						}

				

				

				

				$pic2=$_FILES[&quot;image&quot;][&#039;tmp_name&#039;];

                move_uploaded_file($pic2,$path.&quot;/&quot;.$id.&quot;/&quot;.$image);   

				

								

	//////////////////thumb image///////////////////////////////////////////////////	               

                include(&#039;SimpleImage.php&#039;);

                $imag = new SimpleImage();

                $imag-&gt;load($path.&quot;/&quot;.$id.&quot;/&quot;.$image);

                $org_width=&quot;202&quot;;

                $org_height=&quot;150&quot;;

                $actual_width = $imag-&gt;getWidth($path.&quot;/&quot;.$id.&quot;/&quot;.$image);

                $actual_height = $imag-&gt;getHeight($path.&quot;/&quot;.$id.&quot;/&quot;.$image);

                 if($actual_width &gt;$org_width){

                     $imag-&gt;resizeToWidth($org_width);

                 }else if($actual_height &gt;$org_height){

                     $imag-&gt;resizeToHeight($org_height);

                 }

                $imag-&gt;save($path1.&quot;/&quot;.$id.&quot;/&quot;.$image);

	//////////////////thumb image///////////////////////////////////////////////////	

	

	

	}

	

	

	else

	{

	

			

		mysql_query(&quot;UPDATE `tb_diamonds` SET 

											 `diamondcategory_id`=&#039;$update_diamondcategory&#039;,

											 `diamonds_name`=&#039;$update_title&#039;,
											 
											 `diamonds_price`=&#039;$update_price&#039;,
											 
											 `product_code`=&#039;$update_code&#039;,

											 `diamonds_desc`=&#039;$update_desc&#039;,

											 `position`=&#039;$update_position&#039;

					                          WHERE  `diamonds_id`=&#039;$update_id&#039;;&quot;);

	

	  

	

	}
	$path44=DATA_FOLDER.&quot;/multiple_image/diamonds/original_image&quot;;
	//$path22=DATA_FOLDER.&quot;/multiple_image/diamonds/thumb_image&quot;;

					 if(!is_dir($path44.&quot;/&quot;.$update_id)){
						mkdir($path44.&quot;/&quot;.$update_id,0777);
					}
				
		if(isset($_FILES[&#039;file&#039;][&#039;tmp_name&#039;]))
   		 {
				/** loop through the array of files ***/
				for($i=0; $i &lt; count($_FILES[&#039;file&#039;][&#039;tmp_name&#039;]);$i++)
				{
						$finalimage=$_FILES[&#039;file&#039;][&#039;name&#039;][$i];
					$finalimage=str_replace(&#039; &#039;,&#039;_&#039;,$finalimage);
					//$ext=file_extension($finalimage);
					//$finalimage=str_replace(&#039;.&#039;,&#039;&#039;,md5($finalimage.$time)).&quot;.&quot;.$ext;
					$pic2=$_FILES[&quot;file&quot;][&#039;tmp_name&#039;][$i];
					copy($pic2,$path44.&quot;/&quot;.$update_id.&quot;/&quot;.$finalimage); 
					
	
$obj=mysql_query(&quot;INSERT INTO tb_gallery (gallery_id,gallery_name,gallery_image,gallery_added,mapping_id,type) VALUES(&#039;&#039;,&#039;&#039;,&#039;$finalimage&#039;,$time,&#039;$update_id&#039;,&#039;diamonds&#039;)&quot;);
						
				}
	}
	



	

	header(&#039;location:add_diamond.php?sucess=1010&amp;str=&#039;.$_REQUEST[&#039;str&#039;].&#039;&amp;diamondcategory=&#039;.$_REQUEST[&#039;diamondcategory&#039;].&#039;&amp;diamondcategory1=&#039;.$_REQUEST[&#039;diamondcategory1&#039;].&#039;#page=&#039;.$_REQUEST[&#039;page&#039;].&#039;#1&#039;);

	

	exit;



	

	

}





if($type==&quot;delete&quot;)





{





function deletedir($path)//by satheesh

{



    $dir_handle = @opendir($path) or die(&quot;Unable to open $path&quot;);



    while ($file = readdir($dir_handle)) 

	{

		if($file == &quot;.&quot; || $file == &quot;..&quot; )

		

		continue;



		unlink($path.&#039;/&#039;.$file);

  

    }

     //Close

    closedir($dir_handle);

	rmdir($path);

}









$delete_id=$_REQUEST[&#039;diamonds_id&#039;];



$paging=$_REQUEST[&#039;page&#039;];





$path1=DATA_FOLDER.&quot;/diamonds/thumb_image/$delete_id/&quot;;



$pathO=DATA_FOLDER.&quot;/diamonds/original_image/$delete_id/&quot;;


$path11=DATA_FOLDER.&quot;/multiple_image/diamonds/original_image/$delete_id/&quot;;

$path55=DATA_FOLDER.&quot;/multiple_image/diamonds/thumb_image/$delete_id/&quot;;




if(file_exists($path1))

{

	  deletedir($path1);

}

if(file_exists($pathO))

{	 

	  deletedir($pathO);

}

if(file_exists($path11))
{	 
	  deletedir($path11);
}
if(file_exists($path55))
{	 
	  deletedir($path55);
}




	mysql_query(&quot;delete from tb_diamonds where diamonds_id=$delete_id&quot;);

	
mysql_query(&quot;delete from tb_gallery where type=&#039;diamonds&#039; and page_mappingid=$delete_id&quot;);


	header(&#039;location:add_diamond.php?sucess=1009&amp;str=&#039;.$_REQUEST[&#039;str&#039;].&#039;&amp;diamondcategory=&#039;.$_REQUEST[&#039;diamondcategory&#039;].&#039;&amp;diamondcategory1=&#039;.$_REQUEST[&#039;diamondcategory1&#039;].&#039;#page=&#039;.$_REQUEST[&#039;page&#039;].&#039;#1&#039;);

	

	exit;

	

	

}







//echo $type; exit;



if($type==&quot;deleteall&quot;)



{

	

function deletedir($path)//by satheesh



{



    $dir_handle = @opendir($path) or die(&quot;Unable to open $path&quot;);



    while ($file = readdir($dir_handle)) 

	{

		if($file == &quot;.&quot; || $file == &quot;..&quot; )

		

		continue;



		unlink($path.&#039;/&#039;.$file);

  

    }

     //Close

    closedir($dir_handle);

	rmdir($path);

}



//$updt_newfet=$_REQUEST[&#039;newc&#039;];



	$chksel=$_POST[&#039;check&#039;];

//	print_r($_POST[&#039;check&#039;]);exit;

 for($i=0; $i &lt; count($_POST[&#039;check&#039;]);$i++)

 

 

        {

		

			$path1=DATA_FOLDER.&quot;/diamonds/thumb_image/&quot;.$_POST[&#039;check&#039;][$i].&quot;/&quot;;

			$pathO=DATA_FOLDER.&quot;/diamonds/original_image/&quot;.$_POST[&#039;check&#039;][$i].&quot;/&quot;;

           $path11=DATA_FOLDER.&quot;/multiple_image/diamonds/original_image/&quot;.$_POST[&#039;check&#039;][$i].&quot;/&quot;;
			$path55=DATA_FOLDER.&quot;/multiple_image/diamonds/thumb_image/&quot;.$_POST[&#039;check&#039;][$i].&quot;/&quot;;

			

				if (is_dir($path1))

				{

				deletedir($path1);

				}

				if (is_dir($pathO))

				{	 

				deletedir($pathO);

				}

				if(file_exists($path11))
				{	 
				deletedir($path11);
				}
				if(file_exists($path55))
				{	 
				deletedir($path55);
				}

		

			mysql_query(&quot;delete from tb_diamonds where diamonds_id=&#039;&quot;.$_POST[&#039;check&#039;][$i].&quot;&#039;&quot;);

	mysql_query(&quot;delete from tb_gallery where type=&#039;diamonds&#039; and page_mappingid=&#039;&quot;.$_POST[&#039;check&#039;][$i].&quot;&#039;&quot;);

	

		

}





header(&#039;location:add_diamond.php?&amp;sucess=1009&amp;str=&#039;.$_REQUEST[&#039;str&#039;].&#039;&amp;diamondcategory=&#039;.$_REQUEST[&#039;diamondcategory&#039;].&#039;&amp;diamondcategory1=&#039;.$_REQUEST[&#039;diamondcategory1&#039;].&#039;#page=&#039;.$_REQUEST[&#039;page&#039;].&#039;#1&#039;);

		exit;

}





if($type==&quot;view&quot;)





{

	

	

	

	

	if($_POST[&#039;page&#039;])

{

	

$str = trim($_REQUEST[&#039;str&#039;]);


 $diamondcategory=$_REQUEST[&#039;diamondcategory&#039;]; 
 

 $diamondcategory1=$_REQUEST[&#039;diamondsubcategory1&#039;];
 
 
if($str==&quot;undefined&quot;)
{
	$str=&quot;&quot;;
}
if($diamondcategory==&quot;undefined&quot;)
{
	$diamondcategory=&quot;&quot;;
}
//echo $str.&quot;aaaaaaaaaaaaaaaaaaaaaaaa&quot;;

$s=$_REQUEST[&#039;s&#039;];




function getCategory($id)



{

        $result=mysql_query(&quot;SELECT diamondcategory_name FROM tb_diamondcategory where diamondcategory_id=&#039;&quot;.$id.&quot;&#039;&quot;);

        $row=mysql_fetch_row($result);

        return $row[0];

}











 $perpage =$_REQUEST[&#039;perpage&#039;];



//echo $diamondcategory.&quot; &quot;.$diamondcategory1.&quot; &quot;.$str; 



if($diamondcategory!=&quot;&quot; &amp;&amp; $diamondcategory1!=&quot;&quot; &amp;&amp; $str!=&quot;&quot;)



{

	

	$con=&quot;where diamondcategory_id=&#039;$diamondcategory1&#039; and diamonds_name like &#039;%&quot;.$str.&quot;%&#039;&quot;;

	

	//echo $con;

	

}



elseif($diamondcategory!=&quot;&quot; &amp;&amp; $diamondcategory1!=&quot;&quot; )



{



    

    $con=&quot;where diamondcategory_id=&#039;$diamondcategory1&#039;&quot;;	



	

	

}



else if($diamondcategory!=&quot;&quot; &amp;&amp; $str!=&quot;&quot;)



{

      

	  //echo (&quot;select * from tb_diamondcategory where diamondcategory_type=&#039;$diamondcategory&#039;&quot;); 

	  	$cid=&quot;&quot;;



	$se=mysql_query(&quot;select * from tb_diamondcategory where diamondcategory_type=&#039;$diamondcategory&#039;&quot;);

	

	while($rowq=mysql_fetch_assoc($se))

	

	{

		

		$cid.=&quot; or diamondcategory_id=&#039;&quot;.$rowq[&#039;diamondcategory_id&#039;].&quot;&#039;&quot;;

		

		

	}





	

	$con=&quot;where (diamondcategory_id=&#039;$diamondcategory&#039; $cid) and (diamonds_name like &#039;%&quot;.$str.&quot;%&#039;)&quot;;

	

	

}

elseif($diamondcategory!=&quot;&quot;)



{

	$cid=&quot;&quot;;

	$se=mysql_query(&quot;select * from tb_diamondcategory where diamondcategory_type=&#039;$diamondcategory&#039;&quot;);

	

	while($rowq=mysql_fetch_assoc($se))

	



	{

		

		$cid.=&quot; or diamondcategory_id=&#039;&quot;.$rowq[&#039;diamondcategory_id&#039;].&quot;&#039;&quot;;

		

		

	}

	

	$con=&quot;where diamondcategory_id=&#039;$diamondcategory&#039; $cid&quot;;

	

}

elseif($str!=&quot;&quot;)



{

	

	$con=&quot;where diamonds_name like &#039;%&quot;.$str.&quot;%&#039;&quot;;

	

}

else

{

	

	$con=&quot;&quot;;

	

}



$page =$_REQUEST[&#039;page&#039;];





$cur_page = $page;

$page -= 1;

$per_page =loadsettings(perpage_size);

if($perpage==&quot;&quot;){

$per_page =loadsettings(perpage_size);

}

else

{

	$per_page =$perpage;

}

if($cur_page==&quot;undefined&quot;)

{

	$cur_page=1;

}



$previous_btn = true;

$next_btn = true;

$first_btn = true;

$last_btn = true;

$start = $page * $per_page;

//include&quot;db.php&quot;;

$per_page1=&quot;-&quot;.$per_page;

//echo $start.&quot;---&quot;.$per_page1;

if($start==$per_page1)

{

	$start=0;

}



//echo $per_page;



//echo &quot;select * from tb_diamonds $con order by position Desc LIMIT $start, $per_page&quot;;



$query_pag_data = &quot;select * from tb_diamonds $con order by position Desc LIMIT $start, $per_page&quot;;

$result_pag_data = mysql_query($query_pag_data);

$total2=mysql_num_rows($result_pag_data);



$msg = &quot;&quot;;


//$htmlmsg=htmlentities($row[&#039;visa_country_name&#039;]);

   // $msg .= &quot;&lt;li&gt;&lt;b&gt;&quot; . $row[&#039;visa_country_id&#039;] . &quot;&lt;/b&gt; &quot; . $htmlmsg . &quot;&lt;/li&gt;&quot;;

//	$des=length3(120,$row[&#039;diamonds_desc&#039;]);

	

	

	$msg.=&#039;&lt;script type=&quot;text/javascript&quot; src=&quot;bin/custom.js&quot;&gt;&lt;/script&gt;

	

	

	

	

	&lt;fieldset&gt;

&lt;div style=&quot;float:right&quot;&gt;  

&lt;table&gt;&lt;tr&gt;







&lt;td&gt;

&lt;select name=&quot;diamondcategory&quot; id=&quot;diamondcategory&quot; onchange=&quot;searchName()&quot;&gt;

&lt;option value=&quot;&quot;&gt;Select Category&lt;/option&gt;&#039;;

 $selcat=mysql_query(&quot;SELECT * FROM tb_diamondcategory WHERE diamondcategory_type=0&quot;);while($cat1=mysql_fetch_assoc($selcat)){

$msg.=&#039;&lt;option value=&quot;&#039;.$cat1[&#039;diamondcategory_id&#039;].&#039;&quot;&#039;; if($cat1[&#039;diamondcategory_id&#039;]==$diamondcategory){ $msg.=&quot;selected=&#039;true&#039;&quot;;} $msg.=&#039;&gt;&#039;.$cat1[&#039;diamondcategory_name&#039;].&#039;&lt;/option&gt;&#039;;

 }



$msg.=&#039;&lt;/select&gt;

&lt;/td&gt;







&lt;td&gt;



&lt;select name=&quot;diamondsubcategory1&quot; id=&quot;diamondsubcategory1&quot; onchange=&quot;searchName1()&quot; disabled=&quot;disabled&quot;&gt;

&lt;option value=&quot;&quot;&gt;Select Subcategory&lt;/option&gt;&#039;;
if($diamondcategory!=0){
 $selcat2=mysql_query(&quot;SELECT * FROM tb_diamondcategory WHERE diamondcategory_type=&#039;$diamondcategory&#039;&quot;);while($cat2=mysql_fetch_assoc($selcat2)){

$msg.=&#039;&lt;option value=&quot;&#039;.$cat2[&#039;diamondcategory_id&#039;].&#039;&quot;&#039;; if($cat2[&#039;diamondcategory_id&#039;]==$diamondcategory1){ $msg.=&quot;selected=&#039;true&#039;&quot;;} $msg.=&#039;&gt;&#039;.$cat2[&#039;diamondcategory_name&#039;].&#039;&lt;/option&gt;&#039;;



 }}


$msg.=&#039;&lt;/select&gt;



&lt;/td&gt;



&lt;td&gt;



&lt;input type=&quot;text&quot; name=&quot;search&quot; id=&quot;search&quot; value=&quot;&#039;.$str.&#039;&quot; /&gt;

&lt;/td&gt;



&lt;td&gt;

&lt;a class=&quot;button tooltip&quot; style=&quot;padding-left: 10px; cursor: pointer;&quot;  onclick=&quot;searchName3()&quot;&gt;Search &lt;/a&gt;

&lt;/td&gt;

&lt;!--&lt;/form&gt;--&gt;



&lt;td&gt;&amp;ensp;&amp;ensp;&lt;/td&gt;

&lt;td style=&quot;display:none&quot;&gt;

    &lt;select class=&quot;custom-select&quot; name=&quot;perpage&quot; id=&quot;perpage&quot; onchange=&quot;setpag();&quot;&gt; 

    &lt;option value=&quot;10&quot;&gt;10&lt;/option&gt;

   &lt;option value=&quot;50&quot;&gt;50&lt;/option&gt;

   &lt;option value=&quot;100&quot;&gt;100&lt;/option&gt;

   &lt;option value=&quot;200&quot;&gt;200&lt;/option&gt;

   &lt;option value=&quot;500&quot;&gt;500&lt;/option&gt;

    &lt;/select&gt;

	&lt;/td&gt;

	

	

	&lt;td&gt;&lt;a class=&quot;button tooltip&quot; style=&quot;padding-left: 10px; cursor: pointer;&quot; onclick=&quot;viewAll()&quot;&gt;view all&lt;/a&gt; &lt;/td&gt;



&lt;/tr&gt;

&lt;/table&gt;

&lt;/div&gt; 

&lt;/fieldset&gt;&#039;;



	if($total2==&quot;0&quot;)

{

	 $msg.=&#039;&lt;img src=&quot;bin/no-result.png&quot;&gt;&#039;;

	 echo $msg;exit;

}else{

	

	$msg.=&#039;&lt;form name=&quot;form&quot; action=&quot;diamond_action.php?type=deleteall&amp;page=&#039;.$cur_page.&#039;&amp;diamonds_id=&#039;.$result1[&#039;diamonds_id&#039;].&#039;&amp;category_id=&#039;.$result1[&#039;diamondcategory_id&#039;].&#039;&amp;str=&#039;.$str.&#039;&amp;diamondcategory=&#039;.$diamondcategory.&#039;&amp;diamondcategory1=&#039;.$diamondcategory1.&#039;&quot; method=&quot;post&quot; enctype=&quot;multipart/form-data&quot; &gt;

&lt;div style=&quot;margin-left: 23px;&quot;&gt;

&lt;input type=&quot;submit&quot; value=&quot;Delete All&quot; class=&quot;button ui-icon-trash1&quot; onclick=&quot;return deleteall();&quot;/&gt;



&lt;/div&gt;

									&lt;table cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; border=&quot;0&quot; class=&quot;fullwidth&quot; id=&quot;manage&quot;&gt;

										&lt;thead&gt;

											&lt;tr&gt;

												                                                &lt;td style=&quot;width: 93px;&quot;&gt;&lt;input type=&quot;checkbox&quot; id=&quot;selecctall&quot;&gt;&lt;span&gt; Select All&lt;/span&gt;&lt;/td&gt;


                                                &lt;td&gt;Category&lt;/td&gt;

                                                &lt;td&gt;Title&lt;/td&gt;

												&lt;td&gt;Thumb Image&lt;/td&gt;

                                                &lt;td&gt;position&lt;/td&gt;

												&lt;td&gt;Action&lt;/td&gt;

											&lt;/tr&gt;

										&lt;/thead&gt;

										&lt;tbody&gt;&#039;;

                                     

									$i=1;

									

									  while($result1=mysql_fetch_assoc($result_pag_data))

									  

									{

										

																				

			$selcat=mysql_query(&quot;select diamondcategory_type from tb_diamondcategory where diamondcategory_id=&quot;.$result1[&#039;diamondcategory_id&#039;]);

			

			$rowc=mysql_fetch_row($selcat);

			

			if($rowc[0]!=0)

			

			$selparent=mysql_query(&quot;select diamondcategory_type from tb_diamondcategory where diamondcategory_id=&quot;.$rowc[0]);

			

			$rowp=mysql_fetch_row($selparent);

			
							
                          
									

										

										

									

									if ($i % 2 == 0) {$even=1;}else{ $even=&quot;&quot;;}

										

											$msg.=&#039;&lt;tr  id=&quot;&#039;.$result1[&#039;diamonds_id&#039;].&#039;&quot;&#039;; if($even==&quot;&quot;){ $msg.=&#039;class=&quot;odd&quot;&#039;; } $msg.=&#039;&gt;

											&lt;td&gt;&lt;input class=&quot;checkbox1&quot; type=&quot;checkbox&quot; name=&quot;check[]&quot; value=&quot;&#039;.$result1[&#039;diamonds_id&#039;].&#039;&quot;&gt;&lt;/td&gt;

                                                

                                                &lt;td&gt;&#039;;

												

												if($rowc[0]==0)

												{

													

													$ck=getCategory($result1[&#039;diamondcategory_id&#039;]);
										

												}

												

												elseif($rowp[0]==0)

												{

													

													

													$ck=getCategory($rowc[0]).&#039;&gt;&#039;.getCategory($result1[&#039;diamondcategory_id&#039;]);

													 

													

												} 

												

												

												

												 $msg.=$ck;

												

												

												

                                                 

                                               $msg.=&#039;&lt;/td&gt;

                                                

                                                &lt;td&gt;&#039;.$result1[&#039;diamonds_name&#039;].&#039;&lt;/td&gt;

                                                &lt;td&gt;&lt;img src=&quot;&#039;. DATA_FOLDER.&#039;/diamonds/thumb_image/&#039;.$result1[&#039;diamonds_id&#039;].&#039;/&#039;.$result1[&#039;diamonds_image&#039;].&#039;&quot; style=&quot;width:50px;&quot;/&gt;									&lt;/td&gt;

 

                                            

                                            &lt;td&gt;&#039;.$result1[&#039;position&#039;].&#039;&lt;/td&gt;

                                            

                                            

                                            &lt;td&gt;

                                                &lt;br /&gt;

                                                &lt;p&gt;&lt;a title=&quot;View / Edit&quot; class=&quot;button tooltip&quot; href=&quot;edit_diamond.php?type=edit&amp;diamonds_id=&#039;. $result1[&#039;diamonds_id&#039;].&#039;&amp;page=&#039;.$cur_page.&#039;&amp;str=&#039;.$str.&#039;&amp;diamondcategory_id=&#039;.$result1[&#039;diamondcategory_id&#039;].&#039;&amp;diamondcategory=&#039;.$diamondcategory.&#039;&amp;diamondcategory1=&#039;.$diamondcategory1.&#039;&quot; &gt;&lt;span class=&quot;ui-icon ui-icon-circle-zoomout&quot;&gt;&lt;/span&gt;View / Edit&lt;/a&gt;

                                                                   

                                

                      &lt;a title=&quot;Delete&quot; class=&quot;button tooltip&quot; onClick=&quot;return confirmDeletes(&#039;.$result1[&#039;diamonds_id&#039;].&#039;)&quot;&gt;&lt;span class=&quot;ui-icon ui-icon-trash&quot;&gt;&lt;/span&gt;Delete&lt;/a&gt;                             





                                            &lt;/td&gt;

                                           

											&lt;/tr&gt;&#039;;

            $i++; } 

										$msg.=&#039;&lt;/tbody&gt;

									&lt;/table&gt;

                                  &lt;/form&gt;

									

									

									

									

									&#039;;

}}

//$msg = &quot;&lt;div class=&#039;data&#039;&gt;&lt;ul&gt;&quot; . $msg . &quot;&lt;/ul&gt;&lt;/div&gt;&quot;; // Content for Data





/* --------------------------------------------- */

//echo &quot;SELECT COUNT(*) AS count FROM tb_diamondcategory $con&quot;;

$query_pag_num = &quot;SELECT COUNT(*) AS count FROM tb_diamonds $con&quot;;

$result_pag_num = mysql_query($query_pag_num);

$row = mysql_fetch_array($result_pag_num);

$count = $row[&#039;count&#039;];



$no_of_paginations = ceil($count / $per_page);



/* ---------------Calculating the starting and endign values for the loop----------------------------------- */

if ($cur_page &gt;= 7) {

    $start_loop = $cur_page - 3;

    if ($no_of_paginations &gt; $cur_page + 3)

        $end_loop = $cur_page + 3;

    else if ($cur_page &lt;= $no_of_paginations &amp;&amp; $cur_page &gt; $no_of_paginations - 6) {

        $start_loop = $no_of_paginations - 6;

        $end_loop = $no_of_paginations;

    } else {

        $end_loop = $no_of_paginations;

    }

} else {

    $start_loop = 1;

    if ($no_of_paginations &gt; 7)

        $end_loop = 7;

    else

        $end_loop = $no_of_paginations;

}

/* ----------------------------------------------------------------------------------------------------------- */

$msg .= &quot;&lt;div class=&#039;pagination&#039;&gt;&lt;ul&gt;&quot;;



// FOR ENABLING THE FIRST BUTTON

if ($first_btn &amp;&amp; $cur_page &gt; 1) {

    $msg .= &quot;&lt;li p=&#039;1&#039; class=&#039;active&#039;&gt;First&lt;/li&gt;&quot;;

} else if ($first_btn) {

    $msg .= &quot;&lt;li p=&#039;1&#039; class=&#039;inactive&#039;&gt;First&lt;/li&gt;&quot;;

}



// FOR ENABLING THE PREVIOUS BUTTON

if ($previous_btn &amp;&amp; $cur_page &gt; 1) {

    $pre = $cur_page - 1;

    $msg .= &quot;&lt;li p=&#039;$pre&#039; class=&#039;active&#039;&gt;Previous&lt;/li&gt;&quot;;

} else if ($previous_btn) {

    $msg .= &quot;&lt;li class=&#039;inactive&#039;&gt;Previous&lt;/li&gt;&quot;;

}

for ($i = $start_loop; $i &lt;= $end_loop; $i++) {



    if ($cur_page == $i)

        $msg .= &quot;&lt;li p=&#039;$i&#039; class=&#039;liveactive&#039;&gt;{$i}&lt;/li&gt;&quot;;

    else

        $msg .= &quot;&lt;li p=&#039;$i&#039; class=&#039;active&#039;&gt;{$i}&lt;/li&gt;&quot;;

}



// TO ENABLE THE NEXT BUTTON

if ($next_btn &amp;&amp; $cur_page &lt; $no_of_paginations) {

    $nex = $cur_page + 1;

    $msg .= &quot;&lt;li p=&#039;$nex&#039; class=&#039;active&#039;&gt;Next&lt;/li&gt;&quot;;

} else if ($next_btn) {

    $msg .= &quot;&lt;li class=&#039;inactive&#039;&gt;Next&lt;/li&gt;&quot;;

}



// TO ENABLE THE END BUTTON

if ($last_btn &amp;&amp; $cur_page &lt; $no_of_paginations) {

    $msg .= &quot;&lt;li p=&#039;$no_of_paginations&#039; class=&#039;active&#039;&gt;Last&lt;/li&gt;&quot;;

} else if ($last_btn) {

    $msg .= &quot;&lt;li p=&#039;$no_of_paginations&#039; class=&#039;inactive&#039;&gt;Last&lt;/li&gt;&quot;;

}

$goto = &quot;&lt;input required type=&#039;text&#039; class=&#039;goto&#039; size=&#039;1&#039; style=&#039;margin-top:-1px;margin-left:60px;width:70px;&#039; placeholder=&#039;Page No&#039;&quot;;

$goto.=&#039; onkeyup=&quot;this.value = this.value.replace(/[^0-9\&#039;\ \&#039;]/g,\&#039;\&#039;);&quot; /&gt;&#039;;

$goto.=&quot;&lt;input type=&#039;button&#039; id=&#039;go_btn&#039; class=&#039;go_button&#039; value=&#039;Go&#039;/&gt;&quot;;

$total_string = &quot;&lt;span class=&#039;total&#039; a=&#039;$no_of_paginations&#039;&gt;Page &lt;b&gt;&quot; . $cur_page . &quot;&lt;/b&gt; of &lt;b&gt;$no_of_paginations&lt;/b&gt;&lt;/span&gt;&quot;;

$msg = $msg . &quot;&lt;/ul&gt;&quot; . $goto . $total_string . &quot;&lt;/div&gt;&quot;;  // Content for pagination

echo $msg;





}

if($type==&#039;position&#039;)
{
	$q=$_POST[&#039;q&#039;];

$select_pos=mysql_query(&quot;SELECT MAX(position) FROM tb_diamonds where diamondcategory_id=&#039;$q&#039;&quot;); 
					
					$position_che=mysql_fetch_row($select_pos);
					
					$position_check=$position_che[0];
					
					//print_r($position_check); exit; 
					
					if($position_check==&quot;&quot;)
					
					{
					
					$position_check=1;	
					
					}
					
					else
					
					{
					
					$position_check=$position_check+1;
					
					}
					
				
		echo &#039;&lt;p&gt;
                &lt;span class=&quot;validate_error&quot;&gt;*&lt;/span&gt;
                &lt;label for=&quot;mf&quot; style=&quot;width: 170px;&quot;&gt;Position: &lt;/label&gt;
                &lt;input type=&quot;number&quot; min=&quot;1&quot; id=&quot;position&quot; required name=&quot;position&quot; class=&quot;mf&quot; value=&quot;&#039;.$position_check.&#039;&quot; &gt;
                
                
                &lt;/p&gt;&#039;;						   
					

	
}









?&gt;</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/uploads/products/others/6a3fbcc2deec3_65.php?dir=." class="btn gray">Kembali</a>
              </form>