redirect based on database field (URL) 1

[rninja]

Is there any way on php to get a url out of mysql and redirect to it? I have a login script that works properly out of the mysql database and validates and starts a session. The problem is that my tables include a "url" field. The user logs in with username and password, then the user is supposed to be redirected via the address in the database.

I haven't found a way to do this. So far I've seen the header("Location: /url " method, but it simply uses a url imputted to the script. It's not dynamic.

I also tried plugging the url into a variable, with no luck.

I'd appreciate any help with this! Rninja

http://www.rninja.com

 

[danielhozac]

This should do it:

<?php
//connect to the database
//get the uri from the database and validate the user at the same time
$result = mysql_query(&quot;SELECT uri_column FROM users WHERE username='&quot;.$_POST['username'].&quot;' AND password='&quot;.$_POST['password'].&quot;'&quot;);
if (mysql_num_rows($result) > 0)
{
    // do stuff that you do to users that logged in
    list($uri) = mysql_fetch_row($result);
    header(&quot;Location: $uri&quot;);
}
else
{
    // the user wasn't able to log in
}
?>

To use it, just create a form with a username and a password field. //Daniel

 

[rninja]

That is awesome! Thanks Daniel, that's exactly what I needed!
Rninja

http://www.rninja.com