[RESOLVED] JQuery response data gets only one row not all the rows

jrough

My page worked when I only get the last row returned from the AJAX response but when I add the array brackets $arrayresult2[] to the form_handler.php page below I get all the rows from the database back from the JSON_encode, otherwise I only get the new input line from the form.
http://janisrough.dyndns.biz/todo9.html
or
http://janisrough.dyndns.biz/form_handler.php

[{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"What needs to be done?"},{"todo":"l"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"What needs to be done?"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"},{"todo":"laundry"}]
form_handler.php

require("db.php");
error_log("form_handler error",3,"/var/tmp/Janis-Rough.local.err");

$task =$_POST['task_todo'];
$date = $_POST['due_date'];
$name = $_POST['todo_name'];

$sql = "INSERT INTO taskos.task(todo, date, name) values('$task','$date','$name') ";
$result = mysql_query($sql);
    if ( !$result ) {die(  mysql_error() .  $sql);}

$sql2 = 'SELECT todo FROM task WHERE todo > "" ';
$result2 = mysql_query($sql2);
if (mysql_fetch_assoc($result2) == 0) {
    echo "All tasks have been completed";
    exit;
}
$arr_result = array();

if ( !$result2 ) {die("Invalid query" . mysql_error() . $sql );}
while($result_of_result2 = mysql_fetch_assoc($result2))
{
    $arr_result[] = $result_of_result2;          ********** added brackets
}

print (json_encode($arr_result[]));                  ****** and here

Is it supposed to be json_encoded on the last line? The datatype is JSON? I get the same error if I use var_dump($arr_result[]);
but the error I'm getting on the form_handler.php is " 
Fatal error: Cannot use [] for reading in /Library/WebServer/Documents/form_handler.php on line 35 " so it doesn't like my brackets. I guess I'm confused about how to get all the rows from the associative array into the response but as I said if I take out the brackets I only get one row.

I know I need to do something like this in Jquery to print out each undered list row but before I do I want to get rid of the error message so I don't have the fatal error.
$.each(response, function() {
$.each(this, function(key, value){
alert(key + " --> " + value);
});
});

thanks,

vivek151189

use something like

$result_query = mysql_fetch_assoc($result2)
        $json_array = json_encode($result_query);
        echo $json_array;

no need to use the while loop if the stuff can be done easily

Derokorian

This line:

print (json_encode($arr_result[]));

Is invalid because empty brackets are used to add an item to the next index of an array, not for retrieving something from the array. Simply remove those so it looks like:

print (json_encode($arr_result));

Bonesnap

I'm a little confused as to what you're trying to accomplish. If you want all the results you're going to need to use a loop to retrieve each row. What are you trying to display?

jrough

thanks for the explanation on the brackets. I should know that it is only used for inputing a value into the array.

jrough

What I want is for all the input todo items to be displayed . I have a lot of repeating dummy data but I want each row to display on the page. The first sql query on the form_handler does the current input row. The second sql query displays all the todo records that have been previously inserted. I took off the json_encode($arr_result[]) brackets which was wrong as suggested above. So now I get the json array. Is it an array or an object? It enclosed in brackets. Is that the json_encode? I don't even see what is encoded. In any case, I am getting the result in the AJAX response as undefined but this result on the form_hander.php page. It does get the response in firebug as well.

But what I ultimately need to do is something like this in the jquery. The problem I'm having is currently I'm only getting the response.todo value. I concat the string I want to display on the web page. I need to fit the response.todo in the $.each function instead of the key and value.

Thanks,

 
function submitForm() {			

$.ajax({
type: 'POST',		 
url:  'form_handler.php', 
dataType : 'json' ,
data: $('#taskForm').serialize(),			


success:  function(response){
var task = response.todo;
var list_start ='<li "class" = "todo-list" >';
var list_end ='</li>';
var checkbx ='<input type="checkbox" id="task" checked="false" />';
var delRow ='<input type="button" value="Delete" class="btnDelete"  onclick="deleteRow(this)" />';

var row= list_start.concat(checkbx ,task, delRow, list_end);

$.each(response, function() { 
$.each(this, function(key, value){
alert(key + " --> " + value); 
});
});
    $("ul").append(
     row); 	                                                                    

                          }               

                      });                       

   return false;
}//end submitForm