ajax jquery errors on json return value from php script

Question

I'm having problems with this ajax/jquery programming. I've tried many different things but nothing has worked.

Ajax posts selItem to ajaxsql.php, this works! The sql query in ajaxsql.php works, cause it outputs this if i call the script directly in the browser: [{"forumname":"SDE forum","user":"michael","txt":"Jeg hedder Michael!"}]

The problem is that the ajax function shows an alert box with Error[object Object]

forum.php script:

<script type="text/javascript">

function ForumChat(selItem) {


 $.ajax({
        type: "POST",
        url: 'ajaxsql.php',
        data: { selectedItem : selItem.value },
        dataType: "json",
        success: function(data) {
            alert(data);
            $('#txtarea').html(data);
        },

        error: function(data) {
            alert('Error' + data);
        }
    });


}
</script>

ajaxsql.php script:

<?php
if(!isset($_SESSION))
{
session_start();
}
include('class.php');

//$sel = $_POST['selectedItem'];
$sel = "SDE forum";


$sql = " SELECT * FROM forum WHERE user = '".$_SESSION['currentuser']."' AND forumname = '".$sel."' ";


    $result = mysqli_query($_SESSION['con'], $sql);

        while($row = mysqli_fetch_array($result)) 
        {       
            $forumname = $row['forumname'];
            $user = $row['user'];
            $txt = $row['text'];

            $return[] = array("forumname" =>$forumname, "user" =>$user, "txt" =>$txt);

        }

        echo json_encode($return);

?>

this is because ajaxsql.php is returning an object not a string .. what you can do is use .each — Demonyowh
– Demonyowh, Commented May 12, 2017 at 6:50

Demonyowh · Accepted Answer · 2017-05-12 07:05:11Z

1

because ajaxsql.php returns object ..

what you can do in your ajax is

success: function(response) {
     $('#txtarea').html('');
     $.each(response.data, function(){
         console.log(this);
         $('#txtarea').append(data);
     });
},

edited May 12, 2017 at 7:05

answered May 12, 2017 at 6:51

Demonyowh

1,6821 gold badge9 silver badges14 bronze badges

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

2 Comments

user3888775 Over a year ago

why response.data ?

Demonyowh Over a year ago

because we used response as the response variable of ajaxsql.php .. you can use data but as you can see , its not good to read data.data ..

Collectives™ on Stack Overflow

ajax jquery errors on json return value from php script

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