Wont insert into mysql

Question

whiteyoh 0 Posting Pro in Training

14 Years Ago

Hi All,

Help if you can,

The following script wont insert a row into my table.

There is an auto increment field at the start of the table called "ID".

<?php
	// this is processed when the form is submitted
	// back on to this page (POST METHOD)
	if ($_SERVER['REQUEST_METHOD'] == "POST") {

		// double-up apostrophes
		$firstname = $_POST['firstname'];
		$lastname = $_POST['lastname'];
		$email = $_POST['email'];
		$add1 = $_POST['add1'];
		$add2 = $_POST['add2'];
		$town = $_POST['town'];
		$statecounty = $_POST['statecounty'];
		$postzip = $_POST['postzip'];

		// setup SQL statement
		$SQL = " INSERT INTO tbl_sellers";
		$SQL = $SQL . " '', sellerFirstName, sellerLastName, email, Address1, Address2, sellerTownCity, sellerStateProvince, zipPostCode) VALUES ";
		$SQL = $SQL . " ('', '$firstname', '$lastname', '$email','$add1','$add2', '$town', '$statecounty', '$postzip') ";

		//execute SQL statement
		$result = mysql_db_query($db,"$SQL",$cid);

		// check for error
		if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n");	}

		echo ("<p><b>New Link Added</b></p>\n");

	}

?>

mysql php

3 Contributors
19 Replies
136 Views
7 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by JRM

ShawnCplus 456 Code Monkey

14 Years Ago

You have a syntax error, you're missing the beginning parenthesis before the field list. Which this line will tell you.

if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n");	}

ShawnCplus 456 Code Monkey

14 Years Ago

If ID is autoincrement don't include it in the field or value list.

ShawnCplus 456 Code Monkey

14 Years Ago

Don't remove ID from the database, just remove it from the field list. Also, what was the error that you got (Not the query, the actual text from ERROR: blah)

ShawnCplus 456 Code Monkey

14 Years Ago

What is the value of $db by the way. I don't see you setting it anywhere. Or $cid for that matter.

ShawnCplus 456 Code Monkey

14 Years Ago

Is all of this code on the same page? If the connection isn't opened on the same page as the one that executes it then it isn't defined.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

whiteyoh 0 Posting Pro in Training · Answer 1 · 2010-01-26T22:07:37+00:00

Hi,

Thanks for your response.

The error i am getting is:
INSERT INTO tbl_sellers (ID, sellerFirstName, sellerLastName, email, Address1, Address2, sellerTownCity, sellerStateProvince, zipPostCode) VALUES ('', 'kjh', '', '','','', '', '', '')

This was a huffy random entry, but the error is in the sql statement???

The columns here match the database, which is what i dont understand.

whiteyoh 0 Posting Pro in Training · Answer 2 · 2010-01-26T22:14:06+00:00

I have tried it with and without any reference to ID, whatever i do i get the same error message.

whiteyoh 0 Posting Pro in Training · Answer 3 · 2010-01-26T22:14:41+00:00

i even tried removing the autoincrement from inside the database, and remove ID all together from everything....... but the same.... baffled!

whiteyoh 0 Posting Pro in Training · Answer 4 · 2010-01-26T22:24:41+00:00

Hi,

The exact error, copied from the screen is:
ERROR: INSERT INTO tbl_sellers (sellerFirstName, sellerLastName, email, Address1, Address2, sellerTownCity, sellerStateProvince, zipPostCode) VALUES ('h', 'h', 'j','k','hg', 'g', 'ug', 'h')

which is also wierd!

ive checked through some syntax of other times ive done this and its all the same. Ive a boogie man in my code

whiteyoh 0 Posting Pro in Training · Answer 5 · 2010-01-26T22:30:01+00:00

ive just put an echo into my connection string and its showing Resource id #1

whiteyoh 0 Posting Pro in Training · Answer 6 · 2010-01-26T22:34:12+00:00

that is the form.

here it is

<?php

	// insert_link.phps from blazonry.com
	// part of the web database tutorial for MySQL and PHP 


	$usr = "*******";
	$pwd = "*******";
	$db = "*******";
	$host = "localhost";

	// connect to database
	echo $cid = mysql_connect($host,$usr,$pwd);
	if (!$cid) { echo("ERROR: " . mysql_error() . "\n");	}

?>
<html>
<head>
   <title>blazonry.com database tutorial - Insert Data lesson</title>

</head>
<body bgcolor="#ffffff">

<p><font size=5><b> Add Link </b> </font></p>



<form name="fa" action="insert_link.php" method="post">
<table>
<tr><td><b>First Name: </b> </td><td><input type="text" name="firstname" size=40></td></tr>
<tr><td><b>Surname:</b> </td><td><input type="text" name="lastname" size=40></td></tr>
<tr><td><b>Email: </b> </td><td><input type="text" name="email" size=40></td></tr>
<tr><td><b>Address 1:</b> </td><td><input type="text" name="add1" size=40></td></tr>
<tr><td><b>Address 2: </b> </td><td><input type="text" name="add2" size=40></td></tr>
<tr><td><b>Town:</b> </td><td><input type="text" name="town" size=40></td></tr>
<tr><td><b>County: </b> </td><td><input type="text" name="statecounty" size=40></td></tr>
<tr><td><b>Post Code:</b> </td><td><input type="text" name="postzip" size=40></td></tr>

<tr><th colspan=2><p><input type="submit" value="submit"></p></th></tr>
</table>
</form>


</body>
</html>

whiteyoh 0 Posting Pro in Training · Answer 7 · 2010-01-26T22:34:27+00:00

that is the form.

here it is

<?php

	// insert_link.phps from blazonry.com
	// part of the web database tutorial for MySQL and PHP 


	$usr = "*******";
	$pwd = "*******";
	$db = "*******";
	$host = "localhost";

	// connect to database
	echo $cid = mysql_connect($host,$usr,$pwd);
	if (!$cid) { echo("ERROR: " . mysql_error() . "\n");	}

?>
<html>
<head>
   <title>blazonry.com database tutorial - Insert Data lesson</title>

</head>
<body bgcolor="#ffffff">

<p><font size=5><b> Add Link </b> </font></p>



<form name="fa" action="insert_link.php" method="post">
<table>
<tr><td><b>First Name: </b> </td><td><input type="text" name="firstname" size=40></td></tr>
<tr><td><b>Surname:</b> </td><td><input type="text" name="lastname" size=40></td></tr>
<tr><td><b>Email: </b> </td><td><input type="text" name="email" size=40></td></tr>
<tr><td><b>Address 1:</b> </td><td><input type="text" name="add1" size=40></td></tr>
<tr><td><b>Address 2: </b> </td><td><input type="text" name="add2" size=40></td></tr>
<tr><td><b>Town:</b> </td><td><input type="text" name="town" size=40></td></tr>
<tr><td><b>County: </b> </td><td><input type="text" name="statecounty" size=40></td></tr>
<tr><td><b>Post Code:</b> </td><td><input type="text" name="postzip" size=40></td></tr>

<tr><th colspan=2><p><input type="submit" value="submit"></p></th></tr>
</table>
</form>


</body>
</html>

whiteyoh 0 Posting Pro in Training · Answer 8 · 2010-01-26T22:39:06+00:00

i had a thought that it could be lack of a database name, so i used dot notation in the sql, but to no avail and same error

whiteyoh 0 Posting Pro in Training · Answer 9 · 2010-01-26T22:43:57+00:00

it doesnt, the form.php uses the php code, defined in the top of the form.

It has to be sending it accross, as the error contains what i input into the form

ShawnCplus 456 Code Monkey Team Colleague · Answer 10 · 2010-01-26T22:45:38+00:00

it doesnt, the form.php uses the php code, defined in the top of the form.
It has to be sending it accross, as the error contains what i input into the form

If the only way the two are connect is because one page POSTs to the other then you need to have the connection code in both places.

JRM 107 Practically a Master Poster · Answer 11 · 2010-01-26T22:45:45+00:00

Your query keeps morphing so it's difficult for someone to keeps up.
For test purposes, why not stick with a single query and get THAT working. move on to the next issue?
Put the auto -increment ID back and:

INSERT INTO tbl_sellers (sellerFirstName, sellerLastName, email, Address1, Address2, sellerTownCity, sellerStateProvince, zipPostCode) VALUES ('h', 'h', 'j','k','hg', 'g', 'ug', '12345')

What is the table structure?
If zip is cast to int, the 'h' wont fly.

whiteyoh 0 Posting Pro in Training · Answer 12 · 2010-01-26T22:51:13+00:00

champion!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

3 points

whiteyoh 0 Posting Pro in Training · Answer 13 · 2010-01-26T22:51:28+00:00

champion!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

3 points

JRM 107 Practically a Master Poster · Answer 14 · 2010-01-26T23:21:53+00:00

JRM 107 Practically a Master Poster

14 Years Ago

Great! Please mark as solved...
Thanks