StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP jQuery: Passing a PHP variable FROM (not to) $.load()
primarykey
Id
19689538
data
AcceptedAnswerId
19689959
AnswerCount
3
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-10-30T17:15:17.477
FavoriteCount
0
LastActivityDate
2014-01-08T23:47:32.203
LastEditDate
2013-10-30T17:22:49.997
LastEditorUserId
2833220
OwnerUserId
2833220
ParentId
0
PostTypeId
1
Score
-1
ViewCount
525
LastEditorDisplayName
text
Body
I've seen questions asking about sending variables TO a document being loaded in $.load, but not retrieving variables from a $.load. I've pasted the pertinent pieces of code below; essentially what I'm trying to do is run a PHP function every so often, and initially when the page first loads. When the page first loads, it runs the getData function - and everything works as intended. But later down the page, when I try to load pullData.php, srcAverage doesn't update with the new value. The JS alert shows the srcAverage value. Example: The first time the page is run, srcAverage is X. Every 5 seconds, we want to load pullData.php and update srcAverage on index.php with the new value (change X). I feel like it's something really small I'm doing incorrectly - ideas? conn.php <pre><code><?php define("HOST", "stuff"); define("USER", "stuff"); define("PASSWORD", "stuff"); define("DATABASE", "stuff"); $mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE); // Connection info above all works as intended ?> </code></pre> index.php <pre><code><?php include 'inc/conn.php'; include 'inc/function.php'; $src = "none"; getData($src, $mysqli); // This initial run of getData works as intended // Skip to further down // The JS alert below does NOT reflect the new srcAverage ?> <script type="text/javascript"> $(document).ready(function() { setInterval(function() { // each interval, get first and second values $("#targetDiv").load("pullData.php"); alert('New value is <?php echo $srcAverage; ?>'); }, 5000); // end setInterval }); </script> </code></pre> pullData.php <pre><code><?php include 'incl/conn.php'; include 'incl/function.php'; $src = "none"; getData($src, $mysqli); ?> </code></pre> The getData function (see code below) grabs 4 values from separate tables, averages them together (I have them all separated in different statements and variables for troubleshooting purposes), then sets the variable srcAverage to the average value. I've tested that the MySQLi statements are working fine, and srcAverage is assigned the correct value by the function. Echoing or JS alerting show the value as intended (on this page). But the variable does NOT get passed to index.php when loaded via load(). function.php <pre><code><?php function getData($src, $mysqli) { // Check SRC for specific source // If no specific source, get average of all sources // If YES specific source, get that value global $srcAverage; if ($src == 'alt') { if ($stmt = $mysqli->prepare("SELECT value FROM table ORDER BY id DESC LIMIT 1;")) { $stmt->execute(); // Execute the prepared query. $stmt->store_result(); $stmt->bind_result($altVal); // get variables from result. $stmt->fetch(); if($stmt->num_rows == 1) { // The entry exists, good to go // echo $altVal; } } else { // Either no results pulled or more than one. echo "Error pulling alternate data!"; return false; } } else { // Value 1 if ($stmt = $mysqli->prepare("SELECT value FROM table ORDER BY id DESC LIMIT 1;")) { $stmt->execute(); // Execute the prepared query. $stmt->store_result(); $stmt->bind_result($firstVal); // get variables from result. $stmt->fetch(); if($stmt->num_rows == 1) { // echo $firstVal; // This works as intended } } else { // Either no results pulled or more than one. echo "Error pulling first value data!"; return false; } // Value 2 if ($stmt = $mysqli->prepare("SELECT value FROM table ORDER BY id DESC LIMIT 1;")) { $stmt->execute(); // Execute the prepared query. $stmt->store_result(); $stmt->bind_result($secondVal); // get variables from result. $stmt->fetch(); if($stmt->num_rows == 1) { // The entry exists, good to go // echo $secondVal; } } else { // Either no results pulled or more than one. echo "Error pulling second value data!"; return false; } // Value 3 if ($stmt = $mysqli->prepare("SELECT value FROM table ORDER BY id DESC LIMIT 1;")) { $stmt->execute(); // Execute the prepared query. $stmt->store_result(); $stmt->bind_result($thirdVal); // get variables from result. $stmt->fetch(); if($stmt->num_rows == 1) { // The entry exists, good to go // echo $thirdVal; } } else { // Either no results pulled or more than one. echo "Error pulling third value data!"; return false; } // Value 4 if ($stmt = $mysqli->prepare("SELECT value FROM table ORDER BY id DESC LIMIT 1;")) { $stmt->execute(); // Execute the prepared query. $stmt->store_result(); $stmt->bind_result($fourthVal); // get variables from result. $stmt->fetch(); if($stmt->num_rows == 1) { // The entry exists, good to go // echo $fourthVal; } } else { // Either no results pulled or more than one. echo "Error pulling fourth value data!"; return false; } // So everything up to this point is working fine. Statements grab data as intended, and assign variables. // We have data - move forward $srcCount = 4; $srcTotal = $firstVal + $secondVal + $thirdVal + $fourthVal; $srcAverage = $srcTotal / $srcCount; $srcAverage = number_format((float)$srcAverage, 2, '.', ''); // echo "Total: $srcTotal .... Average: $srcAverage"; // If we were to echo above, it would display correctly. Problem is passing the variable to index return $srcAverage; } } ?> </code></pre>
Tags
<php><jquery><global-variables>
Title
PHP jQuery: Passing a PHP variable FROM (not to) $.load()
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USLent
UserOwnerUserId
1. USLent
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. VO
 singulars
 PostPostId
 POPHP jQuery: Passing a PHP variable FROM (not to) $.load()
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTDownMod
CommentsPostId
1. CO@Evan From the looks of it the issue is passing variables FROM PHP to Javascript, not Javascript TO PHP.
 singulars
 PostPostId
 POPHP jQuery: Passing a PHP variable FROM (not to) $.load()
 UserUserId
 USMWJump
2. CO@Evan: Not a duplicate of that question. As MWJump said above - I wanted to pass FROM the file, not TO.
 singulars
 PostPostId
 POPHP jQuery: Passing a PHP variable FROM (not to) $.load()
 UserUserId
 USLent

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.