Help Please?

[weirdloquacity]

hi guys, i'm a newbie here and i'm kinda lost. i have no idea if this
is where this is where this should be posted but if ever, could you
guys redirect me?

i'm currently working on this attendance form for my project using
php. Imagine a row in excel. Now each of the rows have a
checkbox. I want to select all of the information for each row but i
only seem to be getting the last batch of information. I've already
tried using a FOREACH loop but i'm still lost. It doesn't seem to
work. I can be working with up to hundreds of records at a time so the employee id's are the names of the checkboxes. I get the
id's from a database that i created.

START OF THE FORM WHERE I GET THE VALUES

for ($i=0; $i <$num_results; $i++) /* loop to display results */ 
{ 

$row = mysql_fetch_array($result); 

$id2  = $row["eid"];
$lname2 = $row["lname"];
$fname2 = $row["fname"];
$mname2 = $row["mname"];
$mid2 = $row["mid"];
$cyear2 = $row["cyear"];		
$one2   = $row["d1"];
$two2   = $row["d2"];
$three2 = $row["d3"];
$four2  = $row["d4"];
$five2  = $row["d5"];

/* Start of the FORM for the submit button. */ 
echo "<FORM action=attendance2.php name=chkbx method=GET>"; 
echo "<tbody class=data><td>"; 
echo "<input type=checkbox name=chkemp[id2] value='$id2' onclick=document.chkbx.chk.disabled=false><td>"; 
echo "<input type=text name=id2 value='$id2' size=10 maxlength=11 readonly><td>"; 
echo "$lname2<td nowrap=nowrap>"; 
echo "$fname2<td nowrap=nowrap>"; 
echo "$mname2<td nowrap=nowrap>"; 
echo "<input type=text name=mid2 value='$mid2' size=2 maxlength=2 readonly><td>"; 
echo "<input type=text name=cyear2 value='$cyear2' size=3 maxlength=4 readonly><td>"; 
echo "<input type=text name=one2 value='$one2' size=4 maxlength=4><td>"; 
echo "<input type=text name=two2 value='$two2' size=4 maxlength=4><td>"; 
echo "<input type=text name=three2 value='$three2' size=4 maxlength=4><td>"; 
echo "<input type=text name=four2 value='$four2' size=4 maxlength=4><td>"; 
echo "<input type=text name=five2 value='$five2' size=4 maxlength=4><td>"; 
} 
echo "</td></tr></TABLE><br>"; 

/* End of the FORM for the checkbox submit button. IF update button is 
pressed, redirect the boxes checked to attendance update. */ 
echo "<input type=submit name=chk value='Submit'>"; 
echo "</FORM>"; 

START OF THE FOREACH LOOP IN THE SECOND PAGE

/* Loop and update for each checked entry. */ 
FOREACH ($_GET['chkemp'] as $entry) 
{ 

//echo "<li>$checkedid[$i] \n"; 
$test = implode(",", $_GET['chkemp']); 
echo "<li>$test<br>"; 

/* Prepare the query string and get the necessary values. */ 

$eid = $_GET["id2"]; 
$mid = $_GET["mid2"]; 
$cyear = $_GET["cyear2"]; 
$one = $_GET["one2"]; 
$two = $_GET["two2"]; 
$three = $_GET["three2"];
$four = $_GET["four2"]; 
$five = $_GET["five2"]; 

/***** Computing Part of the Code. *****/ 

/* Select the employee from the attendance table given the id from the ATTENDANCE.PHP page. */ 

$query = "update attendance set d1='$one', d2='$two', 
d3='$three', d4='$four', d5='$five', d6='$six', d7='$seven', 
d8='$eight', d9='$nine', d10='$ten', d11='$eleven', 
d12='$twelve', d13='$thirteen', d14='$fourteen', d15='$fifteen', 
d16='$sixteen', d17='$seventeen', d18='$eighteen', 
d19='$nineteen', d20='$twenty', d21='$twentyone', 
d22='$twentytwo', d23='$twentythree', d24='$twentyfour', 
d25='$twentyfive', d26='$twentysix', d27='$twentyseven', 
d28='$twentyeight', d29='$twentynine', d30='$thirty', 
d31='$thirtyone', tlate='$tlate', tabsent='$tabsent' 
where eid='$entry' and mid='$mid' and cyear='$cyear'"; 

echo $query ."<BR>"; /* Check if the query is working properly. */ 
$result = mysql_query($query) /* Run Query */ 
 or die(mysql_error()); 
} 

[leatherback]

Hi,

First of all.. Could you please edit your first post a bit, so that the long quesry at the end, it displayed over a few lines.. (put some enters in it.

thta will make you post easier to read.

I think if you change this:

echo "<input type=checkbox name=chkemp[] value='$chkid' onclick=document.chkbx.chk.disabled=false><td>";

into this:

echo "<input type=checkbox name=chkemp[$id2] value='$chkid' onclick=document.chkbx.chk.disabled=false><td>"; 

that it would work better. But I did not check all the logic in the post. It seems that the update query also doesn't include a where staement, which it probably needs.

You seem to be updating some calender data ort something. You might be better of not having a colum for each day, but having a date colum with multiple records, one record per date.

One other thing: You do not need to:
htmlspecialchars(stripslashes())
on data retrieved from the datatbase: You do the HTMLspecialchars to avoid scripts and bad code to mess up your database. once it is in the database, it should have been checked.

J.

[weirdloquacity]

Hi leatherback!

thanks for the reply. sorry for the messy code. i'm still trying to get
the hang of it. could you explain to me what you just did??? i'd really like to know what happened?🙂

I am updating records per employee for a company. So i can be editing around hundreds of records at a time. i don't quite
understand what you meant when you said that i should have a
date column with multiple records, with one record per date?

Is it something like each day in a month will have it's own database per employee? what do you mean exactly?

Sorry if i have so many questions..

[leatherback]

Hi,

"What just happened":

you have a form, for many, many people, where you can update their details. You called the variables chkemp[]. Which is fine. But you need to tell the database which record to update. So I added $id2 to distinguish between different people.

If you look at the sourcecode of your form, you'll see that the checkboxes now have a number in the name as well. That way you know which record you are updating.

I do not know what you are trying to do with your database. But say, you want to know which emplyees have some value checked between the 20th and the 23rd of the month. You cannot effectvely retriewve that from the database, the way it is setup now. Whereas if you would set up the database like this:

Tabe employees:
E_id | E_name | E_status | ...
(Employee ID< name, status..)

Table Activities
A_id | A_name
(Activity ID and name)

Table Employee_Activity
EA_id | EA_E_nr | EA_A_nr | EA_date
(Table ID, Employee number, activity number, date)

You could select from the tables like:

Select from Employee_Activity where EA_e_nr = $employee_id and EA_A_nr = $activity and (EA_date between $startdat and $enddate)

J.

[weirdloquacity]

hi leatherback,

thanks for the explanation. 🙂 anyway, here's what i'm exactly doing.

I'm making an employee database for a company and they want an attendance form report in it. The form that i made has the dates 1-31
with the employee's id. For each day, let's say, day 20, i can either put the number of minutes that an employee is
late or an ''A" if that employee is absent.

I got the thing sort of working, but for some reason, i keep getting only the last record. I've checked the manual but i just got zip info..

[leatherback]

Hi,

Have you looked at the produced HTML in the form? What does it do with the created chkemp[$id2]?

You should also clean your code./ A quick browse gave me three different names for your employee ID. This is asking fro trouble!

Also, place a
print_r($GET);
statement at the top of your SECOND PAGE. THne look at the produced HTML source, so you can see what is actually in the $GET array.

J.

[weirdloquacity]

ok, so i got the thing working. (yay!!🙂) The produced html gets
the necessary employee id. however, once submitted, it only gets
the last values of the query. Let's say i want to edit the
attendance for the months of may and june 2005. I tick the
checkboxes of the employees that i want to edit and input the
info that i want. When i press the submit button, the values that i
get are ONLY those of the last value in the array.

Let's say that the values that i want for May 2005 and June 2005
for employee 070809-0003 are:

Employee ID Month ID Current Year 1 2 3 4 5

070809-0003 06 2005 10 10 10 a a
070809-0003 05 2005 20 20 20 a a

The value that i get in the array will only be that of May 2005.
Yes, it does update individually, but how do you make it work so
that multiple records can be updated? Is it an SQL thing? If so, is
there a way around it? I think i also figured out the problem.

This is the HTML for the first one (copy to a text file and save as html):

<b>you are logged in as 'administrator'.</b><br><br><HEAD><TITLE> Attendance 
Report </TITLE></HEAD><BODY> <H1 align=center> Attendance 
Report </H1><H2 align=center><b> June 2005 
</b></H2><b>Date Today: 2005-06-28</b><br><br>FROM: 05, 
2005<br>TO: 06, 2005<br><p>Number of entries found: 2</p> 
<TABLE border=1 align=center valign=middle width=190%><tr 
align=center valign=middle><td  align=center 
valign=top><colgroup span=16 align=center><thead 
class=titles><td><b>Check<td><b>Employee ID<td><b>Last 
Name<td><b>First Name<td><b>Middle Name<td><b>Month 
ID<td><b>Current 
Year<td><b>1<td><b>2<td><b>3<td><b>4<td><b>5<td><b>6
<td><b>7<td><b>8<td><b>9<td><b>10<td><b>11<td><b>12
<td><b>13<td><b>14<td><b>15<td><b>16<td><b>17<td><b
18<td><b>19<td><b>20<td><b>21<td><b>22<td><b>23<td
<b>24<td><b>25<td><b>26<td><b>27<td><b>28<td><b>29
<td><b>30<td><b>31<td><b>Total Late<td><b>Total 
Absent</b></thead></colgroup><FORM action=attendance2.php 
name=chkbx method=GET><tbody class=data><td><input 
type=checkbox name=chkemp[070809-0003] value='070809-
0003' onclick=document.chkbx.chk.disabled=false><td><input 
type=text name=id2 value='070809-0003' size=10 maxlength=11 
readonly><td>Santos<td nowrap=nowrap>Test2<td 
nowrap=nowrap>Attendance3<td nowrap=nowrap><input 
type=text name=mid2 value='06' size=2 maxlength=2 
readonly><td><input type=text name=cyear2 value='2005' 
size=3 maxlength=4 readonly><td><input type=text name=one2 
value='30' size=4 maxlength=4><td><input type=text 
name=two2 value='a' size=4 maxlength=4><td><input 
type=text name=three2 value='a' size=4 
maxlength=4><td><input type=text name=four2 value='a' 
size=4 maxlength=4><td><input type=text name=five2 value='0' 
size=4 maxlength=4><td><FORM action=attendance2.php 
name=chkbx method=GET><tbody class=data><td><input 
type=checkbox name=chkemp[070809-0003] value='070809-
0003' onclick=document.chkbx.chk.disabled=false><td><input 
type=text name=id2 value='070809-0003' size=10 maxlength=11 
readonly><td>Santos<td nowrap=nowrap>Test2<td 
nowrap=nowrap>Attendance3<td nowrap=nowrap><input 
type=text name=mid2 value='05' size=2 maxlength=2 
readonly><td><input type=text name=cyear2 value='2005' 
size=3 maxlength=4 readonly><td><input type=text name=one2 
value='10' size=4 maxlength=4><td><input type=text 
name=two2 value='10' size=4 maxlength=4><td><input 
type=text name=three2 value='a' size=4 
maxlength=4><td><input type=text name=four2 value='a' 
size=4 maxlength=4><td><input type=text name=five2 value='a' 
size=4 maxlength=4><td></td></tr></TABLE><br><input 
type=hidden name=empid value=070809-0003><input 
type=submit name=chk value='Submit'></FORM><FORM 
action=ctr_attendance.html><input type=submit value='Search 
Again'></FORM><br><FORM action=ctr_customized.html><input 
type=submit value='Return to Customized Reports 
Menu'></FORM><FORM action=ctr_reports.html><input 
type=submit value='Return to Reports Menu'></FORM><FORM 
action='ctr_main.html'><input type=submit value='Return to Main 
Menu'></FORM></BODY>

This is the HTML for the 2nd Page (copy to a text file and save as html):

<b>you are logged in 
as 'administrator'.</b><br><br><HEAD><TITLE> Attendance 
Report </TITLE></HEAD><BODY> <H1 align=center> Attendance 
Report </H1><H2 align=center><b> June 2005 
</b></H2><b>Date Today: 2005-06-28</b><br><br>Array

(
    [chkemp] => Array
        (
            [070809-0003] => 070809-0003
        )

[id2] => 070809-0003
[mid2] => 05
[cyear2] => 2005
[one2] => 20
[two2] => 20
[three2] => 20
[four2] => a
[five2] => a
[empid] => 070809-0003
[chk] => Submit
)
<li>070809-0003<br>update attendance set d1='20', d2='20', 
d3='20', d4='a', d5='a', d6='', d7='', d8='', d9='', d10='', d11='', 
d12='', d13='', d14='', d15='', d16='', d17='', d18='', d19='', 
d20='', d21='', d22='', d23='', d24='', d25='', d26='', d27='', 
d28='', d29='', d30='', d31='', tlate='', tabsent='' where 
eid='070809-0003' and mid='05' and cyear='2005'<BR><FORM 
action=ctr_attendance.html><input type=submit value='Search 
Again'></FORM><br><FORM action=log_attendance.php><input 
type=submit value='Transfer to Excel'></FORM><FORM 
action=ctr_customized.html><input type=submit value='Return to 
Customized Reports Menu'></FORM><FORM 
action=ctr_reports.html><input type=submit value='Return to 
Reports Menu'></FORM><FORM action='ctr_main.html'><input 
type=submit value='Return to Main Menu'></FORM></BODY>

[weirdloquacity]

ei guys!! if you have comments, suggestions, or violent reactions, please please please help too.🙂

i really need to finish this project, ASAP.🙂 Your comments and suggestions would be really appreciated. Besides, it will also help me to be a better
programmer and make cleaner codes, hehehe!🙂