onclick event for table row record to form field

[prosad]

hello,
Just solved a problem using Javascript onclick, can click on any cell in a dynamic table and it will pass the innerText object value to my form text field. parts of code given below:

<script type="text/javascript">
function select_cell(obj)
{
 
    document.getElementById('complaint').value = obj.innerText;
    document.getElementById('selected_form');
}

[PHP]echo "<tr><th>Compla int</th>";
while ($comp_rec= mysql_fetch_arr ay($complaintTa ble))
{echo "<tr><td id = 'complaint' onclick='select _cell(this);'>" ; echo $comp_rec['complaint'];
echo "</td>";[/PHP]

[HTML]<table id = "MAINFORM">
<form id = "selected_f orm" name = "complaint_sett ings" method = "POST" action = "php_complaint_ mysql.php">
<td>
<table border = "3" bordercolor = "gold" bgcolor = "00008B">
<tr><td>
<p style = "color:gold">Co mplaint: <br>
<input type = "text" size = "50" maxlength = "50" name = "complaint" >
</td></tr><br>
<tr><td>
<input type = "submit" name = "submit_c" value = "submit"> <br>
<input type = "submit" name = "submit_c" value = "update"> <br>
<input type = "submit" name = "submit_c" value = "delete" onClick = "return confirm('Are you sure you want to delete record?')">[/HTML]

my problem now is how to pass along my primary key which is the unique id of each $comp_rec to my form as a hidden variable so i can pass $_POST['complaint'] to php_complaint_m ysql.php for update or delete. As it is now the table i use onclick only shows a single column(complain t) and even if i add another cell/column (id) the two cells are not carried and placed in separate fields on the same form. Any idea on populating form fields by clicking a row record with each attribute being passed to appropriate field? Attribute ID not presently on table. wish to keep hidden. But need to pass ID so i can use to update mysql.
thanks.

[prosad]

hi all, struggling with javascript, need help please!
i have a table being generated from a MySQL DB and wish to enable onclick on table row so that table data on that row can be transferred to a form for update or delete. the table row contains the primary key ($comp_rec['id']) which will be used to reference data ($comp_rec['complaint']) in DB for update or delete. my codes are as follows:

1. Javascript Function:

function select_cell(obj )

{
    document.getElementById('complaint').value = obj.cells[0].innerText;
    document.getElementById('complaint').value = obj.cells[1].innerText;
    document.getElementById('selected_form');
} 

2. Table generated from MyQL using PHP:

[PHP]echo "<table>";
echo "<td><div>" ;"</div></td>";
echo "<table id = \"table_c\" border = \"4\" bordercolor = 00008B>";
echo "<tr><th>Compla int</th>";
while ($comp_rec= mysql_fetch_arr ay($complaintTa ble))
{echo "<tr id = 'complaint' onclick='select _cell(this);'>< td> "; echo $comp_rec['complaint'];
echo "</td>"; echo "<td>"; echo $comp_rec['id']; echo "</td>";

}
echo "</tr></table>";[/PHP]

3. HTML Form table row data supposed to be transfered to. Primary id to be sent to hidden field. if i set id value to a primary key e.g. "1" i can update without problem but that will mean putting the onclick into the <td> tag. i wish instead to use the onclick in the <tr> tag.

[HTML]<table id = "MAINFORM">
<form id = "selected_f orm" name = "complaint_sett ings" method = "POST" action = "php_complaint_ mysql.php">
<td>
<table border = "3" bordercolor = "gold" bgcolor = "00008B">
<tr><td>
<p style = "color:gold">Co mplaint: <br>
<input type = "text" size = "50" maxlength = "50" name = "complaint" value = "">
</td></tr><br>
<INPUT TYPE="hidden" NAME="id" value="">
<tr><td>
<input type = "submit" name = "submit_c" value = "submit"> <br>
<input type = "submit" name = "submit_c" value = "update"> <br>
<input type = "submit" name = "submit_c" value = "delete" onClick = "return confirm('Are you sure you want to delete record?')">

</td></tr>
<br><br>
</table>
</form>[/HTML]

looking forward to speedy response.

[JosAH]

Your question is a Javascript question; this is a Java forum; Java and Javascript
are completely disjunct and different. Do you want me to move your question to
a Javascript forum where your question can be better answered?

kind regards,

Jos

[prosad]

Your question is a Javascript question; this is a Java forum; Java and Javascript
are completely disjunct and different. Do you want me to move your question to
a Javascript forum where your question can be better answered?

kind regards,

Jos

yes please, my mistake. apologies.

[JosAH]

yes please, my mistake. apologies.

Consider it done; best of luck. (no need to apologize)

kind regards,

Jos