PHP - Show Article Only If Date Is Current Or Later

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]";
}
?>

Hi,

I have database stored a field of date. I want to check if the date in the DB field is the same as the current date, how to do it?

Code:

$oracle = mysqli_real_escape_string($con, $_POST['oracle']);
$query 	= mysqli_query($con, "SELECT indate FROM staff WHERE OracleID ='$oracle'");
$row	= mysqli_fetch_array($query);
$num_row = mysqli_num_rows($query);
		
	if ($num_row > 0) 
	{	
		$curdate = date();
		if ($row['indate'] !== $curdate)
		{
			$query1=mysqli_query($con, "update staff set ClockedIn = 0, ClockedOut = 0 where OracleID='$session_id'")or die('Error In Session');
			header('location:home.php');				
		}
	}

 

Hi,

This may be something for JavaScript but I would like to know if and how it's possible to show who is currently active/viewing the page. Users are logged into the system with their own account.

The purpose of this is for a CRM where more than one person may be editing the same record, so undesired overwrites might occur which is what I'd like to avoid with this "other user editing this record" notification.

I'm looking to enter the current time and date into a mysql database using php.  My current code looks like this:

Code: [Select]
$now = date("m/d/y",time());
I then insert $now into the table into a datetime column.  This all works but the time when read from the column appears as 0000-00-00 00:00:00.

Any ideas what I'm doing wrong?

Thanks in advance.

What I am trying to do is I am making a Event page and I would like to have it list the events in 2 sections. One being "On" or "Before" current date and the next being "Past" current date so I can list the events in "Upcoming Events" and "Past Events"

the code im showing here is for the listing of my event page
I just need help turning this query into two separate querys with the date function im looking for.

Code: [Select]
<?php 
$result = mysql_query("SELECT * FROM event ORDER by eventdate DESC");
if (!$result) {
   die("query failed: " . msql_error());
}

while ($row = mysql_fetch_array($result)) {
list($id, $eventdate, $header, $description, $image, $location) = $row;
$description = nl2br($description);
$eventdate = date("M j, Y",strtotime("$eventdate"));

print('
<table width="680" border="0" cellpadding="14" cellspacing="0">
 <tr>
 <td>
<div class="myFont"><font size="+1" color="#4e8baf">'.$eventdate.' - </font><font size="+1"><b>'.$header.'</b></font></div>
<font size="+1"><a href="event.php?list=true&eventid='.$id.'">Details</a></font><br />
<hr color="#FFFFFF" width="100" align="left" size="1">
</td>
</tr>
  </table>
');

}
?>

Hi,

when i try to insert to table date value it gives me wrong current date.

$joindate = date('m-d-Y');
		
$sql = mysqli_query($con,"INSERT INTO staff (OracleID,StaffName,Des,joindate,username,password,isadmin)
VALUES ('$oracleid','$name','$des','$joindate','$username', '$pass','$isadmin')");

i get this in the main page after making date("d-m-Y",strtotime(date))

30-11--0001

why is that?

Edited April 7, 2020 by ramiwahdan

I am building a site that needs to update member accounts on a weekly basis.  At the moment I have a cron job set for 12:01 am on Monday, that resets five database fields for all of my members. The first field is the current week, the second field is the previous week, the third field is from two weeks ago, the fourth field is from three weeks ago, and the fifth field is from four weeks ago.  Obviously the cron job resets the first field to 0, and the data from this field is moved to field two (last week), and so on and so forth, and the data from the fifth field is just removed altogether.  However, this is really not preferred, because if/when I get 1000+ users, the cron job will take up a crapload of CPU as many mysql queries need to be executed for each account.

So, I am trying to implement a script that checks the last login date for a user, and if they have have not logged in since before the latest Monday, the Monday before that, the Monday before that, or the Monday before that, etc.

I have never really worked with dates, so I don't even know how to begin.

The last user login is stored as a DATA datatype in a mysql database, and is in the following format: YYYY-MM-DD.

Thanks in advance!

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342459.0

I am writing code in the ZEND framework and i need to get the current day in like 2012-02-03:
In the controller:
Code: [Select]
$time=date('YYYY-mm-dd',time());
$this->view->time=$time;In view:

Code: [Select]
<?php echo $this->time; ?>
Output:
2012201220122012-0202-0303

I dont know why it is displaying like that instead of once...there is no loop anywhere.

i have a table that shows payments made but  want to the payments only showing from a set date(06/12/14) and before this date i dont want to show   this is my sql that doesnt seem to work and is showing dates before the specified date. .

"SELECT * FROM payments2014, signup2014, editprop2014 WHERE signup2014.userid = payments2014.payment_userid AND editprop2014.prop_id = signup2014.prop_id AND signup2014.userid !='page1' AND signup2014.userid !='page6' AND signup2014.userid !='page4' AND payments2014.payment_transaction_status !='none' AND payments2014.payment_transaction_status !='CANCELLEDa' AND payments2014.payment_type !='deposit' AND payments2014.payment_paid_timestamp NOT LIKE '%2012%' AND payments2014.payment_paid_timestamp NOT LIKE '%2011%' AND payments2014.payment_paid_timestamp >= '06/12/14' ORDER BY payments2014.payment_id DESC"

i have some other parts in the statment but this one that should be filtering is 

host_payments2014.payment_paid_timestamp >= '06/12/14' 

thanks in advance

Hey guys only thing i can find online is examples of showing how much time is left until a predetermind time.

but what I need is how many minutes are left until the next hour hits

anyone have any ideas on this? Im wanting to do it in UNIX time

Hi guys

Just wanted to knw whats the php logic needed to create this function which shows current users viewing a topic

I knw we can have a database table which stores the topic ID as well as user id and that way we can record who is viewing a topic but what happens when they leave?

some users can just close there browser in which case I would never know when they left?


thank you guys

Hey guys,   Ive been working on this script and I cant seem to figure out how to highlite the current date in lets say a blue color.   Any ideas please?   <!DOCTYPE html>
    <html>
    <head>
    <title>Simple Month Calendar</title>
    <script type="text/javascript">
    // Author: Danny van der ven
    // Created: 12 aug 2014
    // P.S. I'm from The Netherlands, so the names of the weeks and months are in Dutch.
    var Calendar = function(divId) {
    //Store div id
    this.divId = divId;
    // Days of week, starting on Sunday
    this.DaysOfWeek = [
    'Z',
    'M',
    'D',
    'W',
    'D',
    'V',
    'Z'
    ];
    // Months, stating on January
    this.Months = ['januari', 'februari', 'maart', 'april', 'mei', 'juni', 'juli', 'augustus', 'september', 'oktober', 'november', 'december' ];
    // Set the current month, year
    var d = new Date();
    this.CurrentMonth = d.getMonth();
    this.CurrentYear = d.getFullYear();
    };
    // Goes to next month
    Calendar.prototype.nextMonth = function() {
    if ( this.CurrentMonth == 11 ) {
    this.CurrentMonth = 0;
    this.CurrentYear = this.CurrentYear + 1;
    }
    else {
    this.CurrentMonth = this.CurrentMonth + 1;
    }
    this.showCurrent();
    };
    // Goes to previous month
    Calendar.prototype.previousMonth = function() {
    if ( this.CurrentMonth == 0 ) {
    this.CurrentMonth = 11;
    this.CurrentYear = this.CurrentYear - 1;
    }
    else {
    this.CurrentMonth = this.CurrentMonth - 1;
    }
    this.showCurrent();
    };
    // Show current month
    Calendar.prototype.showCurrent = function() {
    this.showMonth(this.CurrentYear, this.CurrentMonth);
    };
    // Show month (year, month)
    Calendar.prototype.showMonth = function(y, m) {
    var d = new Date()
    // First day of the week in the selected month
    , firstDayOfMonth = new Date(y, m, 1).getDay()
    // Last day of the selected month
    , lastDateOfMonth = new Date(y, m+1, 0).getDate()
    // Last day of the previous month
    , lastDayOfLastMonth = m == 0 ? new Date(y-1, 11, 0).getDate() : new Date(y, m, 0).getDate();
    var html = '<table>';
    // Write selected month and year
    html += '<tr><td colspan="7">' + this.Months[m] + ' - ' + y + '</td></tr>';
    // Write the header of the days of the week
    html += '<tr>';
    for(var i=0; i < this.DaysOfWeek.length;i++) {
    html += '<td>' + this.DaysOfWeek[i] + '</td>';
    }
    html += '</tr>';
    // Write the days
    var i=1;
    do {
    var dow = new Date(y, m, i).getDay();
    // If Sunday, start new row
    if ( dow == 0 ) {
    html += '<tr>';
    }
    // If not Sunday but first day of the month
    // it will write the last days from the previous month
    else if ( i == 1 ) {
    html += '<tr>';
    var k = lastDayOfLastMonth - firstDayOfMonth+1;
    for(var j=0; j < firstDayOfMonth; j++) {
    html += '<td class="not-current">' + k + '</td>';
    k++;
    }
    }
    // Write the current day in the loop
    html += '<td>' + i + '</td>';
    // If Saturday, closes the row
    if ( dow == 6 ) {
    html += '</tr>';
    }
    // If not Saturday, but last day of the selected month
    // it will write the next few days from the next month
    else if ( i == lastDateOfMonth ) {
    var k=1;
    for(dow; dow < 6; dow++) {
    html += '<td class="not-current">' + k + '</td>';
    k++;
    }
    }
    i++;
    }while(i <= lastDateOfMonth);
    // Closes table
    html += '</table>';
    // Write HTML to the div
    document.getElementById(this.divId).innerHTML = html;
    };
    // On Load of the window
    window.onload = function() {
    // Start calendar
    var c = new Calendar("divCalendar");    
    c.showCurrent();
    // Bind next and previous button clicks
    getId('btnNext').onclick = function() {
    c.nextMonth();
    };
    getId('btnPrev').onclick = function() {
    c.previousMonth();
    };
    }
    // Get element by id
    function getId(id) {
    return document.getElementById(id);
    }
    </script>
    <style type="text/css">
    td.not-current {
    color: #777;
    }
    </style>
    </head>
    <body>
    <div id="divCalendar">
    </div>
    <button id="btnPrev" type="button">Terug</button>
    <button id="btnNext" type="button">Vooruit</button>
    </body>
    </html>
 

Hi everyone,

I have a basic calendar that I am trying to change to highlight the current date. I have got the current date highlighted using an if else statement inside a while clause, however, the issue arises when I use the forward/previous links to go to a different month - the same day is highlighted on those months as well.

Here is the code snippet in question (the entire code is below):


while( $day_num <= $days_in_month )
 {
 if(date('d') != $day_num) {
  echo "<td> $day_num </td>";
     $day_num++;
     $day_count++;
  }
// display today's date   
  else {
    echo "<td class=\"today\"> $day_num </td>";
    $day_num++;
$day_count++;
 }


My question is how do I get this calendar to display the current date, just on the current month. I assume there is something I am missing when it comes to handling the date(s) correctly, but what?

Any help is appreciated.

Thanks,

kaiman

Full code:


// gets today's date
$date = time () ;

// puts the day, month, and year in seperate variables
$day = date('d', $date) ;
$month = (int) ($_GET['month'] ? $_GET['month'] : date('m'));
$year = (int) ($_GET['year'] ? $_GET['year'] : date('Y'));

// generate the first day of the month
$first_day = mktime(0,0,0,$month, 1, $year) ;

// get the month name
$current_month = date('F', $first_day) ;

 // determine what day of the week the first day of the month falls on 
 $day_of_week = date('D', $first_day) ; 

 // determine blank days before start of month
 switch($day_of_week){ 

 case "Sun": $blank = 0; break; 

 case "Mon": $blank = 1; break; 

 case "Tue": $blank = 2; break; 

 case "Wed": $blank = 3; break; 

 case "Thu": $blank = 4; break; 

 case "Fri": $blank = 5; break; 

 case "Sat": $blank = 6; break; 

 }

 // determine how many days are in the current month

 $days_in_month = cal_days_in_month(0, $month, $year) ;
 
 // determine next month
 $next_month_link = '<a href="?month='.($month != 12 ? $month + 1 : 1).'&year='.($month != 12 ? $year : $year + 1).'">>></a>';
 
 // determine previous month
 $previous_month_link = '<a href="?month='.($month != 1 ? $month - 1 : 12).'&year='.($month != 1 ? $year : $year - 1).'"><<</a>';

// start building the table

 echo " <table border=0 width=294>\n";
 echo " <tr>\n";
 
// display month and year
 echo " <th> $previous_month_link </th>\n";
 echo " <th colspan=4> $current_month $year </th>\n";
 echo " <th> $next_month_link </th>\n";
 echo " </tr>\n";

// display days of week
 echo " <tr>\n";
 echo " <td width=42>S</td>\n";
 echo " <td width=42>M</td>\n";
 echo " <td width=42>T</td>\n";
 echo " <td width=42>W</td>\n";
 echo " <td width=42>T</td>\n";
 echo " <td width=42>F</td>\n";
 echo " <td width=42>S</td>\n";
 echo " </tr>\n";

 // counts the days in the week

 $day_count = 1;

 echo " <tr>\n";

 // display blank days

 while ( $blank > 0 ) 

 { 

 echo " <td></td>\n"; 

 $blank = $blank-1; 

 $day_count++;

 }
 
// sets the first day of the month to 1 

 $day_num = 1;

// count the days in the month and display them

while( $day_num <= $days_in_month )
 {
 if(date('d') != $day_num) {
  echo "<td> $day_num </td>";
     $day_num++;
     $day_count++;
  }
// display today's date   
  else {
    echo "<td class=\"today\"> $day_num </td>";
    $day_num++;
$day_count++;
 }

 // make sure we start a new row every week

 if ($day_count > 7)

 {

 echo " </tr>\n";
 echo " <tr>\n";

 $day_count = 1;

 }

 } 
 
 // finish calendar

 while ( $day_count >1 && $day_count <=7 ) 

 { 

 echo " <td>\n";
 echo " </td>\n"; 

 $day_count++; 

 } 

 echo " </tr>\n";
 echo " </table>\n";