title: submitting PHP - HTML DATE to MySQL DATE
body: <p>i would like to help with my code how to edit HTML input date into MySQL TIMESTEMP format cause my SQL code is invalid and data are not added to my database, Thanks for help</p>
  
  <p>also i asking to check this code on bottom cause 2nd SQL deppends on 1st SQL, thanks</p>
  
  <pre><code>if (isset($_POST['pridaj_anime_submit'])) {
     $sql_vloz_anime = "INSERT INTO anime (a_name, a_year, a_translated_min, a_translated_max, a_rate_min, a_rate_max, a_edit, a_condition)
                                VALUES ('$_POST[nazov]', '$_POST[rok]', '0', '$_POST[pocet]', '8', '10', '$_POST[preklad]', '$_POST[stav]')";
     mysqli_query($connect_to_db , $sql_vloz_anime);
     $sql_ziskaj_a_id_pridaneho_anime = "SELECT * FROM anime WHERE a_name = '$_POST[nazov]'";
     $run_sql_ziskaj_a_id_pridaneho_anime = mysqli_query($sql_ziskaj_a_id_pridaneho_anime);
     $a_id_ziskane = "";
  while ($db_data = mysqli_fetch_assoc($run_sql_ziskaj_a_id_pridaneho_anime)) {
      $a_id_ziskane = $db_data['a_id'];
  }
  
     $sql_vloz_anime_info = "INSERT INTO anime_info (a_id, a_img, a_start, a_stop, a_time_ep, a_akihabara)
                                          VALUES ('$a_id_ziskane' , '$_POST[obrazok]', '$_POST[zaciatok]', '$_POST[koniec]', '$_POST[cas]', '$_POST[akihabara]')";
     mysqli_query($connect_to_db , $sql_vloz_anime_info);
  }
  </code></pre>