JezK
Edit File: category_management.php
<?php include('admin_functions.php'); if($_SESSION['username']=='') { echo "<script>location.replace('index.php');</script>" ; } ?> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <script type="text/javascript" src="https://www.google.com/jsapi"> </script> <script type="text/javascript"> // Load the Google Transliterate API google.load("elements", "1", { packages: "transliteration" }); function onLoad() { var options = { sourceLanguage: google.elements.transliteration.LanguageCode.ENGLISH, destinationLanguage: [google.elements.transliteration.LanguageCode.TELUGU], shortcutKey: 'ctrl+g', transliterationEnabled: true }; // Create an instance on TransliterationControl with the required // options. var control = new google.elements.transliteration.TransliterationControl(options); //new google.elements.transliteration.TransliterationControl(options); // Enable transliteration in the textbox with id // 'transliterateTextarea'. control.makeTransliteratable(['categoryname']); control.makeTransliteratable(['editcategory']); control.makeTransliteratable(['title']); } google.setOnLoadCallback(onLoad); function validateadd(){ var categoryname = document.getElementById('categoryname').value; var categoryname_english = document.getElementById('categoryname_english').value; if(categoryname == '' || categoryname.trim() == ''){ alert('Please Enter the Telugu category name'); return false; } if(categoryname_english == '' || categoryname_english.trim() == ''){ alert('Please Enter the English category name'); return false; } } </script> <?php $admin=new adm_functions(); if(isset($_POST['action']) && $_POST['action'] == "Save"){ $result=$admin->add_category($_POST); if($result == "200"){ echo "<script>alert('Category Added Successfully.');</script>"; echo "<script>location.replace('category_management.php');</script>"; } } if(isset($_POST['action']) && $_POST['action'] == "update"){ $result=$admin->update_category($_POST); if($result == "200"){ echo "<script>alert('Category Updated Successfully.');</script>"; echo "<script>location.replace('category_management.php');</script>"; } } $categorydata = $admin->get_category(); $i=1; $cate_data = ''; foreach($categorydata as $k=>$val){ $id = (string)$val['id']; $cate_data .= '<tr><td>'.$i.'</td> <td>'.$val['name_en'].'</td> <td>'.$val['name_te'].'</td> <td>'.$val['count'].'</td> <td><a href="#" data-toggle="modal" data-target="#myModal2" onclick="updatecategory(\''.$id.'\',\''.$val['name_te'].'\',\''.$val['name_en'].'\')"><input type="button" class="btn btn-primary" value="Edit"></a> <a href="deletecategory.php?id='.$id.'" data-toggle="modal" ><input type="button" class="btn btn-primary" value="Delete"></a> </td> </tr>'; $i++; } $currentPage='category_management'; include"header.php" ?> <div class="main-panel"> <nav class="navbar navbar-default"> <div class="container-fluid"> <div class="navbar-header"> <button type="button" class="navbar-toggle"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar bar1"></span> <span class="icon-bar bar2"></span> <span class="icon-bar bar3"></span> </button> <a class="navbar-brand" href="#">Category Management</a> </div> </div> <div class="collapse navbar-collapse"> </div> </nav> <div class="content"> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div> <div class="pull-left"><a href="#" data-toggle="modal" data-target="#myModal1"><button class="btn btn-default">Add</button></a></div> <div class="pull-right"><p>Total No.Of Categories:15</p></div> </div> <br><br><br> <div class="content table-responsive table-full-width"> <table class="table table-striped" id="example"> <thead> <th>S.No</th> <th>Category in English</th> <th>Category in Telugu</th> <th>No.of news </th> <th>Action</th> </thead> <tbody> <?php echo $cate_data; ?> </tbody> </table> </div> </div> </div> </div> </div> <!-- Modal for add--> <div class="modal fade" id="myModal1" role="dialog"> <div class="modal-dialog "> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> <h4 class="modal-title">Add New Category</h4> </div> <div class="modal-body"> <form method="post" > <div class="form-group"> <label for="name">Category Name(Telugu):</label> <input type="text" id="categoryname" name="categoryname" > </div> <div class="form-group"> <label for="name">Category Name(English):</label> <input type="text" id="categoryname_english" name="categoryname_english" > </div> <div class=""> <button type="submit" class="btn btn-primary" onclick="return validateadd()">Add</button> <a type="button" class="btn btn-danger" href="category_management.php">Cancel</a> </div> <input type="hidden" name="action" id="action" value="Save"> </form> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> </div> </div> </div> </div> <!-- Modal for edit --> <div class="modal fade" id="myModal2" role="dialog"> <div class="modal-dialog "> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> <h4 class="modal-title">Edit Category</h4> </div> <div class="modal-body"> <form method="post"> <div class="form-group"> <label for="name">Category Name:</label> <input type="text" name="editcategory" id="editcategory" class="form-control"> </div> <div class="form-group"> <label for="name">Category Name ENG:</label> <input type="text" name="editcategory_en" id="editcategory_en" class="form-control"> </div> <div class=""> <button type="submit" class="btn btn-primary">Update</button> <button type="button" class="btn btn-danger" data-dismiss="modal">Cancel</button> </div> <input type="hidden" name="action" id="action" value="update"> <input type="hidden" name="categoryid" id="categoryid" value=""> </form> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> </div> </div> </div> </div> <?php include"footer.php" ?> <script> $(document).ready(function() { $('#example').DataTable(); }) function updatecategory(catid,catename,catenameen){ // data-target="#myModal2" document.getElementById('editcategory').value = catename; document.getElementById('editcategory_en').value = catenameen; document.getElementById('categoryid').value = catid; } function deletecategory2(catid){ var r = confirm("Are you sure want to delete the category?"); if(r == true){ document.location = "deletecategory.php?catid="+catid; }else{ document.location = "category_management.php"; } } </script> <link href="https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css" rel="stylesheet"> <script src="//code.jquery.com/jquery-1.12.4.js"></script> <script src="https://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"></script>