Having Problem with Date

Posted on 16th Feb 2014 07:03 pm by admin

l have a submit buttom where user have the possibility to add a date to specify when his message should be made reachable online.

I have seen a bug which l am not having a clue to solve and l need help.

Any time a user tries to edit his text, the edit formular opens with a given dateon 1999.11.30 and a dateof of 1999.11.30

For God sake l got no clue where these date digits are coming from.
This outdated problem doesn´t allow ediiting to save well.

Enclosed is my code.

MAybe one could figure out where l am going wrong.


Thanks in advance

Code: if(isset($_POST['save'])) {
// Saving Edited Formular

$message = "";
$maintext = htmlentities($_POST['maintext']);
$shorttext = $_POST['shorttext'];
$title = htmlentities($_POST['title']);
$linked = $_POST['linked'];
$dateon = ($_POST['startdate']);
$dateoff = ($_POST['enddate']);

if($lang == "ger") {
if(! empty($dateon)) {
$on = explode(".", $dateon);
if(count($on) == 3 && checkdate($on[1], $on[0], $on[2]))
$dateon = date("Y-m-d", mktime(0, 0, 0, $on[1], $on[0], $on[2]));
else
$status = 5;
}
if(! empty($dateoff)) {
$off = explode(".", $dateoff);
if(count($off) == 3 && checkdate($off[1], $off[0], $off[2]))
$dateoff = date("Y-m-d", mktime(0, 0, 0, $off[1], $off[0], $off[2]));
else
$status = 5;

}
}
else if ($lang != "ger") {
if(!empty($dateon)) {
$on = explode(".", $dateon);
if(count($on) == 3 && checkdate($on[1], $on[2], $on[0]))
$dateon = date("Y-m-d", mktime(0, 0, 0, $on[1], $on[2], $on[0]));
else
$status = 5;
}

if(!empty($dateoff)) {
$off = explode(".", $dateoff);
if(count($off) == 3 && checkdate($off[1], $off[2], $off[0]))
$dateoff = date("Y-m-d", mktime(0, 0, 0, $off[1], $off[2], $off[0]));
else
$status = 5;
}
}
if(empty($status)) {
if(isset($parent)) {
$resDate = my_sql_query("SELECT date_on, date_off FROM navi WHERE nid=$parent", "");
if(isset($resDate[0]))
$status = 2;
$catDateOn = $resDate[1][0]['date_on'];
$catDateOff = $resDate[1][0]['date_off'];
}
if(!empty($catDateOn) && !empty($dateon) && $catDateOn > $dateon) {
$status = 7;
}
else if(!empty($catDateOff) && !empty($dateoff) && $catDateOff < $dateoff) {
$status = 8;
}
else if($dateon != "" && $dateoff != "" && $dateon > $dateoff) {
$status = 9;
}


The Html Formular

Code:
$result = my_sql_query("SELECT date_on, date_off FROM navi WHERE nid=$sel AND is_campaign IS NOT NULL","");
if(!isset($result[0])) {
#$dateon = $result[1][0]["date_on"];
#$dateoff = $result[1][0]['date_off'];
if($lang == "ger") {
if($dateon != "") {
$on = explode("-", $dateon);
if(count($on) == 3)
$dateon = date("d.m.Y", mktime(0, 0, 0, $on[1], $on[2], $on[0]));
}
if($dateoff != "") {
$off = explode("-", $dateoff);
if(count($off) == 3)
$dateoff = date("d.m.Y", mktime(0, 0, 0, $off[1], $off[2], $off[0]));
}
} else {
if($dateon != "") {
$on = explode("-", $dateon);
if(count($on) == 3)
$dateon = date("Y-m-d", mktime(0, 0, 0, $on[1], $on[2], $on[0]));
}
if($dateoff != "") {
$off = explode("-", $dateoff);
if(count($off) == 3)
$dateoff = date("Y-m-d", mktime(0, 0, 0, $off[1], $off[2], $off[0]));
}
}
}

echo "<tr>n"
."<td width='10%'></td>n"
."<td width='800px' align='center' colspan='3'><br />"._FROM."&nbsp<input name='startdate' type='text' value='$dateon' size='15' maxlength='10'>&nbsp;&nbsp;"._TO."&nbsp<input name='enddate' type='text' value='$dateoff' size='15' maxlength='10'</td>n"
."<td width='10%'></td>n"
."</tr>n"
."<tr>n"
."<td width='10%'></td>n"
."<td width='800px' align='center' colspan='3'><br /><input type='submit' name='save' value='"._SAVE."' id='button'>&nbsp;&nbsp;<input type='submit' name='reset3' value='"._RESET."' id='button'></td>n"
#."<td width='10%'></td>n"
."</tr>n";

echo "</table><br /></td></tr></table><br /><br /><br />n"
."</div>n"
."</form>n";
echo "<script>document.form1.title.focus();</script>n";
echo "<script>textCounter(document.form1.shorttext, document.form1.countChars, $numberChars);</script>";

Other php-forum

button help
i originally had this but realised it is much easier to have a button.

Code: <?php

php file erros / need help please
Hello

Someone decoded a zend file for me.. after uploaded it on ftp i get some errors, i trye

php forms and database navigatio
Hello,
I'm new to php and i'd like to post the following.
I have written code to get records f

CHECK A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

tell csv import script to ignore blank rows?
Hi i have the below script but i get an error if a row is blank ie a return in the csv file at the e

Limiting uploaded file type
Hi. First post here
I am working on a simple upload script, and I need it to limit the allowed f

phpmailer class & pop.gmail.com?
Code: <?php
$mail->IsSMTP();
$mail->Host = "pop.gmail.com";

Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so

Passing JS to PHP
So I have the following
Code: <?php
getdetails(?><script type="text/

Pagination won't carry results past page 2.
Hi all,

I've worked out my pagination script and its paginating fine until I click next from