Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampplite\htdocs\register.php on line 98
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampplite\htdocs\register.php on line 98
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampplite\htdocs\register.php on line 99
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampplite\htdocs\register.php on line 107
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampplite\htdocs\register.php on line 107
Registration Failed!
Thats what happens when i try to register. Yes, i used the search engine, and i couldnt find anything.
Thanks in advance:drool:Code:<div id="text">
<h1>Welcome</h1>
<form action="?op=register" method="post">
<div align="center"><br />
</div>
<table width="338" border="0" align="center">
<tr>
<td width="132" height="20" class="b01">Username:</td>
<td width="196"><label>
<input name="user" type="text" class="liteoption" id="user" size="15" maxlength="15" />
</label></td>
</tr>
<tr>
<td height="25" class="b01">Password:</td>
<td><input name="pass1" type="password" class="liteoption" id="pass1" size="15" maxlength="15" /></td>
</tr>
<tr>
<td height="24" class="b01">Repeat Password: </td>
<td><input name="pass2" type="password" class="liteoption" id="pass2" size="15" maxlength="15" /></td>
</tr>
</table>
<p align="center"> </p>
<p align="center">
<input name="submit" type="submit" class="liteoption" value="Register" />
</p>
</form>
<div align="center">
<?php
if(isset($_POST['submit'])) {
if(!$_POST['user'] || !$_POST['pass1'] || !$_POST['pass2']) {
die('You must fill in all of the feilds!!!<BR>');
}
if(!get_magic_quotes_gpc()) {
$user = addslashes($_POST['user']);
$pass = md5($_POST['pass1']);
} else {
$user = $_POST['user'];
$pass = md5($_POST['pass1']);
}
$pass2 = md5($_POST['pass2']);
$check = mysql_query("SELECT * FROM accounts WHERE username = '$user'");
$check2 = mysql_num_rows($check);
if($check2 != '0') {
die("Username: '".$user."' is in use!");
}
if($pass != $pass2) {
die('Passwords dont match!');
}
$insert_member = mysql_query("INSERT INTO accounts (username, password, active) VALUES ('$user', '$pass', '1')");
if($insert_member) {
echo("<p class='b01'>Registration Complete! <a href=?op=home>Click here</a>");
} else {
echo("<p class='b01'>Registration Failed!</p>");
}}
?>
</div>
