StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to retain in the same selection after refresh?
primarykey
Id
19261025
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-10-09T00:39:28.423
FavoriteCount
0
LastActivityDate
2013-10-09T01:05:16.983
LastEditDate
LastEditorUserId
0
OwnerUserId
2853548
ParentId
0
PostTypeId
1
Score
0
ViewCount
285
LastEditorDisplayName
text
Body
<p>How to retain with the same selection in dropdown when refresh or after I submit or delete? </p> <p>I have this code below that select value from database. I want to back with the same value in select dropdown after I refresh or I submit the form or delete records.</p> <p>bid.php</p> <pre><code><html> <head> <script> function showUser(str) { var $txtHint = $('#txtHint'); if (str == "") { $txtHint.html(''); return; } $txtHint.load('bid_list.php?q=' + str) } </script> </head> <body onload=showUser(str="ALL")> <?php $mysqli = new mysqli("localhost", "root", "", "app"); $result = $mysqli->query("SELECT bid FROM procurement WHERE bid LIKE '13-___' OR bid LIKE '1_-___' OR bid LIKE '2_-___' GROUP BY bid ORDER BY bid"); $option = ''; while($row = $result->fetch_assoc()) { $option .= '<option value = "'.$row['bid'].'">'.$row['bid'].'</option>'; } ?> <select name="users" onchange="showUser(this.value)" style="overflow:scroll;width:100px;"> <option value="ALL" selected='ALL'>ALL</option> <?php echo $option; ?> </select> <div id="txtHint"> </div> </body> </html> </code></pre> <h2>bid_list.php</h2> <p></p> <pre><code><?php $mysqli = new mysqli("localhost", "root", "", "app"); $q = $_GET["q"]; $where = ''; if ( $q != 'ALL' ) { $where = " WHERE bid='$q' "; } $result1 = $mysqli->query(" SELECT bid, item_name, item_description, unit, unit_cost, quantity, supplier, po_number, po_date, counter, SUM(unit_cost*quantity) AS total_amount FROM procurement $where GROUP BY counter ORDER BY bid "); echo'<table id="tfhover" cellspacing="0" class="tablesorter" style="text-transform:uppercase;"> <thead> <tr> <th colspan="3" id="none" style="cursor: default;"></th> <th title="Item Name">Item Name</th> <th title="Item Description">Description</th> <th title="Example : Pc, Pcs, Box and Etc.">Unit</th> <th title="Item Price">Unit Cost</th> <th title="Total Item Quantity">QTY</th> <th title="Total Price">Total Amount</th> <th title="Name of Supplier">Supplier</th> <th title="Purchase Order Date">PO Date</th> <th title="Purchase Order #">PO #</th> <th id="none" style="cursor: default;"></th> </tr> </thead>'; echo'<tbody>'; while($row = $result1->fetch_assoc()){ if($row['bid'] != '') { echo'<tr> <td align="center"><a href="bid.php?de='.$row["counter"].'" onclick="return confirm(\'Really want to delete ?\');"><img src="images/del.png" border="0" width="10" height="10" title="Delete"></a></td> <td align="center"><a class="fancybox" href="edit.php?pn='.$row["counter"].'"><img src="images/edit.png" border="0" width="10" height="10" title="Edit"></a></td> <td align="center"><a class="fancybox" href="comments.php?pn='.$row["counter"].'"><img src="images/remarks.png" border="0" width="10" height="10" title="Remarks and Notes"></a></td> <td>'.$row['item_name'].'</td> <td>'.$row['item_description'].'</td> <td>'.$row['unit'].'</td> <td>'.number_format($row['unit_cost'], 2, '.', ',').'</td> <td>'.$row['quantity'].'</td> <td>'.number_format($row['total_amount'], 2, '.', ',').'</td> <td>'.$row['supplier'].'</td> <td>'.$row['po_date'].'</td> <td>'.$row['po_number'].'</td> <td><input name="checkbox[]" type="checkbox" id="checkbox[]" value="'.$row['counter'].'"></td> </tr>'; } } echo "</tbody></table>"; </code></pre>
Tags
<javascript><php><jquery><mysqli>
Title
How to retain in the same selection after refresh?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USaltaire lastname
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.