[RESOLVED] Editing Page Content

[obrienkev]

Morning all,

I want to allow users to edit content in a webpage.

How do I ensure that text is placed between <p> tags? and that when the user hits return that new <p> tags will be inserted?

Any help on this would be appreciated.

Thanks,

Kevin.

[ZibingsCoder]

$inputString = str_replace(array('\n\r', '\r\n', '\r', '\n'), '</p><p>', $inputString);

echo ( "<p>{$inputString}</p>" );

simple.

[obrienkev]

Cheers.
I've decided to store the content in database table - easier to update. So I'm thinking the best way to allow the user to update the content is via textarea fields??

How do I ensure proper storage of text & <p> tags? and that the text will appear correctly on the webpage?

Thanks,

Kevin.

[thorpe]

what part of ZibingsCoder's solution dont you understand?

[obrienkev]

Hasn't worked for me. No <P> tags in html code.

Here's my code...
Page 1:

<?php

include('db_connect.php');

$query = "SELECT * FROM content";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{
 		echo $row['content'];
}

?>


<form action="index2.php" method="post">
<textarea name="content">

</textarea>

<input type="submit" name="submit" value="submit" />
</form>

Page 2:

$content = $_POST['content'];

$content = str_replace(array('\n\r', '\r\n', '\r', '\n'), '</p><p>', $content);

echo ( "<p>{$content}</p>" );

include('db_connect.php');

$query = "INSERT INTO content values(NULL, '$content')";

$result = mysql_query($query) or die(mysql_error());

[thorpe]

dont store html in your db. try

while($row = mysql_fetch_array($result))
{
        echo '<p>'.str_replace(array('\n\r', '\r\n', '\r', '\n'), '</p><p>', $row['content'].'</p>');
}

when you retrieve from the db.

[obrienkev]

Doesn't make any difference. Pressing return when typing text in textarea field doesnt add \n tags, etc.

Any ideas?

[thorpe]

sorry, i cant test it at the moment, im at work. but it should work. you might want to just check out the [man]nl2br/man function. it adds <br> tags, but may help. there are also some user defined examples in the manual that may help you out.

[obrienkev]

Yup tried echo ( "<p>". nl2br($row['content']) . "</p>" ); and it does the job.

I have a css stylesheet. Is there any way that I could create a button, so that when the user highlights text in the textarea field and clicks the button then a certain style in the css file will be applied. e.g. color effect.

Thanks again.

[thorpe]

that my friend is all done with javascript. you might want to look at using something like htmlarea.

[ZibingsCoder]

And remember, if this is resolved, please click the "Mark Thread Resolved" link. Makes us all feel warm and fuzzy inside.