PHP - Employee Time Card Using Php

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.

Hey, i have made a silly little tester game just to see if i could, its he http://www.zephni.com/test/pairs its for some guy who is attending college and he was given the assignment to make a game of pairs using PHP to sort the cards and lay them down, and javascript to handle the actual game.

Anyway at the moment, my game sorts out the cards as if they are values from 1 to 52, and picks randomly 18 cards from them. During the game, the cards have to be excatly the same, as in:

if(card_picked1 == card_picked2){
      win pair
}

that means that both cards would have to be the same number AND suit. But in pairs you have to pick the same number but obviously in a different suit. Any way I have been trying some diff code to pick 18 cards from the pack. It picks 9, and then doubles them up but +'s 13 to the card so it is the same number card.

Here is the code

Code: [Select]
<?php

$i = 1;
$total_cards = 18;

#Sorting out cards
$card_sort = range(1,52);

while($i <= ($total_cards/2)){
$pick_card = $card_sort[rand(1,52)];

if($pick_card !== null){
$cards[] = $pick_card;
}
unset($card_sort[$pick_card]);

$i = $i+1;
}

foreach($cards as $card){
echo($card."<br/>");
}

?>

I would of thought that when you unset the number from $card_sort that was picked it would'nt choose it again if($pick_card !== null) but it still chooses the same card twice sometimes. I know I really havent explained this well, but i did my best for 9am...

Hi, I want to know something on credit card processing. I do not have any problem here, but want to know how ca shopping website is processed!

For example, a website is selling shoes online, where people will use either VISA or any credit card to buy, then the shoes will be delivered to the person's place. I want to know, how these credit cards are stored, I mean do these information are stored in the database, the website administrator will take the credit number etc...to get the money from the bank?

Hello,
I'm trying to use a rest-based card clearence service, but I don't know how to pass the information through the URL without using the form action attribute.

I need to have a URL looking like this:
index.php?p=checkout?service=cardAuth&msg_id=3864&num_md5=e2740266aab85558996a9a87fc561c0e&amount=24.99&currency=GBP&api_key=739a720ade31ad2a14b30aa7b3a6b20e

But at the moment, I have a URL looking like this:
index.php?cardAuth=&title=Mr&fname=Alderton&sname=Arkie&ctype=mastercard&cnumber=5105105105105100&smonth=01&syear=07&fmonth=01&fyear=10&checkout=Check+Out

There's a few more problems;
- I can't get the card number to md5
- I don't know how to retreive a variable used in another file, which counts up the total amount due

Here's my PHP:
Code: [Select]
<h2>Please enter your details</h2>
<h3>All fields required</h3>
<div id="checkout">

<?php

if (isset($_GET['checkout'])){

$title = $_GET['title'];
$fname = $_GET['fname'];
$sname = $_GET['sname'];
$ctype = $_GET['ctype'];
$cnumber = md5($_GET['cnumber']);
$syear = $_GET['smonth'] . $_GET['syear'];
$fyear = $_GET['fmonth'] . $_GET['fyear'];
$service = $_GET['cardAuth'];
$amount = $_REQUEST[$total];
$msg = rand(1000,9999);
$api = 'd41d8cd98f00b204e9800998ecf8427e';


}

?>

<form method="get" action="index.php?p=checkout?<?php.'service='.$service.'msg_id='.$msg.'num_md5='.$cnumber.'amount='.$amount.'currency=GBP'.'api_key='.$api.?>">

<table>
<tr>
<td><input type="hidden" name="cardAuth" value="<?php if (!empty($service)) echo $service; ?>" /></td>
</tr>
<tr>
<td>
Title:
</td>
<td>
<select name="title" value="<?php if (!empty($title)) echo $title; ?>" >
<option></option>
<option>Mr</option>
<option>Sir</option>
<option>Ms</option>
<option>Miss</option>
<option>Mrs</option>
</select>
</td>
</tr>
<tr>
<td>
First Name:
</td>
<td>
<input type="text" name="fname" value="<?php if (!empty($fname)) echo $fname; ?>"/>
</td>
</tr>
<tr>
<td>
Surname:
</td>
<td>
<input type="text" name="sname" value="<?php if (!empty($sname)) echo $sname; ?>"/>
</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Card Type:
</td>
<td>
<select name="ctype" value="<?php if (!empty($ctype)) echo $ctype; ?>">
<option>mastercard</option>
<option>visa</option>
<option>amex</option>
<option>solo</option>
<option>maestro</option>
<option>jcb</option>
<option>diners</option>
</select>
</td>
</tr>
<tr>
<td>
Card Number:
</td>
<td>
<input type="text" name="cnumber" value="<?php if (!empty($cnumber)) echo $cnumber; ?>"/>
</td>
</tr>
<tr>
<td>
Valid From:
</td>
<td>
<select name="smonth" value="<?php if (!empty($smonth)) echo $smonth; ?>">
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
<select name="syear" value="<?php if (!empty($syear)) echo $syear; ?>">
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
</select>
</td>
</tr>
<tr>
<td>
Expires End:
</td>
<td>
<select name="fmonth" value="<?php if (!empty($fmonth)) echo $fmonth; ?>">
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
<select name="fyear" value="<?php if (!empty($fyear)) echo $fyear; ?>">
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
</select>
</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>
<input type="submit" name="checkout" value="Check Out"/>
</td>
</tr>
</table>

</form>
</div>