StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POReferenceError: ajaxfunction is not defined
primarykey
Id
15488704
data
AcceptedAnswerId
15488752
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-03-18T23:12:04.500
FavoriteCount
0
LastActivityDate
2013-03-18T23:46:25.810
LastEditDate
LastEditorUserId
0
OwnerUserId
1871245
ParentId
0
PostTypeId
1
Score
0
ViewCount
385
LastEditorDisplayName
text
Body
<p>I've been unable to get an ajax script to run for some time.</p> <p>Basically, I need the user to select an option from one drop down box, then, based on what's selected, the second drop down box with populate accordingly based on a MySQL query.</p> <p>My Script looks like</p> <pre><code><script type="text/javascript"> $(function(){ $('select [name="front-size"]').change(function() { $.ajax({ url: '../functions/process.php', type:'get', data:{'value' : $(this).val()}, dataType:"html", success: function(data) { $("#sub").html(data); } }); }); }); </script> </code></pre> <p>My initial drop down box is populated by a MySQL query like so</p> <pre><code><select name="front-size" onchange="ajaxfunction(this.value)"> <?php $door_size = $db->prepare("SELECT DISTINCT door_size FROM doors WHERE door_model = '".$_SESSION['front_door']."'"); $door_size->execute(); while($row = $door_size->fetch(PDO::FETCH_ASSOC)) { $size = $row['door_size']; echo '<option value="'.$size.'">'.$size.'</option>'; } ?> </select> </code></pre> <p>The second drop down box is empty</p> <pre><code><select name="front-finish" id="sub" onchange="ajaxfunction(this.value)"> </select> </code></pre> <p>And process.php should do the next query based on what was previously selected (this works on its own)</p> <pre><code><?php session_start(); include ('config.php'); $parent = $_GET['parent']; $update_option = $db->prepare("SELECT door_finish FROM doors WHERE door_model = '".$_SESSION['front_door']."' AND door_size = '".$parent."'"); $update_option->execute(); while($row = $update_option->fetch(PDO::FETCH_ASSOC)) { $door_finishes = $row['door_finish']; echo '<option value="'.$door_finishes.'">'.$door_finishes.'</option>'; } ?> </code></pre> <p>In Firebug, when I select my first drop down menu, this error is shown and I've been unable to solve it.</p> <pre><code>ReferenceError: ajaxfunction is not defined ajaxfunction(this.value) </code></pre> <p>How can I fix this?</p>
Tags
<php><jquery><ajax>
Title
ReferenceError: ajaxfunction is not defined
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMichael N
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. 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.