|
|
Posted by Jim Michaels on 10/04/23 11:37
echo "<a href=processnews.php?newsid=$row[newsid]&action=delete><img
src=i/delete.gif></a>\n";
and then use $_GET['newsid] and $_GET['action'] to figure out what the user
did.
<andyt_2000_uk@yahoo.co.uk> wrote in message
news:1136941863.807169.246880@g47g2000cwa.googlegroups.com...
> Hi guys,
>
> having a little trouble working out how i'm going to do this. At the
> moment, users can log in and click a link to add news. This opens a
> page to enter the message and submit it to the database. These are then
> shown on the homepage.
>
> Questions are how can i go about letting the users edit or delete the
> messages? I think i need to add a link to the messages with the newsID
> that the users can then click to select that message. They can then be
> given a button to delete or edit it.
>
> So how do i add a link to the messages that will contain that messages
> ID so i can reload it?
>
> Sorry if its a little confusing, tired now.
>
> Cheers for any help.
>
> Heres what i have so far, this is the index page that is displayed with
> the messages on.
>
> Code:
>
> <?php session_start(); if(isset($_SESSION['username'])){ echo "Welcome
> ".$_SESSION['username']. '<br />'; //connect to mysql @ $db =
> mysql_pconnect('localhost', 'root', 'chase'); if(!$db){ echo 'Error:
> Could not connect to the database.'; } //connect to database
> mysql_select_db('dbHelpdesk'); $query = "select * from news"; $result =
> mysql_query($query, $db); $num_results = mysql_num_rows($result);
> $_SESSION['numNews']=$num_results; if($num_results == 0 ){ echo 'There
> are no current news items.'; echo '<br><a href="addNews.html">Add
> News</a><br />'; echo '<br><a href="logout.php">Logout</a><br />';
> exit; }else echo '<br> Number of News Items ' . $num_results . '<br
> />'; //get news items for ($a=0; $a < $num_results; $a++){ $row =
> mysql_fetch_array($result); echo '<br> Message: ' .
> stripslashes($row['Message']) . '<br />'; } echo '<br><a
> href="addNews.html">Add News</a><br />'; echo '<br><a
> href="logout.php">Logout</a><br />'; } else { echo "You are not logged
> in"; } ?>
>
>
>
> Next we have the page where i'm adding the messages.
>
> Code:
>
> <?php session_start(); if(isset($_SESSION['username'])){ $news =
> $HTTP_POST_VARS['message']; //echo '<br>' . $news . '<br />';
> if(!$news){ echo 'Please make sure you fill in the message box.'; echo
> '<br><a href="addNews.html">Return to Message</a><br />'; exit; } $news
> = addslashes($news); //connect to the db to post news @ $db =
> mysql_pconnect('localhost', 'root','chase'); if(!$db){ echo 'Error:
> Could not connect to the database.'; exit; }
> mysql_select_db('dbHelpdesk'); $newsID = $_SESSION['numNews'] + 1 ;
> $currDate = date('Y-m-d'); $newsQuery = "insert into news
> values('".$newsID."','".$news."','".$_SESSION['username']."','".$currDate."'
> )"; $result = mysql_query($newsQuery); if ($result){ echo
> mysql_affected_rows() . ' news item added to database'; } echo '<br><a
> href="index.php">Return to Main Page</a><br />'; echo '<br><a
> href="logout.php">Logout</a><br />'; } else { echo "You are not logged
> in"; } ?>
>
>
>
> Cheers
>
Navigation:
[Reply to this message]
|