Jump to content

Edit Page


muddy9494

Recommended Posts

ok, i need help making a page. I want a page to be like this.

 

It has a form, and the top of the page is editnews.php?id=x

it will GET the id and then in say the title text box it will fetch the name from the row with id x in it.

 

So for example.

Row with id 1 has news title "Welcome"

it will go to row with id 1 and put the welcome in the textbox.

the rest i can get. I know how to make it update it :)

 

Thanks for the help :)

Link to comment
https://forums.phpfreaks.com/topic/162078-edit-page/
Share on other sites

Here is my Delete News Code

<?php
//database connection stuff
include("mysql.php");
$db = "mysql";
//grab postid from the url
$id = intval($_GET['id']);

//check if it exists
$sql = "SELECT id FROM news WHERE id='$id'";
  $result = mysql_query($sql);

if(mysql_num_rows($result) == 1){
  $delete = "DELETE FROM news WHERE id='$id' LIMIT 1";
  
  //exists, "delete" it
  if(!mysql_query($delete)) {
    echo mysql_error();
  }else{
  	include("addliveblog.php");
    echo 'Post has been deleted.';
  }

}else{
//post doesn't exist, or multiple matches (shouldn't have multiple on auto inc ..)
include("addliveblog.php");
echo 'No post exists with that post id.';

}

?>

Link to comment
https://forums.phpfreaks.com/topic/162078-edit-page/#findComment-855259
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.