如何把每一个<选择><选项>在PHP中将combobox转换为变量 - how to put every<select><option> combobox into a variable in PHP

我的PHP脚本输出有一个小问题。

本页的目的是选择票证状态选项之一，例如:

未开票(显示数据库中的票状态为"新票"或"正在审核中")
新票(显示数据库中状态为"新票"的票)
正在审核中(显示数据库中的票证状态为"正在审核中")
Closed Tickets(显示数据库中状态为Closed Tickets的门票)

用户选择状态后，code必须显示所选状态下正确的ticket。

所以我想做的是在每个选项之后放置一个数字变量，然后尝试使其成为这样，当选择某些东西时，刷新页面并发送选项的变量与页面刷新-除了它不起作用，哈哈。

我一直在头脑风暴一些不同的想法，让它检查从选择组合框中的状态获得的变量，但我还没有弄清楚这是相当令人沮丧的。

要点:

脚本必须在同一页面上工作。为每个不同的状态制作一个新页面是很多工作，不是很efficiënt。

下面是当前代码:

<?PHP
session_start();
include('connection.php');
if ($_SESSION['staff'] >='6')
{
    echo "<select name='type' id='type'>
    <option value='Open Tickets'>Open Tickets</option>" . $int= '1' . "
    <option value='New Tickets'>New Tickets</option>" . $int= '2' . "
    <option value='Under Review'>Under Review</option>" . $int = '3' . "
    <option value='Closed Tickets'>Closed Tickets</option>" . $int = '4' . "
    </select><BR>"; 
    echo "Current listed support tickets: <BR><BR>";
        if ($int = '1')
        {
            $result1 = mysql_query("SELECT * FROM support WHERE status = 'New Ticket' OR 'Under Review'");
            while ($row1 = mysql_fetch_array($result1))
            {
                $ticket1 = $row1['TicketID'];
                $user1 = $row1['name'];
                echo "Ticket ID: " . $row1['TicketID'] . "<BR>" . $row1['type'] . "<BR>Subject: " . $row1['subject'] . "<BR>Ticket Status: " . $row1['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket1' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user1' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
        }elseif ($int = '2')
        {
            $result2 = mysql_query("SELECT * FROM support WHERE status = 'New Ticket'");
            while ($row2 = mysql_fetch_array($result2))
            {
                $ticket2 = $row2['TicketID'];
                $user2 = $row2['name'];
                echo "Ticket ID: " . $row2['TicketID'] . "<BR>" . $row2['type'] . "<BR>Subject: " . $row2['subject'] . "<BR>Ticket Status: " . $row2['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket2' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user2' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
        }elseif ($int = '3')
        {
            $result3 = mysql_query("SELECT * FROM support WHERE status = 'New Ticket'");
            while ($row3 = mysql_fetch_array($result3))
            {
                $ticket3 = $row3['TicketID'];
                $user3 = $row3['name'];
                echo "Ticket ID: " . $row3['TicketID'] . "<BR>" . $row3['type'] . "<BR>Subject: " . $row3['subject'] . "<BR>Ticket Status: " . $row3['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket3' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user3' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
        }elseif ($int = '4')
        {
            $result4 = mysql_query("SELECT * FROM support WHERE status = 'Closed'");
            while ($row4 = mysql_fetch_array($result4))
            {
                $ticket4 = $row4['TicketID'];
                $user4 = $row4['name'];
                echo "Ticket ID: " . $row4['TicketID'] . "<BR>" . $row4['type'] . "<BR>Subject: " . $row4['subject'] . "<BR>Ticket Status: " . $row4['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket4' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user4' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
        }

    echo "Click <A href='overview_page.php'>HERE</A> to return to the overview page.<BR>";
    echo "Click <A href='uitlogen_user.php'>HERE</A> to logout!<BR>";
}else
{
    echo "You need to be an GM or Admin to view this page!<BR>";
    echo "Click <A href='uitlogen_user.php'>HERE</A> to login!";
}
?>

两个想法:

a)你可以通过实现一些javascript来做到这一点，它在选择改变后切换每张票的显示状态。

if ($_SESSION['staff'] >='6')
{
    echo "<select name='type' id='type' onchange='typeChanged()' onpropertychange='typeChanged()'>
    <option value='tab1'>Open Tickets</option>
    <option value='tab2'>New Tickets</option>
    <option value='tab3'>Under Review</option>
    <option value='tab4'>Closed Tickets</option>
    </select><BR>"; 
    echo "Current listed support tickets: <BR><BR>";
    echo "<div id="tab1" name="tabs">";
            $result1 = mysql_query("SELECT * FROM support WHERE status = 'New Ticket' OR 'Under Review'");
            while ($row1 = mysql_fetch_array($result1))
            {
                $ticket1 = $row1['TicketID'];
                $user1 = $row1['name'];
                echo "Ticket ID: " . $row1['TicketID'] . "<BR>" . $row1['type'] . "<BR>Subject: " . $row1['subject'] . "<BR>Ticket Status: " . $row1['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket1' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user1' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
    echo "</div>";
    echo "<div id="tab2" name="tabs">";
            $result2 = mysql_query("SELECT * FROM support WHERE status = 'New Ticket'");
            while ($row2 = mysql_fetch_array($result2))
            {
                $ticket2 = $row2['TicketID'];
                $user2 = $row2['name'];
                echo "Ticket ID: " . $row2['TicketID'] . "<BR>" . $row2['type'] . "<BR>Subject: " . $row2['subject'] . "<BR>Ticket Status: " . $row2['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket2' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user2' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
    echo "</div>";
    echo "<div id="tab3" name="tabs">";
            $result3 = mysql_query("SELECT * FROM support WHERE status = 'New Ticket'");
            while ($row3 = mysql_fetch_array($result3))
            {
                $ticket3 = $row3['TicketID'];
                $user3 = $row3['name'];
                echo "Ticket ID: " . $row3['TicketID'] . "<BR>" . $row3['type'] . "<BR>Subject: " . $row3['subject'] . "<BR>Ticket Status: " . $row3['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket3' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user3' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
    echo "</div>";
    echo "<div id="tab4" name="tabs">";
            $result4 = mysql_query("SELECT * FROM support WHERE status = 'Closed'");
            while ($row4 = mysql_fetch_array($result4))
            {
                $ticket4 = $row4['TicketID'];
                $user4 = $row4['name'];
                echo "Ticket ID: " . $row4['TicketID'] . "<BR>" . $row4['type'] . "<BR>Subject: " . $row4['subject'] . "<BR>Ticket Status: " . $row4['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket4' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user4' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
    echo "</div>";

    echo "Click <A href='overview_page.php'>HERE</A> to return to the overview page.<BR>";
    echo "Click <A href='uitlogen_user.php'>HERE</A> to logout!<BR>";
}else
{
    echo "You need to be an GM or Admin to view this page!<BR>";
    echo "Click <A href='uitlogen_user.php'>HERE</A> to login!";
}
?>
<script type="text/javascript">
function typeChanged()
{
    var chosen = document.getElementById('type').value;
    var tabs = document.getElementsByName('tabs');
    for (var i in tabs)
    {
        tabs[i].style.display = 'none';
    }
    document.getElementById(chosen).style.display = 'block';
}
</script>

b)重定向到该页面，使用url参数表示选择了哪个票证，并显示相应的票证。

<?PHP
session_start();
include('connection.php');
if ($_SESSION['staff'] >='6')
{
    $chosen = isset($_GET['chosen']) ? $_GET['chosen'] : 'tab1';
    echo "<select name='type' id='type' onchange='typeChanged()' onpropertychange='typeChanged()'>
    <option value='tab1'>Open Tickets</option>
    <option value='tab2'>New Tickets</option>
    <option value='tab3'>Under Review</option>
    <option value='tab4'>Closed Tickets</option>
    </select><BR>"; 
    echo "Current listed support tickets: <BR><BR>";
    if ($chosen == 'tab1')
    {
            $result1 = mysql_query("SELECT * FROM support WHERE status = 'New Ticket' OR 'Under Review'");
            while ($row1 = mysql_fetch_array($result1))
            {
                $ticket1 = $row1['TicketID'];
                $user1 = $row1['name'];
                echo "Ticket ID: " . $row1['TicketID'] . "<BR>" . $row1['type'] . "<BR>Subject: " . $row1['subject'] . "<BR>Ticket Status: " . $row1['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket1' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user1' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
    }
    if ($chosen == 'tab2')
    {
            $result2 = mysql_query("SELECT * FROM support WHERE status = 'New Ticket'");
            while ($row2 = mysql_fetch_array($result2))
            {
                $ticket2 = $row2['TicketID'];
                $user2 = $row2['name'];
                echo "Ticket ID: " . $row2['TicketID'] . "<BR>" . $row2['type'] . "<BR>Subject: " . $row2['subject'] . "<BR>Ticket Status: " . $row2['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket2' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user2' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
    }
    if ($chosen == 'tab3')
    {
            $result3 = mysql_query("SELECT * FROM support WHERE status = 'New Ticket'");
            while ($row3 = mysql_fetch_array($result3))
            {
                $ticket3 = $row3['TicketID'];
                $user3 = $row3['name'];
                echo "Ticket ID: " . $row3['TicketID'] . "<BR>" . $row3['type'] . "<BR>Subject: " . $row3['subject'] . "<BR>Ticket Status: " . $row3['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket3' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user3' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
    }
    if ($chosen == 'tab4')
    {
            $result4 = mysql_query("SELECT * FROM support WHERE status = 'Closed'");
            while ($row4 = mysql_fetch_array($result4))
            {
                $ticket4 = $row4['TicketID'];
                $user4 = $row4['name'];
                echo "Ticket ID: " . $row4['TicketID'] . "<BR>" . $row4['type'] . "<BR>Subject: " . $row4['subject'] . "<BR>Ticket Status: " . $row4['status'] . "<BR>";
                echo "<form action='detail_ticket.php?t=$ticket4' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
                echo "<form action='reply_ticket.php?r=$user4' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
            }
    }

    echo "Click <A href='overview_page.php'>HERE</A> to return to the overview page.<BR>";
    echo "Click <A href='uitlogen_user.php'>HERE</A> to logout!<BR>";
}else
{
    echo "You need to be an GM or Admin to view this page!<BR>";
    echo "Click <A href='uitlogen_user.php'>HERE</A> to login!";
}
?>
<script type="text/javascript">
function typeChanged()
{
    var chosen = document.getElementById('type').value;
    window.location.href = 'FILENAME.php?chosen=' + chosen;
}
</script>

下面是一个未经测试的(我没有您的数据库)示例，说明AJAX将如何为您工作。

如果你已经知道这一点，请原谅我，但AJAX并不是什么花哨的东西-它是一个简单的方法，允许你从javascript调用另一个PHP文件。

AJAX通过第二个PHP文件来工作，该文件执行下一项工作，并将结果返回给javascript。下面是流程:

在File1中，javascript/jQuery获取用户选择的选项并"调用"(AJAX)第二个PHP文件，传递用户的选择。使其发生的代码在这个位下面:

$('#type').change( function() { //grab the new value, send to File2 via AJAX });

File2(在本例中命名为"another_php_file.php")(a)接收从File1发送的post值，(b)执行数据库查找，(c)构建新的HTML， (d)将构建的代码(在我称为$x的变量中)返回给File1

现在，这非常重要:File1接收AJAX例程的success:函数中的新代码。在这个成功函数中，它可以使用jQuery来更新File1中的div。如果您希望用户按下其他按钮，您可以使用这些按钮来执行另一个AJAX查找，则下一个AJAX查找也必须在这个成功函数中。

无论如何，这应该回答了你的直接问题:

文件1

<?php
    session_start();
    include('connection.php');
?>
<html>
    <head>
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
        <script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/jquery-ui.min.js"></script>
        <link rel="stylesheet" href="http://code.jquery.com/ui/1.9.1/themes/base/jquery-ui.css" />
        <script type="text/javascript">
            $(document).ready(function() {
                $('#type').change( function() {
                    var chosen = $(this).val();
                    alert('You chose: ' + chosen);
                    $.ajax({
                        type: "POST",
                        url: "another_php_file.php",
                        data: 'theOption=' + chosen,
                        success: function(whatigot) {
//alert('Server-side response: ' + whatigot);
                            $('#report').html(whatigot);
                            $('#theButton').click(function() {
                                alert('You clicked the button');
                            });
                        } //END success fn
                    }); //END $.ajax
                }); //END dropdown change event
            }); //END $(document).ready()
        </script>
    </head>
<body>
<?php
if ($_SESSION['staff'] >='6')
{
    //Note: the value text string MUST MATCH the value stored in the database, because it is this exact string you will search for in the 2nd php (AJAX) file.
    echo "<select name='type' id='type'>
        <option value='Open Ticket'>Open Tickets</option>
        <option value='New Ticket'>New Tickets</option>
        <option value='Under Review'>Under Review</option>
        <option value='Closed'>Closed Tickets</option>
    </select><br><br>
    <div id='report'></div>"; 
}else
{
    echo "You need to be an GM or Admin to view this page!<BR>";
    echo "Click <A href='uitlogen_user.php'>HERE</A> to login!";
}
?>

FILE 2 -在本例中必须命名为"another_php_file.php"。如果更改名称，还必须更改上面AJAX代码段中的文件名:

<?php
$chosen = $_POST['theOption'];
//die('You clicked: ' . $chosen);
if ($chosen == 'New Ticket') {
    $result = mysql_query("SELECT * FROM support WHERE status = '$chosen' OR 'Under Review'");
    while ($row1 = mysql_fetch_array($result1))
    {
        $ticket1 = $row1['TicketID'];
        $user1 = $row1['name'];
        $x =  "Ticket ID: " . $row1['TicketID'] . "<BR>" . $row1['type'] . "<BR>Subject: " . $row1['subject'] . "<BR>Ticket Status: " . $row1['status'] . "<BR>";
        $x .= "<form action='detail_ticket.php?t=$ticket1' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
        $x .= "<form action='reply_ticket.php?r=$user1' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
    }
}else{
    $result = mysql_query("SELECT * FROM support WHERE status = '$chosen'");
    while ($row1 = mysql_fetch_array($result1))
    {
        $ticket1 = $row1['TicketID'];
        $user1 = $row1['name'];
        $x = "Ticket ID: " . $row1['TicketID'] . "<BR>" . $row1['type'] . "<BR>Subject: " . $row1['subject'] . "<BR>Ticket Status: " . $row1['status'] . "<BR>";
        $x .= "<form action='detail_ticket.php?t=$ticket1' method='post' name='detail_t' id='detail_t'><input type='submit' name='detail_b' id='detail_b' value='View Ticket!'></form>";
        $x .= "<form action='reply_ticket.php?r=$user1' method='post' name='r_ticket' id='r_ticket'><input type='submit' name='reply_b' id='reply_b' value='Reply on Ticket!'></form>";
    }
}
$x .= "Click <A href='overview_page.php'>HERE</A> to return to the overview page.<br>";
$x .= "Click <A href='uitlogen_user.php'>HERE</A> to logout!<br><br>";
$x .= "<input type='button' id='theButton' value='Click Me Example'>";
echo $x;

乍一看，这可能看起来很复杂，所以这里是AJAX的另一个例子，简化得多。请复制/粘贴到您自己的服务器上的文件，看看它是如何工作的。这真的很简单。