Databases
StackOverflow2013
Postsdbo
POhow to give a link to execute this
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to give a link to execute this
    primarykey
    data
    text
    <pre><code>$sql=mysql_query("SELECT * FROM feedback.subject WHERE branch='cse'"); $row = mysql_fetch_assoc($sql) or die("error : $sql" .mysql_error()); $data =array(); $n=mysql_num_rows($sql); while($row = mysql_fetch_array($sql)) { $query_result_array[]=$row; } for($i=0;$i&lt;$n;$i++) { $subid=$query_result_array[$i]['subid']; $bt =$query_result_array[$i]['batch']; $y =$query_result_array[$i]['year']; $s = $query_result_array[$i]['semister']; $subname=$query_result_array[$i]['subname']; $tid = $query_result_array[$i]['tid']; $sql2=mysql_query("SELECT * FROM teacher WHERE teacher.tid='$tid'"); $row2 =mysql_fetch_array($sql2); $tname= $row2['tname']; echo "&lt;table id='table'&gt;"; echo "&lt;tr&gt;"; echo "&lt;td&gt;".$bt."&lt;/td&gt;"; echo "&lt;td&gt;CSE&lt;/td&gt;"; echo "&lt;td&gt;".$y."&lt;/td&gt;"; echo "&lt;td&gt;".$s."&lt;/td&gt;"; echo "&lt;td style='width:150px'&gt;".$subname."&lt;/td&gt;"; echo "&lt;td style='width:150px'&gt;".$row2['tname']."&lt;/td&gt;"; echo '&lt;form methode="get"&gt; &lt;input type="hidden" name="report"&gt; &lt;input type="submit" value="report"&gt; &lt;/form&gt;'; echo "&lt;/tr&gt;"; echo "&lt;/table&gt;"; } function handler($x,$y){ session_regenerate_id(); $_SESSION['SUBID']=$x; $_SESSION['TID']=$y; echo '&lt;a href="report.php" target="_blank"&gt;report&lt;/a&gt;'; } if(isset($_GET["report'$i'"])) { handler($query_result_array[$i]['subid'], $query_result_array[$i]['tid']); unset ($_GET["report"]); } } this results a table like BATCH | BRANCH | YEAR | SEMISTER | SUBJECT NAME | TEACHER NAME | ACTION | ------------------------------------------------------------------------------- 9 CSE 4 1 DBMS ABC REPORT 9 CSE 4 1 WT XYZ REPORT ------------------------------------------------------------------------------- </code></pre> <p>when i click the report of a row suppose ('ABC' teacher) i want to carry the details ('ABC' and 'DBMS') to further process. but it always carrying the details of last person in the loop(here 'XYZ' and 'WT'). how to get that? is there any alternate process through i can call the handler function for a particular row which carries that particular row details.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. US54849
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COplease tell me method without using ajax.. and im new to php so please help me
      singulars
      1. POhow to give a link to execute this
      1. US54849
    2. COI suggest re-read PHP basics. Your code is terribly messy, use of the <form> here does not make any sense. $i has the value of the last pass after the for cycle, so it obviously can't work.
      singulars
      1. POhow to give a link to execute this
      1. USamik
    3. COproblem might be understanding the for loop... this is pretty straight forward question and the student deserves an answer on that level. My answer is below, comment if you need anything specific.
      singulars
      1. POhow to give a link to execute this
      1. USRastko
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload