How to get table detail clicking on row?

[dkate777]

HI,

I have table what I display on form. The table has multiple row with the same projectNumber, but difference description.
I need to click on row and another form open with detail belong to this row.
Is anybody can give code sample how to do this?
How can i find out that i click on right row?

Thanks

[Purple]

Hi,

first thoughts are Javascript and clientside technologies, take a look at extjs.com the paged grid exampe. There are a number of the ajax components which will get you what you need.

if you want a quick solution without heavy javascript / ajax you could always use a submit button formatted with CSS to look a little more like your page style. by setting the value of the submit on each row of the table to a key on your database and using array_flip on $_post you can work out which row has been selected..

Hope this helps..

Regards Purple

[dkate777]

i think i like more second solution............could you please base on my code give me exemple. I need to know how to add value to every row, i think i know how to do this, but i am not sure how to pass this to another page


THIS IS MY TABLE DISPLAY FORM:

 <?php
    echo "    
    <tr>
    <td colspan='3'>
        <form name='controltest' method='post'>
          <div style='overflow:auto; height:100px;'>    
    <table align='center' width='90%' border-style='inset'  padding='0' bgcolor='#FOFOFO' >
    <tr>
    <th bgcolor='#FOFOFO' align='left'><font color='navy'>Functionality to be Tested</font></th>
    <th bgcolor='#FOFOFO' align='left'><font color='navy'>Person Responsible</font></th>
    <th bgcolor='#FOFOFO' align='left'><font color='navy'>Due Date</font></th>
    <th bgcolor='#FOFOFO' align='left'><font color='navy'>Completion Date</font></th>
    </tr>"; 
 
      $controlQuery="SELECT * 
            FROM project_controltest
            WHERE projectNumber='$POST_projectNumber'";
            $result=mysql_query($controlQuery);
            $controlFound=false;
            $controlNumber=0;
            $count=mysql_num_rows($result);                
        while ($controlrow = mysql_fetch_array($result)) {
                        $controlFound=true;
                    $controlNumber=$controlNumber+1;
 
    echo "                
        <tr bgcolor='white'> " ;      
 
       echo "<tr input type='hidden' name='control' value='$controlNumber'> ";
       echo "<tr input type='hidden' name='projectNumber[$controlNumber]' 
       id='projectNumber' value='$controlrow[projectNumber]'> ";
 
 
     echo "<td bgcolor='white' class='tdnavy' width='300px'>\n";     
     echo "<a onClick='updateProject(\"testcontrol\")' href='javascript:void(0)'>";
         echo "$controlrow[shortdescription]</a> ";
         echo " </td> 
<td bgcolor='white' class='tdnavy' >"; echo get_user_info($controlrow[personresponsible],'name'); echo "</td>  
<td bgcolor='white' class='tdnavy'>";echo convert_date($controlrow[duedate],'fromSQL');
echo "</td>
<td bgcolor='white' class='tdnavy'>";
if (convert_date($controlrow[completiondate],'fromSQL')<>'00/00/0000'){
echo convert_date($controlrow[completiondate],'fromSQL');
    }
  else echo '' ;  
    echo "</td>";
    echo "</tr>";
 
 }    
 
 echo "</table></div></form>";
    echo "<input type='hidden' name='maxcontrolNumber' value='$controlNumber'>  ";
   echo "</tr>";
 
 ?>  

[Please use CODE tags when posting source code. Thanks! --pbmods]

THIS IS THE FORM I WANT TO DISPLAY WHEN I CLICK ON ANY ROW.

<div id='testcontrolTable' style='position:absolute;
                              top:150px;
                              left:50px;
                              width:1000px;
                              height:550px;
                              z-index:4;
                                                 visibility="hidden"'>
   <form name='testcontrolForm' method='post' onSubmit='return validateField("testcontrol")'> 
  <input type='hidden' name='userNumber'       value='<?php echo $POST_userNumber; ?>'>
  <input type='hidden' name='projectNumber'    value='<?php echo $POST_projectNumber; ?>'> 
   <input type='hidden' name='shortdescription'    value='<?php echo $POST_shortdescription; ?>'> 
  <input type='hidden' name='controlStatus'   value='restore'>
    <table class='projectBar' align='right' width='100%' height='50%'>    
   <tr>
    <th colspan='4' align='center' >
     <h3>Update Test Requirement</h3>
    </th>
   </tr>
   <?php
 
   $controlQuery="SELECT * 
            FROM project_controltest
            WHERE projectNumber='$POST_projectNumber'";
            $result=mysql_query($controlQuery);
            $controlFound=false;
    //        $controlNumber=0;                
        while ($controlrow = mysql_fetch_array($result)) {
                        $controlFound=true;
    //                $controlNumber=$controlNumber+1;
    $shortdesc=$controlrow[shortdescription];
      }
   }
   ?>
   <tr>
   <th>     Short Description:
    </th>
   <td>
    <input readonly type='text' 
           size='50' 
           name='shortdescription' 
           value='<?php echo $shortdesc ?>' 
           maxlength='50'></input>
 </td>
 
   </tr>       
   <tr>
         <th>Functionality to be Tested:</th>
      <td>
    <textarea wrap='soft' rows='5' cols='52' name='funcText' value=''></textarea>
    </td>
    <th> Testing Result:</th> 
    <td>
    <textarea wrap='soft' rows='5' cols='52' name='testresult' value=''></textarea>
    </td>
   </tr>
   <tr>
     <td align='right'>
     Due Date:
    </td>
    <td >
 <input name='DueDate' 
             type='text' 
             size='15' 
             onBlur='chkDateFld(this,"DueDate",true,true)' 
             value=''>
         <a href="javascript:showCal('Calendar15')">
 <img border='0' src='/images/b_calendar.png'
         alt='Get Date'>
        </a>
    </td>    
    <td> Completion Date:</td>
    <td>
    <input name='CompletionDate' 
             type='text' 
             size='15' 
             onBlur='chkDateFld(this,"CompletionDate",true,true)' 
             value=''>
         <a href="javascript:showCal('Calendar16')">
 <img border='0' src='/images/b_calendar.png'
         alt='Get Date'>
        </a></td>    
 </tr>        
    <tr>           
  <td align='right' >
   Person Responsible:
      </td><td>     
      <input readonly type='text'
              size='25'  
             name='personresponsible' 
         maxlength='25'
         value=''></input>
      </td>
      <td>     Completed By:
    </td>
   <td>
    <input  type='text' 
           size='25' 
           name='completedby' 
           value='' 
           maxlength='25'></input>
 </td>
     </tr> 
     </tr> 
 
   <tr>
 
    <th colspan='4' align='center'>
    <input  type='submit' value='Submit' class='fancyButton' >
     <input   type='button' value='Cancel' class='fancyButton' onClick='closeControl("close")'>
                </th>
            </tr>
        </table>
    </form>
</div>

[Purple]

Hi,

I am having difficulty with readability of your code in the post - if you use code tags the code will be formatted with line numbers - makes it much easier to talk about..

Anyhow the logic for the select in the table

select records to be displayed including a key field
Loop the fetch2
[PHP]echo "<tr><td><input type = 'submit' name = '".$keyfield."' value = 'select'></input></td>more detail for the record in detail tags</tr>";[/PHP]
end loop

when the form is processed the $_POST array will have an element with a name of the record key and a value of select.

if you copy and array_flip($_POST) you then have the record key = $new_array['select']

Hows that ?

Purple

[dkate777]

i am not really understand how exactly to do this, but i can try and let you know
I am still not clear, but i can play with this

[Purple]

Hi dkate777

Apologies if my answer was not clear.

Which bit are you having a problem understanding ?

Ask for clarification and we can assist further.

Regards Purple