INSERT help for Newbie

kirkenall · January 11, 2010

Hi good people. I am trying to put together a simple application where I take info from an html form and insert it into a mySQL db. everything appears to work proper but a new record is never actually created in the db. Below is the PHP code. Thanks in advance for any assistance.

<?php

$con = mysql_connect ("localhost", "root", "xxxx");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db ("registrants")or die(mysql_error());

$ebits = ini_get('error_reporting');

error_reporting($ebits ^ E_NOTICE);

$firstname =$_POST["firstname"];

$lastname = $_POST["lastname"];

$dateofbirth =$_POST["dateofbirth"];

$ss = $_POST["ss"];

$address = $_POST["address"];

$apt = $_POST["apt"];

$city = $_POST["city"];

$state =$_POST["state"];

$zip = $_POST["zip"];

$email = $_POST["email"];

$homephone = $_POST["homephone"];

$cell = $_POST["cell"];

$Sex = $_POST["Sex"];

$maritalstat = $_POST["maritalstat"];

$race = $_POST["race"];

$citizen = $_POST["citizen"];

mysql_query ("INSERT INTO registrants (first name, last name, date of birth, ss#, address, city, state, zipcode, email, homephone, cellphone, sex, marriage, ethnicity, citizen, apt#, id) Values ('$firstname', '$lastname', '$dateofbirth', '$ss', '$address', '$city', '$state', '$zip', '$email', '$homephone', '$cell', '$Sex', '$maritalstat', '$race', '$citizen', '$apt', 'NULL')");

?>

kirkenall · January 11, 2010

Here is the form info:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Registration</title>

<!--

body {

background-color: #F90;

font-size: medium;

}

#form1 table tr td div label {

color: #FFF;

}

#form1 table {

color: #FFF;

font-size: 24px;

}

-->

</style></head>

<body>

</label>

<tr>

<div align="right">First Name</div>

</label> </td>

</div></td>

</tr>

<tr>

</label> </td>

</div></td>

</tr>

<tr>

<div align="right">Date of Birth</div>

</label> </td>

</div></td>

</tr>

<tr>

<div align="right">Social Security #</div>

</label> </td>

</div></td>

</tr>

<tr>

<div align="right">Address</div>

</label> </td>

</div></td>

</tr>

<tr>

</label> </td>

</div></td>

</tr>

<tr>

</label> </td>

</div></td>

</tr>

<tr>

<div align="right">State</div>

</label> </td>

</div></td>

</tr>

<tr>

<div align="right">Zipcode</div>

</label> </td>

</div></td>

</tr>

<tr>

<div align="right">email Address</div>

</label> </td>

</div></td>

</tr>

<tr>

<div align="right">Home Phone</div>

</label> </td>

</div></td>

</tr>

<tr>

<div align="right">Cell Phone</div>

</label> </td>

</div></td>

</tr>

<tr>

</label> </td>

<p>

<label>

Male</label>

<label>

Female</label>

<br />

</p>

</div></td>

</tr>

<tr>

<div align="right">Marital Status</div>

</label> </td>

<option value="1">Never Married</option>

<option value="2">Divorced</option>

<option value="3">Widowed</option>

<option value="4">Separated</option>

<option value="5">Married</option>

</select></td>

</tr>

<tr>

<label for="race">Race/Ethnicity</label>

</div></td>

<option value="1">African American</option>

<option value="2">Hispanic or Latino</option>

<option value="3">American Indian or Native Alaskan</option>

<option value="4">White or Caucasian</option>

<option value="5">Multi-racial</option>

<option value="6">Asian Pacific Islander</option>

<option value="7">Other</option>

</select></td>

</tr>

<tr>

<p><label>Are you a US Citizen?</label><br />

</p>

</div></td>

<label>Yes

No </label></td>

</tr>

<tr>

</tr>

<tr>

</div></td>

</tr>

</table>

</form>

</body>

</html>

Catfish · January 11, 2010

check your mysql query works with an if() conditional and output the error on failure:

if (mysql_query ("INSERT INTO registrants (first name, last name, date of birth, ss#, address, city, state, zipcode, email, homephone, cellphone, sex, marriage, ethnicity, citizen, apt#, id) Values ('$firstname', '$lastname', '$dateofbirth', '$ss', '$address', '$city', '$state', '$zip', '$email', '$homephone', '$cell', '$Sex', '$maritalstat', '$race', '$citizen', '$apt', 'NULL')"))
{
   // succeeded. continue with code
}
else
   print("Could not INSERT data to database. Error given: ".mysql_error()."<br/>\n");

the link in my signature has a short topic on flow control which shows you this method to validate all your script's actions as you go. it's a handy way to code.

Adam · January 11, 2010

Here's your problem:

mysql_query ("INSERT INTO registrants (first name, last name, date of birth, ss#, address, city, state, zipcode, email, homephone, cellphone, sex, marriage, ethnicity, citizen, apt#, id) Values ('$firstname', '$lastname', '$dateofbirth', '$ss', '$address', '$city', '$state', '$zip', '$email', '$homephone', '$cell', '$Sex', '$maritalstat', '$race', '$citizen', '$apt', 'NULL')");

kirkenall · January 11, 2010

Catfish---thanks for the reply,

I tried your code and received the following error: Could not INSERT data to database. Error given: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'name, last name, date of birth, ss#, address, city, state, zipcode, email, homep' at line 1

kirkenall · January 11, 2010

MrAdam---thank you too for the reply....I tried your code too and still the same results .....no record is created in the db.

MatthewJ · January 11, 2010

field names with spaces must be enclosed with backticks (`)

kirkenall · January 11, 2010

MattewJ....I am not seeing the field names with spaces......I do not want spaces

MatthewJ · January 11, 2010

"INSERT INTO registrants (first name, last name, date of birth, ss#, address, city, state, zipcode, email, homephone, cellphone, sex, marriage, ethnicity, citizen, apt#, id) Values ('$firstname', '$lastname', '$dateofbirth', '$ss', '$address', '$city', '$state', '$zip', '$email', '$homephone', '$cell', '$Sex', '$maritalstat', '$race', '$citizen', '$apt', 'NULL')"

kirkenall · January 11, 2010

MatthewJ....Same thing. After I changed the code to your rec. I still receive the following after running the code and then checking for a new record in PHPMyAdmin...............................MySQL returned an empty result set (i.e. zero rows).

Lamez · January 11, 2010

in your database, edit the column with the # sign, remove it, then edit your query.

kirkenall · January 11, 2010

I edited out the # sign and am still getting the same result. No record is added to the db when the script is ran.

kirkenall · January 11, 2010

Thanks for all of the help.....you people are great. The problem had to do with having spaces in the column names.

Catfish · January 12, 2010

rofl. that's what he said 6 posts back

Sign In

INSERT help for Newbie

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Archived

Important Information