PHP - Issue In Count Date From Date Range

I am working on a report generation. Here I need to count the number of months involved in the selected date range. I need to apply the monthly charges accordingly.

Example: If the user selects 25-08-2011 to 03-10-2011, it should return 3 as the number of months.

Yes, the number of days are less than 60 but still the date range is spread across 3 months.

Any solution.. Please.

Girish

Setup:
Mysql table 1: acct#, client name, status(active/not active), Starting balance, ending balance
Mysql table 2: acct#, invoice amount, invoice date, total


how do i select all customers that are Active, and the starting balance != ending balance and then get the total for all invoices for that customer where the invoice date is between 2010-01-01 and 2010-03-01

Basically my out put needs to look like this.

Customer name, Total of all invoices for customer
john doe,  $10,564.21   
Susy Scott, $158.02
Bang Head, $837,294.85

Customer can have multiple invoices within the given date range. But I only need the total for all the invoices for each customer added up and echo'ed.

Quickness is also a factor on the query and echo.

Thank you for your valuable time.

 

Hi,   I can I include a date range criteria to query with in the following code? The date field in the table (t_persons) is IncidentDate.

$criteria = array('FamilyName', 'FirstName', 'OtherNames', 'NRCNo', 'PassportNo', 'Gender', 'IncidenceCountryID', 'Status', 'OffenceKeyword', 'AgencyID', 'CountryID', 'IncidenceCountryID' );
    $likes = "";
    $url_criteria = '';
    foreach ( $criteria AS $criterion ) {
            if ( ! empty($_POST[$criterion]) ) {
                    $value = ($_POST[$criterion]);
                    $likes .= " AND `$criterion` LIKE '%$value%'";
                    $url_criteria .= '&'.$criterion.'='.htmlentities($_POST[$criterion]);
            } elseif ( ! empty($_GET[$criterion]) ) {
                    $value = mysql_real_escape_string($_GET[$criterion]);
                    $likes .= " AND `$criterion` LIKE '%$value%'";
                    $url_criteria .= '&'.$criterion.'='.htmlentities($_GET[$criterion]);
            } //var_dump($likes);
    }
    $sql = "SELECT * FROM t_persons WHERE PersonID>0" . $likes . " ORDER BY PersonID DESC";

Kind regards.  

Hi all This is a one I've spent DAYS on and can't figure out :-\ This is for a wedding venue and their pricing schedule is divided into low, medium, high and very high seasons. I.e. low season runs from 8 Jan 16 to 28 Feb 16, medium runs from 4 Mar 16 to 20 Mar 16, etc.

The database for this is laid out as attached.   I would like people to be able to enter their arrival and departure date and for it to be able to choose which seasons the date range falls under. I.e. If they stay 8 to 12 Jan, that's no problem to calculate and falls under LOW season. However, if they stay 27 Feb to 10 Mar, this falls under both LOW and MID seasons, with the majority of the stay in the MID season (which we'd price with but can use PHP to choose the 'highest' season from the array). I'm a bit stumped on this one so any help is hugely appreciated! I'm sure it's something quite simple that I'm missing. Attached Files  Screen Shot 2015-01-10 at 16.58.17.png   146.3KB   0 downloads

I'm trying to do the following PHP. I have written it in English

if (today's date) => date1 AND <= date2 then {display image1}
elseif (today's date) => date3 AND <= date4 then {display image2}
else {display image 13}

There are 24 fixed dates and 13 fixed images.

I have tried using combinations of strtotime(), replacing the date value with variables, hard coding the dates within the program. I don't seem to be able to get any combination to work properly. I'm sure it's just a syntax error but I can't see it. When I've searched the web all the answers I've found relate to dates within databases but as I only have 24 dates it seems a bit of overkill. I would appreciate any pointers to the correct method I might be able to use. The dates need only a day and month as I would like this to repeat year after year.

<?php
$today = strtotime(date('d-m'));

if (strtotime($today) >= strtotime('28-10') && strtotime($today) <= strtotime('24-11')) {echo "<div>image1</div>";}
elseif (strtotime($today) >= strtotime('25-11') && strtotime($today) <= strtotime('22-12')) {echo "<div>image2</div>" ;}
elseif (strtotime($today) >= strtotime('23-12') && strtotime($today) <= strtotime('24-02')) {echo "<div>image3</div>" ;}
else {echo "<div>image13</div>";}
?>

The result I get from this is image1 appears on the web page but I would expect image3 as today is 22-01

Thank you in advance.

Andrew

Hello,

Im trying to work out some code.  On my site between Thursday 12th July and Sunday 15th July between the hours of 22:00 and 23:00 I want to display some code.  I've done this so far, but am having trouble. Anyone please help?



$the_date = date("H:i:s"); 
$timesep = explode(":",$the_date); // 
$hour = $timesep[0]; 

if (($the_date > 2010-08-12  && < 2010-08-15) && ($hour >= 22) && ($hour <= 23)) {
//Code
}

Hi. Im searching for a way to enter multiple records at once to mysql databased on a date range. Lets say i want to insert from date 2010-11-23 to date 2010-11-25 a textbox with some info and the outcome could look in database like below.

----------------------------------------------------------
| ID   |   date                |   name   |    amount   |
-----------------------------------------------------------
| 1     |   2010-11-23    |   Jhon     |        1         |
| 2     |   2010-11-24    |   Jhon     |        1         |
| 2     |   2010-11-25    |   Jhon     |        1         |
-----------------------------------------------------------

The reason i need the insertion to be like this is because if quering by month and by user to see vacation days then vacations that start in one month and end in another month can be summed by one month. If its in one record then it will pop up in both months.

Help is really welcome.

Hello,   I've been going about reading different posts on here and other forums but so far I haven't been able to come across something that works for my purpose so after all the reading I thought I'd finally just ask. I'm rather new at php/sql queries so please bare with me.   First what I'm trying to accomplish.   I need a form with several fields (options) to fetch information from a table that will then display the results based on the options selected.   - from date - to date - employee name - department - branch - product line   In other words, the purpose is to be able to choose a date range (from one day to up to a year or more) and then to be able to choose either ONE employee name to view statistics invididually from a given department and branch or to select a department to view all the statistics for everyone under that given department and/or brach and/or product line.   Now the tricky part is that besides fetching the records, calculations need to be made before the records are displayed and that part right here is what is giving me a huge headache.   This is the query that I have.

SELECT
report_daily_id,
report_date,
emp_id,
emp_fullname,
emp_dept,
emp_branch
prod_line
calls,
tk_time,
hld_time,
ac_time,
tran_calls,
work_time,
tran_rate,
ah_time
FROM daily_report
GROUP BY emp_id, emp_fullname, emp_branch, emp_dept, prod_line

The calculations based on the date range and one or more of the other options need to give me the following results.

SUM(calls) AS 'Total Calls'
SUM(tk_time) / SUM(calls) AS 'Talk Time'
SUM(hld_time) / SUM(calls) AS 'Held Time'
SUM(ac_time) / SUM(calls) AS 'AC Time'
SUM(tran_calls) AS 'Total Trans'
SUM(tran_calls) / SUM(calls) AS 'Tran Rate'
SUM(ah_time) / SUM(calls) AS 'AH Time'

I don't know how else to explain myself past this point but if you have any questions, perhaps I can answer it and give more details.   Thank you,

I have the week date range displaying the week range from sunday - saturday   $current_dayname = date("0"); // return sunday monday tuesday etc.
echo $date = date("Y-m-d",strtotime('last sunday')).'to'.date("Y-m-d",strtotime("next saturday"));   Which outputs in the following format 2015-01-25to2015-01-31   However, when I press next or previous, the dates don't change.   <?php
$year = (isset($_GET['year'])) ? $_GET['year'] : date("Y");
$week = (isset($_GET['week'])) ? $_GET['week'] : date('W');
if($week > 52) {
    $year++;
    $week = 1;
} elseif($week < 1) {
    $year--;
    $week = 52;
}
?>

<a href="<?php echo $_SERVER['PHP_SELF'].'?week='.($week == 52 ? 1 : 1 + $week).'&year='.($week == 52 ? 1 + $year : $year); ?>">Next  Week</a> <!--Next week-->
<a href="<?php echo $_SERVER['PHP_SELF'].'?week='.($week == 1 ? 52 : $week -1).'&year='.($week == 1 ? $year - 1 : $year); ?>">Pre Week</a> <!--Previous week-->

<table border="1px">
    <tr>
        <td>user</td>
<?php
if($week < 10) {
    $week = '0'. $week;
}
for($day= 1; $day <= 7; $day++) {
    $d = strtotime($year ."W". $week . $day);

    echo "<td>". date('l', $d) ."<br>". date('d M', $d) ."</td>";
}
?>
    </tr>
</table>

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack

Hi guys, I've hit a brick wall here and am in need of your help.

I'm pretty new to PHP and have limited knowledge to say the least. I'll explain what it is I'm trying to do.

Set start date as 01/01/2004 (dmY) $oFour
Set how many days has it been since then? $today
Set how many days it was from $ofour 30 days ago. $today -30 = $thirtyDaysAgo


But the problem is I don't know how to make date('z'); work from 2004 and not 01/01/2010.

So $today will be how many days it has been since the start of 2004 and $thirtyDaysAgo will be $today -30. I can set up $thirtyDaysAgo no problem but it's just finding out how to get the $today number...


Hope anyone can offer a little light to my situation :/

Mav

Hello i am working on an application where i want to count from a selected date to another date and query all entries my database right now is composed of the following
sales_id
barcode_id
student_id
type of lunch
date

i have created the count per day, but now dont know how to go about to query the results and the count for the month.
Code: [Select]
$query = 'SELECT COUNT(*) FROM `sales` WHERE `tlunch` = 1 AND DATE(date) = CURDATE()';
$result = mysql_query($query) or die('Sorry, we could not count the number of results: ' . mysql_error());
$free = mysql_result($result, 0);

has any one done something similar

I made the basic function to count the number of left count and right count. However now i need to display then number of additions to a tree according to their joining date. I stuck here. can someone please show me the logic to do this ?

I know i need to use UNION for sql because date of joining and tree structure are in different tables.

Sql tables-

Member table -(doj is date of join)


Tree table-


Basic Code-
Code: [Select]
<?php 
function tree_count($node)   //Function to calculate count;$node is first lchild or first rchild.
  {
    $sql = "SELECT lchild,rchild FROM tree WHERE parent = '".$node."'" ;
 // $sql = "SELECT lchild,rchild FROM tree WHERE parent = '".$node."'             should i do something like this ?
 //           UNION SELECT member_id FROM member WHERE id_sponsor=".$node." AND doj BETWEEN '".$from."' AND '".$to."'" ;
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
    
    if(!empty($array['lchild']))
    {
      $count += tree_count($array['lchild']);
      
    } 
    if(!empty($array['rchild']))
    {
       $count += tree_count($array['rchild']);
       
    }
    
    $totalcount = 1 + $count;
    return $totalcount;
    
  }  
?>

Hi guys

I'm kinda stuck..so hopefully you guys can lend me a hand

I've got an array containing date elements ("Y-m-d")...

I'm trying to output some data into googlecharts..so i need to count how many elements that are in the array with todays date -1 day, todays date-2 days...todays date -3days etc... Up until a set number of days (for example 7 days, 14 days etc)..

Any advice on how to go about to achieve this?