[RESOLVED] get wrong values from JQuery .each

jrough

I don't know how to get the right value from Jquery .each? There are 3 name/value pairs: todo, date, user.
I just want the"todo" collection listed, for every row, but what I am getting is the first row values (todo, date, user)instead of a list of only todo values(do laundry, do shopping, ...). I don't think I need a nested .each but I want it to loop through each row in the object instead of loop through the first row values.

I found the json object came back from the json encoded ajax response as an array and to get rid of the brackets I had to do response[0]

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 respObj = response[0];
$.each(response[0], function(i,value) {

	var row = list_start.concat(checkbx ,value, delRow, list_end);
	alert(row);
	$("ul").append(row);
        });  
        }//end each

     });//success end/ ajax end

thanks,

Bonesnap

Can you also post the PHP that's generating the response?

jrough

Bonesnap;11005879 wrote:
Can you also post the PHP that's generating the response?

require("db.php");
//ini_set("max_execution_time",'800');
#error_reporting(E_ALL | E_NOTICE);
error_log("form_handler error",3,"/var/tmp/Janis-Rough.local.err");

//$arry= json_decode($_POST,true);
$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,date,name FROM task WHERE todo > "" ';
$result2 = mysql_query($sql2);
if (mysql_fetch_assoc($result2) == 0) {
    echo "There is no database connection.  Please try again later.";
    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;
}
/*$result_query = mysql_fetch_assoc($result2);	$json_array = json_encode($result_query);
*/	echo $json_array;

print (json_encode($arr_result));

jrough

This is as close as I can come to what I want in the php form_handler page.

$sql2 = 'SELECT todo,date,name FROM task WHERE todo > "" ';
$result2 = mysql_query($sql2);


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

print_r(array_values($arr_result['todo']));

This is the error:
<b>Warning</b>: array_values() [<a href='function.array-values'>function.array-values</a>]: The argument should be an array in <b>/Library/WebServer/Documents/form_handler.php</b> on line <b>42</b><br />
I want the 'todo' values, the 1st result in the row for each row.

I also tried it as a foreach:

foreach ($arr_result as $key => $value){
if $key = todo{ print $value};
}};

I also tried it this way:
foreach ($arr_result as $key => $value){

if($array_values($key) ==='todo'){ print $value};
};// end foreach
As I said I just need 'todo' value for each row in the SQL query. thanks,
thanks,

jrough

I tried also array_map but the message says you cannot do this in my version of PHP? All I want is to get the first entry from all subarrays. Is this right if I had the right PHP version? and if so how can I fix it for my version?

$sql2 = 'SELECT todo,date,name FROM task WHERE todo > "" ';
$result2 = mysql_query($sql2);

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

foreach ($arr_result as $value){
$arr_result = array_map(function($value){ return $value[0];}, $arr_result);
echo $arr;}

jrough

ok I finally got the answe.
you con't use response[0] because you get only the first row values
you have to use item.todo, item.name, item.date
This works to get all the subarrays.

var rows= ' ';
$.each(response, function(idx,item) {
rows+= list_start + checkbx + item.todo + ', ' + item.name + item.date + delRow +list_end;
$("ul").append(rows);

});

}