Adding users...

FourthChapter

Hi, can any one spot an error on line 8? its to add users to my database.

<html><head><title>Add a user</title></head>
<body>
<?php
if( (!$username) or (!$password) )

{
$form ="please enter details"
$form.="<form action=\"$PHP_SELF\"";                    //This line
$form.=" method=\"post\">Username: ";
$form.="<input type=\"text\" name=\"username\"";
$form.=" value=\"$username\"><br>Password: ";
$form.="<input type=\"text\" name=\"password\"";
$form.=" value=\"$password\"><br>";
$form.="<input type=\"submit\" value=\"submit\">"
$form.="</form>";
echo($form);
}
else
..................

Thanks very much

Matt

sgoku01

Yeah, I can spot an error on line 7 😉
You have to 'close' line 7 with a ;

Tekron-X

you also missed one on line 14
$form.="<input type=\"submit\" value=\"submit\">"
you need that ; in the above line 🙂

FourthChapter

silly mistake by me!

theres now an error on line 15:

$form.="</form>";

any one see a problem?

thanks very much

Matt

Tekron-X

yea what I just posted above 🙂

sgoku01

Are U sure you placed a ; on line 14???

Tekron-X

I don't think he put one on line 14 he might have not seen my post.

FourthChapter

lol soz, i didnt refresh the bb, soz didnt see that message. There all silly mistakes!

Lastly (I hope)

it says there is an error on line 31, there is no line 31 😕

................
$form.="</form>";
echo($form);
}
else
{ $conn = @mysql_connect("host", "username", "password")
     or die("could not connect");
	$db = @mysql_select_db("database", $conn)
     or die("could not select database");
	$sql = "insert into table (username,password) values (\"$username\",password(\"$password\") )";
	$result = @mysql_query($sql,$conn)
		 or die("could not execute query");
	if($result) { echo("New user $username added");
}
?>
</body>
</html>
                    //Line 31 is this line ???

thx very much

Matt

FourthChapter

Wait lol, done it, missed out a

"}"

Thanks for ur help

Matt

Tekron-X

LOL stupid mistakes lol

FourthChapter

Hey again

That script added users to the database, this script verifys the login (its the end bit)

if($num != 0)
{ 
session_start();

$msg = "<meta http-equiv=\"refresh\" content=\"0; url=./secure/index.php?usn=$username&(SID)\">"; } //This doesnt Work
else
{ $msg = "<meta http-equiv=\"refresh\" content=\"0; url=./denied.php\">"; }

 ?>

<html>
<head><title>Log-In Authentication...</title>
<?php echo($msg); ?>
</head>
<body> <?php echo(SID); ?> </body> </html>  //This works

I want it to refresh to page "./secure/index.php" which it does, i also want it to send the username which it does, i want it to send the PHP_SESSID, which it doesnt, but it echos it at the bottom as a test that it works.

I dont know how to get it to send the PHP_SESSID, ive had an attempt, but it just comes out with

"./secure/index.php?usn=Matt&(SID)"

Can some one tell me whats wrong with that line of code.

Thanks very much

Matt

Tekron-X

you are missing a \" after url=