PHP 在 HTML 中获取和回显

Question

<?php  
    include_once 'config.php';  

    $query = $config -> prepare("SELECT `edit`, `user_banned`, `ban_reason`, `ban_time`, `user_banner`, `ban_timestamp` FROM `samp_ban` ORDER BY `edit` ASC LIMIT 10");  
    if($query -> execute())  
    {  
        $query_results = $query->fetchAll();
         if($ban_time == 0) { $query_result["ban_time"] = "Permanent"; } 

    }  
?>

代码编辑代码编辑代码编辑代码编辑

错误: undefined variable :ban_time

Answer 1

您必须结合 html 和 php 才能从查询中获取所有数据

if($row_count)  
        {  
            while($query_result = $query -> fetch()){  
                 $Username = $query_result['Username']; 
                 $Headshots = $query_result['Headshots']; 
                 $ForumName = $query_result['ForumName'] ; 
                 ?>
                 <div class="row">
                            <div class="cell" data-title="Full Name">
                                <?php echo $Username ?>
                            </div>
                            <div class="cell" data-title="Headshots">
                                <?php echo $Headshots ?>
                            </div>
                            <div class="cell" data-title="Forum Title">
                                <?php echo $ForumName ?>
                            </div>
                        </div>
                 <?php
                }
        }