Untitled

<?php
$dbhost = "localhost";
$dbname = "cea_db";
$dbuser = "root";
$dbpass = "swork";
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());


if(!empty($_POST)) {
  if ($_POST['submit'] == "edit") {
  //EDITAR REGISTO

$uploaddir = $_SERVER["DOCUMENT_ROOT"] .'/upload/';
$uploadfile = $uploaddir . basename($_FILES['uploadedfile']['name']);

if (move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $uploadfile)) {
    $uperr = "0";
} else {
    $uperr = "1";
}


  $id_evento = $_POST['id_evento'];
  $nome_evento = $_POST['nome_evento'];
  $data_inicio_evento = $_POST['data_inicio_evento'];
  $data_fim_evento = $_POST['data_fim_evento'];
  $hora_inicio_evento = $_POST['hora_inicio_evento'];
  $local_evento = $_POST['local_evento'];
  $descricao_evento = $_POST['descricao_evento'];
  $tipos_eventos = $_POST['tipos_eventos'];
  $img = $uploadfile;

  $sql = "UPDATE eventos SET nome_evento='". $nome_evento ."', data_inicio_evento='". $data_inicio_evento ."', data_fim_evento='". $data_fim_evento ."', hora_inicio_evento='". $hora_inicio_evento ."', local_evento='". $local_evento ."', descricao_evento='". $descricao_evento ."' WHERE id_evento='". $id_evento ."' WHERE uploadedfile='". $img ."'";
  $update = mysql_query($sql);

echo $sql ."<br>";
}
if ($_POST['submit'] == "delete") {

$id_evento = $_POST['id_evento'];

$sql = "DELETE FROM eventos WHERE id_evento='". $id_evento ."'";
$delete = mysql_query($sql);
}
}

?>
<html>
<link href="style.css" rel="stylesheet" type="text/css">
<link href="../style.css" rel="stylesheet" type="text/css">
<?php
$sql = " SELECT * FROM eventos NATURAL JOIN tipos_eventos ";
$query = mysql_query($sql);
 while ($row = mysql_fetch_assoc($query)) {
?>
<table border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> <td height="204" align="center">
 <form name="form<?php echo $row['id_evento']; ?>" enctype="multipart/form-data" method="POST" action="?page=editar_remover_evento">
 <input type="hidden" name="id_evento" value="<?php echo $row['id_evento']; ?>">
 <table width="461" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="23"><img src="../images/admin_bg_tit_01.gif" width="23" height="29" /></td>
        <td width="407" align="center" valign="middle" background="../images/admin_bg_tit_02.gif" class="box_tit">Editar/Remover Eventos</td>
        <td width="31"><img src="../images/admin_bg_tit_03.png" width="31" height="29" /></td>
      </tr>
      <tr>
        <td rowspan="3" background="../images/admin_bg_tit_04.gif">&nbsp;</td>
        <td bgcolor="#d4dbdb"><table width="461" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="189"><table width="188" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="188"><span class="style8">
                </span><span class="style5">nome: <input type="text" name="nome_evento" value="<?php echo $row['nome_evento']; ?>"> </span>
                </span></td>
              </tr>
            </table></td>
            <td width="58">&nbsp;</td>
            <td width="214"><table width="214" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="215" align="right" id="">de <input type="text" name="data_inicio_evento" value="<?php echo $row['data_inicio_evento']; ?>"> a <input type="text" name="data_fim_evento" value="<?php echo $row['data_fim_evento']; ?>"></span><span class="style5"></span></td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td>horas: <input type="text" name="hora_inicio_evento" value="<?php echo $row['hora_inicio_evento']; ?>"></td>
            <td>&nbsp;</td>
            <td align="right"> local: <input type="text" name="local_evento" value="<?php echo $row['local_evento']; ?>"></td>
          </tr>
          <tr>
            <td colspan="2">descrição: <input type="text" name="descricao_evento" value="<?php echo $row['descricao_evento']; ?>"></td>
            <td align="right">tipo: <input type="text" name="tipos_eventos" value="<?php echo $row['tipos_eventos']; ?>"></td>
            </tr>
        </table></td>
        <td rowspan="3" background="../images/admin_bg_tit_06.gif">&nbsp;</td>
      </tr>
      <tr>
        <td height="24" align="center" valign="top" bgcolor="#d4dbdb">  <input type="hidden" name="MAX_FILE_SIZE" value="30000" />
Imagem: <input name="uploadedfile" type="file" /></td>
      </tr>
      <tr>
        <td height="24" align="center" valign="top" bgcolor="#d4dbdb"><input type="submit" name="submit" value="edit" /> <input type="submit" name="submit" value="delete" />      </tr>
      <tr>
        <td height="26"><img src="../images/admin_bg_tit_07.gif" width="23" height="26" /></td>
        <td background="../images/admin_bg_tit_08.gif">&nbsp;</td>
        <td><img src="../images/admin_bg_tit_09.gif" width="31" height="26" /></td>
      </tr>
    </table>
  <tr>
    <td height="12" align="center">
  </form>
      <?php } ?>
      </table>
      </tr>
      </td>
</table>
</html>