DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- PHP (http://www.daniweb.com/forums/forum17.html)

- - Redirect Output (http://www.daniweb.com/forums/thread120123.html)

still_learning

Apr 20th, 2008 10:05 pm

Redirect Output

Hey guys, I am just learning php and mysql for the first time and I would really appreciate your help. I have created a search engine for my website which searches through a database and then returns the correct results. All of that is working great, EXCEPT for the fact that I want the results to be printed on a new page. I know how to redirect to a new page by uing header(Location: url), BUT when I redirect to the new page, it will not print out the results on the new page. Instead it is printing an error (Warning: mysql_fetch_array(): supplied argument is not a valid MySQL), which tells me that it is not reading any of the variables from the previous page. Can anyone give me any advice for how to perform a search on one page, and then redirec the output to a new page?? Thanks a lot guys.

kkeith29

Apr 20th, 2008 10:22 pm

Re: Redirect Output

have the search form post to the new page you are talking about and process/display the results on that page.

ryan_vietnow

Apr 20th, 2008 10:47 pm

Re: Redirect Output

put the search key in a $_GET variable then perform the query in the header location page":

$var=$_POST['searchtext'];
header("Location: http://www.example.com?var=$var");

still_learning

Apr 20th, 2008 11:53 pm

Re: Redirect Output

Hey guys, still having problems. I appreciate the responses though. I would post my code but that would actually make it more confusing for you. But here is where the problem is coming from....Here I am saying if there is a match then print out the results.

while($result = mysql_fetch_array( $data )) 
{ 
?>
<a href="http://www.someurl.com/<? $result['field'] ?>"> <? $result['field'] ?> </a> 
<br>
<?
} 
?>

I am not sure if this helps you guys at all, but this is what is printing the results right now on the same page that I have the search form. I just want these results printed on the page I am redirecting to. I apologize but you must realize I just started learning php and mysql two days ago so I basically need exact instructions. Thanks for your help!

kkeith29

Apr 21st, 2008 12:17 am

Re: Redirect Output

can you post the form? if so, then i can type some code up for you, so you can see how to do it.

ryan_vietnow

Apr 21st, 2008 12:23 am

Re: Redirect Output

like what I have said before,put the search key( the one that is inputted by the user in the textbox in a variable then perform the search query in the page you are redirecting to.

for example this is the page where you will redirect:

$var=$_GET['var'];
//put your search query here...
$query="Select * from table where field LIKE '%$var%'";
$data=mysql_query($query);
//put your display result here...
while($result = mysql_fetch_array( $data ))
{
?>
<a href="http://www.someurl.com/<? $result['field'] ?>"> <? $result['field'] ?> </a>
<br>
<?
}
?>

still_learning

Apr 21st, 2008 1:35 am

Re: Redirect Output

I used the code like you showed me above and I keep getting this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

I am not sure why it is, but I know the variable is being transferred.

ryan_vietnow

Apr 21st, 2008 1:55 am

Re: Redirect Output

try to run the query in Mysql,maybe your query is incorrect.

nav33n

Apr 22nd, 2008 8:26 am

Re: Redirect Output

Why do you want to redirect after querying the table ? Why not query the table after "implicitly redirecting" to another page using form method="post" ?

still_learning

Apr 22nd, 2008 4:08 pm

Re: Redirect Output

That is a good question. My answer: I just started learning php a couple of days ago : ) So in other words, I don't even know what you're talking about. I did get it to work though so thanks for the help guys.

All times are GMT -4. The time now is 5:33 am.