Good day!

I encountered error in saving data data in my database.

First, I have code for uploading/importing .xml file to database.

in my .xml file the date is : 10/1/2011 but when it was display in webpage the result is :
2011-01-10T00:00:00.000

and I used
PHP Code:
$date substr($date,0,-13); 
to remove the last part.

and now I used this code:
PHP Code:
$date strtotime($date); 
 
$date date('d-m-Y'$date); 
to change the format of date..the good thing is it was display as 01-10-2011 when I run that code. But it did not save in database.

Here is my whole code:
PHP Code:
<?php
$data 
= array();


$con mysql_connect("localhost""root","");
if (!
$con) { 
  die(
mysql_error());
}
$db mysql_select_db("db_upload"$con);
if (!
$db) { 
  die(
mysql_error());
}

$sql "select * from employee";
$result =  mysql_query($sql$con);
if (!
$result) {
    die(
mysql_error());
}
$total mysql_num_rows($result);
if (
$total 0) {
    
$sql "delete from employee";
    
$result =  mysql_query($sql$con);
    if (!
$result) {
        die(
mysql_error());
    }
}
  
function 
add_employee($emp$employee$last$mi$date$time)
  {
      global 
$data
      
      
$con mysql_connect("localhost""root","");
      if (!
$con){ die(mysql_error());}
      
$db mysql_select_db("db_upload"$con);
      if (!
$db) { 
          die(
mysql_error());
      }

      
$emp $emp;
      
$employee $employee;
      
$last $last;
      
$mi $mi;
   
      
$date substr($date,0,-13);
      
$time substr($time,11,-4);
      
$date strtotime($date); 
      
$date date('d-m-Y'$date);
      
      
$time strftime('%I:%M %p'strtotime($time));


           
      
$sql "INSERT INTO employee (EMP_NO, Name, last, mi, date, time) VALUES ('$emp', '$employee', '$last', '$mi', '$date', '$time')";
      
mysql_query($sql$con);
      
    
      
$data []= array('EMP_NO' => $emp'Name' => $employee'last' => $last'mi' => $mi'date' => $date'time' => $time);
      
  }
  
  if ( 
$_FILES['file']['tmp_name'] )
  {
      
$dom DOMDocument::load$_FILES['file']['tmp_name'] );

      
$rows $dom->getElementsByTagName'Row' );
      global 
$last_row;
      
$last_row false;
      
$first_row true;
      foreach (
$rows as $row)
      {
          if ( !
$first_row )
          {
             
              
$emp "";
              
$employee "";
              
$last "";
              
$mi "";
              
$date "";
              
$time "";
              
              
              
$index 1;
              
$cells $row->getElementsByTagName'Cell' );
          
              foreach( 
$cells as $cell )
              { 
                  
$ind $cell->getAttribute'Index' );
                  if ( 
$ind != null $index $ind;
                  
                  if ( 
$index == $emp $cell->nodeValue;
                  if ( 
$index == $employee $cell->nodeValue;
                  if ( 
$index == $last $cell->nodeValue;
                  if ( 
$index == $mi $cell->nodeValue;
                  if ( 
$index == $date $cell->nodeValue;
                  if ( 
$index == $time $cell->nodeValue;
                  
$index += 1;
              }
         
              if (
$emp=='' and $employee=='' and $last=='' and $mi=='' and $date=='' and $time=='') {
                    
$last_row true;
              }      
              else {
                
                    
add_employee($emp$employee$last$mi$date$time);
              }      
          }
          if (
$last_row==true) {
              
$first_row true;
          }     
          else {
              
$first_row false;
          }
       
      }
  }
  
?>
  
  <html>
  <body>
  <table>
  <tr>
      <th>Employee Attendance</th>
  </tr>

  <?php foreach( $data as $row ) { ?>
  <tr>
  <td><?php echo( $row['EMP_NO'] ); ?></td> 
  <td><?php echo( $row['Name'] ); ?></td>
  <td><?php echo( $row['last'] ); ?></td>
  <td><?php echo( $row['mi'] ); ?></td>
  <td><?php echo( $row['date'] ); ?></td>
  <td><?php echo( $row['time'] ); ?></td>
  </tr>
  <?php ?>
  </table>
  </body>
 </html>
Thank you