<h2>Edit File - news_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/news_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;]);

$title=specialchar($title);



$desc=trim($_POST[&#039;desc&#039;]);

$desc=specialchar($desc);



$image=$_FILES[&#039;image&#039;][&#039;name&#039;];

 $filesize=$_FILES[&#039;image&#039;][&#039;size&#039;];

$image=str_replace(&#039; &#039;,&#039;_&#039;,$image);



$position=trim($_POST[&#039;position&#039;]);







function deletedir($path)//by 

{



    $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);

}









 if($title==&quot;&quot; || $image==&quot;&quot;  )

 {

	 header(&#039;location:add_news.php?error=1005&#039;);

		exit;

 }

 

 





	

	

	$total=total(tb_news,&quot;news_name=&#039;$title&#039;&quot;);

	

	if($total != 0)

	{

	 header(&#039;location:add_news.php?error=1018&#039;);

		exit;

	}

	

	

	

	

	if($position!=&quot;&quot;)

	{

		$serpos=$position;

		

	}

	

	else

	{

	

	$result=mysql_query(&quot;SELECT MAX(position) FROM tb_news&quot;);

 	$row=mysql_fetch_row($result);

	$serpos=$row[0]+1;

	}







	//start

	

	$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;];

	

	

	$path=DATA_FOLDER.&quot;/news/original_image&quot;;

	$path1=DATA_FOLDER.&quot;/news/thumb_image&quot;;

	

	$file_ext=imageTypeCheck($image);

	$file_size=imageSizeCheck($image,$filesize);

	

	

	

	

	$obj=mysql_query(&quot;INSERT INTO `tb_news` (`news_name`, `news_desc`, `news_image`, `news_addedon`, `position`) VALUES (&#039;$title&#039;, &#039;$desc&#039;, &#039;$image&#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();

					

			

					

					

					//create thunb image

					$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/news/original_image&quot;;



	



					 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];

				$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,$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;news&#039;,&#039;$serpos&#039;)&quot;);



		}

	}

	

					

	header(&#039;location:add_news.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_position=trim($_POST[&#039;position&#039;]);



$beforeposition=trim($_POST[&#039;beforeposition&#039;]);



$beforenews=trim($_POST[&#039;beforenews&#039;]);



$update_id=trim($_POST[&#039;editid&#039;]);



$update_image=$_POST[&#039;editimage&#039;];



$image=$_FILES[&#039;image&#039;][&#039;name&#039;];

$image=str_replace(&#039; &#039;,&#039;_&#039;,$image);

 $filesize=$_FILES[&#039;image&#039;][&#039;size&#039;];





$update_title=specialchar($update_title);

$update_desc=specialchar($update_desc);



$total=total(tb_news,&quot;news_name=&#039;$update_title&#039; and news_id!=&#039;$update_id&#039;&quot;);

	

	if($total != 0)

	{

	 header(&#039;location:edit_news.php?news_id=&#039;.$update_id.&#039;&amp;error=1018&#039;);

		exit;

	}

	

 

/*	if($update_position!=$beforeposition)

	{

		$total=total(tb_news,&quot;position=&#039;$update_position&#039;&quot;);

		

		if($total != 0)

		{

		 header(&#039;location:edit_news.php?news_id=&#039;.$update_id.&#039;&amp;error=1017&#039;);

			exit;

		}

	}

	*/

	//start

	

	if($image!=&quot;&quot;)

	{

	

	$path=DATA_FOLDER.&quot;/news/original_image&quot;;

	$path1=DATA_FOLDER.&quot;/news/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_news.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_news` SET `news_name`=&#039;$update_title&#039;, `news_desc`=&#039;$update_desc&#039;, `news_image`=&#039;$image&#039;,`position`=&#039;$update_position&#039; WHERE  `news_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();

					

				

					

					

					//create thunb image

					$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_news` SET `news_name`=&#039;$update_title&#039;, `news_desc`=&#039;$update_desc&#039;,`position`=&#039;$update_position&#039; WHERE  `news_id`=&#039;$update_id&#039;;&quot;);

	}

		//////////////////////////////////////////////////////////////

		$path11=DATA_FOLDER.&quot;/multiple_image/news/original_image&quot;;



	

	



					 if(!is_dir($path11.&quot;/&quot;.$update_id)){

						mkdir($path11.&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,$path11.&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,position) VALUES(&#039;&#039;,&#039;&#039;,&#039;$finalimage&#039;,$time,&#039;$update_id&#039;,&#039;news&#039;,&#039;$serpos&#039;)&quot;);



		}

	}



	////////////////////////////////////////////////////////////

	



	header(&#039;location:add_news.php?sucess=1010&amp;str=&#039;.$_REQUEST[&#039;str&#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;news_id&#039;];

	





$path1=DATA_FOLDER.&quot;/news/thumb_image/$delete_id/&quot;;

$pathO=DATA_FOLDER.&quot;/news/original_image/$delete_id/&quot;;

$path11=DATA_FOLDER.&quot;/multiple_image/news/original_image/$delete_id/&quot;;



if (is_dir($path1))

{

	  deletedir($path1);

}

if (is_dir($pathO))

{	 

	  deletedir($pathO);

}

if(file_exists($path11))

{	 

deletedir($path11);

}







	mysql_query(&quot;delete from tb_news where news_id=$delete_id&quot;);

		mysql_query(&quot;delete from tb_gallery where type=&#039;news&#039; and mapping_id=&#039;$delete_id&#039;&quot;);

	echo 1;

		//	header(&#039;location:add_news.php?sucess=1009&amp;page=&#039;.$_REQUEST[&#039;page&#039;].&#039;&amp;search=&#039;.$_REQUEST[&#039;search&#039;]);

			exit;



	

	

}





if($type==&quot;deleteall&quot;)

{

function deletedir($path)

{



    $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);

}



	$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;/news/thumb_image/&quot;.$_POST[&#039;check&#039;][$i].&quot;/&quot;;

		$pathO=DATA_FOLDER.&quot;/news/original_image/&quot;.$_POST[&#039;check&#039;][$i].&quot;/&quot;;

        $path11=DATA_FOLDER.&quot;/multiple_image/news/original_image/&quot;.$_POST[&#039;check&#039;][$i].&quot;/&quot;;

		if (is_dir($path1))

		{

			deletedir($path1);

		}

		if (is_dir($pathO))

		{	 

			deletedir($pathO);

		}

		if (is_dir($path11))

		{	 

			deletedir($path11);

		}



		

			mysql_query(&quot;delete from tb_news where news_id=&#039;&quot;.$_POST[&#039;check&#039;][$i].&quot;&#039;&quot;);

	        mysql_query(&quot;delete from tb_gallery where type=&#039;news&#039; and mapping_id=&#039;&quot;.$_POST[&#039;check&#039;][$i].&quot;&#039;&quot;);

			

		}

		header(&#039;location:add_news.php?sucess=1009&amp;str=&#039;.$_REQUEST[&#039;str&#039;].&#039;#page=&#039;.$_REQUEST[&#039;page&#039;].&#039;#1&#039;);

			exit;

}

if($type==&quot;delemul&quot;)



{

	

$newsid=$_GET[&#039;newsid&#039;];



$image=$_GET[&#039;image&#039;];







$mapping_id=$_GET[&#039;maping_id&#039;];







//$type=$_GET[&#039;type&#039;];





$path=DATA_FOLDER.&quot;/multiple_image/news/original_image/$newsid/$image&quot;;



unlink(&quot;$path&quot;);	          



mysql_query(&quot;delete from tb_gallery where gallery_id=$mapping_id&quot;);	







header(&#039;location:edit_news.php?news_id=&#039;.$newsid.&#039;&amp;sucess=1008#gallery&#039;); 



exit;



	

	

	

	

	

}



if($type==&quot;view&quot;)

{

	if($_POST[&#039;page&#039;])

{

$str =$_POST[&#039;str&#039;];

if($str==&quot;undefined&quot;)
{
	$str=&quot;&quot;;
}

$s=$_REQUEST[&#039;s&#039;];


$perpage =$_POST[&#039;perpage&#039;];	

if($str!=&quot;&quot;){

$condition=&quot;(news_name like &#039;%&quot;.$str.&quot;%&#039;)&quot;;

 

$condition1=&quot;where $condition&quot;;

}

else

{

	$condition1=&quot;&quot;;

}

	 

$page =$_POST[&#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 &quot;select * from tb_news $condition1 order by position desc LIMIT $start, $per_page&quot;;

$query_pag_data = &quot;select * from tb_news $condition1 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;news_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;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;searchName()&quot;&gt;Search &lt;/a&gt;

&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;news_action.php?type=deleteall&amp;page=&#039;.$page.&#039;&amp;search=&#039;.$_GET[&#039;search&#039;].&#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;News &amp; Events Title&lt;/td&gt;

												&lt;td&gt;Thumb Image&lt;/td&gt;

                                                &lt;td&gt;Position&lt;/td&gt;

                                                &lt;td&gt;Added on&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))

									{

										

									

									if ($i % 2 == 0) {$even=1;}else{ $even=&quot;&quot;;}

									

									

											$msg.=&#039;&lt;tr id=&quot;&#039;.$result1[&#039;news_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;news_id&#039;].&#039;&quot;&gt;&lt;/td&gt;

                                                &lt;td&gt;&#039;.$result1[&#039;news_name&#039;].&#039;&lt;/td&gt;

                                     &lt;td&gt;&lt;img src=&quot;&#039;.DATA_FOLDER.&#039;/news/thumb_image/&#039;.$result1[&#039;news_id&#039;].&#039;/&#039;.$result1[&#039;news_image&#039;].&#039;&quot;  height=&quot;50px&quot;/&gt;									&lt;/td&gt;

                                                &lt;td&gt;&#039;.$result1[&#039;position&#039;].&#039;&lt;/td&gt;

												&lt;td&gt;&#039;.dates($result1[&#039;news_addedon&#039;]).&#039;&lt;/td&gt;

												&lt;td&gt;


                                                &lt;p class=&quot;dis_&#039;.$result1[&#039;news_id&#039;].&#039;&quot;&gt;&lt;a title=&quot;View / Edit&quot; class=&quot;button tooltip&quot; href=&quot;edit_news.php?news_id=&#039;.$result1[&#039;news_id&#039;].&#039;&amp;page=&#039;.$cur_page.&#039;&amp;str=&#039;.$str.&#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;confirmDeletes(&#039;.$result1[&#039;news_id&#039;].&#039;)&quot;&gt;&lt;span class=&quot;ui-icon ui-icon-trash&quot;  &gt;&lt;/span&gt;Delete&lt;/a&gt; 

                                                

                                                &lt;/p&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





/* --------------------------------------------- */

$query_pag_num = &quot;SELECT COUNT(*) AS count FROM tb_news $condition1&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;





}









?&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>