Using AJAX?

troy_odyssey34 · 04-18-2014, 01:03 AM

How do I make ajax return multiple rows from a mysql table. So far my query works but I can only get it to return one row.

What I have right now is this for my PHP:

Code:
<?php
session_start();
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db("quackbook") or die(mysql_error());

if(isset($_SESSION["user"]) === FALSE){
	header("location: index.php");
}

$find = "SELECT Firstname,Post FROM wall LEFT JOIN info ON info.Username=wall.Username";

$arrow = mysql_query($find);

$array = array();

$i = 0;
$j=0;
while($fire = mysql_fetch_array($arrow)){

$array[$i] = $fire;

$i+1;
}

echo json_encode($array[$i]);

?>



And this is my JS:


var post,dispost;
var ready;

window.onload=function(){
	hunt();
	setInterval(change,500);
};

function change(){
	
	dispost.innerHTML= post;
	
};

function hunt(){
	
	xmlhttp = new XMLHttpRequest();
	xmlhttp.open("GET","Classes/class.wall.php",true);
	xmlhttp.send();
	
	xmlhttp.onreadystatechange=function(){
		
		if(xmlhttp.readyState==4 && xmlhttp.status==200){
			ready= JSON.parse(xmlhttp.responseText);
			begin();
		}
		
	};
	
};

function begin(){
	post=ready["Firstname"]+" posted: "+ready["Post"]+"<br><br>";
	dispost=document.getElementById("dispost");
};

troy_odyssey34 · 04-18-2014, 01:03 AM

How do I make ajax return multiple rows from a mysql table. So far my query works but I can only get it to return one row.

What I have right now is this for my PHP:

Code:
<?php
session_start();
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db("quackbook") or die(mysql_error());

if(isset($_SESSION["user"]) === FALSE){
	header("location: index.php");
}

$find = "SELECT Firstname,Post FROM wall LEFT JOIN info ON info.Username=wall.Username";

$arrow = mysql_query($find);

$array = array();

$i = 0;
$j=0;
while($fire = mysql_fetch_array($arrow)){

$array[$i] = $fire;

$i+1;
}

echo json_encode($array[$i]);

?>



And this is my JS:


var post,dispost;
var ready;

window.onload=function(){
	hunt();
	setInterval(change,500);
};

function change(){
	
	dispost.innerHTML= post;
	
};

function hunt(){
	
	xmlhttp = new XMLHttpRequest();
	xmlhttp.open("GET","Classes/class.wall.php",true);
	xmlhttp.send();
	
	xmlhttp.onreadystatechange=function(){
		
		if(xmlhttp.readyState==4 && xmlhttp.status==200){
			ready= JSON.parse(xmlhttp.responseText);
			begin();
		}
		
	};
	
};

function begin(){
	post=ready["Firstname"]+" posted: "+ready["Post"]+"<br><br>";
	dispost=document.getElementById("dispost");
};

troy_odyssey34 · 04-18-2014, 01:03 AM

How do I make ajax return multiple rows from a mysql table. So far my query works but I can only get it to return one row.

What I have right now is this for my PHP:

Code:
<?php
session_start();
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db("quackbook") or die(mysql_error());

if(isset($_SESSION["user"]) === FALSE){
	header("location: index.php");
}

$find = "SELECT Firstname,Post FROM wall LEFT JOIN info ON info.Username=wall.Username";

$arrow = mysql_query($find);

$array = array();

$i = 0;
$j=0;
while($fire = mysql_fetch_array($arrow)){

$array[$i] = $fire;

$i+1;
}

echo json_encode($array[$i]);

?>



And this is my JS:


var post,dispost;
var ready;

window.onload=function(){
	hunt();
	setInterval(change,500);
};

function change(){
	
	dispost.innerHTML= post;
	
};

function hunt(){
	
	xmlhttp = new XMLHttpRequest();
	xmlhttp.open("GET","Classes/class.wall.php",true);
	xmlhttp.send();
	
	xmlhttp.onreadystatechange=function(){
		
		if(xmlhttp.readyState==4 && xmlhttp.status==200){
			ready= JSON.parse(xmlhttp.responseText);
			begin();
		}
		
	};
	
};

function begin(){
	post=ready["Firstname"]+" posted: "+ready["Post"]+"<br><br>";
	dispost=document.getElementById("dispost");
};

Ex094 · 04-18-2014, 06:54 AM

This might help you http://stackoverflow.com/questions/96140...-with-ajax

Ex094 · 04-18-2014, 06:54 AM

This might help you http://stackoverflow.com/questions/96140...-with-ajax

Ex094 · 04-18-2014, 06:54 AM

This might help you http://stackoverflow.com/questions/96140...-with-ajax

zomgwtfbbq · 04-18-2014, 10:01 PM

It's better to post your code. If we can't check how you handle the data that was transferred it's just guessing. Did you use firebug to check what data is returned?

zomgwtfbbq · 04-18-2014, 10:01 PM

It's better to post your code. If we can't check how you handle the data that was transferred it's just guessing. Did you use firebug to check what data is returned?

zomgwtfbbq · 04-18-2014, 10:01 PM

It's better to post your code. If we can't check how you handle the data that was transferred it's just guessing. Did you use firebug to check what data is returned?

troy_odyssey34 · 04-20-2014, 07:38 PM

Here is the code:

Code:
<?php
session_start();
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db("quackbook") or die(mysql_error());

if(isset($_SESSION["user"]) === FALSE){
	header("location: index.php");
}

$find = "SELECT Firstname,Post FROM wall LEFT JOIN info ON info.Username=wall.Username";

$arrow = mysql_query($find);

$array = array();

$i = 0;
$j=0;
while($fire = mysql_fetch_array($arrow)){

$array[$i] = $fire;

$i+1;
}

echo json_encode($array[$i]);

?>

Using AJAX?
Author Message