update all as a array

valen53

my problem is i dunno how to update data for each person. code will like that.....

select * from employee
display the employee list, can be many person ... it contain some of the field can be edit for each person.

after user edit the data for each person then click a update button to update for all of employee. but the problem is that system how to know which record was belong to certain employee? and how to updated it ?

anyone can help me ? thank a lot

khaine

The obvious way would be to tag a unique id on to each record. Or if there already is a unique field use that then set that up as a primary index for the table. all you need to do then is us the replace command in your sql.

i.e.

replace into tbl_employee values (12345, "Mr Smith", "blah", "blah")

With the index set up the database should first look to see if the record exists if it does it will replace the existing values with the ones supplied.

Mark.

valen53

since each record have a unique id, but how to know that that record was already edit

while ( ) {
<td>'.$row[EMP_ID].'</td>
<td><input name="hours" type="text" value="'.$row[HOURS].'" >
<td><select name="status">
<option value="0" selected>approved</option>
<option value="2">reject</option>
</select></td>
<input type="checkbox" name="checkbox[]" value="'.$row[EMP_ID].'">

}

if (isset($POST['checkbox'])) {
foreach ($POST['checkbox'] as $value) {

i can get each emp_id, but i dunno how to get the field was already edit. how to assign unique ID to each field and how to get it?
u get wht i mean ?

khaine

No too sure I understand what you mean. 😕

quote:

but i dunno how to get the field was already edit

Do you mean that you need to get just the fields that have been edited??
Why would you need a unique id for each field surely you mean record??

Mark.

valen53

while(... ) {
<td>'.$row[EMP_ID].'</td>
<td><input name="hours" type="text" value="'.$row[HOURS].'" >
<td><select name="status">
<option value="0" selected>approved</option>
<option value="2">reject</option>
</select></td>
}

the above code will display a listing. maybe i want to change hours textfield and change the select option. when i want to update the data, how i let the system to know that which record was belong to that emp_ID? i only click a button update to update all of the record.
get wht mean ?
thank's reply

abnfire

you should read SQL before you come in database, anyway youcan do following:

   $sql = "  update table_name
                set field_name = '43r'
                      field_name2 = 'add_this_text_to_this filed'
                where emp_id = '343'   // this user_id will be updated only.
             ";

also for selecting one user data do following:

     $sql = "  select *
                 from table_name
                 where emp_id = '434' // this user_id will be provide to you only
             ";

khaine

Right I get what you mean now.

You could output each field with the emp_id attached to the field name then read each one back with a variable variable name. That sounds a little complex so I shall demonstrate

Assuming that you use a loop to ouotput the fields and there names you could do something like

while(... )
{
echo "<tr>\n";
echo "<td><input type=\"hidden\" name=\"emp_id[]\" value=\"".$row[EMP_ID]."\">".$row[EMP_ID]."</td>\n";
echo "<td><input name=\"hours".$rows[EMP_ID]."\" type=\"text\" value=\"".$row[HOURS]."\" >
<td>\n";
}

so if you had employee numbers

00001
00002
00003
00004
00005

You would get field names of

hours00001
hours00002
hours00003
hours00004
hours00005

To get these into the database you could use

for ( $loop=0; $loop<$POST['emp_id']; $loop++ )
{
$varname="hours".$POST['emp_id[$loop]'];
$query="replace into tbl_employee values (".$emp_id.",".${$varname}.")";
// database stuff
}

This would update the record with the emp_id with the value from the variable hours00001.

Hows that?

Mark.

valen53

thank ur reply..
ur code logically can be run ... but not working for my system
my emp_id is string and quite long the number....
the below for loop() make my server slow down... it quite terrible thing. only a for loop can make the server slow down.

for ( $loop=0; $loop<$POST['emp_id']; $loop++ )
{
$varname="hours".$POST['emp_id[$loop]'];
$query="replace into tbl_employee values (".$emp_id.",".${$varname}.")";
// database stuff
}

khaine

I actually made a mistake in the code it should read

for ( $loop=0; $loop<count($POST['emp_id']); $loop++ )
{
$varname="hours".$POST['emp_id[$loop]'];
$query="replace into tbl_employee values (".$emp_id.",".${$varname}.")";
// database stuff
}

it should work no matter how long the emp_id is because it should run the loop for each input emp_id not just count up from 1, bit of an oops that one.

Mark.