[PHP]ANNOUNCER SYSTEM
Publié : 08 juil. 2016, 18:05
edit.php
delete.php
display.php
add.php
ENJOY
demo :
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'].' » <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 }} ?>
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'].' » <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>
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 :