Problem with the registration

Brajan · July 2, 2008

Hi!

I have problem with my registration.

When you hit the submit-button, the username and the password should be saved in the database and at the same time the user should automaticaly be transferd to the guestbook.php.

Everything worked, until I started to use Ajax. I use Ajax to open the information that my links hold, into my divbox.

Now, when I try to register, the text "The username or the password couldn't be found in the database".

My scripts:

index.php:

<?php
session_start();
?>
<html>
<head>
<script language="javascript" type="text/javascript" src="Ajax.js">
</script>
<link href="Stil.css" rel="stylesheet" type="text/css">
<title>
Byans's Gastbok Version 1.0  -  Logga In
</title>
</head>
<body>
<?php
include("conn.php");
if(isset($_POST['submit'])) {

$password = $_POST['password'];
		$salt = "Jk!%wAF63&¤!#";
		$kryptering = sha1($salt.$password);

$query = "SELECT id FROM users
   WHERE user='{$_POST['user']}'
   AND password='{$kryptering}'";

$result = mysql_query($query)
	or die(mysql_error());

	//Finns användarnamnet eller lösenordet i databasen?
	if(mysql_num_rows($result) == 0) {
		echo "Användarnamn eller Lösenord kunde inte hittas i databasen";
		}
		else {
	//Sätt unikt id på användaren
	$_SESSION['user_id'] = mysql_result($result, 0);
	$_SESSION['user_sess'] = $_POST['user'];
	header("Location: Gastbok.php");
	exit;

	}
}
?>
<div id="layout">
<form action="index.php" method="post">

<div id="loginbox">
<p><br>
Användarnamn:<br> <input type="text" name="user">
<br>
Lösenord:<br> <input type="password" name="password">
<br>
<input type="submit" name="submit" value="Logga in">
<p>
<a href="#" onClick="ajax('register.php/index.php?page2','centerbox')">Registrera dig</a>
<p>
<a href="#" onClick="ajax('om_webbsidan.php/index.php?page2','centerbox')">Om webbsidan</a>
<p>
<a href="#">Teknisk Info</a>
</div>

<div id="rightbox">
</div>

<div id="centerbox">
<p>
Lösenordet krypteras i databasen
</div>
<p>
<div id="banner">
<img src="images/Logo.gif">
</div>



</div>




</body>

register.php:

<?php
session_start();
?>
<html>
<head>
<script language="javascript" type="text/javascript" src="Ajax.js">
</script>
<link href="Stil.css" rel="stylesheet" type="text/css">
<title>
Byans's Gastbok Version 1.0  -  Register
</title>
</head>
<body>
<?php
if(isset($_POST['submit'])) {
include("conn.php");

	//Kolla om något utav formulären är tomma
	if(empty($_POST['user']) && empty($_POST['password'])) {
		echo "Något utav fälten är inte korrekt ifyllda";
		}

	//Kolla om användarnamnet är upptage
	$sql = "SELECT COUNT(*) FROM users WHERE user='{$_POST['user']}'";
	$result = mysql_query($sql)
		or die(mysql_error());

	if(mysql_result($result, 0) > 0) {
		echo "Användarnamn redan upptaget";
		}

	else {
		//Inget fel? Lägg då in allt i databasen och skicka användaren till huvudsidan.

		$password = $_POST['password'];
		$salt = "Jk!%wAF63&¤!#";
		$kryptering = sha1($salt.$password);
		$query = "INSERT INTO users(user,password) VALUES
		('{$_POST['user']}','{$kryptering}'); ";

		$result1 = mysql_query($query)
			or die(mysql_error());

		$_SESSION['user_id'] = mysql_insert_id();
		$_SESSION['user_sess'] = $_POST['user'];

			header("Location: Gastbok.php");
			exit;
		}


}
?>
<p>
<form action="register.php" method="post">
Användarnamn:<br>
<input type="text" name="user">
<br>
Lösenord:<br>
<input type="password" name="password">
<br>
<input type="submit" name="submit" value="Registrera">

</body>
</html>

Gastbok.php:

<?php
session_start();
if(!isset($_SESSION['user_id'])) {
header("Location: index.php");
}

if(isset($_POST['submit'])) {
	include("conn.php");
	$datum = date("Y-m-d H:i:s");

	if(empty($_POST['Namn']) && empty($_POST['text_content'])) {

		echo "Alla fält inte ifyllda";
	}
	else {
		$query = "INSERT INTO posts(Namn,Datum,inlagg) VALUES
		('{$_POST['Namn']}','{$datum}','{$_POST['text_content']}'); ";

		$result = mysql_query($query) 
				or die(mysql_error());

			echo "Postades utan problem";

			}


			}




?>
<html>
<head>
<link href="Stil.css" rel="stylesheet" type="text/css">
<title>
Bryan's Gästbok Version 1.0   -  Welcome
</title>
</head>
<body>
<form action="Gastbok.php" method="post">

Namn: <br><input type="text" name="Namn">
<br>
Skriv: <br><textarea name="text_content"></textarea>
<br>
<input type="submit" name="submit" value="Skicka">
<br>
<a href="loggout.php"> Logga ut </a>
<p>
<?php
include("conn.php");
$query1 = "SELECT * FROM posts ORDER BY id DESC";

$result1 = mysql_query($query1)
	or die(mysql_error());

while($row = mysql_fetch_array($result1)) {

	echo "<div class='ram'>";
	echo "Namn: $row[Namn] <p>";
	echo "Datum: $row[Datum]<hr></hr> <p>";
	echo " $row[inlagg] <p>";
	echo "</div>";
	echo "<p>";
	}
	?>

</body>
</html>

Ajax.js:

function ajax(url, pageElement) {

  document.getElementById(pageElement).innerHTML = 'Uppdaterar';

  var http;

  try
  {
    http = new XMLHttpRequest(); // Firefox, Opera, Safari
  } catch(e) {

    try
    {
      http = new ActiveXObject("Msxml2.XMLHTTP"); // Internet Explorer
    } catch(e) {
   
      try
      {
        http = new ActiveXObject("Microsoft.XMLHTTP"); // Internet Explorer
      } catch(e) {
        http = false;
        alert('Your browser dont support AJAX!');
      }
   
    }

  }

  random = parseInt(Math.random()*9999999999);
  modurl = url + '&rand=' + random;

  http.onreadystatechange = function() {responseAjax(pageElement);};
  http.open("GET", modurl, true);
  http.send(null);


  function responseAjax(pageElement) {

    if (http.readyState == 4) {

      if (http.status == 200) {
   
        output = http.responseText;
        document.getElementById(pageElement).innerHTML = output;
   
      } else {
        alert('Ajax error: ' + http.statusText);
      }

    }

  }
}

Sorry for my english!

Can somebody help me?

Sign In

Problem with the registration

Recommended Posts

Brajan

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information