title: Importing dates to mysql by csv file problem
body: <p>I hope someone could give me a quick answer to my question, since i'm not very good in PHP &amp; MySQL.</p>
  
  <p>I want to import a CSV File which includes 2 dates: <code>1-5-2017</code> and <code>31-5-2018</code>.</p>
  
  <p>When i import the csv trough mysql, the dates look like <code>0000-00-00</code></p>
  
  <p>My code:</p>
  
  <pre><code>while (($column = fgetcsv($file, 10000, ";")) !== FALSE) {
      $sqlInsert = "INSERT into employees (naam,functie,afdeling,contract,DID,DUD,manager,profiel)
                    values ('" . $column[0] . "','" . $column[1] . "','" . $column[2] . "','" . $column[3] . "','" . $column[4] . "', '" . $column[5] . "','" . $column[6] . "','" . $column[7] . "')";
      $result = mysqli_query($conn, $sqlInsert);
  </code></pre>
  
  <p>Thanks</p>