[RESOLVED] help with date formatting please

idlepress

Hi I'm trying to change the format of my date to Month Day Year

<?php

mysql_connect ("xxx", "xxx", "xxx") or die ('I cannont connect: ' . mysql_error());
mysql_select_db ("database1");

$sql = "SELECT * FROM database1";

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

while($row=mysql_fetch_assoc($result)) { 
$dateum=$row["dateum"];
$time=$row["time"];
$location=$row["location"];
$event=$row["event"];

echo $dateum;
echo "<br/>";
echo $time;
echo "<br/>";
echo $location;
echo "<br/>";
echo $event;
echo "<br/><br/><hr/><br/>";}
?>

Which shows as:

2012-05-16
8pm
Somewhereville, State
This is the event

I want it to show as:

May 16, 2012
8pm
Somewhereville, State
This is the event

Thank you!

dalecosp

Dunno it's most efficient, but

date("M d, Y",strtotime("$dateum"));

seems like it would do the trick....

HTH,

idlepress

Excellent, thank you! I'm not sure if any of my code is most efficient but it works for me...

I changed M to F.

idlepress

Upon further investigation, my dates are all submitting as 1969...

vivek151189

$dateum = date("F d, Y", strtotime($dateum));

is also working perfectly
but what the proplem do You have with

date("M d, Y",strtotime("$dateum"));

use it as it is

idlepress

I can't figure out what is going on with my dates. I changed it back to normal and everything is showing up as 0000-00-00. I am typing them into my form as 2012-05-25. If I go to the phpmyadmin and do an insert and select the date from the calendar they show up fine.

Brad, I took your advice and listed the columns instead of * (even though I'm using the data from all columns, what is the difference?)

I have tried to use the DATE_FORMAT function but I get errors every way I try it.

Any help is greatly appreciated

<?php

mysql_connect ("xxx", "xxx", "xxx") or die ('I cannont connect: ' . mysql_error());
mysql_select_db ("xxx");

$sql = "SELECT ID, dateum, time, venue, location, event FROM xxx ORDER BY dateum DESC";

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

while($row=mysql_fetch_assoc($result)) { 
$dateum=$row["dateum"];
$time=$row["time"];
$venue=$row["venue"];
$location=$row["location"];
$event=$row["event"];

echo "<b>";
echo $dateum;
echo "</b><br/>";
echo $time;
echo "<br/>";
echo $venue;
echo "<br/>";
echo $location;
echo "<br/><br/>";
echo $event;
echo "<br/><br/><hr/><br/>";}

?>

SundariDevi

I had this 1969 problem when the form was posting a null value. so you get 1969 when the date's value is 0 or non-existent

Bonesnap

idlepress;11004477 wrote:

<?php

mysql_connect ("xxx", "xxx", "xxx") or die ('I cannont connect: ' . mysql_error());
mysql_select_db ("xxx");

$sql = "SELECT ID, dateum, time, venue, location, event FROM xxx ORDER BY dateum DESC";

Shouldn't you be querying a table within the database, and not the database itself (judging from you original post where both were the same and not censored)? If your database is named 'database1', then your query should be trying to pull information from a table within that database. Unless you have a table also named 'database1', which is confusing and certainly not recommended.

idlepress

The table and database are both named database1.

Here is what I'm working with:

Form:

<form method="post" action="insert.php">
Date: (YYYY-MM-DD)<br/>
<input type="text" name="dateum" size="30"><br/>
Time: <br/>
<input type="text" name="time" size="30"><br/>
Venue: <br/>
<input type="text" name="venue" size="30"><br/>
Location: <br/>
<input type="text" name="location" size="30"><br/>
Event Information: <br/>
<textarea name="event" rows="5" cols="30"></textarea><br/>
<input type="Submit"/>
</form><br/><br/>
<a href="clearevents.php">Clear past events</a>

Insert:

<?php
$date = $_POST['date'];
$time = $_POST['time'];
$venue = $_POST['venue'];
$location = $_POST['location'];
$event = $_POST['event'];

define('DB_NAME', 'database1');
define('DB_USER', 'xxx');
define('DB_PASSWORD', 'xxx');
define('DB_HOST', 'xxx');

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if (!$link) {
   die('Could not connect' . mysql_error());
}

$db_selected = mysql_select_db(DB_NAME, $link);

if (!$db_selected) {
   die ('No' . DB_NAME . ':' . mysql_error());
}

$value = $_POST['name'];

$sql = "INSERT INTO database1 (ID, dateum, time, venue, location, event) VALUES ('NULL', '$dateum', '$time', '$venue', '$location', '$event')";

if (!mysql_query($sql)) {
   die('Error ' . mysql_error());
}

echo "Event added";

?>

<?php

mysql_connect ("xxx", "xxx", "xxx") or die ('I cannont connect: ' . mysql_error());
mysql_select_db ("database1");

$sql = "SELECT ID, time, dateum, venue, location, event FROM database1 ORDER BY dateum DESC"; 

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

while($row=mysql_fetch_assoc($result)) { 
$dateum=$row["dateum"];
$time=$row["time"];
$venue=$row["venue"];
$location=$row["location"];
$event=$row["event"];

echo "<b>";
echo $dateum;
echo "</b><br/>";
echo $time;
echo "<br/>";
echo $venue;
echo "<br/>";
echo $location;
echo "<br/><br/>";
echo $event;
echo "<br/><br/><hr/><br/>";}

?>

This is the result:
0000-00-00
4:00 PM
This place
This location

This is an event

0000-00-00 should be 2012-04-16 (that's what I typed into the form)
Everything is showing except the date now, I can't figure out what I'm doing wrong with the dates.

Maybe setting it up wrong on phpmyadmin? Does this look OK or should I change something?

Field: dateum
Type: date
Collation: (blank)
Attributes: (blank)
Null: No
Default: (blank)
Extra: (blank)

Thanks again for the help. I'm obviously very new to this.

SundariDevi

$date = $POST['date'];
$time = $POST['time'];
$venue = $POST['venue'];
$location = $POST['location'];
$event = $_POST['event'];

define('DB_NAME', 'database1');
define('DB_USER', 'xxx');
define('DB_PASSWORD', 'xxx');
define('DB_HOST', 'xxx');

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if (!$link) {
die('Could not connect' . mysql_error());
}

$db_selected = mysql_select_db(DB_NAME, $link);

if (!$db_selected) {
die ('No' . DB_NAME . ':' . mysql_error());
}

$value = $_POST['name'];

$sql = "INSERT INTO database1 (ID, dateum, time, venue, location, event) VALUES ('NULL', '$dateum', '$time', '$venue', '$location', '$event')";

If I read your code correctly, you are getting 000 value for the date because dateum is not defined. In the code above, you define $date, but you insert $dateum, $dateum is defined nowhere in this code.

If you get this problem again you can easily see what value is getting passed to the database by doing something like:

echo "dateum = ".$dateum;

just before the insert command. Then you will see what's going on

Derokorian

SundariDevi;11004503 wrote:
If I read your code correctly, you are getting 000 value for the date because dateum is not defined. In the code above, you define $date, but you insert $dateum, $dateum is defined nowhere in this code.

Also, if error reporting was turned on you would be getting an undefined variable error for this, which would make (or have made, if this solves it) debugging much easier.

idlepress

I knew it would be a stupid mistake on my end. I changed that to dateum and got the date format figured out and everything is working properly.

Thanks for the help!

Now on to the next task of figuring out how to make an area to edit the information once submitted.

SundariDevi

Well, unless you don't need the ID field at all, you still have the problem that bradgrafelman pointed out about inserting the string 'NULL' into the ID field