[Resolved] n00b requires some help... populating textarea.

[The_Stranger2]

Ok.. here's the deal.. I have a MySQL database and have added news there.. Now I am gonna make me a way to update the news. It works ok. all the textfields gets their values from the database and so does the TextArea field.. the data is added into a text column or what it's called.. the type is text. And now when it fetches the data to the TextArea on my form it adds <br /> tags on every linebrake. Is there a way to get rid of that? It would look a lot better and propably work better too. 🙂

Thanks!🆒

[interactive]

Originally posted by The Stranger
Ok.. here's the deal.. I have a MySQL database and have added news there.. Now I am gonna make me a way to update the news. It works ok. all the textfields gets their values from the database and so does the TextArea field.. the data is added into a text column or what it's called.. the type is text. And now when it fetches the data to the TextArea on my form it adds <br /> tags on every linebrake. Is there a way to get rid of that? It would look a lot better and propably work better too. 🙂

Thanks!🆒

Is it possible to take a look at the insert and fetch code (not just the SQL commands, but how the text 'gets' to those commands if you know what I mean). Hard to say where the </ br>'s are coming from.

[The_Stranger2]

ah... you mean that the </ br> things come in when I insert the text.. 😉 yeah.. maybe

This is my add.php:
<?
include("head.php");
?>

<h2>Add News</h2>
<form method="post" action="save.php">
<table>
<tr><td>Aihe:</td><td><input type="text" name="topic"></td></tr>
<tr><td>Avainsanat:</td><td><input type="text" name="keywords"</td></tr>
<tr><td>Lähde:</td><td><input type="text" name="source"></td></tr>
<tr><td>NEttiosoite:</td><td><input type="text" name="www" value="http://"></td></tr>
<tr><td valign="top">Sisältö:</td><td><textarea name="content" COLS="100" ROWS="50"></textarea>
</select></td></tr>
<tr><td><br></td><td></td></tr>
<tr><td></td><td><button type="submit">Send</button></td></tr>
</form>

<?
mysql_close($connection);
?>

here's the save.php

<?
$connection = mysql_connect('localhost', $user, $pwd) or die ("Error Trying to connect to the database..");

mysql_select_db($dbName, $connection) or die ("Either that's not a valid database or you dont have permission to access it.");

$statement ="insert into news (topic, newsText, keywords, source, sourceHttp, d) values ('$topic', '$content', '$keywords', '$source', '$www', '$date')";

if (mysql_query($statement) !=0){
print "Success";
}
else{
print "Something is seriously wrong.";
}

mysql_close($connection);
?>

[The_Stranger2]

and the edit.php

<?
$set = mysql_query("select * from news where newsId = $newsId order by d");
?>
<h2>Muokkaa Uutinen</h2>
<form method="post" action="update.php">
<table>
<?
$row = mysql_fetch_object($set);
echo "<tr><td>Aihe:</td><td><input type=\"text\" name=\"newtopic\" value=\"$row->topic\"></td></tr>";
echo "<tr><td>Avainsanat:</td><td><input type=\"text\" name=\"newkeywords\" value=\"$row->keywords\"</td></tr>";
echo "<tr><td>Lähde:</td><td><input type=\"text\" name=\"newsource\" value=\"$row->source\"></td></tr>";
echo "<tr><td>Nettiosoite:</td><td><input type=\"text\" name=\"newwww\" value=\"$row->sourceHttp\"></td></tr>";
echo "<tr><td valign=\"top\">Sisältö:</td><td><textarea name=\"newcontent\" COLS=\"100\" ROWS=\"50\">"; echo nl2br($row->newsText); echo "</textarea>";
?>
</select></td></tr>
<tr><td><br></td><td></td></tr>
<tr><td></td><td><button type="submit">Lähetä</button></td></tr>
</form>

<?
mysql_close($connection);
?>

and the update.php

<?
$connection = mysql_connect('localhost', $user, $pwd) or die ("Error Trying to connect to the database..");

mysql_select_db($dbName, $connection) or die ("Either that's not a valid database or you dont have permission to access it.");

$statement ="update news set topic = '$newtopic', newsText = '$newcontent', keywords = '$newkeywords', source = '$newsource', sourceHttp = '$newwww' where newsId = '$newsId'";

if (mysql_query($statement) !=0){
print "Success";
}
else{
print "Something is seriously wrong.";
}

mysql_close($connection);
?>

As you propably might see I have a problem with the updating too.. it doesnt update.. I think the problem may be that newsId doesnt get any value.. :B

well.. hope you can help.. 🙂

[Frederick]

you don't need the nl2br function for your form elements

COLS=\"100\" ROWS=\"50\">"; echo nl2br($row->newsText); echo "</textarea>";

should be:

COLS=\"100\" ROWS=\"50\">$row->newsText</textarea>";

[The_Stranger2]

Thanks.. that works. 🙂

now I just need to get the updatething working. 🙂

[Frederick]

<?php
// This page will display your selection for update and then
// loop back to the same page when submit button is pressed
// Button name: update
// Form action: ".$_SERVER["PHP_SELF"]."
// change the form action to redirect to a different location
// I used mysql_fetch_array() for data retieval instead of _object. Less problems, more flexibility

$DBServer = "localhost";
$DBUser = "usename";
$DBPass = "password";
$DBName = "dbname";

////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Use a simple explination for connection failure so it does not reveal your username
$dblink = mysql_connect($DBServer,$DBUser,$DBPass) or die ("Could not connect to MySQL server");
mysql_select_db($DBName,$dblink) or die ("Could not connect to MySQL database");
////////////////////////////////////////////////////////////////////////////////////////////////////////////
if (isset($update)) {
	// check if magic quotes are On or Off for entry of your news content
	if (!get_magic_quotes_gpc()) {
		$str = addslashes($newcontent); // if quotes are Off
	} else {
		$str = $newcontent; // if quotes are On
	}
	$sql = mysql_query("UPDATE news SET newtopic='$newtopic', newkeywords='$newkeywords', newsource='$newsources', newwww='$newwww', newcontent='$str' WHERE news_id=$news_id") or die (mysql_error());
	header("Location: path/to/wherever.php");
} else {
	$sql = mysql_query("SELECT * FROM news WHERE news_id=$news_id") or die (mysql_error());
	$row = mysql_fetch_array($sql);
	echo "<form action=\"".$_SERVER["PHP_SELF"]."\" method=\"post\">\n";
	echo "<input type=\"hidden\" name=\"news_id\" value=\"$news_id\">\n";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">\n";
	echo "<tr>\n";
	echo "<td>Aihe</td>\n";
	echo "<td><input type=\"text\" name=\"newtopic\" value=\"".$row["newtopic"]."\"></td>\n";
	echo "</tr>\n";
	echo "<tr>\n";
	echo "<td>Avainsanat:</td>\n";
	echo "<td><input type=\"text\" name=\"newkeywords\" value=\"".$row["newkeywords"]."\"></td>\n";
	echo "</tr>\n";
	echo "<tr>\n";
	echo "<td>Lähde:</td>\n";
	echo "<td><input type=\"text\" name=\"newsource\" value=\"".$row["newsource"]."\"></td>\n";
	echo "</tr>\n";
	echo "<tr>\n";
	echo "<td>Nettiosoite:</td>\n";
	echo "<td><input type=\"text\" name=\"newwww\" value=\"".$row["newsourceHttp"]."\"></td>\n";
	echo "</tr>\n";
	echo "<tr>\n";
	echo "<td>Sisältö:</td>\n";
	echo "<td><textarea name=\"newcontent\" cols=\"50\" rows=\"6\">".$row["newsText"]."</textarea></td>\n";
	echo "</tr>\n";
	echo "<tr>\n";
	echo "<td height=\"10\"></td>\n";
	echo "<td></td>\n";
	echo "</tr>\n";
	echo "<tr>\n";
	echo "<td></td>\n";
	echo "<td><input type=\"submit\" name=\"update\" value=\"Update News\"></td>\n";
	echo "</tr>\n";
	echo "</table>\n";
}
?>

[The_Stranger2]

Thanks.. I'll try it when I get home.