Edit via PHP

[lostprophetpunk]

I have been working on a way to edit articles in my blog system.

 

I have come across a problem though. I get the article id that is set in the link, and then display the results in a form. I then set variables that contain the information in the database. I then echo the variables as values in the form. I can get the title to work but the thing is that the data in the database isn't all being put in the variable, as only part of it shows in the form...

 

Below is the code for my edit page...

<?php

  include("../connection.php");
  
  include("../header.php");
  
  if($session_name){

    $editid = $_GET['id'];
    $editid = mysql_real_escape_string( $editid );

    $Query = mysql_query(" SELECT * FROM articles WHERE article_id='$editid' ");
    $Data = mysql_fetch_array( $Query );
    
    $title = $Data['article_name'];
    $entrye = $Data['entry'];
  
  echo "<div class='mainc'>\n";
  echo "<div class='maintop'>Edit Article</div>\n";
  echo "<div class='main'>\n";     
      echo "<form name=\"addpost\" method=\"post\" action=\"postd.php\">\n";
      echo "Title  <input type=\"text\" name=\"name\" value=\"$title\"><br />\n";
      echo " <textarea rows=\"20\" cols=\"60\" name=\"entry\" wrap=\"virtual\" onkeyup=\"f=document.addpost;f.char_count.value=f.entry.value.length;\" value=\"$entrye\"></textarea>\n";
      echo "<input type=\"readonly\" name=\"char_count\" size=\"2\" /><br />\n";
      echo "<input type=\"submit\" name=\"submit\" value=\"Post\"><br />\n";
      echo "</form>\n";
      
      }else {
      echo "You have to be logged in to view this page.<br /><br />Redirecting you to the home page...\n";
      echo "<meta http-equiv=\"refresh\" content=\"3;url=../\" />\n";
      }  
  echo "</div>\n";
  echo "<div class='mainbottom'></div>\n";
  echo "</div>\n";
  include("../footer.php");

?>

 

I have been thinking on how to fix this but returned nothing.

[mrMarcus]

I can get the title to work but the thing is that the data in the database isn't all being put in the variable, as only part of it shows in the form...

 

what part(s) is/are not showing up in the form?  please be more specific.

[lostprophetpunk]

The $Data['entry']; isn't showing all of it's data.

[php_dave]

Im not 100% - but cant you just put the $entrye data between the <TEXTAREA></TEXTAREA> Tags - rather than using the Value="" attribute?

[mrMarcus]

The $Data['entry']; isn't showing all of it's data.

so, it's showing some though?  just not all the data?  or is not showing any at all .. 'cause like php_dave said, it's gotta be between the textarea tags and not in the value.

[redarrow]

try this if dosent work use a proper for loop....... with braces.........

 

<?php

  include("../connection.php");
  
  include("../header.php");
  
  if($session_name){

    $editid = $_GET['id'];
    $editid = mysql_real_escape_string( $editid );

    $Query = mysql_query(" SELECT * FROM articles WHERE article_id='$editid' ");
    $Data = mysql_fetch_assoc( $Query );
    
    $title = $Data['article_name'];
    $entrye = $Data['entry'];
  
  echo "<div class='mainc'>\n";
  echo "<div class='maintop'>Edit Article</div>\n";
  echo "<div class='main'>\n";     
      echo "<form name=\"addpost\" method=\"post\" action=\"postd.php\">\n";
      echo "Title  <input type=\"text\" name=\"name\" value=\"$title\"><br />\n";
      echo " <textarea rows=\"20\" cols=\"60\" name=\"entry\" wrap=\"virtual\" onkeyup=\"f=document.addpost;f.char_count.value=f.entry.value.length;\" value=\"$entrye\"></textarea>\n";
      echo "<input type=\"readonly\" name=\"char_count\" size=\"2\" /><br />\n";
      echo "<input type=\"submit\" name=\"submit\" value=\"Post\"><br />\n";
      echo "</form>\n";
      
      }else {
      echo "You have to be logged in to view this page.<br /><br />Redirecting you to the home page...\n";
      echo "<meta http-equiv=\"refresh\" content=\"3;url=../\" />\n";
      }  
  echo "</div>\n";
  echo "<div class='mainbottom'></div>\n";
  echo "</div>\n";
  include("../footer.php");

?>

[JD*]

PHP_dave has it correct...the <textarea> tag doesn't have a "value" attribute...you have to stick the code between the <textarea></textarea> tags