How to make an out.php script?

I just came up with an idea, as an addition to the redirect PHP script.

I think it is in the best interest of the webmaster to hide the fact that the outgoing links are just referencing a database. So, I found a script online that hides the status bar message, so when a visitor hovers over the link the status bar does not display the URL.

Here is the code:

Code:

---

<script>

//Hide status bar msg II script- by javascriptkit.com
//Visit JavaScript Kit (http://javascriptkit.com) for script
//Credit must stay intact for use

function hidestatus(){
window.status=''
return true
}

if (document.layers)
document.captureEvents(Event.MOUSEOVER | Event.MOUSEOUT)

document.onmouseover=hidestatus
document.onmouseout=hidestatus
</script>

---

You just have to place into the HEAD section of your page, or place the script in an external file and place a tag in the HEAD that points to that script.

(I left the credit intact, as the script code requests, so I guess it is OK to post someone else's script, right?)

Sorry to be reviving this old thread, but i like to keep everything consolidated for future reference.

I just set up a new out.php script for my new site, just like explained above and like i did before. But now I can't make it work.

If you go to my "links" page http://sharpsandflats.com/links_01.html and click on the first link "Alspach's Mathematics & Poker Page..." you will see error message "Unable to connect to the database server at this time."

The only other link that is in the database, at this time, is the 4th link on the list "Faro King..." and I get the same error.

I see that this error message is spelled out at the top of the out.php script.

Code:

---

<?php

$db = mysql_connect("localhost", "username", "my_password");
if (!$db) {  echo( "<P>Unable to connect to the " . "database server at this time.</P>" );  exit();}

mysql_select_db("database_name", $db);


$result1 = mysql_query("SELECT * FROM redirect_links where LinkID = '" . addslashes($_GET['LinkID']) . "'", $db);
if (!$result1) {  echo("<P>Error performing query: " . mysql_error() . "</P>"); 
exit();
}
    $numResults = mysql_num_rows($result1);
    if($numResults != 0){

        while($list = mysql_fetch_array($result1)){
        $url = $list[url];
        }
    }
    mysql_free_result($result1);

    header("Location: $url");
    ?>

---

Of course, I tried troubleshooting and the only thing that I could find that looked odd was this...

I go to my CP>PHPmyAdmin and I go to my database. I clicked on the tab "operations" and at the bottom there is a red box with title "ERROR" and text "The additional features for working with linked tables have been
deactivated. To find out why click here."

When I click on "click here" a page opens and says:

PMA Database ... not OK[ Documentation ]
General relation features Disabled

The word "Documentation" is a link, but when I click on it I go to a huge page that just looks like a genera PHP documentation and is entitled "phpMyAdmin 2.6.4-pl2 Documentation".

This documentation page is huge, but clicking on that link opens the page at the following paragraph:

Quote:

---

See the Linked-tables infrastructure section in this document to see the benefits of this infrastructure, and for a quick way of creating this database and the needed tables.

If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb']. For a multi-user installation, set this parameter to the name of your central database containing the linked-tables infrastructure.

---

This is where I'm stuck.

Any ideas what is wrong?

Thanks...

I Just noticed something else that may help resolve this issue.

When I set up the MySQL database for my other sites I had to also set up a user with password, and then add that user to the database.

But this hosting company has a different CP. I only had to set up the database with a password and there is no way to add the user anywhere.

Does that mean that the first line of the pot.php script needs to be changed?

Try and see, sometimes a CP will just use your account username/pw for your mysql connection.

I tried all that in all combinations I could think of.

I changed the first line...

Code:

---

$db = mysql_connect("localhost", "username", "my_password");

---

...so that username and password were those I use for FTP. But since the CP did require me to create a password I also used the FTP username with the new password.

Nothing else I can think of. Any ideas?

Good news.

My problem has been resolves...