StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODynamic PHP pages in jQuery UI dialog box
primarykey
Id
13287992
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-11-08T11:16:24.283
FavoriteCount
0
LastActivityDate
2012-11-08T11:16:24.283
LastEditDate
LastEditorUserId
0
OwnerUserId
1808928
ParentId
0
PostTypeId
1
Score
1
ViewCount
597
LastEditorDisplayName
text
Body
<p>I have a table that is built via PHP & MS-SQL that shows a list of stocks that our clients hold (I work in a stockbrokers). The simplified table looks like this:</p> <pre> | + | Google | | + | Apple | | + | Microsoft | </pre> <p>The plus sign is an image, and when I click it, it brings up a jQuery dialog box. This part works fine, but at the moment each dialog displays static data. What I need now is for the dialog to display another table, that shows the transactions for each stock.</p> <p>Here's the Javascript I have so far:</p> <pre><code><script> $(function() { $('div.dialog') .dialog( { autoOpen: false, modal: true } ); $('img.opener') .css("cursor","pointer") .click(function() { $('#' + this.id.replace(/opener/, 'dialog')) .dialog('open'); return false; } ); }); </script> </code></pre> <p>And the PHP to create the table:</p> <pre><code><?php echo '<tr>'; echo '<td><img id="opener' . $row_counter . '" class="opener" src="../images/procedural/plus-white.png" title="Click to show Transactions"></td>'; echo '<td align=left>' . htmlentities($stock_short_name) . '</td>'; echo '<td style="display: none"><div id="dialog' . $row_counter . '" class="dialog" title="Transactions for ' . $stock_sedol . '">This is box ' . $row_counter . '</div></td>'; echo '</tr>'; ?> </code></pre> <hr/> <p>I've found this script which I've modified a bit to bring back what I want from another PHP file:</p> <pre><code><!doctype html> <html lang="en"> <head> <meta charset="utf-8" /> <title>jQuery UI Dialog - Animation</title> <link rel="stylesheet" href="http://code.jquery.com/ui/1.9.1/themes/base/jquery-ui.css" /> <script src="http://code.jquery.com/jquery-1.8.2.js"></script> <script src="http://code.jquery.com/ui/1.9.1/jquery-ui.js"></script> <script type="text/javascript"> $(document).ready(function() { $('#tire-specs th a').each(function() { var $link = $(this); var $dialog = $('<div></div>') .load($link.attr('href') + ' #content') .dialog({ autoOpen: false, title: $link.attr('title'), width: 600 }); $link.click(function() { $dialog.dialog('open'); return false; }); }); }); </script> </head><body> <table id="tire-specs"> <thead> <tr> <th>Size</th> <th><a href="trans.php?client=62629&stock=34935" title="Transactions">Transactions</a></th> <th>Max Load</th> <th>Max Inflation Pressure</th> <th>Tread Depth</th> </tr> </thead> <tbody> <tr> <td>205/65R15</td> <td>620 A A</td> <td>1477 lbs.</td> <td>44 psi</td> <td>11/32"</td> </tr> </tbody> </table> </body></html> </code></pre> <p>And here is trans.php:</p> <pre><code><!doctype html> <html> <head> <meta charset="utf-8"> <title>Transactions</title> </head> <body> <h1>Transactions</h1> <div id="content"> <?php $client=$_GET["client"]; $stock=$_GET['stock']; $mssql_server= "sql-primary"; $mssql_database = "FOUR_I_CORE"; include("../index_files/mssql_include.php"); $sql = "SELECT * FROM [TRA_CORE] WHERE [CLIENT REC NO] = '$client' AND [STOCK REC NO] = '$stock' AND [QUANTITY] != 0"; $stmt = sqlsrv_query($connnection, $sql); while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) { $cost = $row['COST/PROCEEDS']; echo $cost . '<br>'; } ?> </div> </body> </html> </code></pre> <p>However, I can't work out how to make this second script integrate with the first, so that each dialog box is dynamic. Can anyone help?</p> <p>(Sorry for the lengthy post, figured more info was better than none)</p> <p>Cheers, Dave</p>
Tags
<php><jquery-ui><jquery-ui-dialog>
Title
Dynamic PHP pages in jQuery UI dialog box
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. USDavid Lettice
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. VO
  singulars
  PostPostId
  PODynamic PHP pages in jQuery UI dialog box
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
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.