PHP Redirection - Link Based - PHPBuilder Forums

PHP Redirection - Link Based

Vyrus

I want to make some thing like this:

www.thaoutsydaz.com

turn into:

www.ghettogaming.com/go.php?id=thaoutsydaz

Basically i want to redirect links, and also use MySQL, but i cant find a script that can do this.

cosminb

Could you be more specific???

Vyrus

i have seen many sites use techniques to cover up the original link, like this:

Original Link Which is hidden by the Link On The Web site: www.thaoutsydaz.com

Link On The Website: www.ghettogaming.com/go.php?id=thaoutsydaz

so i want to make people use this link: www.ghettogaming.com/go.php?id=thaoutsydaz

but it opens up www.thoutsydaz.com without showing the original link in the address bar.

RedDragon

if($id=='thaoutsydaz') {
header('Location: index.php');
}

if your getting problems with the header command use javascript or meta tags to redirect

Vyrus

i want something like this, using MySQL:

http://www.hotscripts.com/Detailed/12285.html

jebster

Originally posted by Vyrus
i want something like this, using MySQL:

http://www.hotscripts.com/Detailed/12285.html

😕 That one does use MySQL! 😉

SP8600

Hope i know what you mean. So here goes.

Right, you can start by having a database with a table called something like "sites" with these rows:
- id - AutoNumber
- name - Varchar
- homePage - Varchar

Once you got them then all you need to do is have a PHP page that gets the id from the database with is set in the address bar and then redirect it to the homePage which is also in the database using php header or some other form of redirect method.

Vyrus

i want to know how to set up the database using this script: http://www.hotscripts.com/Detailed/12285.html

I want to do all the stuff through PHP MyAdmin, but the instructions in the script are through SSSH, which i dont have.

Vyrus

Vyrus

Help??

batman

Ok, here is what you want to do. Set up your database structure like something similar. Just run it through phpmyadmin.

mysql_query ("CREATE TABLE `YOUR TABLE NAME` (
`id` VARCHAR( 100 )DEFAULT '' NOT NULL,
`homepage` VARCHAR( 100 )DEFAULT 'http://' NOT NULL ,
`name` VARCHAR( 100 )DEFAULT '' NOT NULL 
)");

Then on the go.php page do something like this:


$id = $_GET['id'];

$select = mysql_query( "SELECT * FROM YOUR TABLE NAME WHERE id='$id'");
$totalrows = mysql_num_rows($select_prod);

if($totalrows==0){echo"<br><br><p align=\"center\">The site you are trying to view no longer exists in our database!</p>";}

if($totalrows!==0){
	  while ($row = mysql_fetch_array($select_prod))
      {
          $name = $row["name"];
          $homepage = $row["homepage"];

echo "<meta http-equiv=\"refresh\" content=\"5;URL=$homepage\">";
echo "You will be directed to $name in 5 seconds <br> If it does not work, then click <a href=\"$homepage\">HERE!</a>";

}

Let me know if that helps any,
-Blake

batman

I forgot to mention one little thing. In the go.php page, you will need somekind of connection to your database.

-Blake

Vyrus

I got the thing working but, the link redirects to:

when i use this http://www.ghettogaming.com/go.php?id=1

and it goes to www.ghettogaming.com/www.mgforums.com

instead of www.mgforums.com

This is my go.php file

<?
include("redirectfuncs.php");

mysql_connect(localhost,$user,$pass);

$result=mysql_db_query("$db", "SELECT url FROM $table WHERE ID='$id'") or die ("Couldn't open \"$db\" database. Please inform $email: ".mysql_error());
$row = mysql_fetch_array($result);
$url = $row["url"];
?>
<HTML>
<HEAD>
<TITLE>Redirecting, please wait!</TITLE>
<meta http-equiv="refresh" content="0; URL=<? echo "$url"; ?>">
</HEAD>
<BODY>
</BODY>
</HTML>

batman

That is because in the database the url for the site that is getting directed to, must be the full url.

http://www.whatever.com

not

www.whatever.com

Change the url in the database to do this, and it should work for ya.

-Blake

Vyrus

SWEET it works now, thanks man 🙂

batman

Your welcome. lol 🙂

batman

If I were you I would change your go.php page to this:

<? 
include("redirectfuncs.php"); 

mysql_connect(localhost,$user,$pass); 

$result=mysql_db_query("$db", "SELECT url FROM $table WHERE ID='$id'") or die ("Couldn't open \"$db\" database. Please inform $email: ".mysql_error()); 
$totalrows = mysql_num_rows($result);
if($totalrows==0){echo"<br><br><p align=\"center\">The site you are trying to view no longer exists in our database!<br> Please click <a href=\"javascript:history.go(-1)\">here</a> to go back.</p>";}
if($totalrows!==0){
$row = mysql_fetch_array($result); 
$url = $row["url"];
} 
?> 
<HTML> 
<HEAD> 
<TITLE>Redirecting, please wait!</TITLE> 
<meta http-equiv="refresh" content="0; URL=<? echo "$url"; ?>"> 
</HEAD> 
<BODY> 
</BODY> 
</HTML>

The reason for this is that I made it to where if the page they are trying to access is not available, it will give error + a back link. This is a better way then just trying to direct them to a url that doesn't exist.

-Blake

Vyrus

EVEN SWEETER thanks again

batman

You know what, that did not work. lol sorry. Try this, it's even better:

<? 
include("redirectfuncs.php"); 

mysql_connect(localhost,$user,$pass); 

$result=mysql_db_query("$db", "SELECT url FROM $table WHERE ID='$id'") or die ("Couldn't open \"$db\" database. Please inform $email: ".mysql_error()); 
$totalrows = mysql_num_rows($result);

if($totalrows==0)
{
echo"<HTML> 
<HEAD> 
<TITLE>Not Found!</TITLE>
</HEAD> 
<BODY>
The site you are trying to view no longer exists in our database!<br> Please click <a href=\"java script:history.go(-1)\">here</a> to go back.
</BODY> 
</HTML>
";}

if($totalrows!==0)
{
$row = mysql_fetch_array($result); 
$url = $row["url"];
echo "<HTML> 
<HEAD> 
<TITLE>Redirecting, please wait!</TITLE> 
<meta http-equiv=\"refresh\" content=\"0; URL=$url\"> 
</HEAD> 
<BODY>
Redirecting you to $url. If it does not work, then click <a href=\"$url\">HERE!</a> 
</BODY> 
</HTML>
";
} 
?>

Try that and let me know,
-Blake

Vyrus

man, how sweet can you get, lol 😃

thanks again 😉