Newbie Questions Here!

Inkybro

Okie doke, first of all I own Wizard Duels and I've been working very hard on learning PHP and MYSQL. Okay Questions below:

1) I've been working on a joining system, I keep getting errors in this code (I changed the username and pass.):

<?
$db = mysql_connect("localhost", "username", "password")
$query = INSERT INTO users VALUES ("$user", "$pass")
?>

What I want it to do is take the info (username and password they entered) and process it to enter it into the database. I named the two fields user and pass on the join form. I'm including it here also:

<HTML>

<BODY>
<form method="post" action="test1.php">
<B>Username:</B> <input type="text" name="user">
<br>
<B>Password:</B> <input type="password" name="pass">
<br>
<input type="submit" value="TEST IT!">
<input type="reset" value="RESET!">
</BODY>

</HTML>

This is probably the most important question I have.

2) When they join, if it is simple, I want it to encrypt their pass in the address bar. How do I do this?

3) How do I see to it that when someone chooses a username that is in use it gives them an error message?

Thanks for reading and possibly answering. Cya.

P.S. The HTML file in action is here and the PHP one is here.

rIkLuNd

Try this:

<?

// Join.php

if(empty($_POST['user'])||empty($_POST['pass']))
{
   echo "You must fill in all fields!";
   exit;
}
else
{
$db = mysql_connect("localhost", "username", "password")

$check_name = mysql_query("select * from YourTable where user='".$_POST['user']."'");
if(!$check_name)
die(mysql_error());

$exists = mysql_num_rows($check_name);
if($exists > 0)
{
   echo "The user already exists!";
   exit;
}
else
{
   $encpass = md5($_POST['pass']);
   $query = mysql_query("insert into YourTable(user,pass) values('".$_POST['user']."','".$encpw."')");
}
?>

You also has to add </form> to the form...

planetsim

encryption 1way..

md5();

then to see if it matches md5(); when they login..

If someone uses a username that already exists i got this too work

//connect to mysql.
//select db
$result=mysql_query("SELECT username FROM table_name WHERE username='$username'");
$check=mysql_num_rows($result);
if($check != 0)
{
//username exists
}
else
{
//insert to db
}

Inkybro

Thanks man! I'll be looking to you for future help (which will be soon, lol).