AJAX not working, success function is working?

Question

the success function is working but the data is not going in the database

$(document).ready(function() {
    $("#ChatText").keyup(function(e){
        if(e.keyCode == 13) {
            var ChatText = $("#ChatText").val();
            $.ajax({
                type:'POST',
                url:'InsertMessage.php',
                data:{ChatText:ChatText},
                success:function(){
                    $("#ChatText").val("");
                }
            });
        }
    });
    setInterval(function(){
        $("#ChatMessages").load("DisplayMessages.php");
    },15000000);

    $("#ChatMessages").load("DisplayMessages.php");
});

PHP

<?php
session_start();
include "connectToDB.php";

if(isset($_POST['ChatText'])){
    $uid = $_SESSION['userid'];
    $gid = $_SESSION['GameId'];
    $ct = $_POST['ChatText'];
    $sql = "INSERT INTO `chats`( `ChatUserId`, `chatGameId`, `ChatText`) VALUES ('$uid','$gid',$ct);";
    $result = mysqli_query($_db , $sql);
}
?>

i used this php code with a submit button and it worked fine — swapnil raj, May 05 '20 at 14:23
Please update your question instead of posting it in the comments. — Timberman, May 05 '20 at 14:25
yes....i think the php code is working fine cuz I used it with a submit button and it worked fine — swapnil raj, May 05 '20 at 14:29
[obligatory SQL injection warning](https://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php) ... which would actually circumvent the issue you have with not having quotes around the `$ct` variable ... `VALUES ('$uid','$gid',$ct)`. I'm almost certain that, with the correct error debugging, you'd find an SQL error here. Assuming your *ChatText* `` has the name `ChatText` of course. — CD001, May 05 '20 at 14:30

score 0 · Answer 1 · answered May 05 '20 at 15:04

0

one thing u could do to debug is that echo your sql query and see if you get the correct query that works. You can event try out that query in phpMyAdmin and see whats going on. Hard to tell anything without debug.

answered May 05 '20 at 15:04

Jatin Patel

1
1

AJAX not working, success function is working?

1 Answers1