Select the right data in PHP -

Select the right data in PHP -

i have interface below

when click edit button (icon pencil), form bellow appear

the edit button has code below in php file :

$elisting =""; $queryf = "select employee.id myid,jobtitle,info,locid,deptid,gender,dob,emid,employee$cid.name,username,dept,datejoin,location.name loc employee left bring together location on location$cid.id = employee.locid inner bring together section on department.id = employee.deptid order username "; $resultf = pg_query($queryf); $numrows = pg_numrows($resultf); while ($rowf = pg_fetch_array($resultf)) { $ct=$ct+1; $myid = $rowf[myid]; $uname = $rowf[username]; $loc1 = $rowf[loc]; $dept = $rowf[dept]; $date = $rowf[datejoin]; $name = $rowf[name]; $emid = $rowf[emid]; $dob = $rowf[dob]; $gender = $rowf[gender]; $job = $rowf[jobtitle]; $info = $rowf[info]; $datejoin = $rowf[datejoin]; $locid = $rowf[locid]; $deptid = $rowf[deptid]; $newbal = $rowf[newbal]; $templatelist = ""; $tempcn = 0; $querytemp = "select tid,ltype leaveatemplate$cid username='$uname' order tid desc"; $resulttemp = pg_query($querytemp); while ($rowtemp = pg_fetch_array($resulttemp)) { $tempcn = $tempcn +1; $tid = $rowtemp[tid]; $ltype = $rowtemp[ltype]; if($tempcn=="1") $templatelist = "$ltype|$tid"; else $templatelist = $templatelist.","."$ltype|$tid"; } $elisting=$elisting."<tr><td align=\"center\">$uname</td><td align=\"center\">$loc1</td><td align=\"center\">$dept</td><td align=\"center\">$date</td><td align=\"center\"><button class=\"btn btn-mini\"data-toggle=\"modal\"href=\"#long\" onclick=\"javascript:edit('$name','$uname','$emid','$dob','$gender','$job','$info','$datejoin','$locid','$deptid','$myid','$templatelist', '$value');\"><i class=\"icon-pencil\"></i></a><button class=\"btn btn-mini\" data-toggle=\"modal\" href=\"#static\" rel=\"tooltip\" data-original-title=\"delete\" onclick=\"javascript:delrec('$myid');\"><i class=\"icon-remove\"></i></a></td> </tr>\n"; }

i wonder how can code select right info button clicked? because saw there no requirement in query, illustration id = 123 or that. when take adam, adam's info appear. can explain this?

update:

function edit(a,b,c,d,e,f,g,h,i,j,k,l){ document.getelementbyid("frm").id.value=k; document.getelementbyid("frm").name.value=a; document.getelementbyid("frm").username.value=b; document.getelementbyid("frm").emid.value=c; document.getelementbyid("frm").dob.value=d; setcheckedvalue(document.forms['frm'].elements['gender'],e); document.getelementbyid("frm").job.value=f; document.getelementbyid("frm").info.value=g; document.getelementbyid("frm").datejoin.value=h; document.getelementbyid('locid').value=i; document.getelementbyid('deptid').value=j; }

this line explain everything:

onclick=\"javascript:edit('$name','$uname','$emid','$dob','$gender','$job','$info','$datejoin','$locid','$deptid','$myid','$templatelist', '$value');

as can see in javascript edit function id of object ($myid guess) passed along other properties of object.

php