Jump to content


Photo

Form submit problem.


  • Please log in to reply
2 replies to this topic

#1 Random

Random
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationIndiana

Posted 06 April 2003 - 05:51 AM

As you can tell from my recent outbreak of posting for newbie help, I am learning MySQL. I am now having trouble with a signup form and the process script. Here they are:

SIGNUP FORM:

[php:1:78927ec1bf]<?php
print \"<BR><BR><BR>\";
print \"<h1>Test for MySQL Tables</h1>\";
print \"<BR><BR><BR>\";
print \'<form action=\"signup_process.php\" method=\"post\">\';
print \'Desired Username: <input type=\"text\" name=\"username\" maxlength=20><BR>\';
print \'Desired Password: <input type=\"password\" name=\"password\" maxlength=20><BR>\';
print \'First Name: <input type=\"text\" name=\"f_name\" maxlength=25><BR>\';
print \'Last Name: <input type=\"text\" name=\"l_name\" maxlength=25><BR>\';
print \'Email Address: <input type=\"text\" name=\"email\" maxlength=\"60\"><BR>\';
print \'Age: <input type=\"text\" name=\"age\" maxlength=\"3\"><BR>\';
print \'Gender: Male<input type=\"radio\" name=\"male\" value=\"male\"> Female<input type=\"radio\" name=\"female\" value=\"female\"><BR>\';
print \'<input type=\"submit\" value=\"Finish signup!\">\';
?>[/php:1:78927ec1bf]

and the PROCESS SCRIPT:

[php:1:78927ec1bf]<?php
$dbuser = \"random\";
$dbpass = \"random\";
$dbname = \"random\";
$_POST[\'username\'] = $uname;
$_POST[\'password\'] = $pword;
$_POST[\'f_name\'] = $fname;
$_POST[\'$l_name\'] = $lname;
$_POST[\'email\'] = $email;
$_POST[\'age\'] = $age;
$_POST[\'gender\'] = $gender;

if (empty($_POST[\'username\']) || ($_POST[\'password\']) || ($_POST[\'f_name\']) || ($_POST[\'l_name\']) || ($_POST[\'email\']) || ($_POST[\'age\']) || ($_POST[\'gender\'])) {
print \"Please fill in all of the required fields!\";

}else {

$link = mysql_connect(\"localhost\", $dbuser, $dbpass) or die (\"Database Error: Couldn\'t Connect!\");

mysql_select_db($dbname, $link) or die (\"Couldn\'t open $db!\");

$query = \"INSERT INTO user_info (username, password, f_name, l_name, email, age, gender)
values( \'$uname\', \'$pword\', \'$fname\', \'$lname\', \'$email\', \'$age\', \'$gender\' )\";

mysql_query($query, $link) or die (\"Couldn\'t input data!\");


mysql_close($link);
}


?>[/php:1:78927ec1bf]

After I hit the submit button and process the form, no errors come up, so I goto my PuTTY box and get onto my database, select the columns, and they just added blank lines to it, no information what-so-ever. Help please.

#2 DocSeuss

DocSeuss
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts
  • LocationTexas, USA

Posted 06 April 2003 - 07:32 AM

hmm your code looks fine, do a couple of echos to make sure you are getting the information from the form.


$_POST[\'$l_name\'] = $lname;



I\'m guessing here that the $ is a mistake but even so it shouldn\'t effect the rest of your variables.
"Unlimited budget? Great, for $5,000,0000 we will run your ad banner for one year"  ----Rasmus Lerdorf

#3 Random

Random
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationIndiana

Posted 06 April 2003 - 03:18 PM

It was because the variables and the $_POST variables need to be switched...

ex. $fname = $_POST[\'f_name\'];

:P thnx anyways




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users