如何从PHP中获取特定数组数据并将其存储起来

Question

我有这个PHP代码可以从数据库表中选择studentid，并在Project1列中输出值为1的学生。

 <?PHP 
     include_once("connectionToProjectChoice.php"); 
     /* Check column 1 (Project1) in tbl_studentchoice*/ 
     $check = "SELECT * FROM tbl_studentchoice WHERE Project1 = '1'"; 
     $result = mysqli_query($conn, $check); 

     if ($result->num_rows > 0){ //check 
      $student = array(); 
      while($row = mysqli_fetch_assoc($result)) { 
       $array[$row['studentid']]=$row['Project1']; 
      } 
     } 
     print_r($array); 
     ?> 

结果我到那里是

所以我的问题是，是，我可以存储studentname（c125582333）和（c12558242）的方式分开，所以我可以做一个if语句，因为我要对它们进行比较在代码的下一部分。

Answer 1

if ($result->num_rows > 0){ //check 
     $student = array(); 
     while($row = mysqli_fetch_assoc($result)) { 
      $array[] = [ 
        'studentid' => $row['studentid']], 
        'Project1' => $row['Project1'] 
      ]; 
     } 
    } 
    print_r($array); 

它可能更容易建立你的数组不同？

Answer 2

<?PHP 
     include_once("connectionToProjectChoice.php"); 
     /* Check column 1 (Project1) in tbl_studentchoice*/ 
     $check = "SELECT * FROM tbl_studentchoice WHERE Project1 = '1'"; 
     $result = mysqli_query($conn, $check); 

     if ($result->num_rows > 0){ //check 
      $i = 1; 
      $students = array(); 
      while($row = mysqli_fetch_assoc($result)) { 
       $students['student'.$i++]=$row['studentid']; 
      } 
     } 
     print_r($students); 
     extract($students); //gives you $student1, $student2, ... 
     ?>