json_decode() expects parameter 1 to be a string ,array
given (CHATTING.PHP )
$(document).ready (function(){
var LLAST = 0;
function CHATTING(){
DATACOUNT = { "LLAST" : LLAST };
$.ajax({
type : "POST",
url : "http://localhost/AJAXPHP/JQUERY/CHATTING/CHATTING.PHP",
data : { "COUNTER" : DATACOUNT },
dataType : "json",
success : function(MESSAGES){
LLAST = LLAST + MESSAGES.Length;
var ULNODE = $("<UL>")
for ( COUNTER= 0;COUNTER < MESSAGES.Length; COUNTER++ ){
NAME = MESSAGES[COUNTER].NAME;
MESSAGE= MESSAGES[COUNTER].MESSAGE;
ULNODE.Append ( "<LI>" + NAME + ":" + MESSAGE + "</LI>" )
}
$("#CHATBOX").append ( ULNODE );
}
});
}
window.setInterval( CHATTING, 5000 );
});
##################################################################################
##################################################################################
CHATTING.PHP
<?php
header ('Content-Type : application/json');
$CON = mysql_connect( "localhost","root","");
mysql_select_db( "AJAXDBF", $CON );
$DATA = $_POST['COUNTER'];
$DATADECODE = json_decode( $DATA);
$LAST = $DATADECODE['LLAST'];
$SQLMESSAGE = " SELECT * FROM MESSAGES ";
$SQLMESSAGE.= " WHERE MESSAGEID > " . $LAST;
$FMESSAGE = mysql_query($SQLMESSAGE , $CON );
$MESSAGES = array();
while ( $ROW = mysql_fetch_array( $FMESSAGE)){
$ROW_ARRAY = array(
'NAME' => $ROW["NAME"],
'MESSAGE' => $ROW["MESSAGE"]
);
array_push( $MESSAGES, $ROW_ARRAY );
}
echo ( json_encode ( $MESSAGES ));
?>
