When I Click
Submit On The
Registration
Page I Get The
Following Error
Message
Code:
Warning:
mysql_fetch_obj
ect(): supplied
argument is not
a valid MySQL
result resource
in
/home/grant1/pu
blic_html/regis
tration.php on
line 38
No database
selected <
br> .. here is
my page code
Code:
<?
require_once($_
SERVER['DOCUMEN
T_ROOT'].'/db_c
onnect.php');
//SEE IF
ALREADY LOGGED
IN
if($_SESSION['
logged_in'] ==
1)
{
//REDIRECT
TO HOMEPAGE
header('Locatio
n: http://' .
$_SERVER['HTTP_
HOST'] .
'');
} else {
if(isset($HTTP
_POST_VARS['sub
mit']))
{
//BEGIN
CHECKING
USERNAME...
if(!$_POST['use
rname'])
die('Alert:
username field
was
blank.');
//array of
invalid
characters
//starting
lenght of
username
$len =
strlen($_POST['
username']);
//replace
invalid
characters
$_POST['usernam
e'] =
str_replace($ju
nk, '',
$_POST['usernam
e']);
$test =
$_POST['usernam
e'];
//if lenghts
are different
($len smaller),
invalid
characters
found, so
prompt
error.
if(strlen($test
) != $len) {
die('Username
Error: Username
contained
invalid
characters. You
can only use
A-Z, 0-9 and
the
underscore
(_).');
}
//Check if
username
already
exists...
$q2 =
mysql_query(&qu
ot;SELECT *
FROM `members`
WHERE
`username` =
'".$_POST[
'username'].&qu
ot;'");
$q3 =
mysql_fetch_obj
ect($q2);
if($q3->user
name ==
$_POST['usernam
e']) {
die('<BR>
;<BR>Sorr
y, but the
username
"'.$q3->
;username.'&quo
t; is taken,
please choose
another.');
}
//PASSWORD
if(!$_POST['pas
sword']) {
die('Error:
Password field
was blank');
}
if(!$_POST['ver
ify_password'])
{
die('Error:
Verify Password
field was
blank.');
}
if($_POST['pass
word'] !=
$_POST['verify_
password']) {
die('Error:
The passwords
do not
match.');
}
if(strlen($_POS
T['password'])
< 6 ) {
die('Error:
Your password
is too short.
Must be 6 or
more characters
in
length.');
}
//ADD NEW
MEMBER
$insert
="INSERT
INTO `members`
(username,
user_password,
user_email)
VALUES
('".$_POST
['username'].&q
uot;',
'".md5($_P
OST['password']
)."',
'".$_POST[
'email']."
')";
$insert2 =
mysql_query($in
sert);
if(!$insert2)
die(mysql_error
());
echo('Registrat
ion Successful,
Welcome new
member! You can
now login to
your new
account.');
} else {
?>
<table>
<form
name="sign
up"
action="&l
t;?
$_SERVER['PHP_S
ELF'];
?>"
method="PO
ST">
<tr>
<td>Usern
ame: <BR>
(only A-Z, 0-9
and _
Allowed)<BR&
gt;</td><
br />
<td><i
nput
type="text
" id
="username
"
name="user
name"
value="&qu
ot;
maxlength="
;30">
<BR></
td>
</tr>
<tr>
<td>Passw
ord:</td>
<td><i
nput
type="pass
word"
id="passwo
rd"
name="pass
word"
value="&qu
ot;
maxlength="
;30">&l
t;BR>
(minimum 6
characters)<
/td>
</tr>
<tr>
<td>Verif
y
Pass:</td>
;
<td><i
nput
type="pass
word"
id="verify
_password"
name="veri
fy_password&quo
t;
value="&qu
ot;
maxlength="
;30">&l
t;BR>
</td>
</tr>
<tr>
<td>Email
:</td>
<td><i
nput
type="text
"
id="email&
quot;
name="emai
l"
value="&qu
ot;
size="30&q
uot;><br&
gt;</td><
br />
</tr>
<tr>
<td>Click
to Complete
Signup:</td&
gt;
<td><i
nput
type="subm
it"
id="submit
"
name="subm
it"
value="sub
mit">&l
t;/td>
</tr>
</form><
br />
</table>
<?
} //end not
logged in
} //end submit
not pressed
?>
can anyone fix
this for me
?
thanks, Grant.
|