TEXTAREA help

[jjoves]

I need the output to inside a textarea so viewers would be able to scroll through the notes instead of scrolling through the web page...

$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
$result = mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "
<textarea name="mynotes" style="width:430; height:100">
<strong style='font-size: 11px;'>$row[notes_user]</strong> $row[notes_time]
<br>----------------------------------------------------------------------------------
<br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />
</textarea>
";
}

[keith73]

ok, what seems to be the problem?

you don't need <br> inside a textarea. A simple \n will give you a line break.

• keith

[jjoves]

Ok here is the more detailed of what i have. I have a form where user type their messages and that goes to a database then displays it. I need the php output to be inside a textarea so I could scroll through the messages.

[ FORM ]

<input name="user" type="text" value="" style="width:135; height:17"> :<strong style='font-size: 10px;color:#666699;'>Username</strong>
<textarea name="mynotes" style="width:430; height:80"></textarea><br />
<input name="submitField" type="submit" value=" post new note " style='font-size: 10px;background-color:#666699;color:#ffffff;height:23'>

[code=php]

<?
if ((!$day || !$year || $month) && !$mydate) {
$mydate = date("Y-m-d");
} else {
$month = $month+1;
if ($month && $year && $day) {
$mydate = "$year-$month-$day";
}
}
echo "<strong style='font-size: 13px;color:#666699;'>$mydate</strong><br /><br />";
echo "<input type=\"hidden\" name=\"mode\" value=\"gowrite\">";
echo "<input type=\"hidden\" name=\"mydate\" value=\"$mydate\">";

				$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
				$result = mysql_query($sql);
				while ($row=mysql_fetch_array($result)) {
					echo "
						<textarea name="mynotes" style="width:430; height:100">	
						<strong style='font-size: 11px;'>$row[notes_user]</strong> $row[notes_time]
						/n
                        <br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />
						</textarea>
					";
				}
				mysql_free_result($result);
				 if ($mynotes && $user) {
					if ($allowhtml == "0") {
						$mynotes = str_replace("<", "&lt;", "$mynotes");
						$mynotes = str_replace(">", "&gt;", "$mynotes");
					}
					if ($mydate && $todayonly == "0") {
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";
					} else {
						$mydate = date("Y-m-d");
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";
					}


							mysql_query($sql) or die("error 324343");



					$adate = explode("-", $mydate);
					$mymonth = $adate[1]-1;
					header("Refresh:0;url=$PHP_SELF?day=$adate[2]&month=$mymonth&year=$adate[0]");
				}

				if ($todayonly == "1") {
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can only post under today's date</strong>";
				} else {
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can post notes under any date, past, present or future</strong>";
				}
			   ?>

[keith73]

code is good. Now I can see what you're doing, BUT you haven't told me what the problem is. Are you getting errors? are you not getting any data returned?

I can see at least one problem.
in your echo statement

echo "
<textarea name="mynotes"

the name= should be
name=\"mynotes\"

in your echo or print statement, you need to escape the " if you want " to be printed out.

• Keith

[jjoves]

Oops sorry about that, here is the error

Parse error: parse error, expecting ','' or';'' in /home/virtual/site168/fst/var/www/html/index.php on line 82

I think I have something wrong in this part of the code but not sure. What I'm trying to do is put the echo output inside a textarea so I viewers could scroll through the output.

$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
$result = mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "
<textarea name=\"mynotes\" style="width:430; height:100">
<strong style='font-size: 11px;'>$row[notes_user]</strong> $row[notes_time]
<br>----------------------------------------------------------------------------------
<br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />
</textarea>

[keith73]

Originally posted by jjoves
Oops sorry about that, here is the error

Parse error: parse error, expecting ','' or';'' in /home/virtual/site168/fst/var/www/html/index.php on line 82


I think I have something wrong in this part of the code but not sure. What I'm trying to do is put the echo output inside a textarea so I viewers could scroll through the output.



$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
$result = mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "
<textarea name=\"mynotes\" style="width:430; height:100">
<strong style='font-size: 11px;'>$row[notes_user]</strong> $row[notes_time]
<br>----------------------------------------------------------------------------------
<br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />
</textarea>

again, the style="..." needs to be escaped. any " that are supposed to be output in the html code MUST be escaped using \"

• Keith

[jjoves]

Thank you - it worked but it put each message or entry inside a textarea and resulted in a bunch of textarea and displays the codes as well.

To view results:
www.faustinay-calasiao.com/index.php

I needed all the messages inside the textarea.

I REALLY APPRECIATE YOUR HELP --- THANK YOU VERY MUCH

[KoshNaranek]

You can format the appearance of the value of a textarea via a stylesheet only.

The HTML-Tags are nonses at this point 😃

Inside a textarea (as said above) you can not use <BR>!
it's echo "\n"

Maybe you'd read the HTML-Specification at w3c.org 😃

This should work:

<?php
$sql = "select * from notes where notes_date='$mydate' order by notes_time desc"; 
$result = mysql_query($sql); 
while ($row=mysql_fetch_array($result)) { 
?>
<textarea name="mynotes" rows="5" cols="60"> 
<?=$row[notes_user]." ".$row[notes_time]."\n----------------------------------------------------------------------------------\n\n"; ?>
</textarea> 
<? }
// more code

if you want to place all notes to one textarea, it's:

<?php
$sql = "select * from notes where notes_date='$mydate' order by notes_time desc"; 
$result = mysql_query($sql); 
?>
<textarea name="mynotes" rows="5" cols="60"> 
<?
while ($row=mysql_fetch_array($result)) { 
echo $row[notes_user]." ".$row[notes_time]."\n----------------------------------------------------------------------------------\n\n"; 
} ?>
</textarea> 
<? // more code

I've written this example this way, to show, what's PHP and what's HTML 🆒

[Hiccup]

I'm not sure anyone has answered his or her question yet...

I think what you're looking for is this:

<INPUT type=textarea rows=5 cols=10 value="<?php echo $body_of_textarea?>"></textarea>

Is that what you meant?

[jjoves]

hmm I tried it and it did not work...here is the error:

Parse error: parse error in /home/virtual/site168/fst/var/www/html/index.php on line 78

and here is the code:

php

<?
if ((!$day || !$year || $month) && !$mydate) {
$mydate = date("Y-m-d");
} else {
$month = $month+1;
if ($month && $year && $day) {
$mydate = "$year-$month-$day";
}
}

				echo "<strong style='font-size: 13px;color:#666699;'>$mydate</strong><br /><br />";
				echo "<input type=\"hidden\" name=\"mode\" value=\"gowrite\">";
				echo "<input type=\"hidden\" name=\"mydate\" value=\"$mydate\">";
                <textarea name="mynotes" rows="10" cols="60">
				$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
				$result = mysql_query($sql);
				while ($row=mysql_fetch_array($result)) {
					echo "
						<strong style='font-size: 11px;'>$row[notes_user]</strong> $row[notes_time]
						<br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />
						";
				}
				</textarea>
				mysql_free_result($result);
				 if ($mynotes && $user) {
					if ($allowhtml == "0") {
						$mynotes = str_replace("<", "&lt;", "$mynotes");
						$mynotes = str_replace(">", "&gt;", "$mynotes");
					}
					if ($mydate && $todayonly == "0") {
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";
					} else {
						$mydate = date("Y-m-d");
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";
					}


							mysql_query($sql) or die("error 324343");



					$adate = explode("-", $mydate);
					$mymonth = $adate[1]-1;
					header("Refresh:0;url=$PHP_SELF?day=$adate[2]&month=$mymonth&year=$adate[0]");
				}

				if ($todayonly == "1") {
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can only post under today's date</strong>";
				} else {
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can post notes under any date, past, present or future</strong>";
				}
			   ?>

---

THANK YOU

[KoshNaranek]

Originally posted by Hiccup

<INPUT type=textarea rows=5 cols=10 value="<?php echo $body_of_textarea?>"></textarea>

Maybe he should read this, too: http://www.w3.org/TR/html4/interact/forms.html#h-17.7
🙁 It's not <input type...! It's <TEXTAREA...> </TEXTAREA>:mad:

@ jjoves

where is line 78 in this code?? i'am not "NOTEPAD" and there are only 52 lines of code 😉 😕

As far, as i can see, this is the fault:
you are mixing HTML and PHP... look at my example, again
?>
<?
are important 🙂

[jjoves]

THANK YOU --- Im almost there!!!

I got all the data to show inside the textarea but - now it shows the HTML code and does not display message itself

Check the output:
http://www.faustinay-calasiao.com/index.php?day=20&month=2&year=2003

How can I make to display the data properly inside a textarea.

ALMOST THERE!!!

[KoshNaranek]

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10233034 is about the same, isn't it?!?

when i click the link, this is the answer:
Parse error: parse error in /home/virtual/site168/fst/var/www/html/index.php on line 54

[jjoves]

Opps sorry about that I forgot to upload the file.

link to the test site...

and here is what i have so far:>>

$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
					$result = mysql_query($sql);
					?>
                <textarea name="mynotes" rows="18" cols="82" readonly>
					<?
					while ($row=mysql_fetch_array($result)) {
						echo "
							<strong style='font-size: 11px;'>$row[notes_user]</strong> $row[notes_time]
							<br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />";
					}
					?>
					</textarea>

😃

[amchargue]

Originally posted by jjoves
THANK YOU --- Im almost there!!!

I got all the data to show inside the textarea but - now it shows the HTML code and does not display message itself

Check the output:
http://www.faustinay-calasiao.com/index.php?day=20&month=2&year=2003


How can I make to display the data properly inside a textarea.

ALMOST THERE!!!

The data inside the textarea cannot be formatted, if that's what you're trying to do. The html code is showing up because that's what you're putting in there.

[KoshNaranek]

Originally posted by KoshNaranek
You can format the appearance of the value of a textarea via a stylesheet only.

The HTML-Tags are nonses at this point 😃

Inside a textarea (as said above) you can not use <BR>!
it's echo "\n"

Maybe you'd read the HTML-Specification at w3c.org 😃

as i said above... 😃 😃

A Textarea is like a Gold fish glass - you can not "format" single parts of the water.

[amchargue]

There are things like Yahoo Mail or Hotmail which allows you to do formatting, but that's not a normal HTML Textarea. That's either an applet or javascript using COM object.

[jjoves]

Thanks "KoshNaranek" and "amchargue" - I see now that you can not format text inside a textarea. I am searching for a javascript or something that I could use to format the text inside it. with php included

Would you happen to know the applet or the javascript that I can use to format text inside a textarea.

<?
					$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
					$result = mysql_query($sql);
					?>
					<textarea name="mynotes" rows="5" cols="81" readonly>

				<?
				while ($row=mysql_fetch_array($result)) {
					echo "
						<strong style='font-size: 11px;'>$row[notes_user]</strong> $row[notes_time]/n
".nl2br(stripslashes($row[notes_note]))."<br /><br /><br />";
				}?>
				</textarea>
				<?

[amchargue]

Here's an attachment that has some javascript that does it. A ton of code, which I haven't even tried to understand. This is just a sample file, I'm not even sure where I got it.

On applets, I believe your server needs to be set up for that? Or no, I guess maybe the java is executed on the client side. Hmm. Seems like you could search and find something. Maybe it's not an applet that I've seen, maybe it's something else. Look at the code for hotmail (with the formatting toolbar on) and yahoo, and you might learn something there. I looked at that a while back but don't recall the details.