PHP / Ajax code not working

Question

I can't figure out why this isn't working! The idea is the code is supposed to run a php script on another page that will check for changes in the DB state. Then it will return a string that will update the CURRENT page.

(External) PHP:

$QgetShift = mysql_query("SELECT * FROM shifts");

$num = mysql_num_rows($QgetShift);

if(isset($_POST['ajax'])) {
    if(isset($_SESSION['data'])) {

        $data = $_SESSION['data'];      
        if($data != $num){
            $_SESSION['data'] = $num;
            echo "WORKING";
        } else {
            echo "NOT WORKING";
        }
    } else {
        $_SESSION['data'] = $num;
        echo "started";
    }
}

HTML:

<button type="button" id="clickMe">Click Here</button> <br />
                <div id="data"></div>

Javascript:

$('#clickMe').click(function(){
  $.ajax({
    method: 'post',
    url: 'function.php',
    data: {
      'ajax': true
    },
    success: function(data) {
      $('#data').text(data);
    }
  });
});

Can anyone tell me if there is an error somewhere?

By not working, do you mean that you're getting an output of "NOT WORKING", or that the script is failing to run? — user1637579
– user1637579, Commented Aug 12, 2013 at 18:17
May be session_start() could be a problem you have to put this on the top of the file — M Khalid Junaid
– M Khalid Junaid, Commented Aug 12, 2013 at 18:24
For one thing, you success function is changing a DIV. It should read: $('#data').html(data); — cssyphus
– cssyphus, Commented Aug 12, 2013 at 18:29

cssyphus · Accepted Answer · 2013-08-12 18:30:37Z

1

This line in your AJAX success function is incorrect ($('#data').text(data);): Try instead:

success: function(data) {
    $('#data').html(data);
}

Another thing to try is to add this to the top of your function.php file (just for one test):

<?php
    echo 'Received OK from PHP';
    die();

answered Aug 12, 2013 at 18:30

cssyphus

40.4k20 gold badges104 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Axschech Over a year ago

Weird... it's not pulling in that string. Any ideas?

Axschech · Accepted Answer · 2013-08-12 19:02:55Z

0

Wow I'm dumb, the link was wrong :/

answered Aug 12, 2013 at 19:02

Axschech

2951 gold badge2 silver badges14 bronze badges

1 Comment

cssyphus Over a year ago

If any of the answers helped you to find the solution yourself, please upvote and select a correct answer. Otherwise, after the waiting period, please select your own answer as correct.

Collectives™ on Stack Overflow

PHP / Ajax code not working

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related