help!! with redirection...

luna_blue

HI all,
I have a database with password, username and a url field.the user logs in then gets redirected to the url that is stored in their url field. I am using
the header function..
is there another way that i can grab the url stored and open up a new window with it?

thanks!!!

nashirak

Sure just some javascript+php.

echo "<html><head><script language=JAVASCRIPT>";
echo "window.open('$database_url.html','newwin','toolbar=0,scrollbars=0,status=0,location=0,menubar=0,width=800,height=600');";

echo "</script></head>";

etc....
Hope this Helps!

luna_blue

🙂

Thank you for the reply!

I am new to php where would i put the java window open in this script?

my column is called $page

$result= mysql_query("SELECT * FROM users WHERE  username='$username' AND password='$password'");
$show=mysql_fetch_array($result);
header("Location: .$show['page']");

🙂

luna_blue

i am doing something wrong, the new window isn't opening. in my newbieness,I thought a 'if result count >1'statement would be okay.
then adding my $page name to the open.window. like so:

$result= mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'");
$show=mysql_fetch_array($result);
if ($result > 1){
echo "<html><head><script language=JAVASCRIPT>"; 
echo "window.open('$page','newwin','toolbar=0,scrollbars=0,status=0,lo
cation=0,menubar=0,width=800,height=600');"; 
echo "</script></head>"; 
}
}

thank you!

luna_blue

well, i kinda have it working,sorta of

after a successful login I do have the pop up window working...but, i get a 404, its looking for the url 'page' which is my coloum name.. how do I get the field(in my 'page' coloum) that has the url in it to my pop up?

thank you!

my php :

$result= mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'");
$row=mysql_fetch_array($result);
if ($result > 1){
echo "<html><head><script language=JAVASCRIPT>"; 
echo "window.open('$page','newwin','toolbar=0,scrollbars=1,status=1,location=0,menubar=1,width=800,height=600');"; 
echo "</script></head>"; 
}
}

adhi_nugraha

if the table fields was (only three fileds) : username, password, page

$result= mysql_query("SELECT FROM users WHERE username='$username' AND password='$password'");
// $lr = mysql_fetch_array($rslt_gb); / i'm not sure using this
$lr = mysql_fetch_row($result);

if ($result > 1){
$lst=list($user, $pass, $page);
echo "<html><head><script language=JAVASCRIPT>";
echo "window. open('$page','newwin','toolbar=0,scrollbars=1,status=1,location=0,menubar=1,width=800,height=600');";
echo "</script></head>";
}
}

luna_blue

thank you, adhi_nugraha for your reply.

i get an error on on one of the lines.the error is:
Parse error: parse error, expecting `'='' in login.php on line 22
what's causing it?

          //Login Success*
$result= mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'");  

// $lr = mysql_fetch_array($rslt_gb); /* i'm not sure using this 
$lr = mysql_fetch_row($result); 
if ($result > 1){ 
//$lst=list($username, $password, $area); /*this is the line with the error
echo "<html><head><script language=JAVASCRIPT>"; 
echo "window. open('$area','newwin','toolbar=0,scrollbars=1,stat
us=1,location=0,menubar=1,width=800,height=600');"; 
echo "</script></head>"; 
} 
}