PHP - Formatting A Php Date From String

Hi guys, I'm putting together a small event system where I want the user to add his own date and time into a textfield (I'll probably make this a series of drop-downs/a date picker later).
This is then stored as a timestamp - "0000-00-00 00:00:00" which displays fine until I try to echo it out as a UK date in this format - jS F Y, which just gives today's date but not the inputted date.



Here's the code I have right now:

Code: [Select]
$result = mysql_query("SELECT * FROM stuff.events ORDER BY eventdate ASC");

echo "<br />";
echo mysql_result($result, $i, 'eventvenue');
echo ", ";

$dt = new DateTime($eventdate);

echo $dt->format("jS F Y");


In my mysql table eventdate is set up as follows:
 
field - eventdate
type - timestamp
length/values - blank
default - current_timestamp
collation - blank
attributes - on update CURRENT_TIMESTAMP
null - blank
auto_increment - blank


Any help as to why this could be happening would be much appreciated, thanks.

Hi all

Been trying to get my head around formatting a string, and struggling.

I have a serious of numbers held in a DB and I need these to display as 5 figure numbers. 

if the DB held the record "48"  I would need this to be displayed as "00048".

Can anyone give me a clue.  I've tried reading the php manual but this just confuses me more.

I am having a problem with what is probably encoding.

I am pulling strings from a WordPress database.  Below is a sample string:


Code: [Select]
Sed nec neque quis sapien scelerisque aliquet. In in est odio, ac auctor erat. Vestibulum fringilla dapibus sodales. Morbi facilisis egestas arcu, eu semper mi luctus vitae. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Suspendisse sollicitudin, metus sed hendrerit tristique, enim ante venenatis metus, ac consectetur mauris lorem et felis. Phasellus ac purus massa. Aliquam ligula mauris, iaculis et posuere vitae, pellentesque sit amet leo.

Praesent at eros et lacus scelerisque feugiat. Aliquam non facilisis libero. Ut blandit leo ut tortor convallis porttitor. Aliquam erat volutpat. Aliquam rhoncus rutrum metus, tempor sollicitudin ante laoreet in.

Sed tincidunt nibh a augue euismod sagittis. Fusce ullamcorper ultricies nisi, sit amet elementum mi scelerisque eget. Cras sed elit ligula, sit amet aliquam lectus. Nulla vel mollis nibh. Pellentesque ultricies, dui non aliquam eleifend, tortor ligula blandit dolor, quis interdum diam augue non eros. Nullam id molestie nunc. Integer id tempus est.

When WordPress displays this text, it is formatted correctly, with spaces between paragraphs, etc.

When I pull the string from the database, and echo it onto a page, the spaces between paragraphs are replaced by spaces, so in the end the output is as follows:


Code: [Select]
Sed nec neque quis sapien scelerisque aliquet. In in est odio, ac auctor erat. Vestibulum fringilla dapibus sodales. Morbi facilisis egestas arcu, eu semper mi luctus vitae. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Suspendisse sollicitudin, metus sed hendrerit tristique, enim ante venenatis metus, ac consectetur mauris lorem et felis. Phasellus ac purus massa. Aliquam ligula mauris, iaculis et posuere vitae, pellentesque sit amet leo.  Praesent at eros et lacus scelerisque feugiat. Aliquam non facilisis libero. Ut blandit leo ut tortor convallis porttitor. Aliquam erat volutpat. Aliquam rhoncus rutrum metus, tempor sollicitudin ante laoreet in. Sed tincidunt nibh a augue euismod sagittis. Fusce ullamcorper ultricies nisi, sit amet elementum mi scelerisque eget. Cras sed elit ligula, sit amet aliquam lectus. Nulla vel mollis nibh. Pellentesque ultricies, dui non aliquam eleifend, tortor ligula blandit dolor, quis interdum diam augue non eros. Nullam id molestie nunc. Integer id tempus est.

What can I do to follow WordPress' formatting?

Hi,

I have a textarea called registerDomain which i enter multiple domain names into (separated by a new line) e.g.

www.google.com www.sky.com www.bt.com

I have the following code to get each of the domains and format them like

google.com (lowercase without any spaces) sky.com (lowercase without any spaces) bt.com (lowercase without any spaces)

The below code I have works perfectly, however its awful to look at. I wondered if anyone could advise on a cleaner/more elegant way of achieving this.

Thanks,

	if (isset($_POST['submit'])) {
		$values = trim($_POST['registerDomain']);
		$array = explode("\n", $values);
		$array = array_filter($array, 'trim');
		
		foreach ($array as $line) {
			$domain = addslashes($line);
			$domain = preg_replace("/\r|\n/", "", $domain);
			$domain = strtolower($domain);
			$domain = str_replace("www.", "", $domain);
			$domain = str_replace(" ", "", $domain);

 

I'm going round in circles with this one, but I have a feeling that the answer is obvious.  I have POST information that I want to use as a date and display it using date format, but I don't know how to

The POST data outputs the following: 2011-9-23

Assuming I have defined $date as the posted data from the previous form, how do I write some code to tell it to output it as September 23, 2011, or just Sept 2011?