PHP - Date From Database + 365 Days?

is there an easy way to add weekdays to a stored date ... so far i have

echo date ( 'Y-m-j' , strtotime ( '5 weekdays' ) );

this adds 5 weekdays to the current date , can i have it add 5 weekdays to say $TableDate 1;

Thanks in advance...

I was wondering if there was a way to have the MAX function NOT return a Date that is more than 2 days into the future (from the current day)?  If there is a Date that is more than 2 days into the future I would like to return the one closest to the current day.  Here is the code I have:

Code: [Select]
<?php

mysql_connect("local", "xxx", "xxx") or die(mysql_error());
mysql_select_db("pricelink") or die(mysql_error());



// Get a specific result from the "ft9_fuel_tax_price_lines" table
$query ="SELECT ItemNumber,TableCode,Cost, MAX(`Date`) as `max_date`, MAX(`Time`) as 'max_time' FROM `ft9_fuel_tax_price_lines`
         GROUP BY `ItemNumber`,`TableCode`";

$result = mysql_query($query) or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>ItemNumber</th> <th>TableCode</th> <th>Date</th> <th>Time</th> <th>Cost</th> </tr>";


// keeps getting the next row until there are no more to get
while($row=mysql_fetch_array($result))
{

// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['ItemNumber'];
        echo "</td><td>";
        echo $row['TableCode'];
        echo "</td><td>";
        echo $row['max_date'];
        echo "</td><td>";
        echo $row['max_time'];
        echo "</td><td>";
        echo $row['Cost'];
echo "</td></tr>"; 


} 

echo "</table>";
?>

Any help would be appreciated.
Thanks!

Hi, I am trying to get the number of days between the current date and a date in the future specified by column 'end_date'. The code I have seems to be working but it displays the number of days as a negative number, how do I change this to be a positive number? I have tried simply changing $days = $now - $end_date; to $days = $end_date - $now; but that doesn't work as I thought it would! Thanks in advance..

Code: [Select]
$now = time();
      $end_date = strtotime($row['end_date']);
      $days = $now - $end_date;
      echo floor($days/(60*60*24));

I have date stored in database in any of the given forms 2020-06-01, 2020-05-01 or 2019-04-01

I want to compare the old date with current date 2020-06-14

And the result should be in days.

Any help please?

PS: I want to do it on php side. but if its possible to do on database side (I am using myslq) please share both ways🙂

Edited June 14, 2020 by 684425

Hi all,

I am trying to figure out how to calculate 5 working days prior to a given date.

I have done some googling but can only see examples of how to add 5 working days onto a date, such as this:

Code: [Select]
$holidayList = array();
$j = $i = 1;

while($i <= 5)

{
    $day = strftime("%A",strtotime("+$j day"));
    $tmp = strftime("%d-%m-%Y",strtotime("+$j day"));
    if($day != "Sunday" and $day != "Saturday" and !in_array($tmp, $holidayList))
    {
        $i = $i + 1;
        $j = $j + 1;
    }
    else
        $j = $j + 1;
}
    $j = $j -1;
echo strftime("%A, %d-%m-%Y",strtotime("+$j day"));
Does anyone know how to calculate 5 working days prior to a date?

Many thanks,

Greens85

I need to display the last 30 days entries from database in PHP and here is the code that i am currently using, but its not working.

While entering the data in database, the date format that i am using is this...
Code: [Select]
$subon = date("F j, Y, g:i a");
And to display the code i am using this query...
Code: [Select]
$start_date = date("F j, Y, g:i a", strtotime('-30 days'));
$curr_date = date("F j, Y, g:i a");
$sql = "SELECT * FROM table WHERE status = 'approved' AND subon BETWEEN '$start_date' AND '$curr_date' ORDER BY ID DESC LIMIT 0, 5";
And then i am using the usual stuff to display the data but its not working.

Somebody please help me... Thanks in advance.

Hellow, i need help please, writing code and it doesn't work. please help...   Here it is

WHERE start_date BETWEEN 'start_date".strtotime('-3 day')."' AND 'start_date'";

without this code everithing works fine   Thank you

Hi, Currently I am making a module for joomla. every article has an publish date, if the article was published in 7 days ago, it will displayed as "article in last week", My idea is to use today's date - publish date, if the result is greater than 7 and smaller than 14, the article will be displayed as "article in last week.
Any one know how to write this code?
Here is what I have got, but not working.

<?php
$todays_date = date("Y-m-d"); 

$result = mysql_query("select * from jos_content where $test between $todays_date-14 and $todays_date-7");  
while($row = mysql_fetch_array($result))
  {
echo "$todays_date - $row[title]";
}
?>

heres the problem
i have 3 things in url bar
$day
$month
$year
(its important it stays 3 variables in url)

i know how to get them but what i need is convert these 3 into 1 value and store it to DATE(it would be good to be date type for later use) type in mysql

any ideas?

I am trying to update last logged in entry in the database upon succesful login. 

I may be way off in the logic here or I may be missing something simple.  I don't get any errors and it logs in fine.  Just does not update the lastvisit field in the database. 


       Code: [Select]
//record date of most recent login
$result = mysql_query("SELECT username FROM users WHERE user_id ='".$_SESSION['userId'] . "'");
$dtCreated = date('Y-m-d');
mysql_query("UPDATE users SET lastvisit=('$dtCreated') WHERE username = $result");

Hi
I have started my error checking for my form.  I am understand that the date must be inserted in the format yyyy/mm/dd but on my form i need it to be inserted in the format dd/mm/yyyy.  I have wrote some code but have only been doing php about a week properly so I can't see what my error is.  Whenever I try to insert the date, the form its self does not error but if i check the database the date is simply 0000/00/00.   Can anyone help?


if(isset($_POST['submit'])) {
     $first_name = mysql_real_escape_string($_POST['first_name']);
  $last_name = mysql_real_escape_string($_POST['last_name']);
   $DOB = mysql_real_escape_string($_POST['DOB']);
  $sex = mysql_real_escape_string($_POST['sex']);
 $email = mysql_real_escape_string($_POST['email']);
  $username = mysql_real_escape_string($_POST['username']);
   $password = mysql_real_escape_string($_POST['password']); 
   $agree = mysql_real_escape_string($_POST['agreed']);
    $creation_date = mysql_real_escape_string($_POST['creation_date']);
$user_type = mysql_real_escape_string($_POST['member_type']);
 $access_level = mysql_real_escape_string($_POST['access_level']);
  $validation = mysql_real_escape_string($_POST['validation_id']);
     $club_user = mysql_real_escape_string($_POST['user_type']);
  
 $date_check = "/^([0-9]{2})/([0-9]{2})/([0-9]{4})$/";
 if($first_name == "") {
$message = "Please enter a first name";
$success = 0;
}
else if($last_name == "") {
$message = "Please enter a surname";
$success = 0;
}

else if($DOB =="") {
$message = "Please enter your date of birth.";
$success = 0;
}
else if(!(preg_match("/^([0-9]{2})\/([0-9]{2})\/([0-9]{4})$/", $DOB))) {
$message = "Please enter your birthday in the format dd/mm/yyyy";
$success = 0;
}
else if($email =="") {
$message = "Please enter a correct email.";
$success = 0;
}
else if($username =="") {
$message = "Please enter a username.";
$success = 0;
}
else if($password =="") {
$message = "Please enter a password greater than 6 characters long.";
$success = 0;
}


else {


$DOB = $explode[2]."-".$explode[1]."-".$explode[0];
  
  $password_md5 = md5($password);
$insert_member= "INSERT INTO Members (`first_name`,`last_name`,`DOB`,`sex`,`email`,`username`,`password`,`agree`,`creation_date`,`usertype`,`access_level`,`validationID`) 
VALUES 
('".$first_name."','".$last_name."','".$DOB."','".$sex."','".$email."','".$username."','".$password_md5."','".$agree."','".$creation_date."','".$user_type."','".$access_level."', '".$validation."')";

$insert_member_now= mysql_query($insert_member) or die(mysql_error());

$url = "thankyou.php?name=".$_POST['username'];
header('Location: '.$url);

I can't figure out how to select something from the database that is under today's date. This is what I have:

if($row['date'] == ".date('Y-m-d').' 00:00:00'."' AND date < '".date('Y-m-d').' 23:59:59'.")

Any help would be greatly appreciated.

hello there.. i have a problem with my php coding where i want to keep date choose by user in the database.


this is the drop down date
Code: [Select]
<select name="Date_Day">
<option> - Day - </option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="Date_Month">
<option> - Month - </option>
<option value="01">January</option>
<option value="02">Febuary</option>
<option value="03">March</option>
<option value="04">April</option>
<option value="05">May</option>
<option value="06">June</option>
<option value="07">July</option>
<option value="08">August</option>
<option value="09">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="Date_Year">
<option> - Year - </option>
    <option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
    <option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
    <option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>
</select>
     
the code to connect to the database
Code: [Select]
      $date_year= ($_POST['Date_Year']);
$date_month=($_POST['Date_Month']);
$date_day=($_POST['Date_Day']);
                $date=$date_year."-".$date_month."-".$date_day;

$query="INSERT INTO aduan (date)
VALUES ('date($date)')";
$result=mysql_query($query);
if($result){
echo 'Registration success.';
?><script>window.location ='thanks.php'</script>
<?php
}
else
echo 'Registration failed';}
when enter a value of date, the database will just show '0000-00-00'.. really hope for your help.. 

Hi there,

I'm new to PHP so sorry if this is a really basic question.

How do i post date of birth collected from a form, into a database?

I have the fields in the form set up as 'day' 'month' 'year' all of which are drop-down boxes.

I tried doing it one way which i saw on a different website, but it didn't work. Here is what i tried: Code: [Select]
'$_POST[day] . - . $_POST[month]' . - . $_POST[year]',
More info: In the database table this information is going to, the "date of birth" field is set to "DATE" type. Don't know if that makes any difference

Hi people I have some code to retireve dates from a database, see below.

The issue is i can not find a way to change the output to d,m,Y instead of what the data comes back from database.

Any help with this would be much appriciated.

The transaction date is getting the invoice date created back as 2020-04-01 etc, but how to swap this code?, I dont think i can do it within the array.

$statement_transactions = array();
        $client_total_balance = $client_opening_balance;
        foreach ($client_invoices as $invoice_entry) {

        $transaction = [
                'transaction_type'          => self::TRANSACTION_TYPE_INVOICE,
                'transaction_date'          => $invoice_entry->invoice_date_created,
                'transaction_amount'        => $invoice_entry->invoice_total,
                'invoice_id'                => $invoice_entry->invoice_id,
                'client_id'                 => $invoice_entry->client_id,
                'user_company'              => $invoice_entry->user_company,
                'invoice_amount_id'         => $invoice_entry->invoice_amount_id,
                'invoice_item_subtotal'     => $invoice_entry->invoice_item_subtotal,
                'invoice_item_tax_total'    => $invoice_entry->invoice_item_tax_total,
                'invoice_total'             => $invoice_entry->invoice_total,
                'invoice_sign'              => $invoice_entry->invoice_sign,
                'invoice_status_id'         => $invoice_entry->invoice_status_id,
                'invoice_date_created'      => $invoice_entry->invoice_date_created,
                'invoice_time_created'      => $invoice_entry->invoice_time_created,
                'invoice_number'            => $invoice_entry->invoice_number,
            ];

            $client_total_balance += $invoice_entry->invoice_total;

            $statement_transactions[] = $transaction;

        }