1. <?php
  3. $link = mysqli_connect('localhost','mahdi','****','valiasr');
  4. mysqli_set_charset($link,'utf8');
  5. $query= "select * from majors where group_id=".$_GET['groupid'];
  6. $q1 = "select colleges.id from colleges join groups on colleges.id = groups.college_id where groups.id=".$_GET['groupid'];
  7. $result = mysqli_query($link,$query);
  8. $r1 = mysqli_query($link,$q1);
  9. $rows = mysqli_fetch_all($result,MYSQLI_ASSOC);
  10. $colid = mysqli_fetch_object($r1)->id;
  11. // echo $row1->id;
  12. // die();
  13. foreach ($rows as $row){
  14. // var_dump($row);
  15. echo "<input type=checkbox class='major groupid{$_GET[groupid]} collegeid{$colid} ' value=$row[id] >
  16. <span class='major groupid{$_GET[groupid]} collegeid{$colid} '>$row[name]</span>";
  17. }
  18. ?>

gatmajor.php