Jump to content

alternative for 'new DateTime()' and 'date_format()' functions


hellonoko

Recommended Posts

My below code works fine running off WAMP however when I upload it to my host (globat) It fails after echoing "Recurring Events:" No errors even with all error reporting turned on.

 

Not sure if this is a problem with my host since they seem to have allot of trouble telling me if they have the DateTime and date_format functions installed...

 

Is there an alternative way to do what I am doing?

Change the format of how date is stored in the database YYYY-MM-DD.

 

Or is there something wrong with my code?

 

Thanks for your time.

 

<?php

error_reporting(E_ALL);


include 'dbconnect.php';

// echos recurring events first.

$query = "SELECT * FROM schedule WHERE recurring = 'TRUE'";

$result = mysql_query($query);
$rows = mysql_num_rows($result);


echo "<td align='center' valign='top'>";
echo "<div style='overflow:auto; height:320'>";


echo "<br><br>Recurring Events:<br><br>";

for ($i=0; $i <$rows; $i++)
{
	$row = mysql_fetch_array($result);

	$dateTime = new DateTime($row['eventdate']);

	echo	date_format( $dateTime, 'm-d-Y' );
	echo	"<br>";
	echo	$row['event'];
	echo	"<br>";
	//echo	$row[recurring];
	echo	"<br>";
	echo	"<br>";

}


// echos one time events

$query = "SELECT * FROM schedule WHERE recurring = 'FALSE'";

$result = mysql_query($query);
$rows = mysql_num_rows($result);


echo "Events:<br><br>";

for ($i=0; $i <$rows; $i++)
{
	$row = mysql_fetch_array($result);


	$dateTime = new DateTime($row['eventdate']);

	echo	date_format( $dateTime, 'm-d-Y' );
	echo	"<br>";
	echo	$row[event];
	echo	"<br>";
	//echo	$row[recurring];
	echo	"<br>";
	echo	"<br>";

}


echo "</div></td>";
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.