[RESOLVED] $.each function doesn't parse out the AJAX response

jrough

I have an AJAX request in Jquery on my page, http://janisrough.dyndns.biz/todo15.html

below is the php AJAX function for response todosx.php

require_once 'lib/global.inc.php';
ini_set('error_reporting', E_ALL);
error_log("get_todosx error",3,"/var/tmp/Janis-Rough.local.err");

$mysqli = new mysqli($dbhost,$dbuser, $dbpass, $dbname,$dbport);
if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}
echo 'Success... ' . $mysqli->host_info . "\n";


$sql = 'SELECT todo,date,name FROM task WHERE todo IS NOT NULL || > "" ';
$result = $mysqli->query($sql);

if($result = $mysqli->query($sql)){

while($obj = $result->fetch_object())
	{
		printf( $obj->todo, $obj->date, $obj->name);
	}	
$result->close();
}//end if


$mysqli->close();
[\php]

I get a response in the AJAX response header in firebug.
Do you know why I don't get any results back from the AJAX response printed to the page?
They should add to the unordered lists all the Todos.
thanks,
http://janisrough.dyndns.biz/todo15.html

Here is the JQuery AJAX function:
[code]
 $(document).ready(function() {
	$.ajax({
	  url: 'get_todosx.php',
	  dataType : 'json',
	  success: function(data) {
		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)" />';
	    $('.result').html(data);
	    alert('Load was performed.');
	var rows= ' ';
		$.each(data, function(idx,item) { 
		    rows+= list_start + checkbx + item.todo + ', ' + item.name + item.date + delRow +list_end;
			$("ul").append(rows);


	});
  }
});//end document ready

It has to do with the $.each function This got changed, before it was working. I changed the query to MySQLi so the values come back
Something might be wrong with the printf values from the MySQLi object.
Previously it was the vardump of mysql_fetch_assoc function result and worked . The structure of "data" returned to to Jquery AJAX function needs to be tweaked. I don't know if I did the printf line correctly but I need it to work in the $.each function. Instead of the
printf( $obj->todo, $obj->date, $obj->name); should I return the object? then parse it with item.todo , item.name , date.name like before or use the printf or what is item? Is that the array that was returned previously? Thanks,
thanks

Weedpacket

The first argument to [man]printf[/man] should be a format string. Are you missing it, or is it in [font=monospace]$obj->todo[/font]?

jrough

Weedpacket;11009277 wrote:
The first argument to [man]printf[/man] should be a format string. Are you missing it, or is it in [font=monospace]$obj->todo[/font]?

Ok, I format the printf statement and the AJAX data returns.
This is my print string:

printf("%s %s %s \n",$obj->todo, $obj->date, $obj->name);

The data returned is my task list:

laundry 0000-00-00 me
chores 0000-00-00 By kids 
cook dinner 0000-00-00 me

But it is kind of munged together and it still doesn't get displayed on the web page
because something is wrong with the Jquery each statement see below?

Isn't it better to return the entire object to Jquery data and parse it in the each function?

print_r($obj);

The results in firebug:

stdClass Object
(
    [todo] => What needs to be done?
    [date] => 0000-00-00
    [name] => By whom?
)
stdClass Object
(
    [todo] => What needs to be done?
    [date] => 0000-00-00
    [name] => By whom?
)
stdClass Object
(
    [todo] => What needs to be done?
    [date] => 0000-00-00
    [name] => By whom?
)

So I still need to know how to display this with the Jquery .each function?
To display the name, todo item and the date:

$(document).ready(function() {
	$.ajax({
	  url: 'ajax/get_todosx.php',
	  dataType : 'json',
	  success: function(data) {
		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)" />';
	    $('.result').html(data);
	    alert('Load was performed.');
	var rows= ' ';
		$.each(data, function(idx,item) { 

	rows+= list_start + checkbx + item.todo + ', ' + item.name + item.date + delRow +list_end;
		$("ul").append(rows);


	});
  }
});//end document ready

Something is wrong with the item and the index. Should it be i
thanks,

Weedpacket

When posting code, please use the forum markup tags described in the FAQs to mark up your code for readability.

jrough

ok, I fixed it. I think it is an easy answer. I just have to get the right level for the item

jrough

Sorry I think the problem is I don't fully understand the difference between an array and an object. I changed it to fetch_assoc from the query. I thought you needed fetch_object since it is an object. But it seems like the Jquery .each function requires an object or an array not just the rows to display the data.

$sql = 'SELECT todo,date,name FROM task WHERE todo IS NOT NULL || todo > "" ';
$result = $mysqli->query($sql);

if($result = $mysqli->query($sql)) {
$todoArray = array();	
	while($rows = $result->fetch_assoc()) {

$todoArray[] = $rows;
	}	
$result->close();

}//end if

$mysqli->close();
var_dump($todoArray);

Weedpacket

jrough wrote:
Sorry I think the problem is I don't fully understand the difference between an array and an object. I changed it to fetch_assoc from the query. I thought you needed fetch_object since it is an object. But it seems like the Jquery .each function requires an object or an array not just the rows to display the data.

PHP arrays/objects aren't to be confused with jQuery (rather, JavaScript) arrays/objects. Completely different beasts in completely different languages.

Since you're telling your Ajax object to expect JSON-encoded data from the server, have you considered json-encoding the data you send to the client? (Not incidentally, JSON is a mechanism for describing data as something that can be interpreted as a JavaScript object).

jrough

tnx,