PHP - Echo W/c Dates

I have a log system that allows 10 logs on each side(Left and right). I am trying to make it so that the left side has the 10 most recent logs, then the right as the next 10. Any ideas?

Hi   I try to echo out random lines of a html file and want after submit password to whole content of the same html file. I have two Problems. 1st Problem When I echo out the random lines of the html file I don't get just the text but the code of the html file as well. I don't want that. I just want the text. How to do that?

for($x = 1;$x<=40;$x++) {
		$lines = file("$filename.html");
        echo $lines[rand(0, count($lines)-1)]."<br>";
        }

I tried instead of "file("$filename.html");" "readfile("$filename.html");" But then I get the random lines plus the whole content. Is there anything else I can use instead of file so that I get the random lines of text  without the html code?P.S file_get_contents doesn't work either have tried that one.     2nd Problem:   As you could see in my first problem I have a file called $filename.html. After I submit the value of a password I want the whole content. But it is like the program did forget what $filename.html is. How can I make the program remember what $filename.html is? Or with other words how to get the whole content of the html file?   My code:

if($_POST['submitPasswordIT']){
if ($_POST['passIT']== $password ){
$my_file = file_get_contents("$filename.html");
echo $my_file;
}
else{
echo "You entered wrong password";
}
}

If the password isn't correct I get: You entered wrong password. If the password is correct I get nothing. I probably need to create a path to the file "$filename.html", but I don't know exactly how to do that.   

Hey guys,

What I'm trying to do is set 2 dates.  Today's date and then a date 14 days from now.  However, I want it to increase the month if by adding 14 days will bring me to the next month, same with the year.

I have this, but it doesn't increment the month or year.

$week = mktime(11, 59, 59, date("m"), date("d")+14, date("y"));
$date =  date("Y-m-d H:i:s", $week);

Hey, I have just recently coded a forum and my topics are ordered by date. This means if there is a topic at 4pm and then there is another topic made at 4:01pm the topic which was posted at 4:01pm will be listed at the top.

I know how to add timezones but there is bit of a problem,  if  person from the UK posts a topic and his/hers timezone is set to:

date_default_timezone_set('Europe/London');()

this means the time at which the topic was posted will be 20:36pm (Just a randome time example).

However if someone posted a topic from america/los_angeles one hour before the one above his/her time will be 11:36 am. Even though this topic was posted one hour before the UK post. The UK topic will override it because it is 8:36pm. In fact, all UK topics will show up at the top and all the america/los_angeles topics will show bellow.

How do I slove this problem? I just don't get it even tough I looked online.

Please help, thanks.

Hi guys,

I am trying to create a program which manages campaigns.
each campaign has a start date and and end date.
a user has to enter data releated to the campaign everyday

example
start date: 10-1-2011
end date: 17-1-2011

now all this information is stored in 2 tables
1st table is "campaigns" this stores the campaign name, start date and end date
and 2nd table is "campaign_data" this table stored the data for each campaign and also date of when that data was entered

my question is, if the user did not enter data on 11-1-2011 how will I know this, keeping in mind the month diffrence which can accur if the length of the campign was 2 month long?


table:
campaigns
fields:
id | campaign_name | start_date | end_date

table:
campaign_data
fields:
id | campaign_id | date | page

Thank you

i want to created a case like the following need help with the syntax:
Code: [Select]
switch (true)
{
case($fromdate-$todate==17-04-2001-25-04-2011):
echo $finalprice = $result;
        break;
}

Hi,
So I only want my users to be able to perform certain tasks each 12 hours.
This is the code I use:
Code: [Select]
function canVote($ip, $vote_id, $updateTimer = true){
$time = date("Y-m-d H:i:s");

$this->CI->db->where('vote_id', $vote_id);
$this->CI->db->where('user_ip', $ip);
$this->CI->db->from('votes_voters');
$count =  $this->CI->db->count_all_results();
/*$count = $this->CI->db
->where('vote_id =', $vote_id)
->where('user_ip =', $ip)
->from('votes_voters')
-count_all_results();*/

$row = $this->CI->db
->where('vote_id =', $vote_id)
->where('user_ip =', $ip)
->get('votes_voters')
->row();

if($count == 0){
$data = array(
   'vote_id' => $vote_id,
   'user_ip' => $ip,
   'last_vote' => $time
);

$this->CI->db->insert('votes_voters', $data);
return true;
}
else{
$last_vote = $row->last_vote;
if($last_vote + strtotime("12 hours") < $time){
return false;
}
else{
if($updateTimer = true){
$data = array(
               'last_vote' => $time,
            );

$this->CI->db->where('vote_id', $vote_id);
$this->CI->db->where('user_ip', $ip);
$this->CI->db->update('votes_voters', $data);
}
return true;
}
}
}
Apparently the failing bit is this:
Code: [Select]
if($last_vote + strtotime("12 hours") < $time){
return false;
}
I believe you can guess what I'm trying to do here, if variable 1 + 12 hours is smaller than variable 2, then return false.
Any help is much appreciated.

Evening All,

How would I go about selecting a future date based on a date?

What I want to achieve is to take todays date, add ten days to it and then store it as the month end following that date.

For example 19th Nov + 10days = 29th November = 31st Dec


Many thanks for any pointers!

Hi All,

Bit stuck on something I think should be quite simple.
I have a table which includes events that have a state date and end date (startdate, enddate).

I've got a search function that pulls out with various criteria etc, however i'm now doing a search by date.

For example, an event may start on 1st Jan 2011 and finish on 1st May 2011.
If my search for which events are on on the 2nd February; it should pull the above event out, as it lies inbetween those dates.

Code: [Select]
SELECT * FROM events WHERE ((DAY(events.startdate <= '".date('d',$day)."') AND DAY(events.enddate >= '".date('d',$day)."')) AND MONTH(events.startdate <= '".date('m',$day)."') AND MONTH(events.enddate >= '".date('m',$day)."'))

Theres a bunch of other stuff joining tables etc, but you get the idea.
For some reason this isn't working?

I've got it working by month, but month AND day is eluding me. I also need to add in the year, but that isn't so important at the moment.

Any help would be amazing!

Thanks

E

I need to do some reporting and I need some help.  The reporting periods are as follows:

08/28-09/03
09/04-09/10
09/11-09/17
09/18-09/24
09/25-10/01

So, they are Sunday through Saturday throughout each month.  Say the date is Sept. 7.... How can I find out the date of the Sunday before last.  How can I know what month I am reporting for?

I am querying the database each Wed. for sales data from the previous month.  I want to take the totals from my query and store them in a separate table.  The problem is, I don't know how to find out what month the previous week falls into.  And I don't know how to find the date of the Sunday before last.

Thanks,

Jake

Hello there,

I have a DB table where everyday I insert my meetings for the future.

I want to ask you guys if anybody can help me with creating some sort of a weekly report.

EXAMPLE:

I have meeting from the beginning of the year (Mon-Sat)...could be 4-10 meeting per day, so a lot in general.

I want them to appear , with sql, under the WEEK they were in for example:
(a year has 52 weeks)

WEEK 1 (01-01-2011 -> 08-01-2011)
*M1
*M2
*M3
...

WEEK 2 (09-01-2011 -> 16-01-2011)
*M4
*M5
*M6
...


etc...

Is there a way to define the date's range after the week ended automatically?

Thanks

how do I order two tables by date so that the most recent are first and the most unrecent last?  like table 1 should be first then a table 2 then a table 1.  does this make sense?

Hi, I am trying two compare to dates but have not been successful.

A row is filled in Mysql database called htime with   $check=mktime(17,0,0,04,10,2011);

My first question is  that in the mktime function I have entered 17 which is hours. I would like to know if thats like the 17th hour of the given day or thats not how it works?

My second question is it a valid query to use <= or >= or < in a  mysql query for example.

$query="SELECT * FROM hdb WHERE htime <='".time()."'";

Thirdly I want to know if a row is filled with mktime(17,0,0,04,10,2011);  for example How can I only extract the day from the database based on the time has passed? This is because my own query doesnt seem to be working which is the query above I have no errors but the results dont seem to be right. Any help is much appreciated thanks.

Hi, I have a created comment system, now what i am after is when the comment is posted the time is posted in hidden format. All is going fine but what i don't know, what should the time be posted as example date(H:m:s) or... the result i want is time in minutes first e.g.
commented 2 mins ago and increasing to hours after that days. Could some one kindly guide me in the right directions.