选项从数据库获取数据 - Option get data from DB

Option get data from DB

本文关键字：数据获取数据库选项 | 更新日期: 2023-09-27

我的数据库中有这个表：

**train_information**
train_id
country_id
user_id
train_name
tare_weight
number_of_bogies
number_of_axles
wheel_diameter_min
wheel_diameter_max

然后我有 2 .php页（1 页仅用于课程）

选择器.php

<!--Selector-->
<form name='form' id='selector'>
    <?php
        $selector = $database->selector();
    ?>
        <select onchange= "mySelection()" id ="selector" name="selector">
        <option selected="true" disabled="disabled">Selecteer een trein</option>
    <?php 
        foreach ($selector as $selector) {
            print "<h3>" . $selector['train_id'] . "==" . $selector_id . "</h3>";
            if ($selector['train_id'] == $selector_id) {
                echo "<option value=" . $selector['train_id'] . " selected='selected'> " . $selector['train_name'] . "</option>";
            } else {
                echo "<option value=" . $selector['train_id'] . "> " . $selector['train_name'] . "</option>";
            } }     
        ?>
    </select>
</form>

然后是班级.php

function selector() {
        $sql = "SELECT train_id, train_name FROM train_information";
        $sth = $this->pdo->prepare($sql);
        $sth->execute();
        return $sth->fetchAll();
    }

选择

器在选择中显示列车名称。所以这很好。但是当我选择它时，我希望它，然后按下一个按钮，例如：选择。它选择所选列车的信息并将其显示在页面上。而且我不仅想显示 1，而且如果我想在那之后选择另一列火车，它会在页面上显示两列火车的信息。

我该怎么做？

你可以

执行以下操作

将此方法添加到类中.php

function select_train_details($trainId) {
         $sql = "SELECT * FROM train_information where train_id = " . $trainId;
         $sth = $this->pdo->prepare($sql);
         $sth->execute();
         return $sth->fetchAll();
     }

将以下内容添加到选择器.php

 <form name='form' id='selector'>
     <?php
     $selector = $database->selector();
     if (isset($_POST['selector'])) {
         $selectorDetail = $database->select_train_details();
     }
     ?>
     <select onchange= "this.form.submit" id ="selector" name="selector">
         <option selected="true" disabled="disabled">Selecteer een trein</option>
         <?php
         foreach ($selector as $selector) {
             print "<h3>" . $selector['train_id'] . "==" . $selector_id . "</h3>";
             if ($selector['train_id'] == $selector_id) {
                 echo "<option value=" . $selector['train_id'] . " selected='selected'> " . $selector['train_name'] . "</option>";
             } else {
                 echo "<option value=" . $selector['train_id'] . "> " . $selector['train_name'] . "</option>";
             }
         }
         ?>
     </select> </form> <?php if (isset($selectorDetail)) {
     echo "<pre>";
     $selectorDetail; } ?>