Not inserting to database

boboreo · October 14, 2010, 3:16pm

&lt;?php
include "config.php";

?&gt;
&lt;center&gt;&lt;H3&gt;Register for the LAN Event!&lt;/H3&gt;&lt;/center&gt;
&lt;form method="post" action="thankyou.php"&gt;

	&lt;div align="center"&gt;&lt;center&gt;&lt;table border="1" width="90%"&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;First Name&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="firstname" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;Last Name&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="lastname" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;Birthdate&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="birthdate" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;Email&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="email" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;Phone&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="phone" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;&lt;input type="submit" name="submit" value="Submit" /&gt;
			&lt;input type="reset" value="Reset" /&gt;&lt;/th&gt;
		&lt;/tr&gt;
	&lt;/table&gt;
	&lt;/center&gt;
	&lt;/div&gt;
&lt;/form&gt;
	
&lt;?
// registration checks


if($_POST['submit']){
 
$errors = ""; 
if (!isset($_POST['firstname'])) 
    $errors .= "Please provide a first name. &lt;br /&gt;"; 
if (!isset($_POST['lastname'])) 
    $errors .= "Please provide a last name. &lt;br /&gt;"; 
if (!isset($_POST['birthdate'])) 
    $errors .= "Please provide a birthdate. &lt;br /&gt;"; 
if (!isset($_POST['email'])) 
    $errors .= "Please provide a email address. &lt;br /&gt;"; 
if (!isset($_POST['phone'])) 
    $errors .= "Please provide a phone number. &lt;br /&gt;"; 
if ($errors == "") { 


// query

	$query = "INSERT INTO `attendees` (`firstname`,`lastname`,`birthdate`,`email`,`phone`) VALUES('".addslashes($_POST['firstname']) . "','" .addslashes($_POST['lastname']). "','" .addslashes($_POST['birthdate']). "','" .addslashes($_POST['email']). "','" .addslashes($_POST['phone']). "')";
	$result = mysql_query($query);
	if(!$result) error_message(sql_error());
}
}

?&gt;

I do not see any errors, but it is not inserting into the database. Can anyone tell me whats wrong?

boboreo · October 14, 2010, 5:53pm

Yes.

boboreo · October 14, 2010, 4:59pm

Yes, I have wamp server running. and both Apache and MySQL are running.

DarthGuido · October 14, 2010, 3:21pm

Is this the code of the ‘thankyou.php’ script?

boboreo · October 14, 2010, 4:13pm

How do you use mysql_real_escape_string?

and I took out the backticks.

DarthGuido · October 14, 2010, 4:22pm

Like addslashes. Just substitute addslashes with mysql_real_escape_string. But this won’t resolve your problem, it’s just something to improve the script

Please answer 2) and try to do 3) and let us know the results. Ah, and do an echo of $query please.

rguy84 · October 14, 2010, 4:09pm

try taking out your backticks in your query

DarthGuido · October 14, 2010, 4:09pm

don’t use addslashes, instead use mysql_real_escape_string
what does error_message() do? and where did you define that function?
you could add some echo’s in ‘thankyou.php’ to see what is executed and what not, and do a print_r of $_POST at the beginning of the script to check its values.

boboreo · October 14, 2010, 4:02pm

thankyou.php

&lt;?
include "config.php";

if($_POST['submit']){
 
$errors = ""; 
if (!isset($_POST['firstname'])) 
    $errors .= "Please provide a first name. &lt;br /&gt;"; 
if (!isset($_POST['lastname'])) 
    $errors .= "Please provide a last name. &lt;br /&gt;"; 
if (!isset($_POST['birthdate'])) 
    $errors .= "Please provide a birthdate. &lt;br /&gt;"; 
if (!isset($_POST['email'])) 
    $errors .= "Please provide a email address. &lt;br /&gt;"; 
if (!isset($_POST['phone'])) 
    $errors .= "Please provide a phone number. &lt;br /&gt;"; 
if ($errors == "") { 


// query

	$query = "INSERT INTO `attendees` (`firstname`,`lastname`,`birthdate`,`email`,`phone`) VALUES('".addslashes($_POST['firstname']) . "','" .addslashes($_POST['lastname']). "','" .addslashes($_POST['birthdate']). "','" .addslashes($_POST['email']). "','" .addslashes($_POST['phone']). "')";
	$result = mysql_query($query);
	if(!$result) error_message(sql_error());
}
}

	
?&gt;

DarthGuido · October 14, 2010, 3:56pm

Ok, then please post the entire ‘thankyou.php’ script.

DarthGuido · October 14, 2010, 3:43pm

nevermind… let me look at it.

DarthGuido · October 14, 2010, 3:45pm

Did you put the include to config.php in ‘thankyou.php’?

boboreo · October 14, 2010, 3:51pm

Yes I did.

boboreo · October 14, 2010, 3:40pm

This is now my thankyou.php file:

&lt;?
// registration checks


if($_POST['submit']){
 
$errors = ""; 
if (!isset($_POST['firstname'])) 
    $errors .= "Please provide a first name. &lt;br /&gt;"; 
if (!isset($_POST['lastname'])) 
    $errors .= "Please provide a last name. &lt;br /&gt;"; 
if (!isset($_POST['birthdate'])) 
    $errors .= "Please provide a birthdate. &lt;br /&gt;"; 
if (!isset($_POST['email'])) 
    $errors .= "Please provide a email address. &lt;br /&gt;"; 
if (!isset($_POST['phone'])) 
    $errors .= "Please provide a phone number. &lt;br /&gt;"; 
if ($errors == "") { 


// query

	$query = "INSERT INTO `attendees` (`firstname`,`lastname`,`birthdate`,`email`,`phone`) VALUES('".addslashes($_POST['firstname']) . "','" .addslashes($_POST['lastname']). "','" .addslashes($_POST['birthdate']). "','" .addslashes($_POST['email']). "','" .addslashes($_POST['phone']). "')";
	$result = mysql_query($query);
	if(!$result) error_message(sql_error());
}
}

	
?&gt;

And this is register.php:

&lt;center&gt;&lt;H3&gt;Register for the LAN Event!&lt;/H3&gt;&lt;/center&gt;
&lt;form method="post" action="thankyou.php"&gt;

	&lt;div align="center"&gt;&lt;center&gt;&lt;table border="1" width="90%"&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;First Name&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="firstname" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;Last Name&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="lastname" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;Birthdate&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="birthdate" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;Email&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="email" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;Phone&lt;/th&gt;
			&lt;td width="70%"&gt;&lt;input type="text" name="phone" size="15" /&gt;&lt;/td&gt;
		&lt;/tr&gt;
		&lt;tr&gt;
			&lt;th width="30%" nowrap&gt;&lt;input type="submit" name="submit" value="Submit" /&gt;
			&lt;input type="reset" value="Reset" /&gt;&lt;/th&gt;
		&lt;/tr&gt;
	&lt;/table&gt;
	&lt;/center&gt;
	&lt;/div&gt;
&lt;/form&gt;

and this is config.php:


&lt;?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

?&gt;

it just doesnt work. it wont connect i dont think. or my insert query is wrong. do you see any errors?

SpacePhoenix · October 14, 2010, 3:36pm

Try echoing $query, does anything look out of place? if you can’t see anything that looks out of place, try the query via phpmyadmin

DarthGuido · October 14, 2010, 3:36pm

Then you’ll have to move the PHP code at the end of the form to the top of ‘thankyou.php’. Or you’ll have to have the form call the ‘register.php’ script, move the PHP code to the top of the script, and in case of successful registration, redirect to ‘thankyou.php’

The point is, that the entire ‘register.php’ script is executed at once, server side, and then the resulting HTML page (the form) is sent to the browser. Once the user clicks the send button, the script DOES NOT continue at the end of the form. The script called by the form (in this case thankyou.php) is executed (on the server) from the beginning to the end, and the resulting HTML page is sent to the browser.
So, in your case, the part of the script that does the insert is never executed. The first time it isn’t executed because the form hasn’t been submitted yet, and after form submition it isn’t executed because the script that contains the insert code isn’t called.

boboreo · October 14, 2010, 3:31pm

No; this is register.php

rguy84 · October 14, 2010, 4:56pm

I see you have localhost listed… are you using xampp or something? if so is apache and mysql running?

boboreo · October 14, 2010, 4:55pm

The text that I put at the top of the page before the <?php tag. It showed up.

So, right now, the code looks like:


asdfjadfj
<?php
include "config.php";
print_r ($_POST);
?>

rguy84 · October 14, 2010, 4:23pm

…and? Did you suceed?

mysql_real_escape_string

Topic		Replies	Views
Registration form help PHP	2	773	October 8, 2014
Registration Page: Not adding user to database PHP	2	409	October 8, 2014
Not inserting Databases	4	276	October 28, 2010
Help with simple form/php code PHP	20	2451	October 8, 2014
Unable to insert data in Database using PHP.. below is my PHP code with Html. Thanks PHP	5	744	November 12, 2014

Not inserting to database

Related topics