当前位置： 文江博客话题详情

根据查询结果在 html 表中生成复选框

发布于 2025-01-04 13:20:09 字数 1965 浏览 0 评论 0原文

我正在尝试生成一个每行都有复选框的表。我在下面找到了一个工作代码，用于根据查询结果生成表。是否可以在此处插入一段代码，该代码将提供一个额外的列，该列将在每行中包含复选框？

<?php

    function SQLResultTable($Query)
    {
        $link = mysql_connect("localhost","root" , "") or die('Could not connect: ' . mysql_error());      //build MySQL Link
        mysql_select_db("dbName") or die('Could not select database');        //select database
        $Table = "";  //initialize table variable

        $Table.= "<table border='1' style=\"border-collapse: collapse;\">"; //Open HTML Table

        $Result = mysql_query($Query); //Execute the query
        if(mysql_error())
        {
            $Table.= "<tr><td>MySQL ERROR: " . mysql_error() . "</td></tr>";
        }
        else
        {
            //Header Row with Field Names
            $NumFields = mysql_num_fields($Result);
            $Table.= "<tr style=\"background-color: #000066; color: #FFFFFF;\">";
            for ($i=0; $i < $NumFields; $i++)
            {
                $Table.= "<th>" . mysql_field_name($Result, $i) . "</th>";
            }
            $Table.= "</tr>";

            //Loop thru results
            $RowCt = 0; //Row Counter
            while($Row = mysql_fetch_assoc($Result))
            {
                //Alternate colors for rows
                if($RowCt++ % 2 == 0) $Style = "background-color: #FFCCCC;";
                else $Style = "background-color: #FFFFFF;";

                $Table.= "<tr style=\"$Style\">";
                //Loop thru each field
                foreach($Row as $field => $value)
                {
                    $Table.= "<td>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp$value&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</td>";
                }
                $Table.= "</tr>";
            }

        }
        $Table.= "</table>";

        return $Table;
    }

?>
原文

I'm trying to generate a table with checkboxes on each row. I have found a working code below for generating a table based on query results. Is it possible to insert a code in here which will provide an extra column which will contain checkboxes in each row?

<?php

    function SQLResultTable($Query)
    {
        $link = mysql_connect("localhost","root" , "") or die('Could not connect: ' . mysql_error());      //build MySQL Link
        mysql_select_db("dbName") or die('Could not select database');        //select database
        $Table = "";  //initialize table variable

        $Table.= "<table border='1' style=\"border-collapse: collapse;\">"; //Open HTML Table

        $Result = mysql_query($Query); //Execute the query
        if(mysql_error())
        {
            $Table.= "<tr><td>MySQL ERROR: " . mysql_error() . "</td></tr>";
        }
        else
        {
            //Header Row with Field Names
            $NumFields = mysql_num_fields($Result);
            $Table.= "<tr style=\"background-color: #000066; color: #FFFFFF;\">";
            for ($i=0; $i < $NumFields; $i++)
            {
                $Table.= "<th>" . mysql_field_name($Result, $i) . "</th>";
            }
            $Table.= "</tr>";

            //Loop thru results
            $RowCt = 0; //Row Counter
            while($Row = mysql_fetch_assoc($Result))
            {
                //Alternate colors for rows
                if($RowCt++ % 2 == 0) $Style = "background-color: #FFCCCC;";
                else $Style = "background-color: #FFFFFF;";

                $Table.= "<tr style=\"$Style\">";
                //Loop thru each field
                foreach($Row as $field => $value)
                {
                    $Table.= "<td>      $value      </td>";
                }
                $Table.= "</tr>";
            }

        }
        $Table.= "</table>";

        return $Table;
    }

?>

如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论， 你可以免费 注册 一个本站的账号。

评论（2）

奈何桥上唱咆哮 2025-01-11 13:20:09

如果您希望它作为每行的最后一列：

<?php

        function SQLResultTable($Query)
        {
            $link = mysql_connect("localhost","root" , "") or die('Could not connect: ' . mysql_error());      //build MySQL Link
            mysql_select_db("dbName") or die('Could not select database');        //select database
            $Table = "";  //initialize table variable

            $Table.= "<table border='1' style=\"border-collapse: collapse;\">"; //Open HTML Table

            $Result = mysql_query($Query); //Execute the query
            if(mysql_error())
            {
                $Table.= "<tr><td>MySQL ERROR: " . mysql_error() . "</td></tr>";
            }
            else
            {
                //Header Row with Field Names
                $NumFields = mysql_num_fields($Result);
                $Table.= "<tr style=\"background-color: #000066; color: #FFFFFF;\">";
                for ($i=0; $i < $NumFields; $i++)
                {
                    $Table.= "<th>" . mysql_field_name($Result, $i) . "</th>";
                }
                $Table.= "<th>Checkbox column</th>";
                $Table.= "</tr>";

                //Loop thru results
                $RowCt = 0; //Row Counter
                while($Row = mysql_fetch_assoc($Result))
                {
                    //Alternate colors for rows
                    if($RowCt++ % 2 == 0) $Style = "background-color: #FFCCCC;";
                    else $Style = "background-color: #FFFFFF;";

                    $Table.= "<tr style=\"$Style\">";
                    //Loop thru each field
                    foreach($Row as $field => $value)
                    {
                        $Table.= "<td>      $value      </td>";
                        $Table.= "<td><input type="checkbox" name="nameHere" value="valueHere" ></td>";
                    }
                    $Table.= "</tr>";
                }

            }
            $Table.= "</table>";

            return $Table;
        }
?>

虽然生成的代码确实很难看 - 内联样式，呃。 -_-

If you want it as the last column in each row:

<?php

        function SQLResultTable($Query)
        {
            $link = mysql_connect("localhost","root" , "") or die('Could not connect: ' . mysql_error());      //build MySQL Link
            mysql_select_db("dbName") or die('Could not select database');        //select database
            $Table = "";  //initialize table variable

            $Table.= "<table border='1' style=\"border-collapse: collapse;\">"; //Open HTML Table

            $Result = mysql_query($Query); //Execute the query
            if(mysql_error())
            {
                $Table.= "<tr><td>MySQL ERROR: " . mysql_error() . "</td></tr>";
            }
            else
            {
                //Header Row with Field Names
                $NumFields = mysql_num_fields($Result);
                $Table.= "<tr style=\"background-color: #000066; color: #FFFFFF;\">";
                for ($i=0; $i < $NumFields; $i++)
                {
                    $Table.= "<th>" . mysql_field_name($Result, $i) . "</th>";
                }
                $Table.= "<th>Checkbox column</th>";
                $Table.= "</tr>";

                //Loop thru results
                $RowCt = 0; //Row Counter
                while($Row = mysql_fetch_assoc($Result))
                {
                    //Alternate colors for rows
                    if($RowCt++ % 2 == 0) $Style = "background-color: #FFCCCC;";
                    else $Style = "background-color: #FFFFFF;";

                    $Table.= "<tr style=\"$Style\">";
                    //Loop thru each field
                    foreach($Row as $field => $value)
                    {
                        $Table.= "<td>      $value      </td>";
                        $Table.= "<td><input type="checkbox" name="nameHere" value="valueHere" ></td>";
                    }
                    $Table.= "</tr>";
                }

            }
            $Table.= "</table>";

            return $Table;
        }
?>

Though the code's that's generated is really ugly - inline styles, ugh. -_-

回复 原文
谁的年少不轻狂 2025-01-11 13:20:09

这是一个非常简单的逻辑，对不起，我不使用您的完整代码：

index.php:

<html>
  <head>
    <title>your page</title>
  </head>
  <body>
    <form method="post">
      <table>
        <caption>myTable</caption>
        <thead>
          <tr>
            <th>column with checkbox</th>
            <th>column with text</th>
          </tr>
        </thead>
        <tbody>
          <?php
            // get your databaseresult to an array called $result
            $connection = mysql_connect("server", "user", "password");
            mysql_select_database("databasename");
            $resultHash = mysql_query("SELECT * FROM mytable");

            while($row = mysql_fetch_array($resultHash)){
               $result[] = $row;
            }
            mysql_close($connection); // never forget to close the connection if not longer needed

            foreach($result as $key => $value)
            {
              echo "<tr>\r\n";
              echo "  <td><input type=\"checkbox\" name=\"yourCheckboxName".$key."\" /></td>\r\m";
              // $key is the index of your numeric $result array
              echo "  <td>".$value[0]."</td>\r\n";
              echo "</tr>\r\n";
            }
          ?>
        <tbody>
      </table>
    </form>
  </body>
<html>

我认为这就是您需要做的所有事情，请使用 mysql_fetch_array()< /代码>
http://php.net/manual/en/function.mysql-fetch-array.php 它甚至更快

我希望代码是正确的，如果不正确看看数组$result< /code> 和 $value 就像使用 var_dump() 一样。没有测试它，也没有写 php 4 周或类似的东西

编辑：
昨晚犯了一个错误，抱歉，这里稍微纠正一下。

我认为你的数据库表设计是这样的。

表（id int auto_increment，某些varchar（255）不为空，主键（id））

<?php
  foreach($result as $index => $row){
    echo "<tr>";
    echo "<td>";
      echo "<input type='checkbox' name='yourname".$index."' />"; // now every checkbox has an unique identifier
    echo "</td>";
    foreach($row as $column => $value){
      echo "<td>";
      echo "column = ".$column;
      echo "\r\n";
      echo "value = ".$value;
      echo "<td>";
    }
    echo "</tr>";
  }
?>

its a very simply logic, excuse me i don't use your complete code:

index.php:

<html>
  <head>
    <title>your page</title>
  </head>
  <body>
    <form method="post">
      <table>
        <caption>myTable</caption>
        <thead>
          <tr>
            <th>column with checkbox</th>
            <th>column with text</th>
          </tr>
        </thead>
        <tbody>
          <?php
            // get your databaseresult to an array called $result
            $connection = mysql_connect("server", "user", "password");
            mysql_select_database("databasename");
            $resultHash = mysql_query("SELECT * FROM mytable");

            while($row = mysql_fetch_array($resultHash)){
               $result[] = $row;
            }
            mysql_close($connection); // never forget to close the connection if not longer needed

            foreach($result as $key => $value)
            {
              echo "<tr>\r\n";
              echo "  <td><input type=\"checkbox\" name=\"yourCheckboxName".$key."\" /></td>\r\m";
              // $key is the index of your numeric $result array
              echo "  <td>".$value[0]."</td>\r\n";
              echo "</tr>\r\n";
            }
          ?>
        <tbody>
      </table>
    </form>
  </body>
<html>

That is simply all you need to do I think, and please work with mysql_fetch_array()
http://php.net/manual/en/function.mysql-fetch-array.php it's even faster

I hope the code is correct, if not look what the arrays $result and $value are like by using var_dump(). Didn't test it and didn't write php 4 weeks or something like this

Edit:
I did a mistake last night, sorry, here is a little correction.

I think your database table design is like.

table(id int auto_increment, something varchar(255) not null, primary key(id))

<?php
  foreach($result as $index => $row){
    echo "<tr>";
    echo "<td>";
      echo "<input type='checkbox' name='yourname".$index."' />"; // now every checkbox has an unique identifier
    echo "</td>";
    foreach($row as $column => $value){
      echo "<td>";
      echo "column = ".$column;
      echo "\r\n";
      echo "value = ".$value;
      echo "<td>";
    }
    echo "</tr>";
  }
?>
回复 原文
~没有更多了~

关于作者

鱼忆七猫命九

暂无简介

文章
评论
24 人气
发私信

相关话题

更多

热门标签

操作系统 程序设计 IT运维 Linux系统管理 JavaScript 服务器应用 solaris C/C++ PHP Shell BSD Vue.js aix Oracle Python HTML 系统管理 HTML5 CSS 前端
更多

推荐作者

卷耳

文章 0 评论 0

佚名

文章 0 评论 0

℉服软

文章 0 评论 0

qq_2gSKZM

文章 0 评论 0

凉宸

文章 0 评论 0

gyhjy

文章 0 评论 0

更多

友情链接

文江博客
    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站，即表示您同意使用 Cookies 和您的相关数据。
    原文