php - 将表添加到数据库时如何插入手风琴

Question

对于我数据库中的每个表，我需要插入一个手风琴。所以，当我添加一个表时，它应该在手风琴的标题中创建一个带有表名的手风琴。

这是我的代码：

应该插入手风琴（.php）的代码：

<?php
       require 'includes/dbh.inc.php';

       $sql = "SELECT count(*) AS TOTALNUMBEROFTABLES FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '4grcbd'";
       $result = $conn->query($sql);

       foreach ($result as $row) {
         $accordion .= '                 
             <h3>' . $row['TOTALNUMBEROFTABLES'] . '</h3>
               <div>
                 <p>                
                   my age is
                 </p>
             </div>';
       }
?>

手风琴 HTML 引导程序：

 <div id="accordion">
        <div class="card">
          <div class="card-header" id="headingOne">
            <h5 class="mb-0">
              <button class="btn btn-link" data-toggle="collapse" data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
                Collapsible Group Item #1
              </button>
            </h5>
          </div>

          <div id="collapseOne" class="collapse show" aria-labelledby="headingOne" data-parent="#accordion">
            <div class="card-body">
              Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven't heard of them accusamus labore sustainable VHS.
            </div>
          </div>
        </div>

我与数据库的连接（dbh.inc.php）：

    $servername = "localhost"; 
    $dBUsername = "root";
    $dBPassword = "";
    $dBName = "4grcbd";

    $conn = mysqli_connect($servername, $dBUsername, $dBPassword, $dBName);

    if(!$conn) {
        die("Connection failed: ".mysqli_connect_error());
    }

谢谢您的帮助！

标签： phpmysqldatabasebootstrap-4accordion