Tryin' to do an edit in textarea

SeanKann

I'm tryin' to have 1 area to edit posts that i do on my website but I can't seem to get a text area to show up to do the edit

I just want to have the Post ID number and the news that is posted then have an edit at the end of the page and send it off.. can't seem to get past this atm

mysql_connect($dbhost,$dbuser,$dbpass) or die("You broke it");
@mysql_select_db("$dbname") or die("You broke the database");

$query="SELECT * from $table";	  

echo "<td><table width='100%' border='1'>
<tr><td colspan='7'><center>Edit News</center></td></tr>
<tr>
<th width='7%'>id</th>
<th width='90%'>news</th>
<th width='3%'>edit</th>
</tr>";

$query =  "SELECT * FROM $table ORDER BY id Asc";
$result=mysql_query($query);

while($row = mysql_fetch_array($result))
{

echo "<tr>";
echo "<td>" .$row['id']	.	"</td>";
echo "<td>"	<textarea> .$row['news']. </textarea> "</td>";
echo "<td><form action='sendedit.php' method='post'>";
echo "<input type='hidden' name='news_id' value='$row[id]' />";
echo "<input type='submit' value='edit' /></form></td>";
echo "</tr>";
}
echo "</table>";
mysql_close();
?>

my connection for dbuser,dbpass etc is over all of this i just didn't include it

rincewind456

This row:

echo "<td>"	<textarea> .$row['news']. </textarea> "</td>";

Should be like:

echo "<td><textarea>" .$row['news']. "</textarea> </td>";

suntra

Also, VERY IMPORTANT, you should ALWAYS use htmlentities() to display texte between <textarea> and </textarea>... often, if there is HTML, especially if </textarea> is present ! This will convert "<" to "<", ">" to ">", quotes to """, and also accents (example : "é" => "é")...

Very simple :

echo "<td><textarea>" . htmlentities($row['news']) . "</textarea> </td>";

SeanKann

rincewind thank you that worked.. Now i'm tryin' to do an update and i can't seem to get that working.

error_reporting(E_ALL);

mysql_connect($dbhost,$dbuser,$dbpass) or die("You broke it");
@mysql_select_db("$dbname") or die("You broke the database");

$query="SELECT * from $table";	  

echo "<td><table width='100%' border='1'>
<tr><td colspan='7'><center>Edit News</center></td></tr>
<tr>
<th width='7%'>id</th>
<th width='90%'>news</th>
<th width='3%'>edit</th>
</tr>";.

$query =  "SELECT * FROM $table ORDER BY id Desc";
$result=mysql_query($query);

while($row = mysql_fetch_array($result))
{

echo "<tr>";
echo "<td>" .$row['id']	.	"</td>";
echo "<td><textarea name='news' cols='50' rows='5'>" .$row['news']. "</textarea></td>";
echo "<td><form action='sendedit.php' method='post'>";
echo "<input type='hidden' name='news_id' value='$row[id]' />";
echo "<input type='submit' value='edit' /></form></td>";
echo "</tr>";
}
echo "</table>";
mysql_close();
?>

I get an error here with the $news Parse error: syntax error, unexpected T_VARIABLE.

error_reporting(E_ALL);
$news=_$POST['news'];
mysql_connect($dbhost,$dbuser,$dbpass) or die("You broke it");
@mysql_select_db("$dbname") or die("You broke the database");

$sqlquery = "UPDATE $table SET 'news' = $news WHERE 'id' = 'id'";

$results = mysql_query($sqlquery);

mysql_close();
print "It was sent"

?>

The line is where i got $sqlquery.. only thing i want to change is the news that is being changed.. the time/date and poster can stay the same even if someone else does the edit

rincewind456

This piece of code

echo "<td><table width='100%' border='1'>
<tr><td colspan='7'><center>Edit News</center></td></tr>
<tr>
<th width='7%'>id</th>
<th width='90%'>news</th>
<th width='3%'>edit</th>
</tr>";.		//<---------Stray Dot

You have a stray dot.

SeanKann

Not sure why that showed but in my code i didn't have that..

But i still tried it with and with out that dot same results.

The page comes up and i can edit the news that i've posted.. just when i hit Submit(edit).. I get the error on the second page that i have setup to send it to the database which is this code

error_reporting(E_ALL);
$news=_$POST['news'];
mysql_connect($dbhost,$dbuser,$dbpass) or die("You broke it");
@mysql_select_db("$dbname") or die("You broke the database");

$sqlquery = "UPDATE $table SET 'news' = $news WHERE 'id' = 'id'";

$results = mysql_query($sqlquery);

mysql_close();
print "It was sent"

?>

rincewind456

I looked at the second snippet and there was a problem with the second line

$news=_$POST['news'];

it should be

$news=$_POST['news'];

also why do you have quotes around the field names in your sql statement, they should be backticks, and only then if the name you use for a table cell is a reserved word. And as you really shouldn't need to use reserved words as names then there is no need for the backticks.

SeanKann

tried that still no go.. gives me the same error.. i've done some google searches and everythng looks fine to me i think

but there is always 1 little thing that i'm missing and i can't see it

rincewind456

I can't see anymore T variable errors, the only thing that I can see is the single quotes in the sql query which must be taken out or the query will fail.

bradgrafelman

Few things about this SQL query:

$sqlquery = "UPDATE $table SET 'news' = $news WHERE 'id' = 'id'";

1. As rincewind456 pointed out, you do not denote column names in SQL with single quotes. Normally, there's no need to surround them in delimiters at all, i.e.

UPDATE myTable SET myColumn = 'myValue';

If you did want to delimit the column names, you could use backticks (i.e. UPDATE myTable ...).

The new value for the news column should have quotes around it, as I showed in my example SQL query above.
Are you sure you're trying to check if the id column matches 'id' ? Is that possibly a typo and you meant to use the variable $id ? Either way, if id is a numeric SQL column, its value should not have quotes around it.
If you're debugging a SQL query, it's always nice to know what MySQL is trying to tell you, so add some debug messages:
```
$results = mysql_query($sqlquery) or die('Error: ' . mysql_error() . '<hr/>Query: ' . $sqlquery);
```