Mixing
how to set date field to 3 months back
-1
I am using a radio button for fetching the record of last 3 months from database. I am using a radio button for the user to select the date range, for three months back.
How do I set the value of the radio button, to eaxctly 3 months back?
<input type="radio" id="test7" name="thismonth" value="<?php echo date("Y-m", strtotime("-3 months"));?>" />
This sets the value for only one month but is there way I set the value to exactly three months back?
php mysql
edited Jan 2 at 14:22
Penguine
420414
asked Jan 2 at 10:45
Ahil KhanAhil Khan
226
add a comment |
-1
I am using a radio button for fetching the record of last 3 months from database. I am using a radio button for the user to select the date range, for three months back.
How do I set the value of the radio button, to eaxctly 3 months back?
<input type="radio" id="test7" name="thismonth" value="<?php echo date("Y-m", strtotime("-3 months"));?>" />
This sets the value for only one month but is there way I set the value to exactly three months back?
php mysql
edited Jan 2 at 14:22
Penguine
420414
asked Jan 2 at 10:45
Ahil KhanAhil Khan
226
I see no attempt of accessing your database in your code...
– Islam Elshobokshy
Jan 2 at 10:46
1
@Akhil, The question look like for MySQL part but you are showing HTML
– Anirudha Gupta
Jan 2 at 10:47
I just confirm that is there any way set the value of radio button from previous 3 months to current month?
– Ahil Khan
Jan 2 at 10:49
The issue is in your query, show us your query
– Muhammad Bilal
Jan 2 at 10:51
add a comment |
-1
-1
-1
I am using a radio button for fetching the record of last 3 months from database. I am using a radio button for the user to select the date range, for three months back.
How do I set the value of the radio button, to eaxctly 3 months back?
<input type="radio" id="test7" name="thismonth" value="<?php echo date("Y-m", strtotime("-3 months"));?>" />
This sets the value for only one month but is there way I set the value to exactly three months back?
php mysql
edited Jan 2 at 14:22
Penguine
420414
asked Jan 2 at 10:45
Ahil KhanAhil Khan
226
I am using a radio button for fetching the record of last 3 months from database. I am using a radio button for the user to select the date range, for three months back.
How do I set the value of the radio button, to eaxctly 3 months back?
<input type="radio" id="test7" name="thismonth" value="<?php echo date("Y-m", strtotime("-3 months"));?>" />
This sets the value for only one month but is there way I set the value to exactly three months back?
php mysql
php mysql
edited Jan 2 at 14:22
Penguine
420414
asked Jan 2 at 10:45
Ahil KhanAhil Khan
226
edited Jan 2 at 14:22
Penguine
420414
asked Jan 2 at 10:45
Ahil KhanAhil Khan
226
edited Jan 2 at 14:22
Penguine
420414
edited Jan 2 at 14:22
Penguine
420414
edited Jan 2 at 14:22
Penguine
420414
420414
asked Jan 2 at 10:45
Ahil KhanAhil Khan
226
asked Jan 2 at 10:45
Ahil KhanAhil Khan
226
asked Jan 2 at 10:45
Ahil KhanAhil Khan
226
226
I see no attempt of accessing your database in your code...
– Islam Elshobokshy
Jan 2 at 10:46
1
@Akhil, The question look like for MySQL part but you are showing HTML
– Anirudha Gupta
Jan 2 at 10:47
I just confirm that is there any way set the value of radio button from previous 3 months to current month?
– Ahil Khan
Jan 2 at 10:49
The issue is in your query, show us your query
– Muhammad Bilal
Jan 2 at 10:51
add a comment |
I see no attempt of accessing your database in your code...
– Islam Elshobokshy
Jan 2 at 10:46
1
@Akhil, The question look like for MySQL part but you are showing HTML
– Anirudha Gupta
Jan 2 at 10:47
I just confirm that is there any way set the value of radio button from previous 3 months to current month?
– Ahil Khan
Jan 2 at 10:49
The issue is in your query, show us your query
– Muhammad Bilal
Jan 2 at 10:51
I see no attempt of accessing your database in your code...
– Islam Elshobokshy
Jan 2 at 10:46
I see no attempt of accessing your database in your code...
– Islam Elshobokshy
Jan 2 at 10:46
1
1
@Akhil, The question look like for MySQL part but you are showing HTML
– Anirudha Gupta
Jan 2 at 10:47
@Akhil, The question look like for MySQL part but you are showing HTML
– Anirudha Gupta
Jan 2 at 10:47
I just confirm that is there any way set the value of radio button from previous 3 months to current month?
– Ahil Khan
Jan 2 at 10:49
I just confirm that is there any way set the value of radio button from previous 3 months to current month?
– Ahil Khan
Jan 2 at 10:49
The issue is in your query, show us your query
– Muhammad Bilal
Jan 2 at 10:51
The issue is in your query, show us your query
– Muhammad Bilal
Jan 2 at 10:51
add a comment |
2 Answers
2
active
oldest
votes
1
<?php
$value = $_POST["thismonth"];
// note : name attribute for your input field is 'thismonth', should be something else.
$query = "SELECT *columns* FROM *table* WHERE *date_column* BETWEEN '".$value."' AND '".date('Y-m')."' ";
?>
answered Jan 2 at 10:58
AkKiAkKi
18416
This is a dangerous way of creating queries. Please use prepared statements / parameterized queries.
– Christiaan
Jan 2 at 10:59
@Christiaan this was just for demo purpose to make him understand.
– AkKi
Jan 2 at 11:01
add a comment |
0
try like this:
<?$effectiveDate=date('y-m-d');
$effectiveDate = strtotime("-3 months", strtotime($effectiveDate)); ?>
<input type="radio" id="test7" name="thismonth" value="<?php echo effectiveDate?>" />
answered Jan 2 at 11:02
PenguinePenguine
420414
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004924%2fhow-to-set-date-field-to-3-months-back%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
<?php
$value = $_POST["thismonth"];
// note : name attribute for your input field is 'thismonth', should be something else.
$query = "SELECT *columns* FROM *table* WHERE *date_column* BETWEEN '".$value."' AND '".date('Y-m')."' ";
?>
answered Jan 2 at 10:58
AkKiAkKi
18416
This is a dangerous way of creating queries. Please use prepared statements / parameterized queries.
– Christiaan
Jan 2 at 10:59
@Christiaan this was just for demo purpose to make him understand.
– AkKi
Jan 2 at 11:01
add a comment |
1
<?php
$value = $_POST["thismonth"];
// note : name attribute for your input field is 'thismonth', should be something else.
$query = "SELECT *columns* FROM *table* WHERE *date_column* BETWEEN '".$value."' AND '".date('Y-m')."' ";
?>
answered Jan 2 at 10:58
AkKiAkKi
18416
This is a dangerous way of creating queries. Please use prepared statements / parameterized queries.
– Christiaan
Jan 2 at 10:59
@Christiaan this was just for demo purpose to make him understand.
– AkKi
Jan 2 at 11:01
add a comment |
1
1
1
<?php
$value = $_POST["thismonth"];
// note : name attribute for your input field is 'thismonth', should be something else.
$query = "SELECT *columns* FROM *table* WHERE *date_column* BETWEEN '".$value."' AND '".date('Y-m')."' ";
?>
answered Jan 2 at 10:58
AkKiAkKi
18416
<?php
$value = $_POST["thismonth"];
// note : name attribute for your input field is 'thismonth', should be something else.
$query = "SELECT *columns* FROM *table* WHERE *date_column* BETWEEN '".$value."' AND '".date('Y-m')."' ";
?>
answered Jan 2 at 10:58
AkKiAkKi
18416
answered Jan 2 at 10:58
AkKiAkKi
18416
answered Jan 2 at 10:58
AkKiAkKi
18416
answered Jan 2 at 10:58
AkKiAkKi
18416
18416
This is a dangerous way of creating queries. Please use prepared statements / parameterized queries.
– Christiaan
Jan 2 at 10:59
@Christiaan this was just for demo purpose to make him understand.
– AkKi
Jan 2 at 11:01
add a comment |
This is a dangerous way of creating queries. Please use prepared statements / parameterized queries.
– Christiaan
Jan 2 at 10:59
@Christiaan this was just for demo purpose to make him understand.
– AkKi
Jan 2 at 11:01
This is a dangerous way of creating queries. Please use prepared statements / parameterized queries.
– Christiaan
Jan 2 at 10:59
This is a dangerous way of creating queries. Please use prepared statements / parameterized queries.
– Christiaan
Jan 2 at 10:59
@Christiaan this was just for demo purpose to make him understand.
– AkKi
Jan 2 at 11:01
@Christiaan this was just for demo purpose to make him understand.
– AkKi
Jan 2 at 11:01
add a comment |
0
try like this:
<?$effectiveDate=date('y-m-d');
$effectiveDate = strtotime("-3 months", strtotime($effectiveDate)); ?>
<input type="radio" id="test7" name="thismonth" value="<?php echo effectiveDate?>" />
answered Jan 2 at 11:02
PenguinePenguine
420414
add a comment |
0
try like this:
<?$effectiveDate=date('y-m-d');
$effectiveDate = strtotime("-3 months", strtotime($effectiveDate)); ?>
<input type="radio" id="test7" name="thismonth" value="<?php echo effectiveDate?>" />
answered Jan 2 at 11:02
PenguinePenguine
420414
add a comment |
0
0
0
try like this:
<?$effectiveDate=date('y-m-d');
$effectiveDate = strtotime("-3 months", strtotime($effectiveDate)); ?>
<input type="radio" id="test7" name="thismonth" value="<?php echo effectiveDate?>" />
answered Jan 2 at 11:02
PenguinePenguine
420414
try like this:
<?$effectiveDate=date('y-m-d');
$effectiveDate = strtotime("-3 months", strtotime($effectiveDate)); ?>
<input type="radio" id="test7" name="thismonth" value="<?php echo effectiveDate?>" />
answered Jan 2 at 11:02
PenguinePenguine
420414
answered Jan 2 at 11:02
PenguinePenguine
420414
answered Jan 2 at 11:02
PenguinePenguine
420414
answered Jan 2 at 11:02
PenguinePenguine
420414
420414
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004924%2fhow-to-set-date-field-to-3-months-back%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I see no attempt of accessing your database in your code...
– Islam Elshobokshy
Jan 2 at 10:46
1
@Akhil, The question look like for MySQL part but you are showing HTML
– Anirudha Gupta
Jan 2 at 10:47
I just confirm that is there any way set the value of radio button from previous 3 months to current month?
– Ahil Khan
Jan 2 at 10:49
The issue is in your query, show us your query
– Muhammad Bilal
Jan 2 at 10:51