TEXT format

[aj123cd]

In the DB text field I am keeping different type of date formats.

To display the date I am using different type of code with echo. Can anyone advice me is there any other method available.

• nl2br
  <pre></pre>
  
• 
  

[carugala]

use the DB datatypes

[aj123cd]

I am using LONGTEXT(MySQL)

thank you.

[Psycho]

I am using LONGTEXT(MySQL)

 

He meant use one of the database DATE types: date, datetime, timestamp, time, & year. If you use something other than a MySQL date/time format for date/time values you are preventing the ability to use many of the built-in functions for dealing with date/time value.

 

You only need to store a date once. You can then output that date in any way you need to using either the MySQL or PHP functions as needed. If you ONLY need the date (and not the time component), then you should use the 'date' type. You would store the value in the format YYYY-MM-DD. Then when you retrieve the value, just use the PHP date() function to output it in whatever format you wish.

[aj123cd]

In the DB text field I am keeping different type of date formats.

To display the date I am using different type of code with echo. Can anyone advice me is there any other method available.

• nl2br
  <pre></pre>
  
• 
  

 

#Please accept my apology

My typing mistake. NOT DATE IT SHOULD BE DATA

 

[cyberRobot]

So, what is the question? It kind of sounds like you're asking how to display information from a database. If so, could you explain what you're doing now and what you're looking to do. If you don't like the method you're currently using, what don't you like about it?

[aj123cd]

Stores the DATA in html formatted information in a MySQL database

eg:

 

<p>Hello</p><ul><li>1</li><li>2</li></ul>

I just want to retrieve html formatted text which is stored in a MySQL  database & display it on a page.

 

But the page is displaying the html coding rather than the formatted output.

Expected result was

Hello

1

2

BUT  I am getting the following result.

 

<p>Hello</p><ul><li>1</li><li>2</li></ul>

 

I have tried all the method,

 

THANKYOU

[cyberRobot]

What is the code used to display the data? There's probably a function like htmlentities() being used on the data. Removing the function might give you the expected results.

[Pikachu2000]

Code?

[aj123cd]

INSERT code

			$sql = "INSERT INTO messages
			   (  date, user_id, topic_id,  body  )  
				 VALUES( NOW(),'". 5 ."','"
						   . 1 ."','"
						   . $postedValue ."');";
		$res = mysql_query($sql);

 

to display

 

			$sql = "INSERT INTO messages
			   (  date, user_id, topic_id,  body  )  
				 VALUES( NOW(),'". 5 ."','"
						   . 1 ."','"
						   . $postedValue ."');";
		$res = mysql_query($sql);

[Jessica]

You posted the same code for both.

[aj123cd]

I am sorry

this is the code for display

 

                    $threadsql = "SELECT * FROM messages";
                    $threadresult = mysql_query($threadsql);
				$threadrow = mysql_fetch_assoc($threadresult);
				echo $threadrow['body'];

[Barand]

Between "$postedvalue" being posted and getting into that variable, what are you doing to it?

[aj123cd]

using CKeditor to post the value.

[Barand]

Good luck with your problem.

[aj123cd]

thank you

why I can not get HELP  :'(

[Pikachu2000]

The problem is obviously on line 42.

[Barand]

thank you

why I can not get HELP  :'(

 

When we ask you for further information that we need in order to help you, you don't give it. If you don't help us we can't help you.

[aj123cd]

This my code. Thank you.

 

<?php
include("../includes/config.php");	


if (isset($_POST['submit'])  ) {

		$sql = "INSERT INTO  forum_messagess
			   (  date, user_id, topic_id,  body  )  
				VALUES( NOW(),'". 5 ."','"
						   . 1 ."','"
						   . $postedValue ."');";
		$res = mysql_query($sql);



		$threadsql = "SELECT * FROM  forum_messages";
                    $threadresult = mysql_query($threadsql);
				$threadrow = mysql_fetch_assoc($threadresult);
				echo $threadrow['body'];
}
?>

<form action="" method="post">

<textarea name="body" rows="5" cols="15"></textarea>
    <input type="submit" name="submit" value="Submit">
   
</form>

[Jessica]

Is CKEditor a rich text editor? It's going to convert the < to <

[gizmola]

Is CKEditor a rich text editor? It's going to convert the

 

^^^^^^^^^^^^

[cyberRobot]

Does this help at all?

http://docs.cksource.com/FCKeditor_2.x/Developers_Guide/Configuration/Configuration_Options/ProcessHTMLEntities

 

Assuming that CKEditor is the one converting things to HTML entities, you could try asking their forum:

http://cksource.com/forums/