url from db into location browser

peter123

Hi,

I have a question about the following:
When a user clicks on a link in my index.html,
I want the corresponding URL to be selected from a database,
and to be put into the address-bar of a new opening window.
the db consists of column ID and column URL(text)

Sounds simple right ? But I have a lot of difficulty doing this.

First of all, the tag in the index.html looks like this now:
<a href="http://localhost/data_out.php3?ID=2">name_of_link</a>

Then data_out.php3 :
<?php
$db = mysql_connect("localhost", "root");

mysql_select_db("testdatabase",$db);
$sql= "select * from links where ID = ?????";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$url = $row["url"];
?>

and redir.php3 :
<?php
header("location:$url");
exit;
?>

So how do I get the ID=2 from the index.html to the data_out.php3 ?
And how do I get $url from data_out.php3 to redir.php3 ?

Can anyone help me with this or give me a clue ?

Best Regards,
Peter

parena

Your query in data_uit.php3 would be:

$sql="SELECT * FROM linkw WHERE ID = ".$ID

The $ID refers to the "ID=2" that is in http://localhost/data_out.php3?ID=2

Then, you don't need to have redir.php3, but after the $url =... line you can put the header function already.

But erm, why do it that way? Why don't you do this:

When creating the links (where you get the ID=x) instead of doing the ID thing, already grab the URL's from the database and then create the links. For example

ID 1 is http://slashdot.org
ID 2 is http://www.phpbuilder.com

instead of grabbing all the ID's, why not grab the URL's?

peter123

Thanks for your response Parena,
I will try your comments.

Best regards,
Peter

Anon

Should work like this:

Then data_out.php3 :
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("testdatabase",$db);
$sql= "select * from links where ID = $ID";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$url = $row["url"];

header("Location: redir.php3?url=$url");

and redir.php3 :
<?php
header("Location: $url");
exit;
?>

If you want it to open in a new window, you must open a window using javascript, i yould suggest:

data_out.php3 generates some javascript code into the page that is loaded after the db query (maybe itself, maybe some page you're redirecting at via header()) which, inserted into that page (e.g. <body onLoad=createPopup()) opens a popup window (see javascript reference/window.open). the javascript contains the dynamically inserted url. no need for header() - header always (re)loads into its own frame.

peter123

Thanks Matto,

The header(location:redir.php3?url=$url) in data_out.php gives the same problem ... cannot add header info since it already was sent to the browser.

With Javascript in data_out.php3 I opened
a new window (window.open="redir.php3")
and then in redir.php3 I put the header("location:$url"). But now he don't remember the data that was in $url.

I guess it should be possible to pass variables to other php-documents ?

regards,
Peter