Post data from javascript to php file using ajax doesn't work

Question

When I tried to used ajax to post data from javascript file to php file, there was nothing displayed on php file after using

$_POST['userinput']

Here is the javascript file:

 searchBox.addListener('places_changed', function() {
        var places = searchBox.getPlaces();
        userinput = places[0].name.toString();  // Get user input from search box

        // Pass data to userinput.php via ajax
        $.ajax({
            url: 'userinput.php',
            data: {userinput : userinput},
            type: "POST",
            success: function (result) {
                alert(JSON.stringify(result));
            }
        });

    });

php file:

    if (isset($_POST)) {
        $servername = "localhost";
        $username = "XXXXXXX";
        $password = "XXXXXXXXX";
        $dbname = "CALIFORNIA";

        $city = $_POST['userinput']; // Nothing is posted here

        // Create connection
        $conn = new PDO("mysql:host=localhost;dbname=$dbname", $username, $password);
        $conn->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, 1);


        $sql = $conn->prepare("SELECT State FROM  CITY as C WHERE   C.City_name=$city");
        $sql->execute();

        $result = $sql->fetchAll();
        $json = json_encode($result);
        echo $json;
    }

I was able to connect to the mysql database. However, there was no data posted from javascript file to php. I'm not sure what to do from this point. the value $city print out nothing. On the client side it printed out an empty object.

alert(userinput); and check what it returns . it will alert your search text input or not ? — Manthan Dave
– Manthan Dave, Commented Oct 24, 2016 at 5:57
@Anant quotes or no quotes do not change anything in this case. Quotes are useful only when setting a key name that is note a valid JS identifier (Ex: not-valid, because of the dash) — user2345
– user2345, Commented Oct 24, 2016 at 6:01
var places = searchBox.getPlaces(); userinput = places[0].name.toString(); varify userinput variable has proper value or not — Anant Waykar
– Anant Waykar, Commented Oct 24, 2016 at 6:02

Nitin Pund · Accepted Answer · 2016-10-24 06:37:49Z

1

in your ajax function try setting dataType property

$.ajax({
            url: 'userinput.php',
            data: {'userinput' : 'userinput'},
            type: "POST",
            dataType: "text", // add this property
            success: function (result) {
                alert(JSON.stringify(result));
            }
        });

answered Oct 24, 2016 at 6:37

Nitin Pund

1,0922 gold badges10 silver badges24 bronze badges

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

2 Comments

tuyenle Over a year ago

it turn out to be that PHP does not allow RAW_POST anymore. the code is fine though

Nitin Pund Over a year ago

this may help you. php.net/manual/en/reserved.variables.httprawpostdata.php

Collectives™ on Stack Overflow

Post data from javascript to php file using ajax doesn't work

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related