Need Help Geeting A Web URL from Sql Database

bmabma

Greetings Forum,
Can someone please tell em how to get a web url from an sql database so that it loads the website into the browser. The script I have now does not work.
I am using............................

<?php
include ("../config/config.inc");

// start session and bring in session variables
session_start();
// forward to login page if the session is not valid

if(!isset($s_email))
{
        header("Location: logon.htm");     

        exit();
}

@$link = mysql_connect(SYSTEM,USERNAME,PASSWORD);

if(!$link)
{
    echo "Database seems to be down";
    exit;
}
mysql_select_db(DATABASE) or die( "Unable to select database");

$query = "SELECT * FROM booth ";
$result = mysql_query($query);

while($row = mysql_fetch_array( $result )) {
$app_link = $row['app_link'];

   if ($app_link == $app_link) 
   {
      $URL='$app_link';
      header ("Location: $URL");
   }
}

?>

where app_link is the field that holds www.mywebsite.com and booth is the table.

Any help would be greatly appreciated.

napper

Well I would not select from the table. You need to tell it a WHERE clause. like SELECT FROM booth WHERE something = something.

From there, make sure the url is formatted in a complete manner. For example, http://www.example.com. So lets say you have a id in the db you want to check and are going to send it to this script via script.php?booth=value. This is purely for me to show you and it may differ:

<?php 
include ("../config/config.inc"); 

// start session and bring in session variables 
session_start(); 
// forward to login page if the session is not valid 

if(!isset($s_email)) 
{ 
        header("Location: logon.htm");      

        exit(); 
} 

$_GET = array_map('strip_tags', $_GET);  //clean up $_GET from HTML data

if(!isset($_GET['booth']) {
  //no booth set, lets just die
  die('No booth id sent to script.  goodbye!');
}

@$link = mysql_connect(SYSTEM,USERNAME,PASSWORD); 

if(!$link) 
{ 
    echo "Database seems to be down"; 
    exit; 
} 
mysql_select_db(DATABASE) or die( "Unable to select database"); 

$query = "SELECT app_link FROM booth WHERE booth='" . $_GET['booth'] . "'"; 
$result = mysql_query($query); 
$row = mysql_fetch_row($result);
$app_link=$row['0'];
header ("Location: " . $app_link); 
flush();   //Flush Buffer to Browser so it immediately send headers and you script can continue peacefully.

?>

napper

I also at one time just wrote a function called refresh(url, [time]). It works very nice.

	function refresh($url, $time=0) {
		header("Refresh: " . $time . "; url=" . $url);
		flush();
		exit();
	}

bmabma

Thanks Napper
I will give this a shot

bmabma

To Napper,
Again, thanks for your response. The code is you suggested is almost working. It is loading the root url into the browser instead of the url tha is in the app_link field.

For example..... the visitor is logged into www.legalcareerfair.com and on the menu page is a flash button named Apply On Line. The link for that button is .............

apply.php?booth_id='$s_booth_id'

Everything in your suggested code is set up so that $_GET['booth_id'] is put in session. But instead of loading www.examplesite.com it loads www.legalcareerfair.com.

Any other suggestions???

napper

Have you tried to put in the function refresh and instead of putting header(); call the refresh($app_link); function?

bmabma

No I didn't. I'll try that and post the results here tomorrow.
Thanks