php表格显示数据、编辑、删除

Question

我花了一整天的时间试着让这个代码片段工作：

    <?php
            include("conn.php");

$result = mysql_query("SELECT * FROM users");
  echo "<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" id=\"product-       table\">
  <tr>
  <th class=\"table-header-check\"><a id=\"toggle-all\" ></a> </th>
  <th class=\"table-header-repeat line-left\" ><a href=\"\">User ID</a></th>
  <th class=\"table-header-repeat line-left\"><a href=\"\"> Username</a></th>
  <th class=\"table-header-repeat line-left\"><a href=\"\">Firstname</a></th>
  <th class=\"table-header-repeat line-left\"><a href=\"\">Lastname</a></th>
  <th class=\"table-header-repeat line-left\"><a href=\"\">Email</a></th>
  <th class=\"table-header-repeat line-left\"><a href=\"\">Registration Date</a></th>
  <th class=\"table-header-options line-left\"><a href=\"\">Options</a></th>
   </tr>";
  while ($row = mysql_fetch_array($result)) {

   echo "<tr>";
   echo "<td>"."<input  type=\"checkbox\"/></td>";
    echo "<td>" . $row['user_id'] . "</td> ";
    echo "<td>" . $row['username'] . "</td>";
    echo "<td>" . $row['first_name'] . "</td>";
    echo "<td>" . $row['last_name'] . "</td>";
     echo "<td>" . $row['email'] . "</td>";
 echo "<td>" . $row['registration_date'] . "</td>";
 echo "<td class=\"options-width\">".
                "<a href=\"\" title=\"Edit\" class=\"icon-1 info-tooltip\">              </a>".
                "><a href="delete.php?id=' . $row['id'] . '"class=\"icon-2 info-tooltip\"></a>".
                "<a href=\"\" title=\"Save\" class=\"icon-5**strong text**info-tooltip\">       </a>".
                "
                </td>";
  echo "</tr>";
  }


     ?>

我想要做的是将我的用户拉到一个html表中，然后创建它，这样我就可以在url字符串ex中编辑/删除他们。

Answer 1

通过此行更改上次回显之前的内容

            echo '<td class="options-width">'.
            '<a href="" title="Edit" class="icon-1 info-tooltip"> </a>'.
            '      <a href="delete.php?id=' . $row['id'] . ' " class="icon-2 info-tooltip"></a>'.
            '<a href="" title="Save" class="icon-5**strong text**info-tooltip">       </a>'.
            '</td>';

您在使用引号(嵌套引号“和‘)时遇到问题

Answer 2

不确定这是否是答案，但它更简洁，也不太容易出现问题：

<?php
    include("conn.php");
    $result = mysql_query("SELECT * FROM users");
    $rows   = mysql_fetch_array($result);
?>
<table border="0" width="100%" cellpadding="0" cellspacing="0" id="product-table">
    <tr>
        <th class="table-header-check"><a id="toggle-all"></a> </th>
        <th class="table-header-repeat line-left"><a href="#">User ID</a></th>
        <th class="table-header-repeat line-left"><a href="#">Username</a></th>
        <th class="table-header-repeat line-left"><a href="#">Firstname</a></th>
        <th class="table-header-repeat line-left"><a href="#">Lastname</a></th>
        <th class="table-header-repeat line-left"><a href="#">Email</a></th>
        <th class="table-header-repeat line-left"><a href="#">Registration Date</a></th>
        <th class="table-header-options line-left"><a href="#">Options</a></th>
    </tr>
    <?php foreach($rows as $row) { ?>
    <tr>
        <td><input type="checkbox" /></td>
        <td><?php echo $row['user_id']; ?></td>
        <td><?php echo $row['username']; ?></td>
        <td><?php echo $row['first_name']; ?></td>
        <td><?php echo $row['last_name']; ?></td>
        <td><?php echo $row['email']; ?></td>
        <td><?php echo $row['registration_date']; ?></td>
        <td class="options-width">
            <a href="#" title="Edit" class="icon-1 info-tooltip"></a>
            <a href="delete.php?id=<?php echo $row['id']; ?>" class="icon-2 info-tooltip"></a>
            <a href="#" title="Save" class="icon-5 strong-text info-tooltip"></a>
        </td>
    </tr>
    <?php } ?>
</table>

希望这能有所帮助:)