Comboboxes not updating

2023-04-08 17:59 问答作者：

I have two php pages, admin_bkp.php and db_submit.php.

The admin_bkp.php gives a user a table that let's the user set permissions to employees and save the permissions to a MySQL table called rights. The employee info is gathered from hs_hr_employee and saved to rights together with an extra 'Permissions' column.

It was working at first, you could save the data and when you refresh the page, the admin_bkp.php shows you the default value in the comboboxes as you had previously chosen.

However, now it is returning the default value as 'All' which is something I don't want. I want it to show the chosen value from before.

The admin_php.bkp saves the values upon clicking the 'Save' button

This is the code: admin_bkp.php

 <?php

$connection = mysql_connect('localhost','admin','root');

if( isset($_POST['submit']) )
{
    if( isset( $_POST['cb_change'] ) && is_array( $_POST['cb_change'] ))
    {
        foreach( $_POST['cb_change']  as $emp_number => $permission)
        {       
echo "$permission";
            $sql = "UPDATE `rights` SET Permission='".mysql_real_escape_string($permission)."' WHERE emp_number='".mysql_real_escape_string($emp_number)."'";
            echo __LINE__.": sql: {$sql}\n";
            mysql_query( $sql );
        }
    }
}
?>
<p style="text-align: center;">
    <span style="font-size:36px;"><strong><span style="font-family: trebuchet ms,helvetica,sans-serif;"><span style="color: rgb(0, 128, 128);">File Database - Administration Panel</span></span></strong></span></p>
<p style="text-align: center;">
    &nbsp;</p>

<head>
<style type="text/css">
/*
http://icant.co.uk/csstablegallery/index.php?css=71

Data Tables and Cascading Style Sheets Gallery
Title: Casablanca
Author: RODrigo CASTilho Galv?o Ferreira - RODCAST
URL: http://www.rodcast.com.br
Update: 04/04/2008 10:51 AM
*/
body{
background: url('bg.gif');
}
table {
    color: #666;
    font: 0.8em/1.6em "Trebuchet MS",Verdana,sans-serif;
    border-collapse: collapse;
    background: #fff;
}

table,caption {
    margin: 0 auto;
    border-right: 0px solid #CCC;
    border-left: 0px solid #CCC;    

}

caption,th,td {
    border-left: 0;
    padding: 10px;

}

caption,thead th,tfoot th,tfoot td {
    background-color: #216dab;
    color: #FFF;
    font-weight: bold;
    text-transform: uppercase
}

thead th {
    background-color: #666;
    color: #fff;
    text-align: center
}

tbody th {
    padding: 20px 10px
}

tbody tr.odd {
    background-color: #F7F7F7;
    color: #666;

}

tbody a {
    padding: 1px 2px;
    color: #fff;
    text-decoration: none;
    border-bottom: 1px dotted #E63C1E;
    background: #7bafd9;
}

tbody a:active,tbody a:hover,tbody a:focus,tbody a:visited {
    color: #fff;

}

tbody tr:hover {
    background-color: #EEE;
    color: #333
}

tbody tr:hover a {
    /*background-color: #FFF*/
    color:fff;
}

tbody td+td+td+td a {
    color: #fff;
    font-weight: bold;
    border-bottom: 0;

}

tbody td+td+td+td a:active,tbody td+td+td+td a:hover,tbody td+td+td+td a:focus,tbody td+td+td+td a:visited {
    color: #fff
}

tbody td a[href="http://www.rodcast.com.br/"] {
    margin: 0 auto;
    display: block;
    width: 15px;
    height: 15px;
    background: transparent url('data:image/gif;base64,R0lGODlhDwAPAIAAACEpMf///yH5BAAAAAAALAAAAAAPAA8AAAIjjA8Qer0JmYvULUOlxXEjaEndliUeA56c97TqSD5pfJnhNxYAOw%3D%3D') no-repeat;
    text-indent: -999em;
    border-bottom: 0;

}

tbody a:visited:after {
    font-family: Verdana,sans-serif;
    content: "\00A0\221A"
}
</style>
</head>

    <form method="post" action="db_submit.php">

    <?php 


        if (!$connection)
          {
          die('Could not connect: ' . mysql_error());
          }

        mysql_select_db('users', $connection);

        #mysql_query('INSERT into rights(Emp_num, ID, Name, Surname) SELECT emp_number, employee_id, emp_firstname, emp_lastname FROM hs_hr_employee');


        $result = mysql_query("SELECT emp_number, employee_id, emp_firstname, emp_lastname, Permissions FROM rights");

        mysql_query("INSERT INTO rights (emp_number, employee_id, emp_firstname, emp_lastname)
                    SELECT emp_number, employee_id, emp_firstname, emp_lastname
                    FROM hs_hr_employee
                    ON DUPLICATE KEY UPDATE employee_id = VALUES(employee_id), emp_number = VALUES(emp_number)
                    ");

        $duplicates = mysql_query("SELECT emp_number, employee_id, emp_firstname, emp_lastname, count(*) FROM rights GROUP BY emp_number, employee_id, emp_firstname, emp_lastname having count(*) > 1");

        $count = mysql_num_rows($duplicates);

        if ($count > 0) {
        while ($row = mysql_fetch_assoc($duplicates)) {
        $field = $row["emp_number"];
        $limit = $row["count(*)"] - 1;
        mysql_query("DELETE FROM rights WHERE emp_number='$field' LIMIT $limit");
        }
        mysql_free_result($duplicates);
        }           


        echo "<center>";
        /*
        echo "      
        <table >
        <tr>
        <th>Employee Number</th>
        <th>ID</th>
        <th>Name</th>
        <th>Surname</th>
        <th>Permissions</th>
        <th>Change</th>
        </tr>"; */

        echo "      
        <table >
        <tr>
        <th>Employee Number</th>
        <th>ID</th>
        <th>Name</th>
        <th>Surname</th>        
        <th>Permissions</th>
        </tr>";

        while($row = mysql_fetch_array($result))
          {
          echo "<tr>";
          echo "<td>" . $row['emp_number'] . "</td>";
          echo "<td>" . $row['employee_id'] . "</td>";
          echo "<td>" . $row['emp_firstname'] . "</td>";
          echo "<td>" . $row['emp_lastname'] . "</td>";
          #echo "<td>" . $row['Permissions'] . "</td>";



          echo "<td>
                      <select>
                         <option value='All'>All</option> 
                         <option value='Remote Gaming' selected='selected'>Remote Gaming</option> 
                         <option value='Landbased Gaming'>Landbased Gaming</option>
                         <option value='General Gaming'>General Gaming</option>
                      </select>
                    </td>
                    "; 
          echo "</tr>" ;
          echo "<input type='hidden' name='emp_id[]' value='". $row['employee_id'] ."'>";
          }


        $selected = $row['Permissions'];
            $options = array(
              "Remote Gaming",
              "Landbased Gaming",
              "General Gaming"
            );


            foreach ($options as $option){
              if($option == $selected){
                echo "<option value='$option' selected='selected'>$option</option>";
              }else{
                echo "<option value='$option'>$option</option>";
              }
            }
          #echo "<td>" . $row['Change'] . "</td>";

          echo "</table>
                    <p style='text-align: right;'>
                        <input name='Save_Btn' type='Submit' value='Save' />
                    </p>

                </center>";

     mysql_close($connection);

    ?>

<p style="text-align: center;">
    &nbsp;</p>
<p style="text-align: center;">
    &nbsp;</p>

</form>

db_submit.php:

<html>
<body>
<p>Data submitted successfully.</p>

<?php

$connection = mysql_connect('localhost','admin','root');
mysql_select_db('users', $connection);

$cbchange = $_POST['cb_change'];
$emp_id = $_POST['emp_id'];

foreach($cbchange as $a => $b){
    echo $cbchange[$a] ." - ". $emp_id[$a];
    echo "<br/>";

    $query = "

                UPDATE `rights`
                SET `rights`.`Permissions`='".$cbchange[$a]."'
             开发者_运维技巧   WHERE `rights`.`employee_id`='".$emp_id[$a]."'
                ";
    mysql_query($query);
}

?>
</body>
</html>

Here are some images to give you a general idea of the setup.

Comboboxes not updating

Original Code:

   <?php

$connection = mysql_connect('localhost','admin','root');

if( isset($_POST['submit']) )
{
    if( isset( $_POST['cb_change'] ) && is_array( $_POST['cb_change'] ))
    {
        foreach( $_POST['cb_change']  as $emp_number => $permission)
        {       
echo "$permission";
            $sql = "UPDATE `rights` SET Permission='".mysql_real_escape_string($permission)."' WHERE emp_number='".mysql_real_escape_string($emp_number)."'";
            echo __LINE__.": sql: {$sql}\n";
            mysql_query( $sql );
        }
    }
}
?>
<p style="text-align: center;">
    <span style="font-size:36px;"><strong><span style="font-family: trebuchet ms,helvetica,sans-serif;"><span style="color: rgb(0, 128, 128);">File Database - Administration Panel</span></span></strong></span></p>
<p style="text-align: center;">
    &nbsp;</p>

<head>
<style type="text/css">
/*
http://icant.co.uk/csstablegallery/index.php?css=71

Data Tables and Cascading Style Sheets Gallery
Title: Casablanca
Author: RODrigo CASTilho Galv?o Ferreira - RODCAST
URL: http://www.rodcast.com.br
Update: 04/04/2008 10:51 AM
*/
body{
background: url('bg.gif');
}
table {
    color: #666;
    font: 0.8em/1.6em "Trebuchet MS",Verdana,sans-serif;
    border-collapse: collapse;
    background: #fff;
}

table,caption {
    margin: 0 auto;
    border-right: 0px solid #CCC;
    border-left: 0px solid #CCC;    

}

caption,th,td {
    border-left: 0;
    padding: 10px;

}

caption,thead th,tfoot th,tfoot td {
    background-color: #216dab;
    color: #FFF;
    font-weight: bold;
    text-transform: uppercase
}

thead th {
    background-color: #666;
    color: #fff;
    text-align: center
}

tbody th {
    padding: 20px 10px
}

tbody tr.odd {
    background-color: #F7F7F7;
    color: #666;

}

tbody a {
    padding: 1px 2px;
    color: #fff;
    text-decoration: none;
    border-bottom: 1px dotted #E63C1E;
    background: #7bafd9;
}

tbody a:active,tbody a:hover,tbody a:focus,tbody a:visited {
    color: #fff;

}

tbody tr:hover {
    background-color: #EEE;
    color: #333
}

tbody tr:hover a {
    /*background-color: #FFF*/
    color:fff;
}

tbody td+td+td+td a {
    color: #fff;
    font-weight: bold;
    border-bottom: 0;

}

tbody td+td+td+td a:active,tbody td+td+td+td a:hover,tbody td+td+td+td a:focus,tbody td+td+td+td a:visited {
    color: #fff
}

tbody td a[href="http://www.rodcast.com.br/"] {
    margin: 0 auto;
    display: block;
    width: 15px;
    height: 15px;
    background: transparent url('data:image/gif;base64,R0lGODlhDwAPAIAAACEpMf///yH5BAAAAAAALAAAAAAPAA8AAAIjjA8Qer0JmYvULUOlxXEjaEndliUeA56c97TqSD5pfJnhNxYAOw%3D%3D') no-repeat;
    text-indent: -999em;
    border-bottom: 0;

}

tbody a:visited:after {
    font-family: Verdana,sans-serif;
    content: "\00A0\221A"
}
</style>
</head>

    <form method="post" action="db_submit.php">

    <?php 


        if (!$connection)
          {
          die('Could not connect: ' . mysql_error());
          }

        mysql_select_db('users', $connection);

        #mysql_query('INSERT into rights(Emp_num, ID, Name, Surname) SELECT emp_number, employee_id, emp_firstname, emp_lastname FROM hs_hr_employee');


        $result = mysql_query("SELECT emp_number, employee_id, emp_firstname, emp_lastname, Permissions FROM rights");

        mysql_query("INSERT INTO rights (emp_number, employee_id, emp_firstname, emp_lastname)
                    SELECT emp_number, employee_id, emp_firstname, emp_lastname
                    FROM hs_hr_employee
                    ON DUPLICATE KEY UPDATE employee_id = VALUES(employee_id), emp_number = VALUES(emp_number)
                    ");

        $duplicates = mysql_query("SELECT emp_number, employee_id, emp_firstname, emp_lastname, count(*) FROM rights GROUP BY emp_number, employee_id, emp_firstname, emp_lastname having count(*) > 1");

        $count = mysql_num_rows($duplicates);

        if ($count > 0) {
        while ($row = mysql_fetch_assoc($duplicates)) {
        $field = $row["emp_number"];
        $limit = $row["count(*)"] - 1;
        mysql_query("DELETE FROM rights WHERE emp_number='$field' LIMIT $limit");
        }
        mysql_free_result($duplicates);
        }           


        echo "<center>";
        /*
        echo "      
        <table >
        <tr>
        <th>Employee Number</th>
        <th>ID</th>
        <th>Name</th>
        <th>Surname</th>
        <th>Permissions</th>
        <th>Change</th>
        </tr>"; */

        echo "      
        <table >
        <tr>
        <th>Employee Number</th>
        <th>ID</th>
        <th>Name</th>
        <th>Surname</th>        
        <th>Permissions</th>
        </tr>";

        while($row = mysql_fetch_array($result))
          {
          echo "<tr>";
          echo "<td>" . $row['emp_number'] . "</td>";
          echo "<td>" . $row['employee_id'] . "</td>";
          echo "<td>" . $row['emp_firstname'] . "</td>";
          echo "<td>" . $row['emp_lastname'] . "</td>";
          #echo "<td>" . $row['Permissions'] . "</td>";

          echo "<td> <select name='cb_change[]' SELECTED VALUE=".$row['Permissions'].">
          <option value='All'>All</option> 
          <option value='Remote Gaming'>Remote Gaming</option> 
          <option value='Landbased Gaming'>Landbased Gaming</option>
          <option value='General Gaming'>General Gaming</option>
          </select> </td>"; 
          echo "</tr>" ;
          echo "<input type='hidden' name='emp_id[]' value='". $row['employee_id'] ."'>";
          }

          #echo "<td>" . $row['Change'] . "</td>";

          echo "</table>
                    <p style='text-align: right;'>
                        <input name='Save_Btn' type='Submit' value='Save' />
                    </p>

                </center>";

     mysql_close($connection);

    ?>

<p style="text-align: center;">
    &nbsp;</p>
<p style="text-align: center;">
    &nbsp;</p>

</form>

Can you kindly point me in the right direction?

If the correct values are displaying in the database, then your problem is with displaying the data at the other end. From what I understand, you want to output a list of permissions in an html select box, with the currently stored permission set as 'selected' for that user, correct?

If so, your code here:

echo "<td> <select name='cb_change[]' SELECTED VALUE=".$row['Permissions'].">
 <option value='All'>All</option> 
 <option value='Remote Gaming'>Remote Gaming</option> 
 <option value='Landbased Gaming'>Landbased Gaming</option>
 <option value='General Gaming'>General Gaming</option>
 </select></td>";

Is wrong. you need to match the <option> value to the currently selected value, then stick attribute on it.

eg:

$selected = $row['Permissions'];
$options = array(
  "Remote Gaming",
  "Landbased Gaming",
  "General Gaming"
);
foreach ($options as $option){
  if($option == $selected){
    echo "<option value='$option' selected='selected'>$option</option>";
  }else{
    echo "<option value='$option'>$option</option>";
  }
}

That should work.

FINAL EDIT

The following code marked 'Code' should be placed underneath:

echo "      
    <table >
    <tr>
    <th>Employee Number</th>
    <th>ID</th>
    <th>Name</th>
    <th>Surname</th>        
    <th>Permissions</th>
    </tr>";

Code:

    $options = array(
        "All",
        "Remote Gaming",
        "Landbased Gaming",
        "General Gaming"
    );

    while($row = mysql_fetch_array($result))
    {
        echo "<tr>";
        echo "<td>" . $row['emp_number'] . "</td>";
        echo "<td>" . $row['employee_id'] . "</td>";
        echo "<td>" . $row['emp_firstname'] . "</td>";
        echo "<td>" . $row['emp_lastname'] . "</td>";
        #echo "<td>" . $row['Permissions'] . "</td>";
        echo "<td> <select name='cb_change[]'>";
        foreach($options as $option){
            if($option == $row['Permissions']){
                echo "<option value='" . $option . "' selected='selected'>". $option ."</option>";
            }else{
                echo "<option value='" . $option . "'>". $option ."</option>";
            }
        }
        echo "</select> </td>";
        echo "</tr>" ;
        echo "<input type='hidden' name='emp_id[]' value='". $row['employee_id'] ."'>";
    } // end while

继续阅读：combobox list php

Comboboxes not updating

更多精彩内容

精彩评论

最新问答

央视是哪个频道？

请问买过的朋友，舒提啦旅行箱实际使用体验如何？？

检查不孕不育需要的费用？

海信ULED电视画质有什么不同的地方?？

钉子可以挂的住画框幕布吗？

问答排行榜

王昌瑞《潜梦追凶》剧组庆生新锐演员未来可期？

Is it allowed to ask users to enter credit card details for own payment method?

Escaping "<" in Perl-generated XML

imessage会显示已读吗？

微信重新建群怎么建？

更多精彩内容

精彩评论

最新问答

央视是哪个频道？

请问买过的朋友，舒提啦旅行箱实际使用体验如何？？

检查不孕不育需要的费用？

海信ULED电视画质有什么不同的地方?？

钉子可以挂的住画框幕布吗？

问答排行榜

王昌瑞《潜梦追凶》剧组庆生 新锐演员未来可期？

Is it allowed to ask users to enter credit card details for own payment method?

Escaping "<" in Perl-generated XML

imessage会显示已读吗？

微信重新建群怎么建？

王昌瑞《潜梦追凶》剧组庆生新锐演员未来可期？