
Originally Posted by
Nile
Could you show us all of your code so that we can see anything that may of been done wrong? Also - when showing us errors, please copy and paste. Thanks
PHP Code:
<?PHP
if(!isset($_SESSION))
{
session_start();
}
if (!$_SESSION['userID']) {
header("Location: http://".$_SERVER['HTTP_HOST']
.dirname($_SERVER['PHP_SELF'])
."/login.php");
exit;
}
if (!isset($_POST['form_datum'])) $_POST['form_datum'] = '';
if (!isset($_POST['form_medium'])) $_POST['form_medium'] = '';
if (!isset($_POST['form_prtext'])) $_POST['form_prtext'] = '';
if (!isset($status)) $status = '';
if (isset($_POST['upload'])) {
if (isset($_POST['form_datum']) && ($_POST['form_medium']) && ($_POST['form_prtext']))
{
$sql = "INSERT INTO pressetexte (datum, medium, pressetext) VALUES (
'".$_POST['form_datum']."',
'".$_POST['form_medium']."',
'".$_POST['form_prtext']."'
)";
$result = mysql_query($sql);
if($result) {
$status = "...eingetragen";
unset($_POST);
}
else {
$status = "...fehlgeschlagen '".mysql_error()."'";
}
}
else {
$status = '...Fehler! Fehlende Daten ';
}
}
?>
<script language="javascript">
function openWindow(url) {
var win;
win = window.open(url,'Druckversion','width=500,height=400, scrollbars=yes, menubar=no');
win.focus();
}
</script>
<h2>Pressetext <?=$status?></h2>
<form action="<?= $_SERVER['REQUEST_URI'] ?>" method="post" enctype="multipart/form-data" name="pressetexte">
Datum:<br>
<input name="form_datum" type="text" class="form_text" size="30" maxlength="30" value="<?= $_POST['form_datum'] ?>">
<br>
Medium:<br>
<input name="form_medium" type="text" class="form_text" size="40" maxlength="40" value="<?= $_POST['form_medium'] ?>">
<br>
Pressetext:<br>
<textarea name="form_prtext" cols="40" rows="15"> <?= $_POST['form_prtext'] ?></textarea>
<br>
<p><input type="submit" name="upload" value="Upload"></p>
</form>
<p> </p>
<table width="650" border="0" cellspacing="1" cellpadding="5" bgcolor="#CCCCCC">
<?PHP
$sql = "SELECT id, datum, medium, pressetext FROM pressetexte ORDER by id ASC";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)){
echo '<tr>';
echo '<td width="70" bgcolor="white" align="center">'.$row['datum'].'</td>';
echo '<td width="130" bgcolor="white" align="center">'.$row['medium'].'<br /></td>';
echo '<td width="430" bgcolor="white" align="center">'.$row['pressetext'].'<br /></td>';
echo '<td width="20" bgcolor="white" align="center"><a href="javascript:openWindow(\'pressetext_edit.php?id='.$row['id'].'\');">edit</a></td>';
echo '</tr>';
}
?>
</table>
Thanks for the help
Bookmarks