Jeg er lige ramt ind i endnu et problem har udfra bogen "lav dit eget CMS med Dreamweaver PHP og MySQL af Heine Lennart Christensen" lavet mit nyhedsscript fra nogle af de principper han benytter, men nu kan jeg kun lave en nyhed, jeg får den 1. nyhed frem og mangler derfor at nyheden kun lagres og ikke skal redigeres, dette laver jeg en side til senere..
Her er min kode:
<?php require_once('../Connections/cms.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "nyhed")) {
$insertSQL = sprintf("INSERT INTO nyhed (overskrift, kortnyt, billede, billede2, nyhed, forfatter, kategori) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['overskrift'], "text"),
GetSQLValueString($_POST['kortnyt'], "text"),
GetSQLValueString($_POST['billede'], "text"),
GetSQLValueString($_POST['billede2'], "text"),
GetSQLValueString($_POST['nyhed'], "text"),
GetSQLValueString($_POST['forfatter'], "text"),
GetSQLValueString($_POST['kategori'], "text"));
mysql_select_db($database_cms, $cms);
$Result1 = mysql_query($insertSQL, $cms) or die(mysql_error());
$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_cms, $cms);
$query_rsNyhed = "SELECT * FROM nyhed";
$rsNyhed = mysql_query($query_rsNyhed, $cms) or die(mysql_error());
$row_rsNyhed = mysql_fetch_assoc($rsNyhed);
$totalRows_rsNyhed = mysql_num_rows($rsNyhed);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<link href="../css/styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="layout">
<tr>
<td colspan="2" class="top"><h1>Administrationsområde</h1></td>
</tr>
<tr>
<td colspan="2" class="top1"> </td>
</tr>
<tr>
<td class="left"><p> </p>
<p align="center"><strong>Skriv nyhed </strong></p>
<p align="center"><a href="index.php">Admin forside</a></p></td>
<td class="middle"><p> </p>
<h1>Skriv nyhed </h1>
<form action="<?php echo $editFormAction; ?>" method="POST" name="nyhed" id="nyhed">
<table width="500" border="0" cellspacing="0" cellpadding="2">
<tr>
<td>Overskrift</td>
<td colspan="2"><input name="overskrift" type="text" id="overskrift" value="<?php echo $row_rsNyhed['overskrift']; ?>" size="70"></td>
</tr>
<tr>
<td>kort nyt </td>
<td colspan="2"><textarea name="kortnyt" cols="70" rows="3" id="kortnyt"><?php echo $row_rsNyhed['kortnyt']; ?></textarea></td>
</tr>
<tr>
<td>nyhed</td>
<td colspan="2"><textarea name="nyhed" cols="70" rows="6" id="nyhed"><?php echo $row_rsNyhed['nyhed']; ?></textarea></td>
</tr>
<tr>
<td>Forfatter</td>
<td colspan="2"><input name="forfatter" type="text" id="forfatter" value="<?php echo $row_rsNyhed['forfatter']; ?>" size="70"></td>
</tr>
<tr>
<td>Kategori</td>
<td colspan="2">
<select name="kategori" id="kategori">
<option>division</option>
<option>jyllandserie</option>
<option>serie3</option>
<option>junior1</option>
<option>junior2</option>
<option>klubnyt</option>
<option>oldgirlsh</option>
<option>oldgirlsv</option>
</select></td>
</tr>
<tr>
<td>billede</td>
<td><input name="billede" type="text" id="billede" value="<?php echo $row_rsNyhed['billede']; ?>" size="30"></td>
<td><input name="billede2" type="text" id="billede2" value="<?php echo $row_rsNyhed['billede2']; ?>" size="30"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="Tilføj nyhed"></td>
<td><input type="reset" name="Reset" value="Slet "></td>
</tr>
</table>
</form> <p> </p></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rsNyhed);
?>
