循环浏览并显示数据库sql中的多个表行 - Looping through and displaying multiple table rows from database sql

Looping through and displaying multiple table rows from database sql

本文关键字：sql 浏览显示数据库循环 | 更新日期: 2024-06-10

我试图循环浏览我的数据库并显示每一行。我不知道我的代码出了什么问题，但它根本没有显示任何内容。。。有人能帮忙吗？

<?php
$players = mysql_query("SELECT * FROM users");
while ($row = mysql_fetch_assoc($players)) {
    $steamid = $row["name"];
    $profilename = $row["profilename"];
    $profileurl = $row["profileurl"];
    $avatar = $row["avatar"];
    $region = $row["region"];

?>

<p><?php echo $name ?></p>
<p>><?php echo $profilename ?></p>
<p>><?php echo $profileurl ?></p>
<p><?php echo $avatar ?></p>

<?php
}
?>

这就是我包括这个文件的地方：

<?php include 'fetch_players.php'; ?>

下面给出了使用正确方法的mysqli_*的示例。也请注意评论：-

<?php
error_reporting(E_ALL); // check all type of error
ini_set('display_errors',1); // display those error
$connection = mysqli_connect('hostname','username','password','dbname'); // provide your db credentials here
$final_data = array(); // create empty array
if($connection){
    $players = mysqli_query($connection,"SELECT * FROM users");
    if($players){
        while ($row = mysqli_fetch_assoc($players)) {
            $final_data[$row['id']]['name'] = $row['name']; // assign values id wise to the array
            $final_data[$row['id']]['profilename'] = $row['profilename'];
            $final_data[$row['id']]['profileurl'] = $row['profileurl'];
            $final_data[$row['id']]['avatar'] = $row['avatar'];
            $final_data[$row['id']]['region'] = $row['region'];
        }
    }else{
        echo "query execution failed because of". mysqli_error($connection);
    }
}else{
  echo "db connection error because of". mysqli_connect_error();
}
?>
<?php 
if(count($final_data) >0){ // check array have some value or not?
foreach($final_data as $final_dat){?>
    <p><?php echo $final_dat['name'] ?></p><!-- print out values -->
    <p><?php echo $final_dat['profilename'] ?></p>
    <p><?php echo $final_dat['profileurl'] ?></p>
    <p><?php echo $final_dat['avatar'] ?></p>
    <p><?php echo $final_dat['region'] ?></p>
<?php }}?>