[RESOLVED] Date function

[tams]

Hello,

I have this date function that generates a drop down menu for dates. The problem is that the day and month section in the dates is in "d" and "m" format and I want it to be in "DD" and "MM" format. How can I achieve the desired result so mysql can record the dates?

Thank you

[NogDog]

It's hard to say without seeing any code. One possibility is to use sprintf() to get the desired format:

$month = 7;
$day = 9;
$year = 2007;
$date = sprintf("%04f-%02f-%02f", $year, $month, $day);

[tams]

Here is the function I am using

function dateSelect()
{

$date1 = array(date(Y),date(m), date(d));

 echo "<select type=\"text\" name=\"month\" value=\"\" size=\"1\">";
for ($i=1;$i<=12;$i++) {
    if($i==$date12[1]) { echo "<option SELECTED>&nbsp;$i&nbsp;</option>"; }
    else { echo "<option>$i</option>"; }
}
echo "</select>"; 

   echo "<select type=\"text\" name=\"day\" value=\"\" size=\"1\">";
  for ($i=1;$i<=31;$i++) {
    if($i==$date12[2]) { echo "<option SELECTED>&nbsp;$i&nbsp;</option>"; }
    else { echo "<option>$i</option>"; }
}
    echo "</select>";

  echo "<select type=\"text\" name=\"year\" value=\"\" size=\"1\">";
  for ($i=2015;$i>=1945;$i--) {
    if($i==$date12[0]) { echo "<option SELECTED>&nbsp;$i&nbsp;</option>"; }
    else { echo "<option>$i</option>"; }
}
    echo "</select>";

}

so how do I use the code you provided with this function?
thank you

[tams]

Here is the part of the date function where I format it.

<?php dateSelect();
           $date12 =  $_POST['year']."-".$_POST['month']."-".$_POST['day'];

?>

However, I am not sure where to add the sprintf. I tried adding in both pieces of code but it didn't seem to work.

Any ideas?

Thank you

[NogDog]

$date12 =  sprintf("%04d-%02d-%02d", $_POST['year'], $_POST['month'], $_POST['day']);

[tams]

I did try the above code but my date format in my form is still yyyy-m-d. And when I insert any of this into the database the dates are saved as "0000-00-00".

I have attached an image of the dates.

[bradgrafelman]

tams wrote:

I did try the above code but my date format in my form is still yyyy-m-d.

How do you know? The code suggested doesn't change the displayed dates at all - it alters the date before it's (presumably) used in a SQL query. To verify, I even tested the code:

$_POST['year'] = '2007';
$_POST['month'] = '7';
$_POST['day'] = '2';

$date12 =  sprintf("%04d-%02d-%02d", $_POST['year'], $_POST['month'], $_POST['day']); 
echo $date12; // 2007-07-02

tams wrote:

And when I insert any of this into the database the dates are saved as "0000-00-00".

Might be a problem with your query. Can you show us the code that inserts the data? Also, it might help if you echo out the query and paste that for us to see, too.

[tams]

ok here is the code that inserts it in the database.

 	
$query="INSERT INTO dependent    

(familyname,firstname,relationship,nationality,birthdate,sex,familyname2,firstname2,
relationship2,nationality2,birthdate2,sex2,familyname3,firstname3,relationship3,
nationality3,birthdate3,sex3)
VALUES('$_POST[ffname]','$_POST[ffirstname2]','$_POST[frelation1]','$_POST[fnationality2]','$_POST[date10]','$_POST[sex2]','$_POST[ffname1]','$_POST[ffirstname3]','$_POST[frelation2]','$_POST[fnationality3]','$_POST[date11]','$_POST[sex3]','$_POST[ffname2]','$_POST[ffirstname4]','$_POST[frelation3]','$_POST[fnationality4]','$_POST[date12]','$_POST[sex4]')";
$result = mysqli_multi_query($cxn,$query) or die ("Couldn't execute query.".mysqli_error($cxn));
	echo $query;

This code inserts the values for all other fields into the database. It just doesn't insert the dates. Instead the dates show up as "0000-00-00"

[bradgrafelman]

The code used above creates a variable called $date12, not $_POST['date12']. Fix that and it should work fine.

Also, it appears as though you're vulnerable to SQL injection attacks. User-supplied data should never be placed directly into a SQL query! Instead, sanitize it with a function such as [man]mysql_real_escape_string/man.

[shaneH]

bradgrafelman, code should work for you but, your "date(m)" and "date(d)" should be giving you a 2 digit month (MM) and day (DD) according to php.net. That is how I get it with my code when I need a 2 digit month or day.

[tams]

It still doesn't work. the format in the database is still 0000-00-00.
here is the result of echo query

INSERT INTO dependent (familyname,firstname,relationship,nationality, birthdate,sex,familyname2,firstname2,relationship2,nationality2, birthdate2,sex2,familyname3,firstname3,relationship3,nationality3, birthdate3,sex3) VALUES('something1','something1','relation1','somewhere1','','Male','something2','something2','relation2','somewhere2','','Male','something3','something3',
'relation3','somewhere3','','Male')

[bradgrafelman]

tams wrote:

It still doesn't work.

Did you fix the problem I pointed out above? If so, can we see the new PHP code for the INSERT query?

[tams]

I did change it.

Here is the new code

$query="INSERT INTO dependent (familyname,firstname,relationship,nationality, birthdate,sex,familyname2,firstname2,relationship2,nationality2, 			birthdate2,sex2,familyname3,firstname3,relationship3,nationality3, birthdate3,sex3)
		VALUES('$_POST[ffname]','$_POST[ffirstname2]','$_POST[frelation1]','$_POST[fnationality2]','$date10','$_POST[sex2]','$_POST[ffname1]','$_POST[ffirstname3]','$_POST[frelation2]','$_POST[fnationality3]','$date11','$_POST[sex3]','$_POST[ffname2]','$_POST[ffirstname4]','$_POST[frelation3]','$_POST[fnationality4]','$date12','$_POST[sex4]')";
$result = mysqli_multi_query($cxn,$query) or die ("Couldn't execute query.".mysqli_error($cxn));
	echo $query;

[bradgrafelman]

And you also added the above suggested code, so your code looks like:

$date12 =  sprintf("%04d-%02d-%02d", $_POST['year'], $_POST['month'], $_POST['day']);

$query="INSERT INTO dependent (familyname,firstname,relationship,nationality, birthdate,sex,familyname2,firstname2,relationship2,nationality2,             birthdate2,sex2,familyname3,firstname3,relationship3,nationality3, birthdate3,sex3) 
        VALUES('$_POST[ffname]','$_POST[ffirstname2]','$_POST[frelation1]','$_POST[fnationality2]','$date10','$_POST[sex2]','$_POST[ffname1]','$_POST[ffirstname3]','$_POST[frelation2]','$_POST[fnationality3]','$date11','$_POST[sex3]','$_POST[ffname2]','$_POST[ffirstname4]','$_POST[frelation3]','$_POST[fnationality4]','$date12','$_POST[sex4]')"; 
$result = mysqli_multi_query($cxn,$query) or die ("Couldn't execute query.".mysqli_error($cxn)); 
    echo $query; 

?

[tams]

yes, everything is done.
but it is still 0000-00-00

I have been working on this since last month and now it is just driving me crazy so help is greatly appreciated.

[maxpup979]

Can you print out your query please? (print $query) It appears that it should work, however if it is entering 0000-00-00 there is most likely a formatting issue or possibly the date fields are not there to begin with.

Thanks

[tams]

Here is the result of print $query
As you can see the date fields are empty.

INSERT INTO dependent (familyname,firstname,relationship,nationality, birthdate,sex,familyname2,firstname2,relationship2,nationality2, birthdate2,sex2,familyname3,firstname3,relationship3,nationality3, birthdate3,sex3) VALUES('something12','something12','someone12','somewhere12','','Male','something22','something22','someone22','somewhere22','','Male','something32','something32','someone32','somewhere32','','Male')

[tams]

Here is all the php code

function gen12Select()
{

$date12 = array(date(Y),date(MM), date(DD));
 echo "<select type=\"text\" name=\"month\" value=\"\" size=\"1\">";
for ($i=1;$i<=12;$i++) {
    if($i==$date12[1]) { echo "<option SELECTED>&nbsp;$i&nbsp;</option>"; }
    else { echo "<option>$i</option>"; }
}
echo "</select>"; 

   echo "<select type=\"text\" name=\"day\" value=\"\" size=\"1\">";
   for ($i=1;$i<=31;$i++) {
   if($i==$date12[2]) { echo "<option SELECTED>&nbsp;$i&nbsp;</option>"; }
   else { echo "<option>$i</option>"; }
}
    echo "</select>";

  echo "<select type=\"text\" name=\"year\" value=\"\" size=\"1\">";
  for ($i=2015;$i>=1950;$i--) {
    if($i==$date12[0]) { echo "<option SELECTED>&nbsp;$i&nbsp;</option>"; }
    else { echo "<option>$i</option>"; }
}
    echo "</select>";

}

<?php gen12Select();
           $date12 =  sprintf("%04d-%02d-%02d", $_POST['year'], $_POST['month'], $_POST['day']);

?>

$query="INSERT INTO dependent (familyname,firstname,relationship,nationality, birthdate,sex,familyname2,firstname2,relationship2,nationality2, 			birthdate2,sex2,familyname3,firstname3,relationship3,nationality3, birthdate3,sex3)
		VALUES('$_POST[ffname]','$_POST[ffirstname2]','$_POST[frelation1]','$_POST[fnationality2]','$date10','$_POST[sex2]','$_POST[ffname1]','$_POST[ffirstname3]','$_POST[frelation2]','$_POST[fnationality3]','$date11','$_POST[sex3]','$_POST[ffname2]','$_POST[ffirstname4]','$_POST[frelation3]','$_POST[fnationality4]','$date12','$_POST[sex4]')";
  	$result = mysqli_multi_query($cxn,$query) or die ("Couldn't execute query.".mysqli_error($cxn));
	print $query;

That is all the code I have used for dates.

Thank you in advance.

[tams]

Does having your mysql server and php on a linux machine effect the date saving process?
I mean I read about strtotime for unix timestamp and I was wondering if something similar is having an effect on my dates.

[maxpup979]

Thanks for the info- I think you have a couple of problems, but they are most likely easily fixed. The first issue appears to me to be in the function gen12select. I would guess that you are not getting todays date preselected in the dropdowns. This is because MM and DD are not doing what you think they are. This will not work:

$date12 = array(date(Y),date(MM), date(DD));

but this should:

$date12 = array(date(Y),date(n), date(j));

The second thing that is a bit confusing to me is the placement of the date12 =sprintf... line. Try putting that right above the query. ie:

$date12 =  sprintf("%04d-%02d-%02d", $_POST['year'], $_POST['month'], $_POST['day']); 
$query="INSERT INTO dependent (familyname,firstname,relationship,nationality, birthdate,sex,familyname2,firstname2,relationship2,nationality2,             birthdate2,sex2,familyname3,firstname3,relationship3,nationality3, birthdate3,sex3)
        VALUES('$_POST[ffname]','$_POST[ffirstname2]','$_POST[frelation1]','$_POST[fnationality2]','$date10','$_POST[sex2]','$_POST[ffname1]','$_POST[ffirstname3]','$_POST[frelation2]','$_POST[fnationality3]','$date11','$_POST[sex3]','$_POST[ffname2]','$_POST[ffirstname4]','$_POST[frelation3]','$_POST[fnationality4]','$date12','$_POST[sex4]')";
      $result = mysqli_multi_query($cxn,$query) or die ("Couldn't execute query.".mysqli_error($cxn));
    print $query; 

I believe you are trying to access the $_POST variables for the date before they actually exist.

Hope that helps!