Jump to content

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


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>";
?>

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.