Cory94bailly Posted May 25, 2008 Share Posted May 25, 2008 List.php: <head> <title>Edit/Delete News</title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <br /> <div id="menu"> <? include('menu.html'); ?> </div> <div id="content"> <?php require 'config.php'; // Make a MySQL Connection mysql_connect($path, $username, $password) or die(mysql_error()); mysql_select_db($database) or die(mysql_error()); $query1 = "SELECT * FROM news ORDER BY sticky, id ASC"; $result1 = mysql_query($query1) or die(mysql_error()); function printNews($result) { if ( mysql_num_rows($result) < 1 ) { echo "<h1>No news!</h1>"; } else { echo "<table cellspacing=\"2\" cellpadding=\"5\">\n"; while($news = mysql_fetch_assoc($result)) { $sticky = ($news['sticky'] == 'y') ? "<font color='red'><u>Announcement:</u></font> " : ''; echo <<<HTML <tr> <th align="left">{$sticky}<b>{$news['title']}</b></th> <td rowspan="2" valign="bottom" align="left"> <a href="news_edit.php?id={$news['id']}"><img border="0" src="../images/edit.png" alt="Edit" /></a><br /> <a href="news_delete.php?id={$news['id']}"><img border="0" src="../images/delete.png" alt="Edit" /></a> </td> </tr> <tr> <td>{$news['news']}</td> </tr> HTML; } echo "\n</table><br />"; } } printNews($result1); ?> News_Edit.php: <head> <title>Add/Delete News</title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <br /> <div id="menu"> <? include('menu.html'); ?> </div> <div id="content"> <?php ob_start(); require 'config.php'; // Make a MySQL Connection mysql_connect($path, $username, $password) or die(mysql_error()); mysql_select_db($database) or die(mysql_error()); //Starts if you click the submit button. if(isset($_POST['submit'])) { //Finds out the ID if(is_numeric($_POST['id'])) { //Set the variables! $id = $_POST['id']; $title = mysql_real_escape_string($_POST['title']); $news = mysql_real_escape_string($_POST['news']); //Update it! $query = "UPDATE news SET title = '$title', news = '$news' WHERE id = '$id'"; mysql_query($query) or die(mysql_error()); echo "<meta http-equiv='refresh' content='1;url=index.php'> ID $id Edited!"; } else { //Error message. die('invalid action'); } } elseif(isset($_GET['id']) && is_numeric($_GET['id'])) { $id = $_GET['id']; $query = "SELECT title, news FROM news WHERE id='$id'"; $result = mysql_query($query); list($news_title, $news_text) = mysql_fetch_row($result); //The form. ?> <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"> <p>Title:<br> <input type="text" name="title" value="<?php echo $news_title ?>" /> </p> <p>Text:<br> <textarea rows="10" cols="50" name="news"><?php echo $news_text ?></textarea> </p> <input type="hidden" name="id" value="<?php echo $id; ?>"> <input type="submit" name="submit" value="Submit"> </form> <?php //End it!!! } ob_end_flush(); ?> News_delete.php: <head> <title>Add/Delete News</title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <br /> <div id="menu"> <? include('menu.html'); ?> </div> <div id="content"> <?php ob_start(); require 'config.php'; // Make a MySQL Connection mysql_connect($path, $username, $password) or die(mysql_error()); mysql_select_db($database) or die(mysql_error()); //Starts if you click the submit button. if(isset($_POST['submit'])) { //Finds out the ID if(is_numeric($_POST['id'])) { //Set the variables! $id = $_POST['id']; $title = mysql_real_escape_string($_POST['title']); $news = mysql_real_escape_string($_POST['news']); //Update it! $query = "DELETE FROM news where id=$id"; mysql_query($query) or die(mysql_error()); echo "<meta http-equiv='refresh' content='1;url=index.php'> ID $id Deleted!"; } else { //Error message. die('invalid action'); } } elseif(isset($_GET['id']) && is_numeric($_GET['id'])) { $id = $_GET['id']; $query = "DELETE FROM news where id=$id"; $result = mysql_query($query); } //End it!!! echo "<meta http-equiv='refresh' content='1;url=index.php'> ID $id Deleted!"; ob_end_flush(); ?> Now how can I make it so if I go to list.php, it will list the news and everything regularly, but when I click edit or delete, it will stay on the same page but go to like http://mysite.com/file.php?action=delete&id=4 it will delete id 4 or edit it if the action is edit.. Please help me.. Quote Link to comment Share on other sites More sharing options...
unidox Posted May 25, 2008 Share Posted May 25, 2008 Use get. http://www.tizag.com/phpT/postget.php Quote Link to comment Share on other sites More sharing options...
deadonarrival Posted May 25, 2008 Share Posted May 25, 2008 and then use a switch to choose which to run Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.