StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POjQuery forms.js with multiple forms per page
primarykey
Id
531395
data
AcceptedAnswerId
531437
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2009-02-10T07:50:23.883
FavoriteCount
1
LastActivityDate
2010-07-28T20:51:27.427
LastEditDate
2009-06-03T21:49:14.117
LastEditorUserId
16417
OwnerUserId
54259
ParentId
0
PostTypeId
1
Score
2
ViewCount
6467
LastEditorDisplayName
Paolo Bergantino
text
Body
<p>I would like to submit information to a mySql database using php and ajax.</p> <p>The page that the info is being sent from (form.php) has multiple forms that are generated from a "while()" loop.</p> <p>On success, I would a response to update a div above the particular form from which the data was submitted.</p> <p>I am currently using jQuery and the <a href="http://malsup.com/jquery/form/#getting-started" rel="nofollow noreferrer">jquery form plugin</a>.</p> <p>I have been successful in getting the data to the database, however I am having trouble with the response being sent back to the proper div. I have been successful in getting a response back to a div that is outside of the while() loop. I have not, however, been successful in getting a response back to a div within the loop. I have placed in the code below a div called: "> Where I would like the note to be placed.</p> <p>I know that this has everything to do with my javascript function:</p> <pre><code><script type="text/javascript"> jQuery(document).ready(function() { jQuery('form').ajaxForm({ target: '#noteReturn', success: function() { $('#noteReturn').fadeIn('slow'); } }); }); </script> </code></pre> <p>The #noteReturn function does not specify which businesses div it should be placed in.</p> <p>I hope that this makes sense.</p> <p>Thank you for your help.</p> <p>The code is below:</p> <pre><code> <script type="text/javascript" src="js/jquery.min.js"></script> <script type="text/javascript" src="js/forms.js"></script> <script type="text/javascript"> jQuery(document).ready(function() { jQuery('form').ajaxForm({ target: '#noteReturn', success: function() { $('#noteReturn').fadeIn('slow'); } }); }); </script> <?php $query = mysql_query("SELECT * FROM businesses"); while( $row = mysql_fetch_assoc( $query ) ): $b_id = $row['bid']; ?> <div class='notes'> <?php // query the db for notes associated with business... return notes texts and notes dates $notesQuery = mysql_query("SELECT business_id, notes, messageDate FROM notes WHERE notes.business_id = $b_id ORDER BY messageDate"); while( $NoteRow = mysql_fetch_assoc( $notesQuery ) ) { extract($NoteRow); echo "$notes<br/><span class='noteDate'>$messageDate</span><br />"; } // end while$notesQuery ?>  <div id="noteReturn<?php echo $b_id; ?>"></div>  <form name="noteForm" action="notesProcess.php" method="post"> <input type="text" name="note" /> <input type="hidden" value="<?php echo $b_id ?>" name="bid" /> <input type="submit" class="button" value="Send" /> </form> </div>  <?php endwhile; ?>  <?php $note = $_POST['note']; $id = $_POST['bid']; $sql = "INSERT INTO notes (business_id, notes) VALUES ('$id', '$note')"; $result = mysql_query( $sql ); if( $result ) { echo " $note"; } ?> </code></pre>
Tags
<php><javascript><jquery><mysql><ajax>
Title
jQuery forms.js with multiple forms per page
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USPaolo Bergantino
UserOwnerUserId
1. USsuperUntitled
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
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POjQuery forms.js with multiple forms per page
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  POjQuery forms.js with multiple forms per page
  UserUserId
  UStalkingnews
  VoteTypeVoteTypeId
  VTFavorite
3. VO
  singulars
  PostPostId
  POjQuery forms.js with multiple forms per page
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COfixed your formatting for you. indent code 4 spaces so it doesn't get processed.
  singulars
  PostPostId
  POjQuery forms.js with multiple forms per page
  UserUserId
  USPaolo Bergantino

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.