多次显示 mysqli 结果

我最近问过这个问题，但它被标记为重复并被删除。请在标记之前查看我的问题，因为它不一样，我正在努力弄清楚这一点。

我想将 MYSQLI 查询中的"公司"和"区域"结果回显到我的页面中，在 php 页面正文的不同点。

仅显示第一个回声。请显示我的错误。

<?php 
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/Connections/****";
include_once($path);
$dbhandle=mysqli_connect($hostname_Demo, $username_Demo, $password_Demo, $database_Demo);
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql_RS1="SELECT * from CompanyName where area = 1";
$result=mysqli_query($dbhandle,$sql_RS1);
?>
<head>
<title>TEST</title>
</head>
<body>
<?php
while($row = mysqli_fetch_assoc($result))
{
    echo $row['company'];
}
?>
<?php
while($row = mysqli_fetch_assoc($result))
{
    echo $row['area'];
}
?>
<?php  $dbhandle->close();  ?>
</body>
</html>

您可以使用

此代码

<?php
    while($row = mysqli_fetch_assoc($result))
    {
    $data_array[] = $row;
    }
    foreach ($data_array as $data) {
        echo $data['company'];
    }
    foreach ($data_array as $data) {
        echo $data['area'];
    }

像这样做..，你不想对你的数据库进行更多的查询。

您正在获取同一行两个不同的行，这是不正确的。

这样的东西应该有效

<?php 
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/Connections/****";
include_once($path);
$dbhandle=mysqli_connect($hostname_Demo, $username_Demo, $password_Demo, $database_Demo);
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql_RS1="SELECT * from CompanyName where area = 1";
$result=mysqli_query($dbhandle,$sql_RS1);
$row =array();
while ($x= mysqli_fetch_assoc($result))
      $row[]=$x;
$i=0;
?>
<head>
<title>TEST</title>
</head>
<body>
<?php
   echo $row[i]['company'];
?>
<?php
   echo $row[i]['area'];
   $i++;
?>

尝试合并它们，看起来它们是一样的

<?php
while($row = mysqli_fetch_assoc($result))
{
echo  $row['company']." 
".$row['area'];
}
?>

这就是我的结尾。它有效，所以我希望它是正确的。感谢大家的帮助。

$sql_RS1="SELECT * from CompanyName where area = 1";
$result=mysqli_query($dbhandle,$sql_RS1);
$row =array();
while ($x= mysqli_fetch_assoc($result))
  $row_RS1=$x;
?>
<?php
$sql_RS2="SELECT * from employees where EmployeeID = 79";
$result=mysqli_query($dbhandle,$sql_RS2);
$row_RS2 =array();
while ($x= mysqli_fetch_assoc($result))
  $row_RS2=$x;
?>
<head>
<title>TEST</title>
</head>
<body>
<p>
<?php  echo $row_RS1['company']; ?>
</p>
<p>
<?php  echo $row_RS1['company']; ?>
</p>
<p>
<?php  echo $row_RS1['area']; ?>
</p>
<p>
<?php  echo $row_RS2['EmployeeID'];  ?>
</p>
<p>
<?php  echo $row_RS2['Surname']; ?>
</p>
<p>
<?php  echo $row_RS2['EmployeeID'];  ?>
</p>
<p>
<?php  $dbhandle->close();  ?>
</p>
</body>

相关内容

最新更新

热门标签：