i dont know whats the problem!(\

kulin · February 13, 2009

im just a beginner in php and dw..im doing a site and

i actually setting my log in page in dreamweaver

and i made it easily but when i try to run it theres an error..

im trying to find the error but still i cant find it!pls help me..i need to make

this site for our thesis..pls help me.. this is the code......

thank you!also i want to know if my codes are correct..i dont have any experience in php and mysql thats why it was hard for me to find the errors thanks! :-[

<?php ('connection.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = 

"") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string

($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}


mysql_select_db($database_connection, $connection);
$query_rsLog = "SELECT * FROM users WHERE users.username=users.password";
$rsLog = mysql_query($query_rsLog, $connection) or die(mysql_error());
$row_rsLog = mysql_fetch_assoc($rsLog);
$totalRows_rsLog = mysql_num_rows($rsLog);
?><?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

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

if (isset($_POST['username'])) {
  $loginUsername=$_POST['username'];
  $password=$_POST['password'];
  $MM_fldUserAuthorization = "access_level";
  $MM_redirectLoginSuccess = "/for women/home.php";
  $MM_redirectLoginFailed = "/for women/account.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_connection, $connection);
  	
  $LoginRS__query=sprintf("SELECT username, password, access_level FROM users WHERE 

username=%s AND password=%s",
  GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 
   
  $LoginRS = mysql_query($LoginRS__query, $connection) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
    
    $loginStrGroup  = mysql_result($LoginRS,0,'access_level');
    
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	      

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- TemplateBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- TemplateEndEditable -->
<style type="text/css">
<!--
body {
background-color: #00FFFF;
background-image: url(g);
}
s {
}
-->
</style>

<style type="text/css">
<!--
a:hover {
color: #FF66FF;
}
-->
</style>
<script src="../SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<link href="../SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" />
<!-- TemplateBeginEditable name="head" --><!-- TemplateEndEditable --><style 

type="text/css">
<!--
.style5 {
font-family: "Adobe Garamond Pro Bold";
color: #66FF66;
font-weight: bold;
}
.style6 {font-size: 24px}
-->
</style></head>

<body>
<p align="center"> </p>
<table width="643" height="210" border="2" align="center">
  <tr>
    <td background="pictures/banner2.jpg" bgcolor="#FF00FF"><blockquote>
      <ul id="MenuBar1" class="MenuBarVertical">
        <li>
          <div align="center"><a href="#home.php">Home</a> </div>
        </li>
        <li>
          <div align="center"><a href="#account.php">My Account</a></div>
        </li>
        <li>
          <div align="center"><a href="#us.php">About Us</a> </div>
        </li>
        <li>
          <div align="center"><a href="#contact.php">Contact </a></div>
        </li>
      </ul>
</blockquote></td>
  </tr>
</table>
<p> </p>
<p> </p>
<table width="700" border="2" align="center">
  <tr>
    <td bgcolor="#000000"><table width="287" border="2">
      <tr>
        <td height="22" bgcolor="#FF00FF"><div align="center" class="style5">
          <p class="style6">Registered Customer?</p>
          <p class="style6">Username</p>
          <form action="<?php echo $loginFormAction; ?>" method="POST" name="form1" 

target="_self" id="form1">
            <label>
              <input name="username" type="text" id="username" maxlength="50" />
              </label>
            <p class="style6">Password</p>
            <p>
              <label>
              <input name="password" type="password" id="password" maxlength="50" />
              </label>
            </p>
            <p> </p>
            <p>
              <label>
              <input type="submit" name="submit" id="submit" value="Submit"/>
              </label>
            </p>
          </form>
          <p class="style6"> </p>
          <p class="style6"> </p>
          <p class="style6"> </p>
        </div></td>
      </tr>
    </table>
      <table width="195" border="2">
        <tr>
          <td width="183"> </td>
        </tr>
      </table>  
      <blockquote>
      <blockquote>
        <p> </p>
      </blockquote>
    </blockquote></td>
  </tr>
</table>
<p> </p>
<script type="text/javascript">

var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", 

{imgRight:"/SpryAssets/SpryMenuBarRightHover.gif"});

</script>
<?php
mysql_free_result($rsLog);

</body>
</html>
<?php ('connection.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = 

"") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string

($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}


mysql_select_db($database_connection, $connection);
$query_rsLog = "SELECT * FROM users WHERE users.username=users.password";
$rsLog = mysql_query($query_rsLog, $connection) or die(mysql_error());
$row_rsLog = mysql_fetch_assoc($rsLog);
$totalRows_rsLog = mysql_num_rows($rsLog);
?><?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

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

if (isset($_POST['username'])) {
  $loginUsername=$_POST['username'];
  $password=$_POST['password'];
  $MM_fldUserAuthorization = "access_level";
  $MM_redirectLoginSuccess = "/for women/home.php";
  $MM_redirectLoginFailed = "/for women/account.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_connection, $connection);
  	
  $LoginRS__query=sprintf("SELECT username, password, access_level FROM users WHERE 

username=%s AND password=%s",
  GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 
   
  $LoginRS = mysql_query($LoginRS__query, $connection) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
    
    $loginStrGroup  = mysql_result($LoginRS,0,'access_level');
    
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	      

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- TemplateBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- TemplateEndEditable -->
<style type="text/css">
<!--
body {
background-color: #00FFFF;
background-image: url(g);
}
s {
}
-->
</style>

<style type="text/css">
<!--
a:hover {
color: #FF66FF;
}
-->
</style>
<script src="../SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<link href="../SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" />
<!-- TemplateBeginEditable name="head" --><!-- TemplateEndEditable --><style 

type="text/css">
<!--
.style5 {
font-family: "Adobe Garamond Pro Bold";
color: #66FF66;
font-weight: bold;
}
.style6 {font-size: 24px}
-->
</style></head>

<body>
<p align="center"> </p>
<table width="643" height="210" border="2" align="center">
  <tr>
    <td background="pictures/banner2.jpg" bgcolor="#FF00FF"><blockquote>
      <ul id="MenuBar1" class="MenuBarVertical">
        <li>
          <div align="center"><a href="#home.php">Home</a> </div>
        </li>
        <li>
          <div align="center"><a href="#account.php">My Account</a></div>
        </li>
        <li>
          <div align="center"><a href="#us.php">About Us</a> </div>
        </li>
        <li>
          <div align="center"><a href="#contact.php">Contact </a></div>
        </li>
      </ul>
</blockquote></td>
  </tr>
</table>
<p> </p>
<p> </p>
<table width="700" border="2" align="center">
  <tr>
    <td bgcolor="#000000"><table width="287" border="2">
      <tr>
        <td height="22" bgcolor="#FF00FF"><div align="center" class="style5">
          <p class="style6">Registered Customer?</p>
          <p class="style6">Username</p>
          <form action="<?php echo $loginFormAction; ?>" method="POST" name="form1" 

target="_self" id="form1">
            <label>
              <input name="username" type="text" id="username" maxlength="50" />
              </label>
            <p class="style6">Password</p>
            <p>
              <label>
              <input name="password" type="password" id="password" maxlength="50" />
              </label>
            </p>
            <p> </p>
            <p>
              <label>
              <input type="submit" name="submit" id="submit" value="Submit"/>
              </label>
            </p>
          </form>
          <p class="style6"> </p>
          <p class="style6"> </p>
          <p class="style6"> </p>
        </div></td>
      </tr>
    </table>
      <table width="195" border="2">
        <tr>
          <td width="183"> </td>
        </tr>
      </table>  
      <blockquote>
      <blockquote>
        <p> </p>
      </blockquote>
    </blockquote></td>
  </tr>
</table>
<p> </p>
<script type="text/javascript">

var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", 

{imgRight:"/SpryAssets/SpryMenuBarRightHover.gif"});

</script>
<?php
mysql_free_result($rsLog);

</body>
</html>
?>

Phoenix~Fire · February 15, 2009

I hate Dreamweaver Code =) Anyways... what error message are you getting?

<?php ('connection.php'); ?> Is that meant to be <?php include('connection.php'); ?>

fenway · February 15, 2009

And please don't ever post that much code again.

Phoenix~Fire · February 16, 2009

lol agreed xD

Sign In

i dont know whats the problem!(\

Recommended Posts

kulin

Link to comment

Share on other sites

Phoenix~Fire

Link to comment

Share on other sites

fenway

Link to comment

Share on other sites

Phoenix~Fire

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information