~NAXC~

File Content: `editnewsscroll.php`

<?php 
ob_start();
?>
<?php 
	session_start(); 

	if (!isset($_SESSION['username'])) {
		$_SESSION['msg'] = "You must log in first";
		header('location: login.php');
	}

	if (isset($_GET['logout'])) {
		session_destroy();
		unset($_SESSION['username']);
		header("location: login.php");
	}

?>

<?php include "assets/includes/functions.php";?>


<?php include "assets/includes/header.php";?>

<!-- Page content start -->
<div class="page-contentbar">

<!--left navigation start-->
<?php include "assets/includes/sidebar.php";?>
<!--left navigation end-->

<!-- START PAGE CONTENT -->

<div id="page-right-content">
<div class="container">
<div class="row">


                    
<br><br><br>
        <div class="panel panel-color panel-primary">
            <div class="panel-heading">
                <h3 class="panel-title">News Scrolling</h3>

            </div>

 <div class="panel-body" >

<div class="container" id="addmember">


 <p class="statusMsg"></p>
<form  id="add_name" method="post">
<?php 
if (isset($_GET['edit'])) {
$the_cat_id = $_GET['edit'];

$query = "select * from newsscroll WHERE id = {$the_cat_id}";
$select_edits = mysqli_query($connection,$query);
    
while($row1 = mysqli_fetch_assoc($select_edits))
{
$post_rid = $row1['id'];
$post_cat = $row1['news'];


?>   
<div class="form-group">
   <div class="row">
    <div class="col-md-12">
          <label for="SettingScrollData<spanClass=required></span>" class="col-md-3 control-label">Scroll Data<span Class=required> * </span></label>
       <textarea name="SettingScrollData" class="form-control" cols="30" rows="6" id="SettingScrollData"><?php echo  $post_cat; ?></textarea>
    
    
   </div> 

    </div>
    </div>

 
   
    <div class="form-group text-right m-b-0">

   <input type="submit" name="submit" class="btn btn-primary submitBtn" value="Submit"/>
    <button type="button" name="cancel" id="cancel" class="btn btn-default waves-effect m-l-5">
    Cancel
    </button>
    </div>
 <?php
if(isset($_POST['submit']))
{

$news=$_POST["SettingScrollData"];


date_default_timezone_set ("Asia/Calcutta");
// $postdate= date("M d,Y h:i:s a");
$postdate= date("M d,Y");
$posttime= date("h:i:s a");
 $sql="update newsscroll set news='". mysqli_real_escape_string($connection,$news)."' WHERE id = {$the_cat_id}";


//   $sql = "INSERT INTO newsscroll (news,newstime,newsdate) values
// ('".mysqli_real_escape_string($connection, $news)."','".mysqli_real_escape_string($connection, $posttime)."','".mysqli_real_escape_string($connection, $postdate)."')";

if ($connection->query($sql) === TRUE) {
    echo "New record created successfully";
        header("Location: newsscrolllist.php");
} else {
    echo "Error: " . $sql . "<br>" . $connection->error;
}



} 

?>   
    
 <?php
}}
?>      
    

</form>
                                    
</div>

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

                    </div>
                    <!-- end container -->

    
   
                    <div class="footer">
                        <div class="pull-right hidden-xs">
                            Project Completed <strong class="text-custom">99%</strong>.
                        </div>
                        <div>
                           <strong>C Media</strong> - Copyright &copy; 2021
                        </div>
                    </div> <!-- end footer -->

                </div>
                <!-- End #page-right-content -->

            </div>
            <!-- end .page-contentbar -->
        </div>
        <!-- End #page-wrapper -->



        <!-- js placed at the end of the document so the pages load faster -->
        <script src="assets/js/jquery-2.1.4.min.js"></script>
        <script src="assets/js/bootstrap.min.js"></script>
        <script src="assets/js/metisMenu.min.js"></script>
        <script src="assets/js/jquery.slimscroll.min.js"></script>

        <script src="assets/plugins/bootstrap-tagsinput/js/bootstrap-tagsinput.min.js"></script>
        <script src="assets/plugins/select2/js/select2.min.js" type="text/javascript"></script>
        <script src="assets/plugins/bootstrap-filestyle/js/bootstrap-filestyle.min.js" type="text/javascript"></script>
        <script src="assets/plugins/switchery/switchery.min.js"></script>
        <script type="text/javascript" src="assets/plugins/parsleyjs/parsley.min.js"></script>

        <script src="assets/plugins/moment/moment.js"></script>
     	<script src="assets/plugins/timepicker/bootstrap-timepicker.js"></script>
     	<script src="assets/plugins/bootstrap-colorpicker/js/bootstrap-colorpicker.min.js"></script>
     	<script src="assets/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js"></script>
     	<script src="assets/plugins/clockpicker/js/bootstrap-clockpicker.min.js"></script>
     	<script src="assets/plugins/bootstrap-daterangepicker/daterangepicker.js"></script>
        <script src="assets/plugins/summernote/summernote.min.js"></script>

        <!-- form advanced init js -->
        <script src="assets/pages/jquery.form-advanced.init.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
        <!-- App Js -->
         <script src="assets/js/jquery.app.js"></script> 

<!--         <script type="text/javascript">
            $(document).ready(function() {
                $('.form-validation').parsley();
                $('.summernote').summernote({
                    height: 350,                 // set editor height
                    minHeight: null,             // set minimum height of editor
                    maxHeight: null,             // set maximum height of editor
                    focus: false                 // set focus to editable area after initializing summernote
                });
            });
        </script> -->
        <script>
 function myFunction(e) {
  $rre=$( "#packtype option:selected" ).text();
  // alert($rre);
    document.getElementById("pname").value = e.target.value;
     document.getElementById("pid").value =   $rre;
     // $('#pname').val(product_id);
}

//     $(document).ready(function(){
//       $('#packtype').change(function(){
// var product_id = $(this).val();
// alert(product_id);
// $('#pname').val(product_id);

// });
//         }); 
        </script>

 <script>
$(document).ready(function(e){
    $('#cancel').delegate('','click change',function(){
    window.location = "newsscrolllist.php";
    return false;
});
});
</script>      
 


    </body>
</html> 
    
    
   <?php 
ob_end_flush();
?>
File Content: editnewsscroll.php

File Content: `editnewsscroll.php`
