StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POhow to validate data on text?
primarykey
Id
19441007
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-10-18T03:17:09.537
FavoriteCount
0
LastActivityDate
2013-10-18T05:05:52.817
LastEditDate
2013-10-18T04:44:50.260
LastEditorUserId
1265817
OwnerUserId
2882205
ParentId
0
PostTypeId
1
Score
0
ViewCount
172
LastEditorDisplayName
text
Body
<p>I have this project where in it requires to validate the data on text field if the user input "0" the process must not run and display an error message instead.. here's my code:</p> <pre><code><?php include('connect.php'); include('func.php'); if (isset($_REQUEST['command'])=='delete' && $_REQUEST['pid']>0){ remove_product($_REQUEST['pid']); } else if (isset($_REQUEST['command'])=='update') { $max=count($_SESSION['cart']); for($i = 0;$i < $max; $i++) { $pid = $_SESSION['cart'][$i]['productid']; $q = intval($_REQUEST['product'.$pid]); if( $q > 0 && $q <= 999){ $_SESSION['cart'][$i]['qty']=$q; } else{ echo "Some products not updated!, quantity must be a number between 1 and 999"; } } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <script language="javascript"> function del(pid){ if(confirm('Do you really mean to delete this item')){ document.form1.pid.value=pid; document.form1.command.value='delete'; document.form1.submit(); } } function clear_cart(){ if(confirm('This will empty your shopping cart, continue?')){ document.form1.command.value='clear'; document.form1.submit(); } } function update_cart(){ document.form1.command.value='update'; document.form1.submit(); } </script> <script type="text/javascript" src="lib/jquery.js"></script> <script type="text/javascript"> $(document).ready(function(){ $("#qty").keypress(function (e) { if( e.which!=8 && e.which!=0 && (e.which<48 || e.which>57)) { return false; } }); }); </script> <script type="text/javascript" src="lib/jquery.js"></script> <script type="text/javascript" src="src/facebox.js"></script> <script type="text/javascript"> jQuery(document).ready(function($) { $('a[rel*=facebox]').facebox({ loadingImage : 'src/loading.gif', closeImage : 'src/closelabel.png' }) }) </script> <script type="text/javascript"> function checkCheckBox(){ agree_check = oForm.elements["agree"].checked; if(!agree_check){ alert("You must agree to the terms and conditions before purchasing."); } return agree_check; } </script> <style type="text/css"> body { background-color: #FFF; } table { margin-top: 15px; } #wrapper { width:900px; height:auto; margin-left:40px; } </style> </head> <body> <div id="wrapper"> <table width="900" align="center"> <tr> <td><img src="images/banner.png" width="900" height="138" /></td> </tr> <form name="form1"> <input type="hidden" name="pid" /> <input type="hidden" name="command" /> <div style="margin:0px auto; width:600px;" > <div style="padding-bottom:10px"> <h1 align="center">Your Shopping Cart</h1> <input type="button" value="Continue Shopping" <onclick="window.location='customerproduct.php'" /> </div> <table border="0" cellpadding="5px" cellspacing="1px" style="font-family:Verdana, Geneva, sans-serif; font-size:11px; background-color:#E1E1E1" width="100%"> <?php if(isset($_SESSION['cart'])){ echo '<tr bgcolor="#FFFFFF" style="font-weight:bold"><td>Serial</td><td>Name</td><td>Price</td><td>Qty</td><td>Amount</td><td>Options</td></tr>'; $max = count($_SESSION['cart']); for($i = 0; $i < $max; $i++){ $pid = $_SESSION['cart'][$i]['productid']; $q = $_SESSION['cart'][$i]['qty']; $pname = get_product_name($pid); if ($q == 0) continue; ?> <tr bgcolor="#FFFFFF"><td><?php echo $i+1?></td><td><?php echo $pname?></td> <td><?php echo number_format(get_price($pid))?>Php</td> <td><input type="text" id="qty" name="product<?php echo $pid?>" value="<?php echo $q?>" maxlength="3" size="2" /></td> <td><?php echo number_format(get_price($pid)*$q)?>Php</td> <td><a href="javascript:del(<?php echo $pid?>)">Remove</a></td></tr> <?php } ?> <tr> <td><b>Order Total: <?php echo number_format(get_order_total())?>Php</b></td> <td colspan="5" align="right"> <input type="button" value="Update Cart" onclick="update_cart()"> <input type="checkbox" value="0" name="agree"> <a rel="facebox" href="terms.php"?>terms and condition</a> <input type="button" id="place" value="Place Order" onclick="window.location='order.php'" > </form></td> </tr> <?php } ?> </table> </div> </form> </code></pre> <p>I like to display the error message when the user inputs "0" in the text of <code>quantity</code>.</p>
Tags
<php><html>
Title
how to validate data on text?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USDACrosby
UserOwnerUserId
1. USBon Corcino
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
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COIsn't that what `if($q>0 && $q<=999){` does?
  singulars
  PostPostId
  POhow to validate data on text?
  UserUserId
  USBarmar
2. CONot sure if it's your issue, but there's a few issues with your code. 1) You include `lib/jquery.js` twice - only need it once. 2) The input after "Your Shopping Cart" has a `<` before the `onclick` attribute - it shouldn't. 3) You have an extra `</form>` tag at the bottom. 4) I generally recommend closing `input` elements, although it isn't necessary in HTML 5 (`<input name=".." type=".." />`). 5) It'll be a lot easier to manage if you separate all the pieces - CSS & JS should be external, do all PHP at the top (except output, obviously)
  singulars
  PostPostId
  POhow to validate data on text?
  UserUserId
  USDACrosby

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.