Send text from textbox to PHP using AJAX

Question

I'm trying to send input from a textbox to my PHP script, but it's not working.

When I change (in my PHP file)

$naam = $_POST["naam"];

to

$naam = "Marvin";

It's working!

AJAX/HTML

<td><lable>Naam</lable></td>
<td><input name="serarchName" class="tagert" type="text" id="searchName"/></td>   

    <script>
             $(document).ready(function(){
            $("#searchName").change(function(){
                 var name = $("#searchName").val();
        $.ajax({
            'url': 'ontwikkelpunten.php',
            'method': 'post',
            'data': 
            {
                 naam: $("#searchName").val()
            },
            'dataType': 'json'
        }).done(function(data){
            console.log(data);

                });
            });
        });

PHP

    $naam = $_POST["naam"];

$stmt = $conn ->prepare("SELECT * FROM ontwikkelpunten WHERE naam = "$naam");
$stmt ->execute();
$myarr = array();
while($data = $stmt -> fetch()){
    $myarr[] = $data;
}
echo json_encode($myarr);

$conn ->prepare("SELECT * FROM ontwikkelpunten WHERE naam = "$naam"); should be $conn ->prepare("SELECT * FROM ontwikkelpunten WHERE naam = '" . $naam . "'"); — Nick Parsons
– Nick Parsons, Commented Jul 15, 2018 at 12:22
You need to concatenate the variable $naam to the query as suggested by Nick Parsons.. — Abu Nooh
– Abu Nooh, Commented Jul 15, 2018 at 12:23
@NickParsons No it shouldn't. What's the point in preparing a query when you don't bind any parameters anyway? Besides that, it looks like there are a couple of things wrong with his code. — icecub
– icecub, Commented Jul 15, 2018 at 12:23
@icecub dataType: specifies the type of the response, not the type of the request. — Barmar
– Barmar, Commented Jul 15, 2018 at 13:09

Barmar · Accepted Answer · 2018-07-15 13:11:29Z

3

You're not substituting the parameter into the query correctly.

$naam = $_POST["naam"];

$stmt = $conn ->prepare("SELECT * FROM ontwikkelpunten WHERE naam = :naam");
$stmt->bindParam(":naam", $naam);
$stmt ->execute();
$myarr = array();
while($data = $stmt -> fetch()){
    $myarr[] = $data;
}
echo json_encode($myarr);

answered Jul 15, 2018 at 13:11

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

Send text from textbox to PHP using AJAX

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related