468,315 Members | 1,404 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,315 developers. It's quick & easy.

PHP Sajax help

what wrong with my script?

<?php
require("connect.php");
require("Sajax.php");
function show_mysql() {
// mysql query
$display="SELECT * FROM Movies ORDER BY id";
$mysql_result=mysql_query($display);
while ($row=mysql_fetch_array($mysql_result))
{
$id=$row["id"];
$Name=$row["Name"];
$Link=$row["Link"];
$Description=$row["Description"];
$Image=$row["Image"];
$Type=$row["Type"];
$ang_rate=$row["ang_rate"];
return print"<table align=\"center\">
<tr>
<td><div align=\"center\">
<table width=\"376\" background=\"/images/bg.jpg\" align=\"center\">
<tr>
<td width=\"98\" rowspan=\"0\"><img src=\"$Image\" width=\"65\"
height=\"65\"><br><span class=\"style3\">$Name</span></td>
<td height=\"91\" colspan=\"3\"><span
class=\"style1\">$Description</span></td></tr>
<tr>
<td width=\"130\"><div align=\"left\"><a
href=\"play_movie.php?row_id=$id\"><span class=\"style1\">Play
Game</span></a></div><div align=\"left\"><a
href=\"comment.php?row_id=$id\"><span class=\"style1\">Add
Comment</span></a></div></td>
<td width=\"264\"><form action=\"rating.php\" method=\"GET\">
<input type=\"hidden\" value=\"$id\" name=\"id\">
<select
name=\"rating\">
<option

selected>Rate Movie</option>

<option
value=\"1\">1</option>
<option

value=\"2\">2</option>
<option

value=\"3\">3</option>
<option

value=\"4\">4</option>
<option

value=\"5\">5</option>
<option

value=\"6\">6</option>
<option

value=\"7\">7</option>
<option

value=\"8\">8</option>
<option

value=\"9\">9</option>
<option

value=\"10\">10</option>
</select>

<input type=\"submit\"
value=\"Go\">
</form></td>
<td width=\"0\" height=\"28\"><div align=\"center\"><span
class=\"style1\">Rating: $ang_rate</span></div></td></tr>
</table></div></div></td></tr></table>";

}
}
//starting SAJAX stuff
$sajax_request_type = "POST";
sajax_init();
sajax_export("show_mysql");
sajax_handle_client_request();
?>
<html>
<head>
<title>MySiteSucks Movies</title>
<script>
<?
sajax_show_javascript();
?>
function show_me(date_server) {
document.getElementById("date_div").innerHTML =
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(show_me);
}
</script>
</head>
<body onLoad="mysql_display();">
<table id="date_div">Loading....</table>
</body>
</html>

Apr 26 '06 #1
7 4646
$display="SELECT * FROM Movies ORDER BY id;";

Apr 26 '06 #2
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
Apr 26 '06 #3
the thing is nothing is printed at all.

Robin wrote:
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


Apr 26 '06 #4
Clovis818 wrote:
the thing is nothing is printed at all.

Robin wrote:
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



But what's your document source look like?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Apr 27 '06 #5
the source looks like this

<html>
<head>
<title>MySiteSucks Movies</title>
<script>

// remote scripting library
// (c) copyright 2005 modernmethod, inc
var sajax_debug_mode = false;
var sajax_request_type = "POST";
var sajax_target_id = "";
var sajax_failure_redirect = "";

function sajax_debug(text) {
if (sajax_debug_mode)
alert(text);
}

function sajax_init_object() {
sajax_debug("sajax_init_object() called..")

var A;

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

if(!A && typeof XMLHttpRequest != "undefined")
A = new XMLHttpRequest();
if (!A)
sajax_debug("Could 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(func_name, args) {
var i, x, n;
var uri;
var post_data;
var target_id;

sajax_debug("in sajax_do_call().." + sajax_request_type + "/" +
sajax_target_id);
target_id = sajax_target_id;
if (typeof(sajax_request_type) == "undefined" || sajax_request_type
== "")
sajax_request_type = "GET";

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

if (uri.indexOf("?") == -1)
uri += "?rs=" + escape(func_name);
else
uri += "&rs=" + escape(func_name);
uri += "&rst=" + escape(sajax_target_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_name);
post_data += "&rst=" + escape(sajax_target_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_type);
}

x = sajax_init_object();
if (x == null) {
if (sajax_failure_redirect != "") {
location.href = sajax_failure_redirect;
return false;
} else {
sajax_debug("NULL sajax object for user agent:\n" +
navigator.userAgent);
return false;
}
} else {
x.open(sajax_request_type, uri, true);
// window.open(uri);

sajax_requests[sajax_requests.length] = x;

if (sajax_request_type == "POST") {
x.setRequestHeader("Method", "POST " + uri + " HTTP/1.1");
x.setRequestHeader("Content-Type",
"application/x-www-form-urlencoded");
}

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

sajax_debug("received " + 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.getElementById(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(data), extra_data);
} catch (e) {
sajax_debug("Caught error " + e + ": Could not eval " + data );
}
}
}
}
}

sajax_debug(func_name + " uri = " + uri + "/post = " + post_data);
x.send(post_data);
sajax_debug(func_name + " waiting..");
delete x;
return true;
}
// wrapper for show_mysql
function x_show_mysql() {
sajax_do_call("show_mysql",
x_show_mysql.arguments);
}

function show_me(date_server) {
document.getElementById("date_div").innerHTML =
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(show_me);
}
</script>
</head>

<body onLoad="mysql_display();">
<table id="date_div">Loading....</table>
</body>
</html>

Jerry Stuckle wrote:
Clovis818 wrote:
the thing is nothing is printed at all.

Robin wrote:
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



But what's your document source look like?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================


Apr 27 '06 #6
fu*************@gmail.com wrote:
the source looks like this

<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.
js*******@attglobal.net
==================
Apr 27 '06 #7
Jerry Stuckle wrote:
First thing I think you need to do is verify your Javascript is working
and calling the PHP properly.


Use firefox and its javascript console and dom inspector to check the
javascript. Turning on sajax_debug_mode 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_mysql' />
<input type='submit' value='Go' />
</form>
</body>
</html>

Robin
Apr 27 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by wukexin | last post: by
3 posts views Thread by Colin J. Williams | last post: by
7 posts views Thread by Corepaul | last post: by
5 posts views Thread by Steve | last post: by
reply views Thread by Clovis818 | last post: by
reply views Thread by funkychicken818 | last post: by
reply views Thread by The Godfather | last post: by
banning
5 posts views Thread by banning | last post: by
1 post views Thread by littlecoder | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.