Membership using PHP/MySQL

Hi, newbie question here,

I'm trying to use PHP and MySQL to implement a membership form....

My initial page is addform.php3 :
<form method="post" action="confirm.php3">
<p>
<font color="#00004D">First Name</font><br>
<input type="text" name="FIRST_NAME"> </p>
<p>Last Name<br>
<input type="text" name="LAST_NAME">
</p>
<p>Password<br>
<input type="password" name="PASSWORD">
</p>
<p>Email<br>
<input type="text" name="EMAIL">
</p>
<p><input type="submit" name="Submit" value="Submit">
<input type="reset" name="Submit2" value="Reset">
</form>


Which loads up "Confirm.php3", which looks like this:
$server= "localhost"; //mysql server address
$dbname= "mydbname"; // mysql database name
$uid= "myusername"; // username for that database
$pwd= "mypassword"; // password for that database

if (($REQUEST_METHOD=='post')) {
$query = "INSERT INTO MEMBERS";
$query .= "(FIRST_NAME, LAST_NAME,";
$query .= "EMAIL, PASSWORD)";
$query .= "values('$FIRST_NAME','$LAST_NAME','$EMAIL','$PASSWORD')";

$conn=mysql_connect($server,$uid,$pwd) or die("Unable to connect to SQL server");
mysql_select_db($dbname, $conn) or die("Unable to select database");

mysql_query($query) or die("Insert Failed!");


However, this just doesn't seem to work! No members are added and I'm getting no errors. Could someone tell me what I'm doing wrong?

thanks in advance,
kankohi

Greetings,
I am also a bit of a newbie but consider adding an else to the conditional statement to test if the first condition is evaluating false, as it is if this:

if (($REQUEST_METHOD=='post')) {

fails (that is if it evaluates false), then execution will stop and you will get no errors and no users added to your DB. Also I'm not sure you need (( *** )) double parens around the conditional statement it's not "if ((this | | (this)) {}"... it's
"if (this) {}"...
Otherwise looks fine to me.
Best
Scott

Hi,

I'm real green, and am trying to do a membership system as well. I have my registration form much like yours with a couple differences.

Not sure why yer asking 'if((REQUEST...' - I have used the get method from my form which works.

The other difference is that I haven't built up my query as you. "$query .="

I just wrote one long line with my column names $tablename (firstName,lastName...) hit 'return' and did VALUES ('$firstName','$lastName'...)"; closing with "; It is my understanding that php does not care about line breaks unless it sees the ';'.

Your approach may certainly be valid (I wouldn't know ) but I do know mine works.

Jay

Sorry, addendum

What I meant is that I don't nest my connection stuff in an 'if' statement. It's just there and runs as it reads.

JB

Hi all, URL

I just wonder, why did you try to check the "if" condition using "$REQUEST_MODE". In my day programming I ussually use the button name to validate.

This makes easy to determine which button is pressed when there are more than 1 button. To catch the button name I check with "if ($btn_name) ...".

But if there is a special purpose to use "$REQUEST_MODE" can you explain more?

Regards,
enka

Thanks for all your help,

I got it to work, just changed $Request_method = "post" to "get"

again, my thanks,
kankohi