Dates do not POST right- I think

[hkalan2007]

Hello Everyone,

 

I seem to be going no place fast...

 

In a PHP file, I should be taking a date from a jquery datpicker, and get it to a format that mysql will read in the yy-mm-dd format with...

 

if(isset($_POST['choice']))
$choice = (isset($_POST['choice'])) ? date("Y-m-d",strtotime($_POST['choice'])) : date("Y-m-d");

 

Can't seem to get a single inline(embeded) jquery Datepicker date to post right to the PHP and mysql correctly to return data from the table.. My reading has me to understand it should be right, but it is not. Now the datepicker select does have several POST events to PHP that trigger from the single select... data being requsted in PHP by the day, month, and year as well as PHP to use the date to create a highcharts graph in the PHP file to select data for hours of a day, days of a month, and months of a year.

 

The Table is very simple... date, time, power

 

Here is the PHP for dayPower.php that will just collect the sum data for the selected day in the datepicker...

 

<?
if(isset($_POST['choice']))
$choice = (isset($_POST['choice'])) ? date("Y-m-d",strtotime($_POST['choice'])) : date("Y-m-d");
$con = mysql_connect("localhost","root","mackie1604"); 
if (!$con)  { 
die('Could not connect: ' . mysql_error()); 
} 
mysql_select_db("inverters", $con); 

$sql = 'SELECT sum(power) AS power '        
.'FROM feed '       
.'WHERE date = $choice';
$res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error());
$row = mysql_fetch_assoc($res);
echo $row['power']; 
?>

 

Here is the javascript that sends the date and how it post the PHP file.

 

$(document).ready(function () {   
      $('#datepicker').datepicker({onSelect: function(dateText,inst) {
            var myDate = $(this).datepicker('getDate');
            $('#apDiv1').html($.datepicker.formatDate('DD, d', myDate));
            $('#apDiv5').html($.datepicker.formatDate('MM', myDate));
            $('#apDiv7').html($.datepicker.formatDate('yy', myDate));
            $.post('dayPower.php', {choice: inst.val()}, function(data) {
                $('#apDiv2').html(data).show();
            });
            $.post('dayGraph.php', {choice: inst.val()}, function(data) {
                  $('#apDiv4').html().show();
		});
		$.post('monthPower.php', {choice: inst.val()}, function(data) {
                $('#apDiv6').html(data).show();
            });
            $.post('monthGraph', {choice: inst.val()}, function(data) {
                  $('#apDiv9').html().show();
		});
		$.post('yearPower.php', {choice: inst.val()}, function(data) {
                $('#apDiv8').html(data).show();
            });
            $.post('yearGraph', {choice: inst.val()}, function(data) {
                  $('#apDiv10').html().show();
		});
      }});
});

 

What am I doing wrong

 

Alan

 

 

[litebearer]

Have you echoed out your variables to be sure they contain what you expect them to contain?

[hkalan2007]

Hello, I have tried var_dump($_POST), print_r, and only wrote hello in the PHP file and the div is always blank... I an just spinning my tires and going no place at this point... It should work.