[RESOLVED] flash->php->sql->php->flash

tomera

Hi there, i've got a flash based video site, i'm working on integrating a guestbook so users can leave comments about the videos.

this is my communication scheme:
flash->php->sql->php->flash
my write function works great and the user can leave a comment based on unique titleID (video number)
but i'm having a hard time fetching entries related to the current playing video. when i test the movie in flash i can see in the output window that the titleID number is stored in the videoID variable and is passed from flash to php using loadVars so i assume that i've got a problem with my php script. This is the code I'm using in php to fetch data from sql:

$id=mysql_escape_string($_GET['videoID']);
$sql = "SELECT * FROM $table WHERE titleID = $id";

when i test it in a browser i use safari activity window and i get this message:

Error in GuestBook Application: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?videoID=000000000' at line 1

any ideas?

alimadzi

Add this...

echo $sql;

...and let us know what it says.

tomera

ok it's working now thank you, however i fetch zero entries even though i've got comments for the video playing stored in the database. i added this php print code:

print '<PRE style="text-align:left;">'; print_r($sql); die("<P>Script Halted...</P>"); print '</PRE>';

and when i test it online i get this sql quary:

SELECT * FROM guestbook WHERE titleID = '000000000?videoID=000000000' ORDER BY time DESC LIMIT 0, 10Script Halted...

while the sql quary that will yield results should be:
SELECT * FROM guestbook WHERE titleID = '000000000' ORDER BY time DESC LIMIT 0, 10

somehow i pass my variable twice???

this is my flash request:

myEntries = new LoadVars();
myEntries.ref = this
myEntries.videoID = videoID
myEntries.sendAndLoad("GuestBook.php?action=read&r="+random(999)+"&NumLow="+_parent.NumLow+"&videoID="+videoID,myEntries,"GET");

and again my php code:

$id=mysql_escape_string($_GET['videoID']);
$sql = "SELECT * FROM $table WHERE titleID = '$id'";

any ideas?

bpat1434

Huh... that's interesting. Have you tried using two different LoadVars() objects (one to send, and one to receive).

Flash Manual wrote:
var submitListener😮bject = new Object();
submitListener.click = function(evt😮bject) {
var result_lv:LoadVars = new LoadVars();
result_lv.onLoad = function(success:Boolean) {
if (success) {
result_ta.text = result_lv.welcomeMessage;
} else {
result_ta.text = "Error connecting to server.";
}
};
var send_lv:LoadVars = new LoadVars();
send_lv.name = name_ti.text;
send_lv.sendAndLoad("http://www.flash-mx.com/mm/greeting.cfm", result_lv, "POST");
};
submit_button.addEventListener("click", submitListener);

Hope that helps.

tomera

got it to work "POST" instead "GET" in the loadVars object did the trick 🙂

pradeepk

hey...tomera

will u please post the code for uploading and playing the videos?tht would be great help for me....

 [url]http://www.phpbuilder.com/board/showthread.php?t=10342682[/url]

Thanks