PHP Sajax help

**strawberry** · Apr 26 '06, 07:25 AM

Re: PHP Sajax help

$display="SELEC T * FROM Movies ORDER BY id;";

**Robin** · Apr 26 '06, 09:35 AM

Re: PHP Sajax help

The ; in the mysql_query isn't needed but in your while loop you have:

return print"<table...

so only the first id will be printed.

Robin

**Clovis818** · Apr 26 '06, 10:15 PM

Re: PHP Sajax help

the thing is nothing is printed at all.

Robin wrote:[color=blue]
> The ; in the mysql_query isn't needed but in your while loop you have:
>
> return print"<table...
>
> so only the first id will be printed.
>
> Robin[/color]

**Jerry Stuckle** · Apr 27 '06, 04:05 AM

Re: PHP Sajax help

Clovis818 wrote:[color=blue]
> the thing is nothing is printed at all.
>
> Robin wrote:
>[color=green]
>>The ; in the mysql_query isn't needed but in your while loop you have:
>>
>>return print"<table...
>>
>>so only the first id will be printed.
>>
>>Robin[/color]
>
>[/color]

But what's your document source look like?

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

**funkychicken818@gmail.com** · Apr 27 '06, 04:15 AM

Re: PHP Sajax help

the source looks like this

<html>
<head>
<title>MySiteSu cks Movies</title>
<script>

// remote scripting library
// (c) copyright 2005 modernmethod, inc
var sajax_debug_mod e = false;
var sajax_request_t ype = "POST";
var sajax_target_id = "";
var sajax_failure_r edirect = "";

function sajax_debug(tex t) {
if (sajax_debug_mo de)
alert(text);
}

function sajax_init_obje ct() {
sajax_debug("sa jax_init_object () called..")

var A;

var msxmlhttp = new Array(
'Msxml2.XMLHTTP .5.0',
'Msxml2.XMLHTTP .4.0',
'Msxml2.XMLHTTP .3.0',
'Msxml2.XMLHTTP ',
'Microsoft.XMLH TTP');
for (var i = 0; i < msxmlhttp.lengt h; i++) {
try {
A = new ActiveXObject(m sxmlhttp[i]);
} catch (e) {
A = null;
}
}

if(!A && typeof XMLHttpRequest != "undefined" )
A = new XMLHttpRequest( );
if (!A)
sajax_debug("Co uld not create connection object.");
return A;
}

var sajax_requests = new Array();

function sajax_cancel() {
for (var i = 0; i < sajax_requests. length; i++)
sajax_requests[i].abort();
}

function sajax_do_call(f unc_name, args) {
var i, x, n;
var uri;
var post_data;
var target_id;

sajax_debug("in sajax_do_call() .." + sajax_request_t ype + "/" +
sajax_target_id );
target_id = sajax_target_id ;
if (typeof(sajax_r equest_type) == "undefined" || sajax_request_t ype
== "")
sajax_request_t ype = "GET";

uri = "/Movies/ajax_index.php" ;
if (sajax_request_ type == "GET") {

if (uri.indexOf("? ") == -1)
uri += "?rs=" + escape(func_nam e);
else
uri += "&rs=" + escape(func_nam e);
uri += "&rst=" + escape(sajax_ta rget_id);
uri += "&rsrnd=" + new Date().getTime( );

for (i = 0; i < args.length-1; i++)
uri += "&rsargs[]=" + escape(args[i]);

post_data = null;
}
else if (sajax_request_ type == "POST") {
post_data = "rs=" + escape(func_nam e);
post_data += "&rst=" + escape(sajax_ta rget_id);
post_data += "&rsrnd=" + new Date().getTime( );

for (i = 0; i < args.length-1; i++)
post_data = post_data + "&rsargs[]=" + escape(args[i]);
}
else {
alert("Illegal request type: " + sajax_request_t ype);
}

x = sajax_init_obje ct();
if (x == null) {
if (sajax_failure_ redirect != "") {
location.href = sajax_failure_r edirect;
return false;
} else {
sajax_debug("NU LL sajax object for user agent:\n" +
navigator.userA gent);
return false;
}
} else {
x.open(sajax_re quest_type, uri, true);
// window.open(uri );

sajax_requests[sajax_requests. length] = x;

if (sajax_request_ type == "POST") {
x.setRequestHea der("Method", "POST " + uri + " HTTP/1.1");
x.setRequestHea der("Content-Type",
"applicatio n/x-www-form-urlencoded");
}

x.onreadystatec hange = function() {
if (x.readyState != 4)
return;

sajax_debug("re ceived " + x.responseText) ;

var status;
var data;
var txt = x.responseText. replace(/^\s*|\s*$/g,"");
status = txt.charAt(0);
data = txt.substring(2 );

if (status == "") {
// let's just assume this is a pre-response bailout and let it
slide for now
} else if (status == "-")
alert("Error: " + data);
else {
if (target_id != "")
document.getEle mentById(target _id).innerHTML = eval(data);
else {
try {
var callback;
var extra_data = false;
if (typeof args[args.length-1] == "object") {
callback = args[args.length-1].callback;
extra_data = args[args.length-1].extra_data;
} else {
callback = args[args.length-1];
}
callback(eval(d ata), extra_data);
} catch (e) {
sajax_debug("Ca ught error " + e + ": Could not eval " + data );
}
}
}
}
}

sajax_debug(fun c_name + " uri = " + uri + "/post = " + post_data);
x.send(post_dat a);
sajax_debug(fun c_name + " waiting..");
delete x;
return true;
}

// wrapper for show_mysql
function x_show_mysql() {
sajax_do_call(" show_mysql",
x_show_mysql.ar guments);
}

function show_me(date_se rver) {
document.getEle mentById("date_ div").innerHTM L =
date_server;
}

function mysql_display() {

//put the return of php's show_now func
//to the javascript show_me func as a parameter
x_show_mysql(sh ow_me);
}
</script>
</head>

<body onLoad="mysql_d isplay();">
<table id="date_div">L oading....</table>
</body>
</html>

Jerry Stuckle wrote:[color=blue]
> Clovis818 wrote:[color=green]
> > the thing is nothing is printed at all.
> >
> > Robin wrote:
> >[color=darkred]
> >>The ; in the mysql_query isn't needed but in your while loop you have:
> >>
> >>return print"<table...
> >>
> >>so only the first id will be printed.
> >>
> >>Robin[/color]
> >
> >[/color]
>
> But what's your document source look like?
>
> --
> =============== ===
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attgl obal.net
> =============== ===[/color]

**Jerry Stuckle** · Apr 27 '06, 12:25 PM

Re: PHP Sajax help

funkychicken818 @gmail.com wrote:[color=blue]
> the source looks like this[/color]
<stuff snipped>

Well, a table with no rows or cells is invalid - you need at least <tr><td> and
</td></tr> around the "Loading... ".

Other than that - you have nothing in the body, and won't if your javascript
fails. Unfortunately, its not something I can test here as I don't have your
functions.

First thing I think you need to do is verify your Javascript is working and
calling the PHP properly.

And, of course, you do realize your page will be 100% unusable by anyone who has
javascript disabled.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

**Robin** · Apr 27 '06, 02:25 PM

Re: PHP Sajax help

Jerry Stuckle wrote:[color=blue]
> First thing I think you need to do is verify your Javascript is working
> and calling the PHP properly.[/color]

Use firefox and its javascript console and dom inspector to check the
javascript. Turning on sajax_debug_mod e might also help.

Also creating a dummy page with a form that calls sajax will se what PHP
is returning, e.g. (untested)

<html>
<body>
<form name='test' action='/Movies/ajax_index.php' method='post'>
<input type='text' name='rs' value='show_mys ql' />
<input type='submit' value='Go' />
</form>
</body>
</html>

Robin

PHP Sajax help

PHP Sajax help

Comment

Comment

Comment

Comment

Comment

Comment

Comment