SQL Statement not working in php while trying to fetch information from mysql database

Question

I tried everything and I'm losing my mind

    
    function submitItem(){
        textarea = $("#textarea").val();
        status = $("#status").val();
        category = $("#categories").val();
        date = $("#date").val();
            
        var ajaxReq = new XMLHttpRequest();
        ajaxReq.onreadystatechange = function() {
            if (this.readyState == 4 && this.status == 200) {
                document.getElementById("message").innerHTML = this.responseText;
            }
        }
        ajaxReq.open("POST","../php/addItem.php",true);
        ajaxReq.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
        ajaxReq.send("textarea="+textarea+"&category="+category+"&status="+status+"&date="+date);
    }

AJAX REQUEST
<?php
session_start();
require("server.php");
$cnx = new mysqli($server_name,$server_username,$server_password,$db);

$category = $_POST["category"];
$item = $_POST["textarea"];
$date = $_POST["date"];
$status = $_POST["status"];
$userID = $_SESSION["userID"];

$searchForCategory = "SELECT * FROM categories where categoryname = \"".$category."\"";
$result = $cnx->query($searchForStatus);
$row = $result->num_rows;

echo $row;

?>

And I tried everything, when I put and actual name it's working fine. I echo-ed the $category to see if it's working and it's working fine. I have no idea what the error might be

C:\wamp64\www\first\php\addItem.php:17:string ' ass ' (length=5) weird the word ass has the length of 5.. why do you think that happened — Ramy Alayane
– Ramy Alayane, Commented Nov 18, 2017 at 1:16
thankyou so much.. if I knew you i'd hug you, I've been trying for hours — Ramy Alayane
– Ramy Alayane, Commented Nov 18, 2017 at 1:22

Barmar · Accepted Answer · 2017-11-18 01:15:50Z

1

The textarea probably contains some special characters, which you aren't encoding properly. Use $.post, which will encode the data properly.

function submitItem() {
    $.post("../php/addItem.php", {
        textarea: $("#textarea").val(),
        category: $("#categories").val(),
        status: $("#status").val(),
        date: $("#date").val()
    }, function(response) {
        $("#message").html(response);
    });
}

If there's some reason you don't want to do this, use the encodeURIComponent() function around each parameter, e.g.

"textarea=" + encodeURIComponent(textarea) + "&category=" + encodeURIComponent(category) + ...

answered Nov 18, 2017 at 1:15

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

SQL Statement not working in php while trying to fetch information from mysql database

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