Delete/change newsitems

RDLyTN · January 9, 2012

Hi,

I'm working on a newssystem, I already can add newsitems to the database but i can't change or delete them. Does anyone have an idea what I'm doing wrong?

CODE:

ADD NEWSITEM:

<?php

require("constants.php");

$connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS);

if(!$connection) {

die("Database connection failed!" . mysql_error());

}

$db_select = mysql_select_db(DB_NAME, $connection);

if(!$db_select) {

die("Database connection failed!" . mysql_error());

}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>AIKIBDUO - Nieuwsadmin</title>

</head>

<body>

<div class="titel">Nieuws administratie</div><br>

<div class="links">Bericht toevoegen</div>

<div align="right" class="small"><a href="nieuws_admin2.php">berichten aanpassen of verwijderen</a></div>

<br>

<?php

if(isset($_POST['voegtoe']))

{

$datum = $_POST['datum'];

$onderwerp = $_POST['onderwerp'];

$bericht = $_POST['bericht'];

mysql_query("INSERT INTO nieuws (datum, onderwerp, bericht)

VALUES ('".$datum."', '".$onderwerp."', '".$bericht."')")

or die (mysql_error());

echo 'Het nieuws is succesvol opgeslagen.';

}

else

{

?>

<form action="<?=$_SERVER['PHP_SELF']?>" method="POST">

<tr>

<td class="tekst" valign="top"><b>Datum:</b></td>

</tr>

<tr>

<td class="tekst" valign="top"><b>Onderwerp:</b></td>

</tr>

<tr>

<td class="tekst" valign="top"><b>Bericht:</b></td>

<tr>

</tr>

</table>

</form>

<?php

}

?>

</td></tr></table>

<br>

</body>

</html>

<?php

mysql_close(DB_SERVER, DB_USER, DB_PASS);

?>

DELETE NEWSITEM

<?php

require("constants.php");

$connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS);

if(!$connection) {

die("Database connection failed!" . mysql_error());

}

$db_select = mysql_select_db(DB_NAME, $connection);

if(!$db_select) {

die("Database connection failed!" . mysql_error());

}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>AIKIBUDO - Nieuwsadmin</title>

</head>

<body>

function doedelete(numb){

if (confirm("Ben je zeker dat je dit bericht wil verwijderen?"))

{

window.document.submitform.del.value = numb;

window.document.submitform.submit();

}

</SCRIPT>

<?php

if (isset($del) && $del >= 0)

{

mysql_query("DELETE FROM nieuws

WHERE id = '$del'");

}

?>

<tr>

<div class="titel">Nieuws administratie</div><br>

<div class="links">Berichten aanpassen/verwijderen</div>

<tr>

<td class="tekst"><b>Datum</b></td>

<td class="tekst"><b>Onderwerp</b></td>

<td class="tekst" align="right"><b>Bewerken</b></td>

</tr>

<tr>

</tr>

<?php

$result = mysql_query("SELECT id, onderwerp, datum

FROM nieuws

ORDER BY id DESC");

while($show_msg = mysql_fetch_array($result))

{

echo( "<tr>\n\t<td class=\"tekst\" colspan=\"2\">$show_msg[datum]</td>\n" .

"\t<td class=\"tekst\" colspan=\"2\">$show_msg[onderwerp]</td>\n" .

"\t<td class=\"tekst\" align=\"right\"><a href=\"nieuws_edit.php?id=$show_msg[id]\"><img src=\"images/edit.gif\" width=\"19\" height=\"14\" alt=\"Bewerk dit bericht\" border=\"0\"></a><a href=\"\" OnClick=\"Javascript:doedelete('$show_msg[id]');return false;\"><img src=\"images/delete.gif\" width=\"19\" height=\"14\" alt=\"Verwijder dit bericht\" border=\"0\"></a></td></tr>\n");

}

?>

<tr>

</tr>

</table>

</div>

</form>

</td>

</tr>

</table>

<br>

</body>

</html>

<?php

mysql_close(DB_SERVER, DB_USER, DB_PASS);

?>

CHANGE NEWSITEM

<?php

require("constants.php");

$connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS);

if(!$connection) {

die("Database connection failed!" . mysql_error());

}

$db_select = mysql_select_db(DB_NAME, $connection);

if(!$db_select) {

die("Database connection failed!" . mysql_error());

}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>AIKIBUDO - Nieuwsadmin</title>

</head>

<body>

<?php

if(isset($_POST['voegtoe'])) {

mysql_query("UPDATE nieuws

SET bericht = '".$_POST['bericht']."'

WHERE id ='".$_POST['id']."'")

or die ("fout bij het opslaan van je bericht in de databank");

}

$result = mysql_query("SELECT *

FROM nieuws

WHERE id = '$id'");

$show_msg = mysql_fetch_array($result);

?>

<tr>

<div class="titel">Nieuws administratie</div><br>

<div class="links">Bericht aanpassen</div>

<tr>

<td class="tekst" valign="top"><b>Onderwerp:</b></td>

</tr>

<tr>

<td class="tekst" valign="top"><b>Bericht:</b></td>

<tr>

</tr>

</table>

</form>

</td>

</tr>

</table>

</body>

</html>

<?php

mysql_close(DB_SERVER, DB_USER, DB_PASS);

?>

RobertP · January 10, 2012

this might help you, its a module i just created today for my custom cms i have created.

17312_.php

Sign In

Delete/change newsitems

Recommended Posts

RDLyTN

Link to comment

Share on other sites

RobertP

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information