# URL link from MySQL using PHP

**URL:** <https://forum.kirupa.com/t/url-link-from-mysql-using-php/194482>\
**Category:** programming\
**Created:** [July 24, 2006, 2:32am UTC](https://forum.kirupa.com/t/url-link-from-mysql-using-php/194482 "2006-07-24T02:32:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![enforcer73](https://avatars.discourse-cdn.com/v4/letter/e/ecd19e/32.png) [@enforcer73](https://forum.kirupa.com/u/enforcer73)\
**Post date:** [July 24, 2006, 2:32am UTC](https://forum.kirupa.com/t/url-link-from-mysql-using-php/194482/1 "2006-07-24T02:32:56Z")

</div>

Hi all,

I have been using Flash, PHP and MySQL intergration for the first time and have been having some luck with it, although having a few problems along the way.  
The problem I have at the moment is this:  
I have a Flash client login at the site [www.brandnew.cc](http://www.brandnew.cc) (clients section)  
When the user enters their username and password, they are checked against a MySQL database using PHP. I have been able to get this working fine. The problem is I want a URL to open in a new window/tab once the username and password have been verified. This URL will be related to the user and so will be included in my database.

My database currently has 3 fields; username, userpassword and url.  
So for example, entry number one reads: roymuir, 12345, [http://www.roymuir.com](http://www.roymuir.com)

Basically I need the flash file or PHP to open the url ([http://www.roymuir.com](http://www.roymuir.com)) once the username, roymuir, and the password, 12345, have been verified.

Here’s my PHP code:

```php
 <?
ini_set('display_errors', true);
$username="$user";
$password="$pass";

//connect to database
$connect2 = mysql_connect("127.0.0.1", "brandnew", "89CBqmqyp");
mysql_select_db("brandnewlogin", $connect2);
//make query
$query = "SELECT * FROM logindetails WHERE username = '$username' AND userpassword = '$password'";
$result = mysql_query( $query ) or die ("didn't query");

//see if there's an EXACT match
$num = mysql_num_rows($result);
if ($num == 1){
print "statustext=You're in&checklog=1";
} else {
print "statustext=Sorry, but your user name and password did not match a user name/password combination in our database. Usernames and passwords are entered in from a different file. Thank you for visiting test login script!!&checklog=2";
}
?>

```

and here is my Flash code:

```auto
this.onEnterFrame = function() {
    if (_root.checklog == 1) {
        this.gotoAndStop(2);
    }
    if (_root.checklog == 2) {
        this.gotoAndStop(3);
    }
};
submit_mc.onRelease = function() {
    userName = userinput.text.toLowerCase();
    passWord = passinput.text.toLowerCase();
    loadVariablesNum("login.php", 0, "POST");
};
clear_mc.onRelease = function() {
    userinput.text = "";
    passinput.text = "";
};
userinput.restrict = "a-zA-Z0-9";
passinput.restrict = "a-zA-Z0-9";
Selection.setFocus(userinput);
userinput.tabIndex = 1;
passinput.tabIndex = 2;
stop();

```

if anyone could help me out, I would be super appreciative,

enforcer73