StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to refresh contents of div after link is clicked
primarykey
Id
17298440
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2013-06-25T13:17:53.843
FavoriteCount
0
LastActivityDate
2017-07-15T21:32:46.020
LastEditDate
2017-07-15T21:32:46.020
LastEditorUserId
4370109
OwnerUserId
2391089
ParentId
0
PostTypeId
1
Score
0
ViewCount
499
LastEditorDisplayName
text
Body
<p>I have a form which contains a dropdown box, when the value is changed the form uses jQuery and ajax to produce a table. The table contains data based on the value of the dropdown box and also links.</p> <p>My initial script which is where the dropdown box is and where the table is added is:</p> <pre><code><?php require_once('/connections/db.php'); mysql_select_db($database_db, $db); $query_weeks = "SELECT WeekNo, WeekName FROM tbl_weeks ORDER BY WeekNo ASC"; $weeks = mysql_query($query_weeks, $db) or die(mysql_error()); $row_weeks = mysql_fetch_assoc($weeks); $totalRows_weeks = mysql_num_rows($weeks); ?> <!DOCTYPE HTML> <html> <head> <meta charset="utf-8"> <title>Untitled Document</title> </head> <body> <form name="form1" method="post" action=""> <select id="weekselect" name="week"> <?php do { ?> <option value="<?php echo $row_weeks['WeekNo']?>"><?php echo $row_weeks['WeekName']?></option> <?php } while ($row_weeks = mysql_fetch_assoc($weeks)); $rows = mysql_num_rows($weeks); if($rows > 0) { mysql_data_seek($weeks, 0); $row_weeks = mysql_fetch_assoc($weeks); } ?> </select> </form> <div id="mydata"></div> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function (){ // listen to change in monthselect $('#weekselect').change(function(){ var week= $('#weekselect option:selected').val(); //pass val to php $.post('test2.php',{week: week}, function(data) { //do something with the data $('div#mydata').html(data); }); }); }); </script> </body> </html> </code></pre> <p>The script produces the dropdown from the mysql db and creates a listener for it, when the select is changed the value of the select is passed to the test2.php using jquery. the data returned is added to div #mydata</p> <p>Test2 which produces the table is as follows</p> <pre><code><?php if (!isset($_SESSION)) {session_start();} include('session.php'); require_once('Connections/dbc.php'); $open_week=$_SESSION['MM_OpenWeek']; $week_selected=$_POST['week']; $season=$_SESSION['MM_Season']; ?> <!DOCTYPE HTML> <html> <head> <meta charset="utf-8"> <title>Untitled Document</title> </head> <body> <?php echo '<p>Week selected: '.$week_selected .'<p>'; echo '<p>Open Week: '.$open_week .'<p>'; if ($week_selected>=$open_week) { echo '<p>Week Open<p>'; } else { echo '<p>Week Closed<p>'; } //create recordset of fixtures for the week selected $sql="SELECT * FROM q_games_stats WHERE WeekNo =".$week_selected . " and Season=". $season ." and at='Home' ORDER BY WeekNo ASC"; $rec_games=mysqli_query($dbc,$sql); //create table using the recordset ?> <div id="data_table"> <table class="table" align="center"> <th class="th" width="80px">Match Date</th> <th class="th" width="150px">Home Team</th> <th class="th" width="40px">Score</th> <th class="th" width="150px">Away Team</th> <th class="th" width="150px">Link</th> <?php while ($row=mysqli_fetch_array($rec_games)) { ?> <tr class="tr"> <td class="td"><?php echo $row['MatchDate']?></td> <td class="td"><?php echo $row['TeamName']?></td> <td class="td"><?php echo $row['Score']?></td> <td class="td"><?php echo $row['OppName']?></td> <td class="td"><a href="#" target="_top">Link</a></td> </tr> <?php } ?> </table> </div> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function (){ // listen to change in monthselect $('#data_table a').click(function(){ alert("link clicked"); }); }); </script> </body> </html> </code></pre> <p>This produces the table, which includes links. There is an event listener of the links in the table, which when I click produces an alert.</p> <p>What I want to do is instead of an alert being produced when clicking a link is for the table to reproduce, the reason for this is when the user clicks a link it will run a script which will change the underlying data in the table and therefore the table will need to be refreshed.</p> <p>Is there I way I can do this, or is there a better way to do what I want to do?</p>
Tags
<php><jquery><ajax><hyperlink><html-table>
Title
How to refresh contents of div after link is clicked
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. USuser2391089
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. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

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.