revealability

Back Back Up Advanced Editor

<?php
  session_start();
  include '../assets/constant/config.php';

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  } catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
  }
  ?>

<?php include('include/sidebar.php'); ?>

<?php include('include/header.php'); ?>
<div class="page-content-wrapper ">

</div>
          <h4 class="page-title">Edit Event</h4>
        </div>
      </div>
      <div class="clearfix"></div>
    </div>
    
    <div class="row">
      <div class="col-lg-12">
        <div class="card">
          <div class="card-body">

<div class="tab-pane active p-3" id="home" role="tabpanel">
                <form name="myform" action="app/event_crud.php" class="row" method="POST" enctype="multipart/form-data" onsubmit="return validation()" id="edit_team">
                  <?php
                  $stmt = $conn->prepare("SELECT * FROM `events` WHERE id='" . $_POST['id'] . "' ");
                  $stmt->execute();
                  $record = $stmt->fetchAll();

foreach ($record as $key) { ?>

<div class="form-group col-md-6">
                      <label class="control-label">Name*</label>
                      <input class="form-control" type="text" name="name1" value="<?php echo $key['name1'] ?>" required="" />
                    </div>

<div class="form-group col-md-6">
                      <label class="control-label">Description<span class="text-danger">*</span></label>
                      <textarea class="form-control" type="text" id="ckeditor" name="description"><?php echo $key['description'] ?></textarea>
                    </div>
                    <div class="form-group col-md-6">
                    <label class="control-label">Address<span class="text-danger">*</span></label>
                   
                    <textarea class="form-control" type="text" name="address" id="ckeditor1"><?php echo $key['address'] ?></textarea>
                  </div>

<div class="form-group col-md-6">
                      <label class="control-label">Existing Photo (file size must be 667 * 1000 pixel) </label><br>
                      <?php
                                                // Read the image file and encode it to Base64
                                                $imagePath = "../assets/images/" . $key['photo']; // Path to your image file
                                                $imageData = file_get_contents($imagePath);
                                                $base64Image = base64_encode($imageData);
                                                ?>
                      <input type="hidden" value="<?php echo $key['photo'] ?>" name="old_photo_img">
                      <img class="img-fluid" src="data:image/jpeg;base64,<?php echo $base64Image; ?>" style="width:100px;height:auto;"><br>
                    </div>

<div class="form-group col-md-6">
                      <label class="control-label">Change Photo</label>
                      <input class="form-control" type="file" name="photo" accept=".jpg,.jpeg">
                    </div>

<div class="form-group col-md-6">
                      <label class="control-label">Event Date<span class="text-danger">*</span></label>
                      <input class="form-control" type="date" name="event_date" value="<?php echo $key['event_date'] ?>">
                    </div>

<div class="form-group col-md-6">
                    <label class="control-label">Time<span class="text-danger">*</span></label>
                    <input class="form-control" type="time" name="time" value="<?php echo $key['time'] ?>">
                  </div>
                  
                     
                          <div class="mydiv">
       
       
                                <?php 
                                                  $stmtq=$conn->prepare("SELECT * FROM `images` WHERE event_id='".$_POST['id']."' ");
                                          $stmtq->execute();
                                          $recordq=$stmtq->fetchAll();

foreach ($recordq as $keyq) { ?>
       
                           
                         <div class="form-group control-group row subdiv">
                             <div class="col-sm-1 sr_no"></div>
                          
                                        <div class="col-sm-5">
                                            <img src="../assets/images/<?php echo $keyq['photo']; ?>" width="80px">
                                             <input type="hidden" name=old_img[] value="<?php echo $keyq['photo']; ?>">
                                            <input type="file" name=img[]>
                                            
                                            
                          </div>

<button class="btn btn-primary" type="submit" name="update" onclick="editTeam()">Update</button>

</div>
                  <?php } ?>
                </form>
              </div>

</div>

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

<?php include('include/footer.php'); ?>

$('#edit_team').validate({
      rules: {
        name1: {
          required: true,
          lettersonly
        },
        description: {
          required: true
        },
         event_date: {
          required: true
        },
         time: {
          required: true
        },
        photo: {
          required: true,
          extension: "png|jpeg"
        }
      },
      messages: {
        name1: {
          required: "Please enter a name."
        },
        description: {
          required: "Please select a description."
        },
        photo: {
          required: "Please select a photo.",
          extension: "Only PNG and JPEG files are allowed."
        }
      },

});
  };
</script>
<script>
  function validation() {
    var fileInput = document.getElementById('add_team').photo;
    var filePath = fileInput.value;
    var allowedExtensions = /(\.jpg|\.jpeg|\.png)$/i;

if (!allowedExtensions.exec(filePath)) {
      alert('Invalid file type! Please upload a JPG, JPEG, or PNG image.');
      fileInput.value = '';
      return false;
    }
    return true;
  }
</script>
<script type="text/javascript">
  $(".add-more").on('click',function(){ 
    
          var html = $(".copy").html();
          $(".after-add-more").before(html);
        //  $(".after-add-more").next().find('select[name^="product_id"]').select2();
          show_no();
      });

$("body").on("click",".remove",function(){ 
          $(this).parents(".control-group").remove();
          show_no();
      });
function show_no()
{
    var row_cnt=0;
  $( ".sr_no" ).each(function() {
      row_cnt++;
    $( this ).html(row_cnt);
    });
}
</script>