Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <link href="style.css" rel="stylesheet" type="text/css">
- <?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);
- }
- if ($_POST['submit'] == "delete") {
- $id_evento = $_POST['id_evento'];
- $sql = "DELETE FROM eventos WHERE id_evento='". $id_evento ."'";
- $delete = mysql_query($sql);
- }
- }
- $sql = " SELECT * FROM eventos NATURAL JOIN tipos_eventos ";
- $query = mysql_query($sql);
- while ($row = mysql_fetch_assoc($query)) {
- ?>
- <link href="../style.css" rel="stylesheet" type="text/css">
- <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"> </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"> </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> </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"> </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"> </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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement