PHP - Calculating Number Of Days

I have a database lets say punch_log

The data in the table looks like:
---------------------------------------------------------------------------
|punch_log_id |  user_id | punch_id |   punch_time           |
---------------------------------------------------------------------------
|   10010         |  21         |   1       | 2010-11-10 15:04:59|
|   10011         |  21         |       2       | 2010-11-10 15:50:05|
|   10010         |  21         |   1       | 2010-11-11 15:04:59|
|   10011         |  21         |       2       | 2010-11-11 15:50:05|
|   10010         |  21         |   1       | 2010-11-12 15:04:59|
|   10011         |  21         |       2       | 2010-11-12 15:50:05|
|   10010         |  21         |   1       | 2010-11-13 15:04:59|
|   10011         |  21         |       2       | 2010-11-13 15:50:05|
|   10010         |  21         |   1       | 2010-11-14 15:04:59|
|   10011         |  21         |       2       | 2010-11-14 15:50:05|
|   10010         |  21         |   1       | 2010-11-14 15:50:59|  <-- this is why i need this.
|   10011         |  21         |       2       | 2010-11-14 15:55:05|  <-- this is why i need this.
----------------------------------------------------------------------------

Im currently using :

$kust  = $_POST['AKuu'];
$kuni3 = $_POST['LKuu'];
$valitudtootaja   = $_POST['TNimi'];


mysql_select_db($database, $con);
$query2 = "SELECT *, SUM(punch_id) FROM punch_log WHERE user_id = '".$valitudtootaja."' AND punch_time   BETWEEN '$kust' AND '$kuni3' AND punch_id ='1' ";   
$result2 = mysql_query($query2) or die(mysql_error());
while($row = mysql_fetch_array($result2)){
   $X = $row['SUM(punch_id)'];

When using the current query im getting

Workers days at work = 6
it should be 5 but thats why i need some solution to group dates and then sum them.

Does anybody have any ideas?

Hi,

I have a job listing website which displays the closing date of applications using:

$expired_date

(This displays a date such as 31st December 2019)

I am trying to show a countdown/number of days left until the closing date.

I have put this together, but I can't get it to show the number of days.

                    <?php 
                    $expired_date = get_post_meta( $post->ID, '_job_expires', true );
                    $hide_expiration = get_post_meta( $post->ID, '_hide_expiration', true );
                    if(empty($hide_expiration )) {
                        if(!empty($expired_date)) { ?>
                                <span><?php echo date_i18n( get_option( 'date_format' ), strtotime( get_post_meta( $post->ID, '_job_expires', true ) ) ) ?></span>
                    
                    <?php
                                        $datetime1 = new DateTime($expired_date);
                                        $datetime2 = date('d');
                                        $interval = $datetime1->diff($datetime2);
                                        echo $interval->d;

                     ?>
                        <?php }
                    } 
                    ?>

Can anyone help me with what I have wrong?

Many thanks

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?

Hello, I have problem durring binding update query. I can't find what is causing problem.

public function Update(Entry $e)
    {
        try
        {
            $query = "update entry set string = $e->string,delimiter=$e->delimiter where entryid= $e->id";
            $stmt = $this->db->mysqli->prepare($query);
            $stmt->bind_param('ssi',$e->string,$e->delimiter,$e->id);

            $stmt->close();
           

        }
        catch(Exception $ex)
        {
            print 'Error: ' .$ex->getMessage();
        }
    }

When I run function update I'm getting next error:Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement   Can you help me to solve this problem ?
Edited by danchi, 17 October 2014 - 10:25 AM.

I need to display a number(the number is retrieved from the db) in the form input field such that only the last 4 digits is visbile, the remaining can be masked as * or X or whatever is applicable.

I know the last 4 can be obtained as follows:

    Code: [Select]
$number=substr($number,-4,4);
 
But when i hit the submit button the form validates the input field and checks if the number is a valid number of a specific format.
Therefore when I click on the submit button then I should still be able to unmask the masked numbers or do something similar that would help me validate the whole number.

  Code: [Select]
  <input type="text" name="no" value="<?php if(!empty($number)){ echo $number;} ?>">

Hi everyone,
I'm trying to add up the current time with a specified amount of seconds and insert it in a database afterwards.
When I add say: 500 seconds to the current time it adds a whole lot more and I get a number few thousands higher than I want. Can anyone help me???.
Gr Ryflex

I have a form that I will post the code for. In my form I have a few things that need to be filled out.... Age, Gender, Coverage Amount, and Health Conditions.

The Health Conditions are 5 check boxes the user can select.

Now what I'm trying to do is make it so that when the user hits submit the Age and number of Health Conditions checked off will do this...

if # of Health Conditions <=2 and Age is <= 30 then = $0.90

if # of Health Conditions =>2 but <=5 and Age is <= 30 then = $1.20

Then after those are calculated I need these to apply to the code...


- Men are charged a 5% gender risk
- Students receive an 8% discount


Here is a example of what I'm trying to get this to do...

If you are a 23 year old male student who smokes but has no other risk factors your
premium amount per $10,000 would be $0.90 * 1.05 * 0.92 = $0.8694. If you wanted to take out a
$150,000 life insurance, your monthly premium would be $13.04 (15 * $0.8694).



I'm doing a life insurance form and these are some of the calculations that need to go into it. I'm not sure how I would code these. If someone could help me get started that would be great.



Here is my form code and the display page.


Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">


<head>
    <title>Lab 4</title>
   
</head>


<body>
    <?php


?>



<form method="POST" action="lab4form.php">

<label for="first_name">First Name:</label>
<input type="text" id="first_name" name="first_name" /><br />
<label for="last_name">Last Name:</label>
<input type="text" id="last_name" name="last_name" /><br />
<label for="coverage_amount">Coverage Amount:</label>
<input type="text" id="coverage_amount" name="coverage_amount" /><br />
<label for="gender">Gender:</label>
<br>
<input id="male" type="radio" value="Male" name="gender" />
<label for="male">Male</label>

<input id="female" type="radio" value="Female" name="gender" />
<label for="female">Female</label> <br />
<br>
<label for="Age">Age:</label>
<input type="text" id="age" name="age" /><br />
<br>
<label for="health">Health Conditions</label> <br />

<input type="checkbox" name="health" value="Heart Disease" />
<label for="health">Heart Disease</label><br />

<input type="checkbox" name="health" value="Diabetes" />
<label for="health">Diabetes</label><br />

<input type="checkbox" name="health" value="High Blood Pressure" />
<label for="health">High Blood Pressure</label><br />

<input type="checkbox" name="health" value="Smoker" />
<label for="health">Smoker</label><br />

<input type="checkbox" name="health" value="Lung Disease" />
<label for="health">Lung disease</label><br />

<FORM METHOD=POST ACTION="lab4form.php">
<P>Employment Status<BR>
<SELECT NAME="employment">
<OPTION VALUE="Unemployed">Unemployed
<OPTION VALUE="Full-Time">Full-Time
<OPTION VALUE="Part-Time">Part-Time
<OPTION VALUE="Student">Student
</SELECT><br />
<br>
<label for="comments">Comments</label>
<input type="text" id="comments" name="comments"/><br />






<br>
<input type="submit" value="Add User" name="btn_add" />
</form>
</body>
</html>



Display Page




Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

   

    <head>

        <title>Lab4</title>

       

    </head>

    <body>

    <div id="page">

        <div id="main">






        <div id="content">

           

            <h2>Life Insurance</h2>

            <table>

                <tr>

                    <th>Coverage Amount</th>

                    <th>Name</th>

                    <th>Gender</th>

<th>Age</th>

<th>Health Conditions</th>

<th>Employment Status</th>

<th>Comments</th>



                </tr>

<?php

$coverage_amount = $_POST['coverage_amount'];
$age = $_POST['age'];
$health = $_POST['health'];


if $age = 



?>










                                <tr>



                    <td><?php echo $_POST['coverage_amount'];?></td>

                    <td><?php echo $_POST['first_name'];?></td>

                    <td><?php echo $_POST['gender'];?></td>

<td><?php echo $age?></td>

<td class="right"><?php echo $_POST['health'];?></td>

<td class="right"><?php echo $_POST['employment'];?></td>

<td><?php echo $_POST['comments'];?></td>



                </tr>

                 

                            </table>

        </div>

        </div>

        <div id="footer"></div>

    </div>

    </body>

</html>

I have a timestamp field in my mySQL table and need to check if it's 14 day or older.  What's the best way to do this?

Any help will be appreciated

Not asking someone to do this for me. Just looking for someone to help me get going, and show me how to do this.


Need helping calculating text boxes on a form. I want my form to display the premium of $10,000 health insurance. What I mean by this is that I have a form that involves filling out life insurance information.

This is the table I'm basing this off of...

                                                      Age <=30
#health conditions <=2                   $0.90
2 <= #health conditions <=5           $1.20



The number of health conditions is equivalent to the number of check boxes that were checked. Additionally,
the following conditions apply:

- Men are charged a 5% gender risk
- Students receive an 8% discount

For example, if you are a 23 year old male student who smokes but has no other risk factors your
premium amount per $10,000 would be $0.90 * 1.05 * 0.92 = $0.8694. If you wanted to take out a
$150,000 life insurance, your monthly premium would be $13.04 (15 * $0.8694).



I'm new to php and haven't really calculated forms before...


here is my form codes....



Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">


<head>
    <title>Lab 4</title>
   
</head>


<body>
    <?php


?>



<form method="POST" action="lab4form.php">

<label for="first_name">First Name:</label>
<input type="text" id="first_name" name="first_name" /><br />
<label for="last_name">Last Name:</label>
<input type="text" id="last_name" name="last_name" /><br />
<label for="coverage_amount">Coverage Amount:</label>
<input type="text" id="coverage_amount" name="coverage_amount" /><br />
<label for="gender">Gender:</label>
<br>
<input id="male" type="radio" value="Male" name="gender" />
<label for="male">Male</label>

<input id="female" type="radio" value="Female" name="gender" />
<label for="female">Female</label> <br />
<br>
<label for="Age">Age:</label>
<input type="text" id="age" name="age" /><br />
<br>
<label for="health">Health Conditions</label> <br />

<input type="checkbox" name="health" value="Heart Disease" />
<label for="health">Heart Disease</label><br />

<input type="checkbox" name="health" value="Diabetes" />
<label for="health">Diabetes</label><br />

<input type="checkbox" name="health" value="High Blood Pressure" />
<label for="health">High Blood Pressure</label><br />

<input type="checkbox" name="health" value="Smoker" />
<label for="health">Smoker</label><br />

<input type="checkbox" name="health" value="Lung Disease" />
<label for="health">Lung disease</label><br />

<FORM METHOD=POST ACTION="lab4form.php">
<P>Employment Status<BR>
<SELECT NAME="employment">
<OPTION VALUE="Unemployed">Unemployed
<OPTION VALUE="Full-Time">Full-Time
<OPTION VALUE="Part-Time">Part-Time
<OPTION VALUE="Student">Student
</SELECT><br />
<br>
<label for="comments">Comments</label>
<input type="text" id="comments" name="comments"/><br />






<br>
<input type="submit" value="Add User" name="btn_add" />
</form>
</body>
</html>

I'm trying to figure out if today's current date and time falls between Mon & Fri, but so far, I can't get it to work.
Can anybody look at my code and see what I'm doing wrong?

Code: [Select]
<?php
$day_start = date('D h:i a', strtotime("Mon 05:30"));
$day_end = date('D h:i a', strtotime("Fri 10:00"));
$day_current = date('D h:i a', strtotime("+1 hours"));

if (($day_current > $day_start) && ($day_current < $day_end))
{
echo "yup";
}
else {
echo "nope";
}
?>

Thanks in advance

Hello,

I am having a heck of a time trying to get time right on my website lol  When a user logs in, they select what timezone they are in (UTC -1,-2,-3,-4,-5,-6....)  Now this is great an all, but with daylight savings time my times are off by one hour in either direction.  How do sites like this get times to work for users so easily?

Thanks!
weee

hi all,

i'm trying to calculate the time difference between two dates in hours, for example: 2010-12-13 15:26:56 and 2011-12-13 15:26:56
i tried mktime but wasn't able to get a working function.

Thanks for the help

Hi,

This query will show match stats of a user, the query is the output in the attatchment.
I want to calculate the streak if score1 is greater than score2. So basically, in the attatchment I have selected 3 rows, these 3 rows should be a 3 streak because the user won 3 matches in a row (according to date)

Code: [Select]
SELECT * FROM webs_cup_matches WHERE ladID='17' AND (clan1 != '0' AND clan2 != '0') AND (clan1='2630' || clan2='2630') AND (clan1 != '2147483647' AND clan2 != '2147483647') ORDER BY date DESC
any help appreciated.

Okay guys, I figured out how to calculate monthly subscriptions into days, but I am stuck on calculating multiple monthly subscriptions.. for example

Heres my mysql table:


How would I calculate this:
Subscription Start: February 21, 2011, 12:00 am
Subscription End: April 22, 2011, 12:00 am
Subscription Left: 60 days

My trouble is that when the user buys another month, it calculates the end time based on the new "Subscription Start Date". Or vice versa.

Any ideas guys?
Thanks.

Hello

Please can someone PLEASE PLEASE help me.

I have a form that the user inputs dimension and weights of a parcel. They then request a price on request I do the following:

$volume_mass = 50(dimm1) *50 (dimm2) * 50 (dimm3);
so that means $volume_mass = 125000
I then take the total of the weight - $actual_mass = 20(weight)

I am doing the following query to see what service are available

  $data = "SELECT * FROM rates WHERE hub_from = 'nxd' AND hub_to = 'auk'";
  $result = mysql_query($data)
  or die ("Error in query: $data. " . mysql_error());

if (mysql_num_rows($result) > 0)
{

while($row = mysql_fetch_object($result))
   
   
                             
    } 
              ?>

So I get multiple results and I need to now work out the cost per result.

Example of results from rates table

$service    $volume    $base    $min_kg    $per_kg
AIR          5000           70.00       5                 4
ECO          4000           80.00       10         4
LOX          5000           45.00        1                35
LSE          5000           45.00        1                35
OVN          5000           70.00        10         4

Know I need to do the following per result (per service)

need to the volume factor from the service -  &totalv = $volume_mass / $volume (from the rates table) Check if which is now greater between $actual_mass and $totalv - $charge_mass = $actual_mass <> $totalv then need to calculate the costs - if $charge_mass <= $min_kg then $total_cost = $base echo "$total_cost" else if $charge_mass > $min_kg then $total_cost = ($charge_mass - $min_kg) *$per_kg + $base  echo "$total_cost"    
   

Any help would be greatly appreciated