Basically I'm trying to add a date to my database (just a date, not datetime)
here's what I have so far:
$wpdb->insert(
'my_table',
array('date-adding'=>date('Y-m-d', '1994-06-14')),
array('%F')
);
it simply inserts 0000-00-00 so its something simple that's wrong - probly the %F but can't figure out what.
Thanks
Your PHP date() function is wrong, what are you trying to accomplish? The second parameter should be a UNIX timestamp, not a date string. Since you're just feeding it a static time string too, just use '1994-06-14', no reason to try and use the date() function.
If you want something dynamic using a string, try this:
date('Y-m-d', strtotime($dynamic_date_string))
EDIT AFTER DISCUSSION:
The root problem turned out to be the third parameter formatting string formatting the DATE as a float. Since there was no reason to format the date, removing that optional parameter fixed the issue. Also, formatting the input as a string using %s would have worked.
$wpdb actually did. I would, after my $wpdb->insert run var_dump($wpdb->last_query); exit(); to verify that the query executed was what I wanted.Use strtotime() and date():
$originalDate = "2010-03-21";
$newDate = date("d-m-Y", strtotime($originalDate));
Source: https://stackoverflow.com/a/2487938/1415724
Have a look at this:
<html>
<head>
<title>..</title>
<body>
<form action="work1.php" method="post">
Value1: <input type="text" name="date"><br>
<input type="Submit"/>
</form>
</body>
</head>
</html>
<?php
$username="root";
$password="abcdef";
$database="test_date";
$date=$_POST["date"]; // Your First Problem Post value
echo $date;
echo "i m here";
$date = date("Y/m/d", strtotime($date)); // 2nd Problem Date Format
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Unable to select database");
$query = "INSERT INTO date VALUES('','$date')";
mysql_query($query);
mysql_close();
?>
Source: http://www.daniweb.com/web-development/php/threads/300356/date-stored-in-mysql-as-0000-00-00
$date = date("Y-m-d", strtotime($_POST['date']));
$result = mysqli_query($link,"INSERT INTO visit_exclude_dates (date) VALUES ('{$date}')");
if(!$result) {
echo "Error: " . $link->error);
die();
}
$result->close();
$link->close();
Source: https://stackoverflow.com/a/16991316/1415724
Given that the data is coming from an input form field, here is an updated answer.
If you're trying to pass your data as a "string", then use double-quotes instead.
I.e.: $string="1994-06-14"; as compared to $string='1994-06-14';
are not treated the same in PHP.
Try using the following as an example:
<input type="text" name="date_input" value="<?php echo htmlspecialchars($date); ?>" />
'?1994, which is all that's going to be left of your date string after PHP tries to conver it to an integer, meaning you're going to be dealing with Jan 1st, 1970, approximately 12:33am.