Re: php inserts into DB

From: The Natural Philosopher <a@xxx>
Date: Sat, 09 Feb 2008 00:41:07 +0000

fb wrote:

Hello. I have some php code that is supposed to throw stuff into a database...the only problem is that it doesn't put anything in the database. It simply continues on it's way and says "You have registered" when really it hasn't touched the DB (other than to connect). Any ideas as to what is wrong?

I posted the whole code, because it didn't seem that long...hope it's not too bad. It doesn't seem to look so great in the newsreader window, but it should cut-and-paste just fine (and with better formatting). Thanks.

When I amd doing all this stuff,I echo te query to teh browser, and cut and paste it into an interactive mysql session to test if it doesn;t work..

//CODE STARTS HERE

<?php
// Connects to your Database
mysql_connect("localhost", "me", "myPass") or die(mysql_error());
mysql_select_db("myDB") or die(mysql_error());

//This code runs if the form has been submitted
if (isset($_POST['submit'])) {

//This makes sure they did not leave any MANDATORY fields blank
if (!$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] | !$_POST['fname'] |
!$_POST['lname'] | !$_POST['country'] | !$_POST['email']) {
die('You did not complete all of the required fields');
}

// 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 person WHERE username = '$usercheck'") or die(mysql_error());
$check2 = mysql_num_rows($check);

//if the name exists it gives an error
if ($check2 != 0) {
die('Sorry, the username '.$_POST['username'].' is already in use.');
}

// this makes sure both passwords entered match
if ($_POST['pass'] != $_POST['pass2']) {
die('Your passwords did not match. ');
}

//Here we encrypt the password (simple md5 hash), etc and add slashes if needed
//Blowfish encryption coming soon!
$_POST['pass'] = md5($_POST['pass']);
$_POST['username'] = md5($_POST['username']);
$_POST['fname'] = md5($_POST['fname']);
$_POST['lname'] = md5($_POST['lname']);
$_POST['country'] = md5($_POST['country']);
$_POST['province'] = md5($_POST['province']);
$_POST['city'] = md5($_POST['city']);
$_POST['pCode'] = md5($_POST['pCode']);
$_POST['suiteNum'] = md5($_POST['suiteNum']);
$_POST['streetNum'] = md5($_POST['streetNum']);
$_POST['streetName'] = md5($_POST['streetName']);
$_POST['DOB'] = md5($_POST['DOB']); //We should probably remove this...
$_POST['email'] = md5($_POST['email']);
if (!get_magic_quotes_gpc()) {
$_POST['pass'] = addslashes($_POST['pass']);
$_POST['username'] = addslashes($_POST['username']);
$_POST['fname'] = addslashes($_POST['fname']);
$_POST['lname'] = addslashes($_POST['lname']);
$_POST['country'] = addslashes($_POST['country']);
$_POST['province'] = addslashes($_POST['province']);
$_POST['city'] = addslashes($_POST['city']);
$_POST['pCode'] = addslashes($_POST['pCode']);
$_POST['suiteNum'] = addslashes($_POST['suiteNum']);
$_POST['streetNum'] = addslashes($_POST['streetNum']);
$_POST['streetName'] = addslashes($_POST['streetName']);
$_POST['DOB'] = addslashes($_POST['DOB']); //We should probably remove this...
$_POST['email'] = addslashes($_POST['email']);
}

I thi
nk this may be where its going wrong...

//now we insert it into the database
$insertMember = "INSERT INTO person (username, password, firstname, lastname, DOB)
VALUES ('$_POST[username]', '$_POST[pass]', '$_POST[fname]',

try VALUES('".$_POST['username']."','".$_POST...and so on..
terminate the string and concatenate the variable, or use sprintf to format the string correctly.

'$_POST[lname]', '$_POST[DOB]')";
$add_member = mysql_query($insertMember);
$insertAddress = "INSERT INTO address (country, province, city, postalCode, suiteNum, streetNum, streetName, email)
VALUES ('$_POST[country]', '$_POST[province]', '$_POST[city]', '$_POST[pCode]',
'$_POST[suiteNum]', '$_POST[streetNum]', '$_POST[streetName]', '$_POST[email]')";
$add_address = mysql_query($insertAddress);
?>

<h1>Registered</h1>
<p>Thank you, you have registered - you may now login</a>.</p>

<?php
}
else
{
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="0">
<tr>
<td>First name:</td>
<td><input type="text" name="fname" maxlength="35"></td>
</tr>
<tr>
<td>Last name:</td>
<td><input type="text" name="lname" maxlength="50"></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="10"></td>
</tr>
<tr>
<td>Confirm Password:</td>
<td><input type="password" name="pass2" maxlength="10"></td>
</tr>
<tr>
<td>Date of Birth:</td>

<td><input type="text" name="DOB" maxlength="60"></td>
</tr>

<br />

<tr>
<td>Select Country:</td>
<td>
<select NAME="country">
<option VALUE="phil">Phil</option>
<option VALUE="usa">USA</option>
<option VALUE="can" selected>Canada</option>
</select>
</td>
</tr>
<tr>
<td>Select Province</td>
<td>
<select NAME="province">
<option VALUE="MB"selected="selected">Manitoba</option>
<option VALUE="AB">Alberta</option>
<option VALUE="ON">Ontario</option>
<option VALUE="BC">British Colombia</option>
<option VALUE="SK">Saskatchewan</option>
<option VALUE="YT/YK">Yukon</option>
<option VALUE="PC/QC">Quebec</option>
<option VALUE="PE">Prince Edward Island</option>
<option VALUE="NS">Nova Scotia</option>
<option VALUE="NL">Newfoundland</option>
<option VALUE="NT">Northwest Territories</option>
<option VALUE="NU">Nunavut</option>
<option VALUE="NB">New Brunswick</option>
</select>
</td>
</tr>
<tr>
<td>city:</td>
<td> <input type="text" name="city" /></td>
</tr>
<tr>
<td>postal_code :</td>
<td><input type= "text" name="pCode"/></td>
</tr>
<tr>
<td>suite_num :</td>
<td><input type= "number" name="suiteNum" /></td>
</tr>
<tr>
<td>street_num :</td>
<td><input type= "number" name="streetNum" /></td>
</tr>
<tr>
<td>street_name :</td>
<td><input type= "text" name="streetName"/></td>
</tr>
<tr>
<td>email :</td>
<td><input type= "text" name= "email"/></td>
</tr>
<tr>
<th colspan=2><input type="submit" name="submit" value="Register"></th>
<th colspan=2><input type="reset" value="Clear Form"></th>
</tr>
</table>

</form>

<?php
}
?>
//CODE ENDS HERE

References:
- php inserts into DB
  - From: fb

Prev by Date: Re: GIS shapefiles question
Next by Date: Re: How much execution time is left?
Previous by thread: php inserts into DB
Next by thread: Re: php inserts into DB
Index(es):
- Date
- Thread

Relevant Pages

Re: Pathname to access and usernames in shortcut
... >> network drive (for maintenance reasons initially, ... >> using usernames but no passwords. ... change their passwords within the access database (they won't know how ... >> gets the current username from the system and then calls access (via the ...
(microsoft.public.access.security)
Re: access database field names in Javascript
... You need quotes around the string values, and you need to concatenate the ... > I trying to get information from a simple MS Access database named users ... > (username, password and stylesheet). ... > The database connection I'm using and where the SQLstr will be used is: ...
(microsoft.public.access.formscoding)
Re: Table comparison
... a text box on a hidden form, that gets the username that's logged into the ... database, and what forms they may open up. ... the same GetUserIDthat i use to get the username originally. ... was having it treat this as a string. ...
(microsoft.public.access.modulesdaovba)
Re: Malfunctioning of JSP application
... Username and Passwords are stored in a Oracle database. ... You rarely, if ever, should declare instance variables in a JSP. ...
(comp.lang.java.programmer)
Re: php inserts into DB
... database...the only problem is that it doesn't put anything in the database. ... // checks if the username is in use ... die('Your passwords did not match. ...
(comp.lang.php)