Page 1 sur 1

[PHP]ANNOUNCER SYSTEM

Publié : 08 juil. 2016, 18:05
par chorao157
edit.php

Code : Tout sélectionner

<?php
function clear($message)
{
	if(!get_magic_quotes_gpc())
		$message = addslashes($message);
	$message = strip_tags($message);
	$message = htmlentities($message);
	return trim($message);
}
mysql_connect('localhost','username','password');
mysql_select_db('db');
if(!$_GET['id'])
{
	$query = mysql_query("SELECT * FROM news ORDER BY id DESC");
	echo 'Edit<hr />';
	while($output = mysql_fetch_assoc($query))
		echo $output['subject'].' &raquo; <a href="?id='.$output['id'].'">Edit</a><br />';
}
else
{
	if ($_POST['submit'])
	{
		$postedby = clear($_POST['postedby']); 
		$subject = clear($_POST['subject']); 
		$news = clear($_POST['news']); 
		$date = time(); 
		$id = $_GET['id']; 
		mysql_query("UPDATE news SET postedby='$postedby', news='$news', subject='$subject', date='$date' WHERE id='$id'");
		mysql_close();
		echo 'News Edited.';
	}
	else
	{
		$id = $_GET['id']; 
		$query = mysql_query("SELECT * FROM news WHERE id='$id'");
		$output = mysql_fetch_assoc($query);
?>
<form method="post" action="?id=<? echo $output['id']; ?>"> 
Editing <? echo $output['subject']; ?><hr />
Posted By:<input name="postedby" id="postedby" type="Text" size="50" maxlength="50" value="<? echo $output['postedby']; ?>"><br />
Subject:<input name="subject" id="subject" type="Text" size="50" maxlength="50" value="<? echo $output['subject']; ?>"><br />
News:<textarea name="news" cols="50" rows="5"><? echo $output['news']; ?></textarea><br />
<input type="Submit" name="submit" value="Enter information">
</form>
<?php }} ?>
delete.php

Code : Tout sélectionner

<html>
<head>
<title>Delete</title>
<script type="text/javascript">
function check(id){
	if (confirm("Are you sure you want to delete this news item?"))
		this.location.href = "?id="+id;
}</script>
</head>
<body>
<?php
mysql_connect('localhost','username','password');
mysql_select_db('db');
if(!$_GET['id'])
{
	$query = mysql_query('SELECT * FROM news ORDER BY id DESC');
	while($output = mysql_fetch_assoc($query)) 
		echo $output['subject'].' &raquo; <a href="#" onclick="check('.$output['id'].'); return false;">Delete</a><br />';
}
else
{
	$id = $_GET['id']; 
	mysql_query("DELETE FROM news WHERE id = $id LIMIT 1"); 
	echo 'News Deleted.';
}
?>
</body>
</html>
display.php

Code : Tout sélectionner

<html>
<head>
<title>News</title>
</head>
<body>
<?php
mysql_connect('localhost','username','password');
mysql_select_db('db');
$query = mysql_query('SELECT * FROM news ORDER BY id DESC');
while($output = mysql_fetch_assoc($query))
{
	echo $output['subject'].'<br />';
	echo $output['news'].'<br / >';
	echo date('D-M-Y', $output['date']).'<br / >';
	echo 'Posted by '.$output['postedby'];
	echo '<hr />'; 
}
?>
</body>
</html>

add.php

Code : Tout sélectionner

<form method="post" action="#"> 
	Posted By:<br /><input name="postedby" id="postedby" type="Text" size="50" maxlength="50"><br />
	Subject:<br /><input name="subject" id="subject" type="Text" size="50" maxlength="50"><br />
	<textarea name="news" id="news" cols="50" rows="5"></textarea><br />
	<input type="Submit" name="submit" id="submit" value="Enter News">
</form>
<?php
function clear($message)
{
	if(!get_magic_quotes_gpc())
		$message = addslashes($message);
	$message = strip_tags($message);
	$message = htmlentities($message);
	return trim($message);
}
if ($_POST['submit'])
{ 
	if (empty($_POST['postedby']))
		die('Enter a name.'); 
	else if (empty($_POST['subject']))
		die('Enter a subject.'); 
	else if (empty($_POST['news']))
		die('Enter an article.'); 
	$postedby = clear($_POST['postedby']); 
	$subject = clear($_POST['subject']); 
	$news = clear($_POST['news']); 
	$date = time();
	mysql_connect('localhost','username','password');
	mysql_select_db('db');
	if(mysql_query("INSERT INTO news (id , postedby , news , subject , date) VALUES ('', '$postedby', '$news', '$subject', '$date')"))
		echo 'News Entered.';
	mysql_close(); 
}
?>

ENJOY


demo :
Image
Image