dark k58 Posted June 16, 2012 Share Posted June 16, 2012 I got this code for a register page, it worked in my other website but when i copied it and edited the fields on my new website, it shows no errors but no data it being inserted in the database it does say that the registration is successful, please help thanks this is the code: <?php error_reporting(E_ALL); ini_set('display_errors', '1'); ?> <?php // Connect to the MySQL database include "../storescripts/connect_to_mysql.php"; //This code runs if the form has been submitted if (isset($_POST['submit'])) { //This makes sure they did not leave any fields blank if (!$_POST['firstname'] | !$_POST['surname'] | !$_POST['business_name'] | !$_POST['address1'] | !$_POST['city'] | !$_POST['postcode'] | !$_POST['telephone_number'] | !$_POST['mobile_number'] | !$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] | !$_POST['email'] ) { header("location: register_user_fail.php"); exit(); } // checks if the username is in use if (!get_magic_quotes_gpc()) { $_POST['username'] = addslashes($_POST['username']); } $usercheck = $_POST['username']; $check = mysql_query("SELECT username FROM user WHERE username = '$usercheck'") or die(mysql_error()); $check2 = mysql_num_rows($check); //if the name exists it gives an error if ($check2 != 0) { header("location: username_is_used.php"); exit(); } // this makes sure both passwords entered match if ($_POST['pass'] != $_POST['pass2']) { header("location: password_don't_match.php"); exit(); } // now we insert it into the database $insert = "INSERT INTO user (firstname, surname, business_name, address1, address2, address3, postcode, city, telephone_number, mobile_number, username, password, email) VALUES ('".$_POST['firstname']."', '".$_POST['surname']."', '".$_POST['business_name']."', '".$_POST['address1']."', '".$_POST['address2']."', '".$_POST['address3']."', '".$_POST['postcode']."', '".$_POST['telephone_number']."', '".$_POST['mobile_number']."', '".$_POST['username']."', '".$_POST['pass']."', '".$_POST['email']."')"; $add_member = mysql_query($insert); ?> <?php header("location: register_success.php"); exit(); ?> <?php } else { ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>User Register</title> <link rel="stylesheet" href="../style/style.css" type="text/css" media="screen" /> </head> <body> <div align="center" id="wrapper"> <?php include_once("user_login_template_header.php");?> <div id="content"> <table width="100%" border="0" cellspacing="0" cellpadding="10"> <tr> <td width="32%" valign="top"> </td> <td width="35%" valign="top"> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <table border="0"> <tr><td>First Name:</td><td> <input type="text" name="firstname" maxlength="60"> </td></tr> <tr><td>Surname:</td><td> <input type="text" name="surname" maxlength="60"> </td></tr> <tr><td>Business Name:</td><td> <input type="text" name="business_name" maxlength="60"> </td></tr> <tr><td>Address 1:</td><td> <input type="text" name="address1" maxlength="60"> </td></tr> <tr><td>Address 2:</td><td> <input type="text" name="address2" maxlength="60"> </td></tr> <tr><td>Address 3:</td><td> <input type="text" name="address3" maxlength="60"> </td></tr> <tr><td>Postcode:</td><td> <input type="text" name="postcode" maxlength="9"> </td></tr> <tr><td>City:</td><td> <input type="text" name="city" maxlength="60"> </td></tr> <tr><td>Telephone Number:</td><td> <input type="text" name="telephone_number" maxlength="12"> </td></tr> <tr><td>Mobile Number:</td><td> <input type="text" name="mobile_number" maxlength="12"> </td></tr> <tr><td>Username:</td><td> <input type="text" name="username" maxlength="60"> </td></tr> <tr><td>Password:</td><td> <input type="password" name="pass" maxlength="25"> </td></tr> <tr><td>Confirm Password:</td><td> <input type="password" name="pass2" maxlength="25"> </td></tr> <tr><td>Email:</td><td> <input type="email" name="email" maxlength="60"> </td></tr> <tr><th colspan=2><input type="submit" name="submit" value="Register"></th></tr> </table> </form> <br /> </p> <p><br /> </p></td> <td width="33%" valign="top"> </td> </tr> </table> </div> <?php include_once("../footer.php");?> </div> </body> </html> <?php } ?> Quote Link to comment https://forums.phpfreaks.com/topic/264286-my-data-is-not-going-to-the-database/ Share on other sites More sharing options...
Barand Posted June 16, 2012 Share Posted June 16, 2012 any error message? $add_member = mysql_query($insert); if (!$add_member) echo "$insert<br/>".mysql_error(); Quote Link to comment https://forums.phpfreaks.com/topic/264286-my-data-is-not-going-to-the-database/#findComment-1354377 Share on other sites More sharing options...
dark k58 Posted June 16, 2012 Author Share Posted June 16, 2012 no i got no error messages, everything goes perfectly but i can't see any data in the database i added that still not working Quote Link to comment https://forums.phpfreaks.com/topic/264286-my-data-is-not-going-to-the-database/#findComment-1354378 Share on other sites More sharing options...
Barand Posted June 16, 2012 Share Posted June 16, 2012 Strange, I would have expected something from that mysql_error() call if nothing is written. Quote Link to comment https://forums.phpfreaks.com/topic/264286-my-data-is-not-going-to-the-database/#findComment-1354380 Share on other sites More sharing options...
dark k58 Posted June 16, 2012 Author Share Posted June 16, 2012 Strange, I would have expected something from that mysql_error() call if nothing is written. I know, I used the same code on my other website but with different fields and it works Quote Link to comment https://forums.phpfreaks.com/topic/264286-my-data-is-not-going-to-the-database/#findComment-1354381 Share on other sites More sharing options...
Barand Posted June 16, 2012 Share Posted June 16, 2012 This line that I addedfor you should have given an error: if (!$add_member) echo "$insert<br/>".mysql_error(); You have 13 fields and 12 values ( city is missing a value) Quote Link to comment https://forums.phpfreaks.com/topic/264286-my-data-is-not-going-to-the-database/#findComment-1354383 Share on other sites More sharing options...
dark k58 Posted June 16, 2012 Author Share Posted June 16, 2012 This line that I addedfor you should have given an error: if (!$add_member) echo "$insert<br/>".mysql_error(); You have 13 fields and 12 values ( city is missing a value) yah I've already added that before, I don't know why but i got no errors Quote Link to comment https://forums.phpfreaks.com/topic/264286-my-data-is-not-going-to-the-database/#findComment-1354385 Share on other sites More sharing options...
PFMaBiSmAd Posted June 17, 2012 Share Posted June 17, 2012 You are probably not seeing any error message from the echo .... mysql_error() statement, because your page is redirecting and you likely have output_buffering turned on in your php.ini. Is the URL in your browser for the page where your INSERT query is on or is it for the register_success.php page? For debugging purposes, temporarily add an exit;/die; statement (or put the msyql_error statement inside of a die() statement) so that you know what execution path your code is actually taking. Also, you should not redirect to the register_success.php unless you have tested that the INSERT query actually executed without any errors and that it inserted the row into the table. See: mysql_affected_rows Quote Link to comment https://forums.phpfreaks.com/topic/264286-my-data-is-not-going-to-the-database/#findComment-1354595 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.