ryoka012 Posted June 23, 2011 Share Posted June 23, 2011 Hi. How to check the existing data to the select tag.. i have attach a image to easily understand what iam saying. The data in the AssignTo column must not be viewed on the Action column which i use a select tag. How can i accomplish this idea.. Thanks. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/240170-how-to-check-a-select-tag-for-value/ Share on other sites More sharing options...
Pikachu2000 Posted June 23, 2011 Share Posted June 23, 2011 Something like this, comparing the value in Assign To to the values for the <option>s in Action and not letting the same value be echoed as an <option> if it is the value in Assign To. $assign_to = 'JoshA'; $action = array( 'JoshA', 'popo', 'OliverB', 'RiedB' ); echo '<table>'; echo '<tr><td>Assign To</td><td>Action</td></tr>'; echo "<tr><td>$assign_to</td><td><select name=\"action\">\n"; foreach( $action as $v ) { if( strcasecmp($assign_to, $v) !== 0 ) { echo "<option value=\"$v\">$v</option>\n"; } } echo '</select></td></tr></table>'; Quote Link to comment https://forums.phpfreaks.com/topic/240170-how-to-check-a-select-tag-for-value/#findComment-1233655 Share on other sites More sharing options...
ryoka012 Posted June 23, 2011 Author Share Posted June 23, 2011 thanks for the reply. This is the code that i have made for the image below.. And i'am lost where will i put the code that you suggested. <?php session_start(); if(isset($_SESSION['username'])){ include_once("conn.php"); $pendtickets = array(); $newtickets=array(); $selectTicketsQuery = mssql_query("Select * from tblTicket inner join tblAssign on tblTicket.TickNo=tblAssign.TicketNo and tblAssign .AssignTo!= '$_SESSION[username]' "); while($pendticket = mssql_fetch_array($selectTicketsQuery)){ $pendtickets[] = $pendticket; } $newtickno=mssql_query("Select * from tblTicket where TickNo not in (select TicketNo from tblAssign)"); while($newticket = mssql_fetch_array($newtickno)){ $newtickets[] = $newticket; } $Assign= mssql_query("Select * from MISPIC "); while($AssignOption = mssql_fetch_array($Assign)){ $AssignOptions[] = $AssignOption; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <script type="text/javascript" language="javascript" src="jquery./jquery.js"></script> <script type="text/javascript" language="javascript" src="jquery./jquery.dataTables.js"></script> <script type="text/javascript" charset="utf-8"> $(document).ready(function() { $('#example').dataTable(); } ); </script> <script type="text/javascript" charset="utf-8"> </script> <?php echo '<meta http-equiv="refresh" content="60;url="UnAssignticket.php">';?> <style type="text/css"> form { float:left; } </style> </head> <body id="dt_example"> <br/> <br/> <p> <table BORDERCOLOR="#0B0B0B" border='1' bgcolor="#F5F5FA" width="100%" align='center'> <tr> <td > <img src='img/pend.png'> </td> </tr> <tr> <td align='center'> <div align='left' id="containerpend"> <div id="demo"> <table BORDERCOLOR="#0B0B0B" frame="box" cellpadding="0" cellspacing="0" frame="box" class="display" id="example"> <thead> <tr> <th><a title="Ticket Number">Ticket No.</a></th> <th><a title="Ticket Create By">Create By</a></th> <th><a title="Ticket Create Date">Create Date</a></th> <th><a title="Date Assigned">Date Assigned</a></th> <th><a title="Problem Error">Problem Description</a></th> <th><a title="Ticket Assigned To">Assign To</a></th> <th><a title="User Action">Action</a></th> </tr> </thead> <tbody> <?php foreach($pendtickets as $pendticket) {?> <tr class="GradeA"> <td class='center'><?php echo "<a href='viewassignticket.php?id={$pendticket['TickNo']}&uname={$pendticket['UserName']}' title='View Ticket'>".$pendticket['TicketNo']."</a>"?></td> <td class='center'><?php echo $pendticket['UserName'];?></td> <td class='center'><?php echo $pendticket['DateCreate'];?></td> <td class='center'><?php echo $pendticket['DateAssign'];?></td> <td class='center'><?php echo $pendticket['Category']." (".$pendticket['Subcat'].")"?></td> <td class='center'><?php echo $pendticket['AssignTo'];?></td> <td class='center'> <form id='trans' name="trans" class='trans' action='forwardtick.php' method='POST' > <?php $_SESSION['ticketassign']=$pendticket['TicketNo']; $_SESSION['nameassign']=$pendticket['AssignTo']; ?> <select name='Trans' onchange="Transferticket('<?php echo $pendticket['TickNo'];?>',$(this));"> <option value="0">Please Select</option> <?php foreach($AssignOptions as $TransferOption){ echo '<option value="', $TransferOption['MISPIC'], '">', $TransferOption['MISPIC'], '</option>'; } ?> </select> </form> </td> </tr> <?php } ?> </tbody> <tfoot> <th>Ticket No</th> <th>Create By</th> <th>Create Date</th> <th>Date Assigned</th> <th>Problem Description</th> <th>Assign To</th> <th>Action</th> </tfoot> </table> </div> </div> </td> </tr> </table > </p> <script type="text/javascript" charset="utf-8"> function Transferticket(ticket,uVal) { if (window.confirm('Transfer this ticket number ' + ticket + ' to ' + uVal.val())) { document.forms['trans'].submit(); }else{ uVal.val(0); }; } var forms = document.getElementsByTagName('trans'), i; for (i = 0; i < forms.length; i += 1) { if (forms[i].className === 'trans') { forms[i].onchange = Transferticket; } } </script> <style type="text/css" title="currentStyle"> @import "css/demo_page.css"; @import "css/demo_table.css"; </style> </body> </html> <?php }else{ //not logged in header('location: login.php'); } ?> Quote Link to comment https://forums.phpfreaks.com/topic/240170-how-to-check-a-select-tag-for-value/#findComment-1233691 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.