Brug af UPDATE funktion
Hej Eksperter...!Jeg har et script som jeg gerne vil fortælle, at når rediger funktionen bliver brugt, skal den ikke bruge INSERT, men UPDATE...
Hvordan fortæller jeg scriptet det?
<?php
session_start();
require('connect.php');
if(isset($_SESSION['admin']))
{
if(is_numeric($_GET['slet']))
{
$query = mysql_query("DELETE FROM Nyheder WHERE id = ".$_GET['slet']." LIMIT 1");
header('Location: ' . $_SERVER['PHP_SELF']);
exit();
}
if(isset($_POST['opretnyhed']))
{
$header = mysql_real_escape_string(strip_tags($_POST['header']));
$news = mysql_real_escape_string(strip_tags($_POST['news']));
$query = mysql_query("INSERT INTO Nyheder(id,header,news,writen) VALUES('','".$header."','".$news."',NOW())");
header('Location: ' . $_SERVER['PHP_SELF']);
exit();
}
//Hack til rediger...
$overskrift = "";
$nyhed = "";
if(is_numeric($_GET['rediger']))
{
$query = mysql_query("SELECT * FROM Nyheder WHERE id = ".$_GET['rediger']." LIMIT 1");
if(mysql_num_rows($query)==1)
{
$row = mysql_fetch_assoc($query);
$overskrift = $row['header'];
$nyhed = $row['news'];
}
}
echo '<DIV align="right">';
echo '<a href="logud.php">Log ud</a>';
echo '</DIV>';
echo '<table>';
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">';
echo '<tr><td>Overskrift:</td><td><input type="text" name="header" value="'.$overskrift.'"></td></tr>';
echo '<tr><td>Nyhed:</td><td><textarea name="news" cols="50" rows="10">'.$nyhed.'</textarea></td></tr>';
echo '<tr><td colspan="2"><input type="submit" value="Opret Nyhed" name="opretnyhed"></td></tr>';
echo '</form>';
echo '</table>';
echo '<hr>';
$query = mysql_query("SELECT *, DATE_FORMAT(writen, '%e. %b %Y') as tid FROM Nyheder ORDER BY writen DESC") or die (mysql_error());
if(mysql_num_rows($query)>0)
{
echo '<table>';
while($row = mysql_fetch_assoc($query))
{
echo '<tr><td><b><font size="2">' . $row['header'] . '</font></b></td></tr>';
echo '<tr><td style="border-bottom: 2px solid black;"><font size="2">' . $row['tid'] . '</font></td></tr>';
echo '<tr><td><font size="2">' . nl2br(substr($row['news'],0,50));
echo '... [<a href="readmore.php?id=' .$row['id'] . '">læs mere</a>]</font></td></tr>';
if($_SESSION['admin'])
{
echo '<tr><td><a href="skrivnyhed.php?slet='.$row['id'].'">Slet artikel</a></td></tr>';
echo '<tr><td><a href="skrivnyhed.php?rediger='.$row['id'].'">Rediger artikel</a></td></tr>';
echo '<tr><td><BR></td></tr>';
echo '<tr><td><HR> </td></tr>';
echo '<tr><td><BR></td></tr>';
}
}
echo '</table>';
}
else
{
echo 'Ingen nyheder endnu';
}
}
else
{
if(isset($_POST['login']))
{
if($_POST['user'] == 'admin' && $_POST['pass'] == 'password')
{
$_SESSION['admin'] = true;
header('Location: ' . $_SERVER['PHP_SELF']);
exit();
}else
{
echo '<b>Du har angivet forkert brugernavn eller password!</b>';
print '<br>';
}
}
echo '<td><center><b><h2>Nyheds administration</h2></b></center></td>';
echo '<table>';
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">';
echo '<tr><td>Brugernavn:</td><td><input type="text" name="user"></td></tr>';
echo '<tr><td>Password:</td><td><input type="password" name="pass"></td></tr>';
echo '<tr><td colspan="2"><input type="submit" value="Log Ind" name="login"></td></tr>';
echo '</form>';
echo '</table>';
}
?>
