PHP - Formatting Date And Adding One Year

Hi,

I've got a date picker on a form which puts data into a database in the YYYY-MM-DD format. Just wondering how I could also put the name of the month (extracted from that) as well as just the year into separate columns. Ie: To use the field race_date from the form to also fill the 'race_month' and 'race_year' columns in the database.

This code obviously only fills the 'race_date' column so far:
Code: [Select]

global $_POST;

$race_date = $_POST["race_date"] ;


....



$query = "INSERT INTO 10k_races (race_date, race_month, race_year)" . "VALUES ( '$race_date', '$race_month',  '$race_year')";

Hi all,   I have a search page where I'd like members to be able to search for races that they and their friends have entered into a database. When entering the data, users put the race date into the race_date field (Which is a DATETIME field) in the table.   I've set up the search and display pages, so users can search by a number of other criteria (first name, last name, race distance, time, etc), but am having trouble with searching by year. On my search form, is a field called race_year.   So, obviously I need some change in the code below, specifically in relation to the line $where .= " AND race_date='$race_year'"; because I want to extract the year part of the race_date column from the table and see if it matches $race_year .   Any advice would be appreciated.   Cheers, Dave  

$race_year = $_POST['race_year'];
if ($race_year != '')
{ // A year is selected
  $where .= " AND race_date='$race_year'";
}

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 i have a drop down menu for date which is meant to insert all 3 values into a date column bt is only sending the year how can i fix it

<select name="date_of_birth">

    <option value="1">January

    <option value="2">February

    <option value="3">March

    <option value="4">April

    <option value="5">May

    <option value="6">June

    <option value="7">July

    <option value="8">August

    <option value="9">September

    <option value="10">October

    <option value="11">November

    <option value="12">December

</select>

<select name="date_of_birth">

    <option value="1">1

    <option value="2">2

    <option value="3">3

    <option value="4">4

    <option value="5">5

    <option value="6">6

    <option value="7">7

    <option value="8">8

    <option value="9">9

    <option value="10">10

    <option value="11">11

    <option value="12">12

    <option value="13">13

    <option value="14">14

    <option value="15">15

    <option value="16">16

    <option value="17">17

    <option value="18">18

    <option value="19">19

    <option value="20">20

    <option value="21">21

    <option value="22">22

    <option value="23">23

    <option value="24">24

    <option value="25">25

    <option value="26">26

    <option value="27">27

    <option value="28">28

    <option value="29">29

    <option value="30">30

    <option value="31">31

</select>

<select name="date_of_birth" id="year">

<?php

$year = date("Y");

for($i=$year;$i>$year-50;$i--)

{

if($year == $i)

echo "<option value='$i' selected>Current Year</option>";

else

echo "<option value='$i'>$i</option>";

}

?>

Hi there,

This doesn't seem to echo as attempted, is their a way of doing this?


$body2 = "Hello $name, \n <strong>I want to make this paragraph bold!</strong>\n";


Displays as:

Code: [Select]
Hello John Smith,
<strong>I want to make this paragraph bold!</strong>

I want to format the text making it bold, but it displays the <strong> tags.

Thanks

Hi

Simple question, how do I reFormat a date.

$dateCreated   (2012-01-14)

to become:   14th jan 2012


So far I have this, but it's not working:
Code: [Select]
$expDate = explode('-',$dateCreated);
$date1 = mktime(0, 0, 0, date('m', $expDate[1]), date('d', $expDate[2]), date('Y', $expDate[0]));
$date = date('d m Y', $date1);



Thanks

Hi,

When I do this the result is a date of zeros?

$DateAndTime = date('d-m-y', strtotime($DateAndTime));

All I want is a date in format of DD0MM-YYY and the Time in HH:MM::SS

Any help would be great! I know it is basic, Thanks in advance

Having used unix timestamps in the past formatting the date used to be easy. But since converting to mysql DATETIME im struggling to format it properly. I basically pull the date from the database, convert it using strtotime(), then convert it to a date using date(). The problem is that when i use 'a' to display am/pm the time almost always says am. If the time is 11am then it will display 11am. If it's 12pm then it will display 12pm, but if it comes to 1pm and above it will revert back to 1am.

This is the date string I use:


date('jS M Y g:i a');


is this due to the fact that mysql DATETIME uses 24 hour clock ('H'), if so is there a way around this?

I'm not sure what I'm doing wrong.  I have a date in a table which is formatted as:
2010-08-13 00:00:00.

I am trying to change the date through PHP to display as 08-13-2010.  The date is being formatted as 12-31-1969.

Here's my code.


if($registrant->StatusDate != '0000-00-00 00:00:00')
{
$formattedDate = date('m-d-Y', $registrant->StatusDate);

$statusDate = '      as of ' . $formattedDate;
}



Can anyone advise me what I am doing wrong?

Thanks!

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?

Hello, i have two fields.  a beginning year and an ending year.  How can i make new fields out of the years in between the beginning and ending years.  i hope that makes sense. 

Hi all

I have a PHP script with the following var

print $date;

at the moment it is formatting the date like

03-24-2010

is it possible to get PHP to switch the date and month, so it looks like

24-03-2010

Thanks

I have selected datetime values from a MySQL database (originally stored with the NOW() method) and want to present them on a page formatted in a specific way. I succeded in making it work with the following php code:

$time = date('d/m Y H:i', strtotime($row['time']));
echo $time;

I am however unsure if this is the best way to do it? I noticed some comments at php.net stating that this method has some limitations due to UNIX time. I am confused. There seem to be many ways of formatting date and time. Maybe somebody can clarify the situation, and tell me what will be appropriate in the current situation? I will appreciate any suggestions ...   Erik 
Edited by erikla, 17 July 2014 - 10:01 AM.

Hi Guys,

I have got a date string which looks like the following:
Quote

Thu Feb 09 2012 07:25:00 GMT 0000 (GMT Standard Time)


I need to convert it to Quote

d-m-Y H:i

format.

Any ideas on how to do this?

Thanks!

Hi all.. 
I'm grabbing the following date format from an rss feed: 
Sun, 16 Jan 2011 00:00:00 -0800

What's the best way to strip away the first 5 characters (Sun, ) and the last 15 characters ( 00:00:00 -080)... but still keeping this as a date (not a string) to store in my database? 

Thanks in advance for any ideas!