Dymanic Data Source

dtalso · #1 (**permalink**) 08-08-05, 10:09 AM

Hello. I am trying to redirect the user to their page after they log in. I am using the Dreamweaver server behavior for this. The problem is that I get this parse error: Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/graphix/public_html/chalk1.php on line 27.

Here is line 27: $MM_redirectLoginSuccess = "<?php echo $row_rs_client_page['CLIENT_PATH']; ?>";

Any help is appreciated.

Talso

wheezy360 · #2 (**permalink**) 08-08-05, 01:31 PM

Quote:

Originally Posted by dtalso

Hello. I am trying to redirect the user to their page after they log in. I am using the Dreamweaver server behavior for this. The problem is that I get this parse error: Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/graphix/public_html/chalk1.php on line 27.

Here is line 27: $MM_redirectLoginSuccess = "<?php echo $row_rs_client_page['CLIENT_PATH']; ?>";

Any help is appreciated.

Talso

PHP Code:


			
$MM_redirectLoginSuccess = $row_rs_client_page['CLIENT_PATH'];

Try that instead and let us know how it works out.

dtalso · #3 (**permalink**) 08-08-05, 02:18 PM

It got rid of the original error but now it gives this one:
Parse error: parse error, unexpected $ in /home/graphix/public_html/chalk1.php on line 53

53 is blank. It follows the closing ?>

Here's the whole page:
<?php
$colname_rs_client_page = "1";
if (isset($_POST['client_name'])) {
$colname_rs_client_page = (get_magic_quotes_gpc()) ? $_POST['client_name'] : addslashes($_POST['client_name']);
}
mysql_select_db($database_mysql_connect, $mysql_connect);
$query_rs_client_page = sprintf("SELECT CLIENT_PATH FROM clients WHERE LOGIN = '%s'", $colname_rs_client_page);
$rs_client_page = mysql_query($query_rs_client_page, $mysql_connect) or die(mysql_error());
$row_rs_client_page = mysql_fetch_assoc($rs_client_page);
$totalRows_rs_client_page = mysql_num_rows($rs_client_page);
?>
<?php
// *** Validate request to login to this site.
session_start();

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($accesscheck)) {
$GLOBALS['PrevUrl'] = $accesscheck;
session_register('PrevUrl');
}

if (isset($_POST['client_name'])) {
$loginUsername=$_POST['client_name'];
$password=$_POST['client_password'];
$MM_fldUserAuthorization = "";
$MM_redirectLoginSuccess = $row_rs_client_page['CLIENT_PATH'];
$MM_redirectLoginFailed ="chalk1.php"; $MM_redirecttoReferrer = false; mysql_select_db($database_mysql_connect, $mysql_connect); $LoginRS__query=sprintf("SELECT LOGIN, PASSWORD FROM clients WHERE LOGIN='%s' AND PASSWORD='%s'", get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); $LoginRS = mysql_query($LoginRS__query, $mysql_connect) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup =""; //declare two session variables and assign them $GLOBALS['MM_Username'] = $loginUsername; $GLOBALS['MM_UserGroup'] = $loginStrGroup; //register the session variables session_register("MM_Username"); session_register("MM_UserGroup"); if (isset($_SESSION['PrevUrl'])&&false) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location:". $MM_redirectLoginSuccess ); } else { header("Location:". $MM_redirectLoginFailed ); } } ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form ACTION="<?php echo $loginFormAction; ?>" name="form1" method="POST">
<p>NAME
<input name="client_name" type="text" id="client_name">
</p>
<p>PASSWORD
<input name="client_password" type="password" id="client_password">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
<?php
mysql_free_result($rs_client_page);
?>

dtalso · #4 (**permalink**) 08-08-05, 02:48 PM

Thanks Wheezy!
Your initial suggestion got me going in the right direction.
After looking at the code the Dreamweaver seemed to have screwed up, I noticed that a bunch of the code was disabled.

Here's the working code:
<?php
$colname_rs_client_page = "1";
if (isset($_POST['client_name'])) {
$colname_rs_client_page = (get_magic_quotes_gpc()) ? $_POST['client_name'] : addslashes($_POST['client_name']);
}
mysql_select_db($database_mysql_connect, $mysql_connect);
$query_rs_client_page = sprintf("SELECT CLIENT_PATH FROM clients WHERE LOGIN = '%s'", $colname_rs_client_page);
$rs_client_page = mysql_query($query_rs_client_page, $mysql_connect) or die(mysql_error());
$row_rs_client_page = mysql_fetch_assoc($rs_client_page);
$totalRows_rs_client_page = mysql_num_rows($rs_client_page);
?>
<?php
// *** Validate request to login to this site.
session_start();

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($accesscheck)) {
$GLOBALS['PrevUrl'] = $accesscheck;
session_register('PrevUrl');
}

if (isset($_POST['client_name'])) {
$loginUsername=$_POST['client_name'];
$password=$_POST['client_password'];
$MM_fldUserAuthorization = "";
$MM_redirectLoginSuccess = $row_rs_client_page['CLIENT_PATH'];
$MM_redirectLoginFailed ="chalk1.php"; $MM_redirecttoReferrer = false; mysql_select_db($database_mysql_connect, $mysql_connect); $LoginRS__query=sprintf("SELECT LOGIN, PASSWORD FROM clients WHERE LOGIN='%s' AND PASSWORD='%s'", get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); $LoginRS = mysql_query($LoginRS__query, $mysql_connect) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup ="";
//declare two session variables and assign them
$GLOBALS['MM_Username'] = $loginUsername; $GLOBALS['MM_UserGroup'] = $loginStrGroup;
//register the session variables
session_register("MM_Username"); session_register("MM_UserGroup"); if (isset($_SESSION['PrevUrl'])&&false) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location:". $MM_redirectLoginSuccess ); } else { header("Location:". $MM_redirectLoginFailed );
} } ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form ACTION="<?php echo $loginFormAction; ?>" name="form1" method="POST">
<p>NAME
<input name="client_name" type="text" id="client_name">
</p>
<p>PASSWORD
<input name="client_password" type="password" id="client_password">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
<?php
mysql_free_result($rs_client_page);
?>

Thanks again!

wheezy360 · #5 (**permalink**) 08-08-05, 04:03 PM

Quote:

Originally Posted by dtalso

Thanks Wheezy!
Your initial suggestion got me going in the right direction.
After looking at the code the Dreamweaver seemed to have screwed up, I noticed that a bunch of the code was disabled.

Here's the working code:
<?php
$colname_rs_client_page = "1";
if (isset($_POST['client_name'])) {
$colname_rs_client_page = (get_magic_quotes_gpc()) ? $_POST['client_name'] : addslashes($_POST['client_name']);
}
mysql_select_db($database_mysql_connect, $mysql_connect);
$query_rs_client_page = sprintf("SELECT CLIENT_PATH FROM clients WHERE LOGIN = '%s'", $colname_rs_client_page);
$rs_client_page = mysql_query($query_rs_client_page, $mysql_connect) or die(mysql_error());
$row_rs_client_page = mysql_fetch_assoc($rs_client_page);
$totalRows_rs_client_page = mysql_num_rows($rs_client_page);
?>
<?php
// *** Validate request to login to this site.
session_start();

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($accesscheck)) {
$GLOBALS['PrevUrl'] = $accesscheck;
session_register('PrevUrl');
}

if (isset($_POST['client_name'])) {
$loginUsername=$_POST['client_name'];
$password=$_POST['client_password'];
$MM_fldUserAuthorization = "";
$MM_redirectLoginSuccess = $row_rs_client_page['CLIENT_PATH'];
$MM_redirectLoginFailed ="chalk1.php"; $MM_redirecttoReferrer = false; mysql_select_db($database_mysql_connect, $mysql_connect); $LoginRS__query=sprintf("SELECT LOGIN, PASSWORD FROM clients WHERE LOGIN='%s' AND PASSWORD='%s'", get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); $LoginRS = mysql_query($LoginRS__query, $mysql_connect) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup ="";
//declare two session variables and assign them
$GLOBALS['MM_Username'] = $loginUsername; $GLOBALS['MM_UserGroup'] = $loginStrGroup;
//register the session variables
session_register("MM_Username"); session_register("MM_UserGroup"); if (isset($_SESSION['PrevUrl'])&&false) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location:". $MM_redirectLoginSuccess ); } else { header("Location:". $MM_redirectLoginFailed );
} } ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form ACTION="<?php echo $loginFormAction; ?>" name="form1" method="POST">
<p>NAME
<input name="client_name" type="text" id="client_name">
</p>
<p>PASSWORD
<input name="client_password" type="password" id="client_password">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
<?php
mysql_free_result($rs_client_page);
?>

Thanks again!

You're welcome. So everything is working properly now??

dtalso · #6 (**permalink**) 08-08-05, 04:04 PM

Yeah, it's working great. Now I'm on the hunt for a script that will send the user their password/user name to their email address if they forgot it.

You don't know of any do you?

Thanks again!