PHP 通过单击查看按钮查看单个记录中的数据

Question

我有两页students_list.php 和students_profile.php

在students_list.php 上，我有一个表格显示所有学生的所有记录和VIEW 按钮，单击该按钮时应打开students_profile.php 页面并从基于std_id 选择的单个记录中获取所有数据

更新：所以现在当我点击 VIEW 按钮时我得到了 id http://localhost/sms/student_profiles.php?std_id=3但我仍然没有从这个选择的记录中检索数据

这是students_list.php的代码

<?php

require_once 'include/database/connect.php';

try {

    $pdo = new PDO("mysql:host=$host_db;dbname=$name_db", $user_db, $pass_db);                                 

    $sql = 'SELECT * FROM students';

    $q = $pdo->query($sql);

    $q->setFetchMode(PDO::FETCH_ASSOC);

    } catch (PDOException $e) {

    die("Could not connect to the database $name_db :" . $e->getMessage());

    }

?>

<table id="data-table-default" class="table">

    <thead>

    <tr>

    <th width="1%">#</th>

    <th width="1%" data-orderable="false"></th>

    <th>Name & Surname</th>

    <th>Gender</th>

    <th>Faculty</th>

    <th>Semester</th>

    <th>Mobile</th>

    <th></th>

    </tr>

</thead>

<tbody>

    <?php while ($row = $q->fetch()): ?>

    <tr class="odd gradeX">

    <td width="1%" class="f-s-600 text-inverse"><?php echo ($row['std_id']) ?></td>

    <td width="1%" class="with-img"><?php echo ($row['std_status']) ?></td>

    <td><?php echo ($row['std_name']) ?></td>

    <td><?php echo ($row['std_gender']) ?></td>

    <td><?php echo ($row['std_faculty']) ?></td>

    <td><?php echo ($row['std_semester']) ?></td>

    <td><?php echo ($row['std_mobile']) ?></td>

    <td align="right">

    <a href="student_profiles.php?std_id=<?php echo $row['std_id']; ?>" class="btn btn-warning btn-xs"><i class="fas fa-eye"></i> View</a>

    </td>

    </tr>

    <?php endwhile; ?>

    </tbody>

</table>

下面是 student_profile.php

<?php

require_once('include/database/sharepoint.php');

if(isset($_GET) & !empty($_GET)){

    $std_id = $_GET['std_id'];

    $sql = "SELECT * FROM `students` WHERE std_id=$std_id";

    $res = mysqli_query($connection, $sql);

}

Answer 1

您不会从查询中获取数据。所以 $row 永远不会包含你期望的数组：$row = mysqli_fetch_assoc($res); //this will populate $row在您的代码中：<?phprequire_once('include/database/sharepoint.php');if(isset($_GET) & !empty($_GET)){&nbsp; &nbsp; $std_id = $_GET['std_id'];&nbsp; &nbsp; $sql = "SELECT * FROM `students` WHERE std_id=$std_id";&nbsp; &nbsp; $res = mysqli_query($connection, $sql);&nbsp; &nbsp; $row = mysqli_fetch_assoc($res);}?>