dsgnze6572 2015-08-08 04:27
浏览 185
已采纳

如何将数组数据放入表中?

I need some help with php code. I want to put data that I get with this query into simple php/html table.

Can you guys help me with this?

<?php

$konekcija=mysqli_connect("111.111.111.111","test","test123","publishers_instagram_accounts");
if (mysqli_connect_errno())
    die ("Error:".mysqli_connect_error());

$select = "select * from publishers_instagram_accounts where followed_id <= (select followed_id from publishers_instagram_accounts where username='zika')*1.2 and followed_id >= (select followed_id from publishers_instagram_accounts where username='zika')*0.8";

$stmt = mysqli_prepare($konekcija, $select);

if (mysqli_error($konekcija))
    die ("Error:" . mysqli_error($konekcija));

mysqli_stmt_bind_param($stmt, "ss", $trazi1, $trazi2);

if (!mysqli_stmt_execute($stmt))
{
    die ("Error:" . mysqli_stmt_error($stmt));
}
else
{
    $rezultat = mysqli_stmt_get_result($stmt);

    while ($red = mysqli_fetch_array($rezultat, MYSQL_ASSOC))
    {
        var_dump($red);
    }
}
  • 写回答

3条回答 默认 最新

  • dsa111111 2015-08-08 04:43
    关注
    while ($red = mysqli_fetch_array($rezultat, MYSQL_ASSOC)) {
     echo "
     <table>
      <thead>
        <td>Username</td>
        <td>Password</td>
      </thead>
      <tbody>
        <td>$red['username']</td>
        <td>$red['password']</td>
      </tbody>
    </table>
     ";
    }
    

    Something like this.. Hope it helps you.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?