1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / manager /
Filename : add-post.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');
include('include/functions.php');
// Enable error reporting
error_reporting(E_ALL);
ini_set('display_errors', 1);


$title="Add Farmer";
$current_date = date("Y-m-d");


if(isset($_POST['submit'])) {
  $title = $_POST['title'];
  $description = $_POST['description'];
  $url = $_POST['url'];


           // Assuming you have a database connection established, perform the SQL insertion using prepared statements
    $sql = "INSERT INTO `tasks` (`title`, `url`,`description`, `created_at`) VALUES (?, ?, ?, ?)";

    $stmt = $con->prepare($sql);
    $stmt->bind_param("ssss", $title, $url, $description,$current_date);

    if ($stmt->execute()) {
        $msg = "New Post Added Successfully";
        $type = "success";
    } else {
        $msg = "Something went wrong, please try again.";
        $type = "warning";
    }

  }
?>

  <!-- Content wrapper -->
  <div class="content-wrapper">
            <!-- Content -->

<div class="container-xxl flex-grow-1 container-p-y">
<h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">New/</span> Add Advert Post</h4>
 
 <div class="card mb-4">
                    <h5 class="card-header">New Post</h5>
                    <!-- Account -->
                    <hr class="my-0" />
                    <div class="card-body">
                    <?php if(isset($msg)){ ?>
                    <div class="alert alert-<?php echo $type?>">
                          <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                          <p class="mb-0"><?php echo $msg?></p>
                        </div>
                        <?php }?>
                    <form  method="post" action="" enctype="multipart/form-data">
                        <div class="row">
                        <div class="mb-3 col-md-12">
                        <label class="form-label" for="basic-default-fullname">Caption</label>
                        <input type="text" name="title" class="form-control"  value="<?php if(isset($_POST['title'])) echo $_POST['title']; ?>">
                      </div>
                      <div class="mb-3 col-md-12">
                        <label class="form-label" for="basic-default-fullname">Description</label>
                        <textarea class="form-control" name="description" > </textarea>
                      </div> 
                    
                      <div class="mb-3 col-md-12">
                        <label class="form-label" for="basic-default-fullname">URL</label>
                        <input type="url" name="url" class="form-control"  value="<?php if(isset($_POST['url'])) echo $_POST['url']; ?>">
                      </div>
                        </div>
                        <div class="mt-2">
                          <button type="submit" class="btn btn-primary me-2" type="submit" name="submit" >Submit</button>
                        </div>
                      </form>
                    </div>
                    <!-- /Account -->
                  </div>
</div></div>

             
              </div>
            </div>
            <!-- / Content -->
<?php include('include/footer.php');?>=p