title: How to insert image and date in php
body: <pre><code>if(isset($_POST['post-submit'])){
  
      $post_category_id = $_POST['post_category_id'];
      $post_title = $_POST['post_title'];
      $post_author = $_POST['post_author']; 
      $post_tags = $_POST['post_tags'];
      $post_status = $_POST['post_status'];
  
      $post_content = $_POST['post_content'];
      // SQL Injection
      $post_content = mysqli_real_escape_string($connection, $post_content );
  
      $post_date = date('d-m-y');
      $post_comment_count = 4;
  
      $post_image = $_FILES['image']['name'];
      $post_image_temp = $_FILES['image']['temp_name'];
      move_uploaded_file($post_image_temp, "../img/blog/$post_image" );
  
      $query  = "INSERT INTO posts(post_image,post_date,post_comment_count, post_category_id, post_title, post_author, post_tags, post_status, post_content) " ;
      $query .= "VALUES('$post_image', now(), '$post_comment_count' ,'$post_category_id','$post_title','$post_author','$post_tags','$post_status','$post_content')";
  
      $insert_all_post_query = mysqli_query($connection, $query);
  
      if(!$insert_all_post_query) {
        die("QUERY FAILED" . mysqli_error($connection));   
      } else {
        echo "&lt;h2&gt;Data Sucessfully Updated&lt;/h2&gt;";
      }
  }
  </code></pre>
  
  <p>Notice: Undefined index: temp_name in C:\xampp\htdocs\cms_admin\admin\postCreate.php on line 35</p>
  
  <p>getting this error - but post is getting inseted perfectly </p>