PHP - How To Refresh Content Every Minute (accoring To The Clock)

I have read almost every forum post I could find on this subject and still couldnt find what I am looking for.

What I need this program to do is allow an employee to punch in and punch out as often as needed. Then I need to be able to calculate the total time they were punched in for that day.

This is what I currently have set up.

The Database
id(auto inc) -- employee -- date -- time

Once the employee logs in I have a button they can click which will create a record in the database. What I need is to be able to do is run a mysql_query and show their total time.

I know there is still a lot left to script and code still. But I wanted to know if I am on the right track with the database. I wasnt sure if I should have two buttons "clock in" and "clock out" and record them in different columns, or if having one column for both clock in and out was sufficient for calculating hours.

I do not need the ability to change hours for an admin because I will be able to manually go into the database if need be. What I do need is to be able to keep this records so that you can look at past weeks.

<?php 
$user = $_SESSION['myusername'];
$result = mysql_query("SELECT * FROM hours WHERE member='$user'");

while ($row = mysql_fetch_array($result)){
echo $row['date'] . " " . $row['time'] . "<br />";
}die (mysql_error());

?>

This is what I currently have just to display all the records from the logged in user. I need to be able to subtract time and organize by date then by week.

Any help will be appreciated.

Thanks in advance.

This topic has been moved to JavaScript Help.

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

Hi,

I will start off trying to explain what I am trying to make the best I can. What I want to create is a script that gets the gold value from this website: http://www.lbma.org.uk/pages/index.cfm?page_id=46&title=current_statistics and then save it to a variable which I will use to calculate values of different gold karats.

Here is the content in bold I need on the website I linked:
Quote

LONDON GOLD FIXING
          USD             GBP              EUR
AM   1588.00     1005.127      1251.083
PM   1589.50     1004.741     1249.803




So what help do I need? Well, I don't expect you to figure out the calculating part for me but some help how to get that content pointed out above and save it to a variable is what I would appreciate getting some help with.

I don't know much PHP, only some and I have been trying to figure this out for a day now without any success.  I suppose php get contents and/or curl should be used here but I don't know how really. I would very much appreciate the help I can get on this.

Thank you!

I am making a time clock, and I was wondering what is the best way to calculate the number of hours an employee worked?

I have a table called "statuses" it holds names of punch types:
- id = the auto_inc
- status = "in/out/break/lunch" text statuses
- paid = whether or not the punch is paid or not (true/false)

I have another table called "logging" This table holds the information about the punch type:
- id = the auto_inc
- owner = the member id
- ip = members ip
- inout = the punch type from the statuses table
- location = the city/state of where the punch took place
- date = the time the member punched

Maybe I am over thinking this, but what is the best way to calculate the hours a person has worked?

Right now I am getting all the punches for for a particular member between a date range. then loop through the data to display it and passing it to a method in a class called Calc. I want to then add the times from punch in to punch out, then the next punch in to punch out.

Any suggestions?

So basically, My Bulletfactory page is playing up. Every 30 minutes the bulletfactory should produce bullets, it is producing the bullets fine, but only when someone views the page (after 30 minutes is up). If there any kind of PHP refresh for this? Or do i just use normal refresh?

Thanks

will refresh a page every second will cause some crash or error ??
cause when i try this, it sometimes display this error

"Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL "
this is occur when i run it in my local server. I am so worried if this might also happen when i run it online.

thanks

i have already echoed title and included that file in my php script, a header file....
but now i want to refresh my php script if the comment has been successfully added else remain in the same page....it remains in the same page now with just a msg that the comment is added....but i cant see the comment unless i refresh the page...
i get he headers already sent error when i put a header() there as i have included another php file which already echoes title to screen....so what do i do now?
i want the comment to be displayed to the user once he clicks on save and not make it tedious for him to refresh....any suggestions?any way around?

Hi all,

I am having some trouble with a part of code. Basically the code is set for a Factory to produce 750 items every 30 minutes. It does this fine IF AND ONLY IF someone clicks the Factory page. For example, it produces 750 bullets, then I leave the page alone for say 20 minutes, but when I click back, it doesn't have 10 minutes left before the next produce. Instead, It has 30 minutes. So it only produces when someone on the game clicks the page. I have tried the basic html refresh but that doesn't work.

Any idea's?

Thanks in advance

I have a php page that is maid up of three pieces.

header.php
main.php
footer.php

I can't figure out how to refresh the header.php and footer.php without refreshing the main.php.

Anyone have an example of how I can do this.

Thanks

hits

hello,

i have a page that parses a string from espn and i have a style sheet that makes it refresh every 2 minutes.  the thing that is buggin me is that when i load the page it loades with the last cached data so i have to wait 2 minutes for the info to update.

is there any way to force the current content on load, and keep my refresh every 2 minutes still?

thanks

is there a way to auto refresh the same page youre on after a script runs?

I'm having trouble getting my script to refresh the page.  If the username, password match it falls into this if statement. Sometimes it works and other times and won't refresh the page automatically.   

I'm trying to use this line to refresh the page
Code: [Select]
echo "<meta http-equiv='refresh' content='=2;index.php' />";
Here is the if statement
Code: [Select]
if(mysql_num_rows($checklogin) == 1)
    {
        // store the row returned from query
    $row = mysql_fetch_array($checklogin);
        // get email address from row returned
        $email = $row['EmailAddress'];
        // store user variables in session array
        $_SESSION['Username'] = $username;
        $_SESSION['EmailAddress'] = $email;
        $_SESSION['LoggedIn'] = 1; // boolean
       
    echo "<h1>Success</h1>";
        echo "<p>We are now redirecting you to the member area.</p>";
        echo "<meta http-equiv='refresh' content='=2;index.php' />";
    }
here is the entire index.php file

Code: [Select]
<?php include "base.php";?> <!-- base.php contains session_start() -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
<title>User Management System (Tom Cameron for NetTuts)</title>
<link rel="stylesheet" href="style.css" type="text/css" />
</head> 
<body> 
<div id="main">
<?php

// check if user is already logged in
if(!empty($_SESSION['LoggedIn']) && !empty($_SESSION['Username']))
{
 ?>
   
    <h1>Pitch Shark Member Area</h1>
  <p>Thanks for logging in! You are <b><?=$_SESSION['Username']?><b> and your email address is <b><?=$_SESSION['EmailAddress']?></b>.</p>
   
    <ul>
        <!-- link that runs logout.php script -->           
        <li><a href="logout.php">Logout.</a></li>
    </ul>
   
    <?php
}
// check login form
elseif(!empty($_POST['username']) && !empty($_POST['password']))
{
    // strip away malicious code 
 $username = mysql_real_escape_string($_POST['username']);
     //  encrypt password
     $password = md5(mysql_real_escape_string($_POST['password']));
     // return all matches to username and password
 $checklogin = mysql_query("SELECT * FROM haas12_test.users WHERE Username = '".$username."' AND Password = '".$password."'");
     // if there is a match
    if(mysql_num_rows($checklogin) == 1)
    {
        // store the row returned from query
     $row = mysql_fetch_array($checklogin);
        // get email address from row returned
        $email = $row['EmailAddress'];
        // store user variables in session array
        $_SESSION['Username'] = $username;
        $_SESSION['EmailAddress'] = $email;
        $_SESSION['LoggedIn'] = 1; // boolean
        
     echo "<h1>Success</h1>";
        echo "<p>We are now redirecting you to the member area.</p>";
        echo "<meta http-equiv='refresh' content='=2;index.php' />";
    }
    // if there information entered could not be found
    else
    {
      echo "<h1>Error</h1>";
        echo "<p>Sorry, your account could not be found. Please <a href=\"index.php\">click here to try again</a>.</p>";
    }
}
// display login form  with link to register form
else
{
?>
   
   <h1>Member Login</h1>
   
   <p>Thanks for visiting! Please either login below, or <a href="register.php">click here to register</a>.</p>
   
<form method="post" action="index.php" name="loginform" id="loginform">
<fieldset>
<label for="username">Username:</label><input type="text" name="username" id="username" /><br />
<label for="password">Password:</label><input type="password" name="password" id="password" /><br />
<input type="submit" name="login" id="login" value="Login" />
</fieldset>
</form>
   
   <?php
}
?>
</div>
</body>
</html>

i have set up a search form which is linked to dynamic update form on the same page,

when you pick an item from listbox in form 1 it will populate form2 (update form) with the  data from DB and repeat for all matching records, the update of the form is done by using a checkbox (onclick), all this works fine and DB updates fine.

My problem is when i check a  checkbox in any of the update forms the data is updated but all the update forms are removed so if i want to update another record i need to  enter original search again to  get forms to display again

i know the problem is because the page is refreshing when onclick is activated and it loses the search value so returns empty form.

i know you can use java to stop page refreshing but never used it before and been trying to get it to work with no success, is there any other way to keep page from refreshing

I've been doing some searching, but I can't figure this out, as I don't know enough about JS.   I have found a tutorial that does this

<HTML>
<HEAD>
<TITLE>Crunchify - Refresh Div without Reloading Page</TITLE>
 
<style type="text/css">
body {
    background-image:
        url('http://cdn3.crunchify.com/wp-content/uploads/2013/03/Crunchify.bg_.300.png');
}
</style>
<script type="text/javascript"
    src="http://code.jquery.com/jquery-1.10.1.min.js"></script>
<script>
    $(document).ready(
            function() {
                setInterval(function() {
                    var randomnumber = Math.floor(Math.random() * 100);
                    $('#show').text(
                            'I am getting refreshed every 3 seconds..! Random Number ==> '
                                    + randomnumber);
                }, 3000);
            });
</script>
 
</HEAD>
<BODY>
    <br>
    <br>
    <div id="show" align="center"></div>
 
    <div align="center">
        <p>
            by <a href="http://crunchify.com">Crunchify.com</a>
        </p>
    </div>
</BODY>
</HTML>

But I don't know what exactly I can remove, what needs to stay (as far as the js), and where exactly I insert my ad code that is in a <script> tag of its own... but that also has a <noscript> tag as a fallback. While I understand I need to change the refresh from 3 secs, can someone help me take out the example JS code, and tell me where I would put my JS ad code? And do I simply remove the <script tags from my ad code, when inserting it into an area that is already between <script> tags?   Any help on this would be appreciated, thanks!