Pass session variable to PHP page

Is the first line of common.php "session_start();"? if yes, then the problem is with Ajax,but if you don't have that line in common.php, put it at the very top and retry.

Yes, "session_start();" is in the common.php file.

In GetChartData1, try adding the session variable to table array and then examine it in your ajax call. At least that way, you'll know whether it's being read correctly. If not, then maybe post your common.php file for us to take a look at

This PHP instruction is almost always your best friend:
http://php.net/manual/en/function.var-dump.php

On a side note, you should always have the following line in any PHP script that gets called by AJAX (e.g. GetChartData1.php)

header("Cache-Control: no-cache, must-revalidate");

Select allOpen in new window

This avoids cached data being used (which might be causing your problem).

On another side note, remember that once you set a session variable, it remains until the session is ended or you use the unset() function.  

On a third side note, line 3 of Reports1.php will generate warnings in your log files every time a user loads the page for the first time.  I usually use something like

if (isset($_POST['workscheduledate'])) {  ... }

Select allOpen in new window

That said, are you using Firefox with the Firebug plugin by any chance?  It is immensely helpful in with debugging AJAX calls because it shows you what data is being sent and returned.

Have you looked in your server logs to see if there are any errors or warnings?

@zappafan2k2: Great suggestion about Firebug!

Thanks.

Ok, I'm trying to see where the issue may be so I commented out the session variable and instead changed the code to do a simple query based on the date parameter entered. Doing that it does not return any records, what am I doing wrong with the date parameters? I put # # on each end of the parameter but that didn't work. If I hard code the parameter to let's say '2013-10-28' then it displays data.

 $query_params = array( 
':reportdate' => $_POST['workscheduledate']
          );
   $query ="SELECT Concat(x.firstname ,'' ,x.lastname) as Name, sum(x.Slab) as Slab, SUM(x.DriedIn) as DriedIn, Sum(x.Slab) + Sum(x.DriedIn) as Total from (SELECT firstname, lastname, count(1) as Slab, 0 as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 1 AND CreateDate > '#:reportdate#'  group by firstname, lastname union all SELECT firstname, lastname, 0 as Slab, count(1) as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 2 AND CreateDate > '#:reportdate#' group by firstname, lastname) x Group by Concat(x.firstname ,'' ,x.lastname) order by Concat(x.firstname ,'' ,x.lastname) ";
    
$stmt = $db->prepare($query); 
            $result = $stmt->execute($query_params);
$data = $stmt->fetchAll();

Select allOpen in new window

Ok I tried the following, but no data is displayed.

require("common.php"); 
header("Cache-Control: no-cache, must-revalidate");

$date = new DateTime($_POST['workscheduledate']);
$query_params = array( 
':reportdate' => $date->format('Y-m-d')
          );

 var_dump($query_params);

 $query ="SELECT Concat(x.firstname ,'' ,x.lastname) as Name, sum(x.Slab) as Slab, SUM(x.DriedIn) as DriedIn, Sum(x.Slab) + Sum(x.DriedIn) as Total from (SELECT firstname, lastname, count(1) as Slab, 0 as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 1 AND CreateDate > ':reportdate'  group by firstname, lastname union all SELECT firstname, lastname, 0 as Slab, count(1) as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 2 AND CreateDate > ':reportdate' group by firstname, lastname) x Group by Concat(x.firstname ,'' ,x.lastname) order by Concat(x.firstname ,'' ,x.lastname) ";

 try {
   $stmt = $db->prepare($query); 
   $stmt->execute($query_params);
   $data = $stmt->fetchAll();
} catch (Exception $e) {
 var_dump($e->errorInfo);
}

Select allOpen in new window

When I do the following code, it displays the results. But when I remove the hardcoded date and put the parameter, that's when it displays nothing.

$query ='SELECT Concat(x.firstname ," " ,x.lastname) as Name, sum(x.Slab) as Slab, SUM(x.DriedIn) as DriedIn, Sum(x.Slab) + Sum(x.DriedIn) as Total from (SELECT firstname, lastname, count(1) as Slab, 0 as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 1 AND CreateDate > "2013-10-01"  group by firstname, lastname union all SELECT firstname, lastname, 0 as Slab, count(1) as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 2 AND CreateDate > "2013-10-01" group by firstname, lastname) x Group by Concat(x.firstname ," " ,x.lastname) order by Concat(x.firstname ," " ,x.lastname) ';

$stmt = $db->prepare($query); 
   $result = $stmt->execute();
   $data = $stmt->fetchAll();

Select allOpen in new window

I then did the var_dump($query); as Ray suggested and in the WHERE statement it shows ":reportdate" instead of the actual date. The parameter is not being placed in the query.

Try omitting the quote marks around the :reportdate

Article edited to emphasize the importance of omitting the quotes.  
https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/A_11177-PHP-MySQL-Deprecated-as-of-PHP-5-5-0.html

The colon-prefixed strings are placeholders, not quoted variable names.  The are sent to PDO::Prepare() where they are used to match keys in the inputs that are passed to PDOStatement::BindParam() and / or PDOStatement:: Execute()

Thanks zappa. I tried your code and got the following error:

array(1) { [0]=> string(5) "HY093" }
Warning: Invalid argument supplied for foreach() in /home/content/12/11231812/html/GetChartData1.php on line 104

It points to:

 foreach($data as $row) {
      $temp = array();
      $temp[] = array('v' => (string) $row['Name']); 
      $temp[] = array('v' => (int) $row['DriedIn']); 
      $temp[] = array('v' => (int) $row['Slab']); 
      $temp[] = array('v' => (int) $row['Total']);
      $rows[] = array('c' => $temp);
    }

Select allOpen in new window

Which is where I hold the output of the page.

Ok. I tried the code below but I get the following error:

Parse error: syntax error, unexpected ':', expecting ')' in /home/content/12/11231812/html/GetChartData1.php on line 39

Line 39 is:

:reportdate => $date->format('Y-m-d')

Select allOpen in new window

require("common.php"); 
header("Cache-Control: no-cache, must-revalidate");

 $date = new DateTime($_POST['workscheduledate']);

  $query ='SELECT Concat(x.firstname ," " ,x.lastname) as Name, sum(x.Slab) as Slab, SUM(x.DriedIn) as DriedIn, Sum(x.Slab) + Sum(x.DriedIn) as Total from (SELECT firstname, lastname, count(1) as Slab, 0 as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 1 AND CreateDate > :reportdate  group by firstname, lastname union all SELECT firstname, lastname, 0 as Slab, count(1) as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 2 AND CreateDate > :reportdate group by firstname, lastname) x Group by Concat(x.firstname ," " ,x.lastname) order by Concat(x.firstname ," " ,x.lastname) ';
    $query_params = array( 
  :reportdate => $date->format('Y-m-d')
    );
$stmt = $db->prepare($query); 
            $result = $stmt->execute($query_params);
  $data = $stmt->fetchAll();

Select allOpen in new window

I got it to work. It turns out I cannot use the same parameter twice in the same query. So I did:

 $query_params = array(
 ':reportdate1' => $_POST['workscheduledate'],
     ':reportdate2' => $_POST['workscheduledate']

$query ='SELECT Concat(x.firstname ," " ,x.lastname) as Name, sum(x.Slab) as Slab, SUM(x.DriedIn) as DriedIn, Sum(x.Slab) + Sum(x.DriedIn) as Total from (SELECT firstname, lastname, count(1) as Slab, 0 as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 1 AND CreateDate > :reportdate1  group by firstname, lastname union all SELECT firstname, lastname, 0 as Slab, count(1) as DriedIn FROM Users INNER JOIN FieldSuperDataEntry ON Users.userid = FieldSuperDataEntry.UserID Where Type = 2 AND CreateDate > :reportdate2 group by firstname, lastname) x Group by Concat(x.firstname ," " ,x.lastname) order by Concat(x.firstname ," " ,x.lastname) ';
   
 );

Select allOpen in new window

And that made the difference, I now see the data in the output.

Couple of things of note. The reason you get the parse error in this line:

:reportdate => $date->format('Y-m-d')

is because you haven't put the reportdate in quotes. You build the parameter array like this:

$query_params = array(
   'reportdate1' => $date->format('Y-m-d'),
   'reportdate2' => $date->format('Y-m-d')
);

Select allOpen in new window

When you var_dump($query) it will show the place holder (:reportdate). The named parameters don't get replaced - they get sent to the server separately.

I'll close this question since I derailed it from the original question. I'll post another question for the session portion since at least I know the query works when passing parameters.

Thank you all for your help!