SQL statement results into another Frame?

[Chaz]

I have a simple framed document. Frame 1 contains a form users can use to search the database for content. This part is working as planned. But I would like the resulting data to be displayed in Frame 2. How is this done? Can I echo to a target? Or do I need to pass the SQL result to a var, and then use JavaScript to document.write the var to another frame. Or is there a solution so simple my feeblemind cannot comprehend the beauty of it all.

Thanx in advance.
Chaz

PS I think it can be done with the search form in an include statement, but I haven't tried that yet either.

[leatherback]

Hi,

Not sure, but I think you could use the <form> definition tag, and set the target property. The post is then made to the otehr frame, where you do the actual processing?

Not sure -> give it a try!

[Chaz]

thanx.

[mtimdog]

You could echo the $POST information in the html include for the framed page as $GET. Then do the db querying on the framed page.

[TTT]

...or without form...
// frame[0]
<sctipt language="javascript">
function sh() {
window.frames[1].location.href = 'search_result.php?sword='+document.getElementById('sw').value;
}

</script>

<input id="sw" type="text" name="searchword">
<input type="button" name="search" onclick="javascript:sh();">

// frame[1]
<? echo $sword;?>

[mtimdog]

Without js, use php to echo the posted variables into the frame src. like
frameb.php?searchword=<? echo $_POST[searchword];?>

Then use $_GET in that frame to get the variables.

[amrigo]

That´s for mtimdog!

Is not clear to me how do you implement your solution just without javascript.

How do the new value is displayed at the moment it is generated?

or: Php can "listen " if a new value is generated inside a text box and use this value without submiting?

[mtimdog]

form on first frame is submitted to page using $POST (or get if you want, but you have to change $POST below).

In the page (usually called a frameset)'s source, you have code to include the frames.

for frame b you could put

src="frameb?searchword=<?echo $_POST[searchword];?>"

(as long as the frameset is parsed by php)

And then on frame b use $GET[] instead of $POST