Not writing to mySQL database

**navaldesign** · 02-08-2011, 08:52 PM

Re: Not writing to mySQL database

Host should be "localhost" and not 127...........

**tbronson7** · 02-09-2011, 04:15 PM

Re: Not writing to mySQL database

alright thank you, i changed that, now im not getting any errors but its still not writing to the mySQl database, is there any reason this code isnt working?

<?PHP
//session_start();if (!(isset($_SESSION['login']) && $_SESSION['login'] != '')) {header ("Location: account.php");}

//set the session variable to 1, if the user signs up. That way, they can use the site straight away
//do you want to send the user a confirmation email?
//does the user need to validate an email address, before they can use the site?
//do you want to display a message for the user that a particular username is already taken?
//test to see if the u and p are long enough
//you might also want to test if the users is already logged in. That way, they can't sign up repeatedly without closing down the browser
//other login methods - set a cookie, and read that back for every page
//collect other information: date and time of login, ip address, etc
//don't store passwords without encrypting them

$uname = "";
$pword = "";
$cpword = "";
$email = "";
$fname = "";
$lname = "";
$errorMessage = "";
$num_rows = 0;

//function quote_smart($value, $handle) {

// if (get_magic_quotes_gpc()) {
// $value = stripslashes($value);
//}

//if (!is_numeric($value)) {
// $value = "'" . mysql_real_escape_string($value, $handle) . "'";
//}
//return $value;
//}

if ($_SERVER['REQUEST_METHOD'] == 'POST'){

//================================================== ==================
// GET THE CHOSEN U AND P, AND CHECK IT FOR DANGEROUS CHARCTERS
//================================================== ==================
$uname = $_POST['username'];
$pword = $_POST['password'];
$cpword = $_POST['cpassword'];
$email = $_POST['email'];
$fname = $_POST['firstname'];
$lname = $_POST['lastname'];

$uname = htmlspecialchars($uname);
$pword = htmlspecialchars($pword);

//================================================== ==================
// CHECK TO SEE IF U AND P ARE OF THE CORRECT LENGTH
// A MALICIOUS USER MIGHT TRY TO PASS A STRING THAT IS TOO LONG
// if no errors occur, then $errorMessage will be blank
//================================================== ==================

$uLength = strlen($uname);
$pLength = strlen($pword);

if ($uLength >= 10 && $uLength <= 20) {
$errorMessage = "";
}
else {
$errorMessage = $errorMessage . "Username must be between 10 and 20 characters" . "<BR>";
}

if ($pLength >= 8 && $pLength <= 16) {$errorMessage = "";}
else {$errorMessage = $errorMessage . "Password must be between 8 and 16 characters" . "<BR>";
}

if ($pword == $cpword){$errorMessage = "";}
else {$errorMessage = $errorMessage . "Your passwords do not match" . "<BR>";}

//test to see if $errorMessage is blank
//if it is, then we can go ahead with the rest of the code
//if it's not, we can display the error

//================================================== ==================
// Write to the database
//================================================== ==================
if ($errorMessage == "") {

$user_name = "*****bid_admin";
$pass_word = "!7HardCore!7";
$database = "*****bid_usersdb";
$server = "localhost";

$db_handle = mysql_connect($server, $user_name, $pass_word) OR die (mysql_error());
$db_found = mysql_select_db($database, $db_handle);

if ($db_found) {

//$uname = quote_smart($uname, $db_handle);
//$pword = quote_smart($pword, $db_handle);
//$email = quote_smart($email, $db_handle);
//$fname = quote_smart($fname, $db_handle);
//$lname = quote_smart($lname, $db_handle);

//================================================== ==================
// CHECK THAT THE USERNAME IS NOT TAKEN
//================================================== ==================

//$SQL = "SELECT * FROM users WHERE UN = $uname";
//$result = mysql_query($SQL);
//$num_rows = mysql_num_rows($result);

$SQL = "SELECT COUNT(UN) AS UN$uname FROM users WHERE UN=$uname";
$result = mysql_query($SQL);

if ($result > 0) {
$errorMessage = "Username already taken";
}

else {

$SQL = "INSERT INTO users (UN, PW, EM, FN, LN) VALUES ($uname, md5($pword), $email, $fname, $lname)";

$result = mysql_query($SQL);

mysql_close($db_handle);
print "User Successfully Created!";

//================================================== ===============================
// START THE SESSION AND PUT SOMETHING INTO THE SESSION VARIABLE CALLED login
// SEND USER TO A DIFFERENT PAGE AFTER SIGN UP
//================================================== ===============================

//session_start();
//$_SESSION['login'] = "1";

//header ("Location: account.php");

}

}
else {
$errorMessage = "Database Not Found";
}

}

}

?>

**navaldesign** · 02-09-2011, 07:39 PM

Re: Not writing to mySQL database

As you understand I can't analyze all your code to see where you might be wrong.

Add this line

error_reporting(E_ALL);

just as second line, after <?PHP

so PHP will report any errors and you might find out is wrong.
After you fix it, remove (or comment with //) this line before going live.

**tbronson7** · 02-09-2011, 09:56 PM

Re: Not writing to mySQL database

of course i understand, added the line, still not writing to the database and not reporting any errors

**tbronson7** · 02-09-2011, 09:58 PM

Re: Not writing to mySQL database

belay my last, it is reporting 6135 as an error

**navaldesign** · 02-11-2011, 07:19 PM

Re: Not writing to mySQL database

MySql should report an error in text . If it doesn't I'm afraid there is not much I can do to help you.

You would need to modify your queries to report the MySQL error.

Not writing to mySQL database

Not writing to mySQL database

Comment

Comment

Comment

Comment

Comment

Comment