Submitting a form does not add data to MySQL database

brokenshadows

To start, let me say that I'm new to both MySQL and PHP. If fact, this is the first time I've tried to build anything from scratch with both. I've worked with databases before and have a good understanding of how they are supposed to work, but I obviously have no idea how to use PHP to connect to one.

If my question has been answered in another post, please accept my apologies and direct me to said post.

My problem is that I have a database that I'm trying to add data into using a simple form. When I fill in the form and hit my Submit button...nothing happens beyond the form fields clearing themselves. After hitting Submit, I pull up the database in phpMyadmin and there is no new data to be seen anywhere.

Here's the code for the form page:

 
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>RMVD</title>
</head>

<body>
<form id="contacts" name="contacts" method="post" action"contacts_insert.php">
<p>Parent's First Name:
<input name="first" type="varchar" id="first" />
</p>
<p>Parent's Last Name:
<input name="last" type="varchar" id="last" />
</p>
<p>Second Parent's First Name:
<input name="first2" type="varchar" id="first2" />
</p>
<p>Parent's Last Name:
<input name="last2" type="varchar" id="last2" />
</p>
<p>Home Phone:
<input name="homephone" type="varchar" id="homephone" />
</p>
<p>Cell Phone:
<input name="cellphone" type="varchar" id="cellphone" />
</p>
<p>Work Phone:
<input name="workphone" type="varchar" id="workphone" />
</p>
<p>E-Mail Address:
<input name="email" type="varchar" id="email" />
</p>
<input type="submit" name="Submit" value="Submit" />
</form>


</body>
</html>

And the code for contacts_insert.php

 
<?php
$host="***removed***";
$user="***removed***";
$password="***removed***";
$database="contacts";

mysql_connect($host,$user,$password)or die("Can not connect DB");
@mysql_select_db($database) or die( "Unable to select database");

$first=$_POST['first'];
$last=$_POST['last'];
$first2=$_POST['first2'];
$last2=$_POST['last2'];
$homephone=$_POST['homephone'];
$cellphone=$_POST['cellphone'];
$workphone=$_POST['workphone'];
$email=$_POST['email'];
mysql_query("INSERT INTO contacts(first, last, first2, last2, homephone, cellphone, workphone, email) values('$first','$last','$first2','$last2','$homephone','$cellphone','$workphone','$email')");
mysql_close();
?>

Here is the SHOW CREATE TABLE information:

Table 	Create Table
contacts 	CREATE TABLE `contacts` (
 `id` int(6) NOT NULL auto_increment,
 `first` varchar(30) NOT NULL,
 `last` varchar(30) NOT NULL,
 `first2` varchar(30) NOT NULL,
 `last2` varchar(30) NOT NULL,
 `homephone` varchar(20) NOT NULL,
 `cellphone` varchar(20) NOT NULL,
 `workphone` varchar(20) NOT NULL,
 `email` varchar(30) NOT NULL,
 PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8

and the EXPLAIN data:

Generation Time: Apr 22, 2009 at 11:59 AM
Generated by: phpMyAdmin 2.11.9.4 / MySQL 5.0.67.d7-ourdelta-log
SQL query: EXPLAIN contacts ;
Rows: 9
Field 	Type 	Null 	Key 	Default 	Extra
id 	int(6) 	NO 	PRI 	NULL 	auto_increment
first 	varchar(30) 	NO 	  	NULL 	 
last 	varchar(30) 	NO 	  	NULL 	 
first2 	varchar(30) 	NO 	  	NULL 	 
last2 	varchar(30) 	NO 	  	NULL 	 
homephone 	varchar(20) 	NO 	  	NULL 	 
cellphone 	varchar(20) 	NO 	  	NULL 	 
workphone 	varchar(20) 	NO 	  	NULL 	 
email 	varchar(30) 	NO 	  	NULL

I'm sure I missed something simple and will subsequently feel like an idiot when it has been pointed out to me...but I'm willing to risk it and would appreciate any help you could offer me.

devinemke

<html>
<head>
<title>RMVD</title>
<body>

<?php
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="post">
	<p>Parent\'s First Name: <input name="first" type="text"></p>
	<p>Parent\'s Last Name: <input name="last" type="text"></p>
	<p>Second Parent\'s First Name: <input name="first2" type="text"></p>
	<p>Parent\'s Last Name: <input name="last2" type="text"></p>
	<p>Home Phone: <input name="homephone" type="text"></p>
	<p>Cell Phone: <input name="cellphone" type="text"></p>
	<p>Work Phone: <input name="workphone" type="text"></p>
	<p>E-Mail Address: <input name="email" type="text"></p>
	<input type="submit" name="submit" value="Submit">
	</form>
	';
}
else
{
	$host = '***removed***';
	$user = '***removed***';
	$password = '***removed***';
	$database = 'contacts';

mysql_connect($host,$user,$password) or exit(mysql_error());
mysql_select_db($database) or exit(mysql_error());

extract($_POST);
$result = mysql_query("INSERT INTO contacts(first, last, first2, last2, homephone, cellphone, workphone, email) VALUES('$first', '$last', '$first2', '$last2', '$homephone', '$cellphone', '$workphone', '$email')") or exit(mysql_error());
var_dump($result);	
}
?>

</body>
</html>

brokenshadows

oy, okay, so I tried the code posted above and it returns the error "Access denied for user 'rivermilljags'@'%' to database 'contacts' "

so I go into phpmyadmin to fix my user privileges and of course I can't find where to do that anywhere...I vaguely remember seeing it when I was running a test server in my office, but I'm trying to do this on my godaddy account (alas, my test box was repurposed a few months ago)...

I tried to run the following in phpmyadmin:

grant all privileges on rivermilljags.* to rivermilljags@**server address** identified by '**password**';

and it returned " #1044 - Access denied for user 'rivermilljags'@'%' to database 'contacts' "

I also tried running the same command (or is it query) using "contacts." instead of "rivermilljags." and it returned the same thing...

I have no idea how to grant myself privileges...

devinemke

privileges are typically set in a database simply called "mysql" in a table called "user"

brokenshadows

devinemke;10912162 wrote:
privileges are typically set in a database simply called "mysql" in a table called "user"

I don't see that...I see my database, and I see "information schema" which has several items related to privileges (COLUMN_PRIVILEGES, SCHEMA_PRIVILEGES, TABLE_PRIVILEGES, USER_PRIVILEGES) but none of them seem to be editable and only USER_PRIVILEGES has any data. It has the rivermilljags account, but no apperant way to edit it.

bradgrafelman

Are you logging in as root and/or have root access to the DBMS?

AHoward007

It looks like you're missing an = sign after action in your Form method cmd line.

brokenshadows

I was indeed missing a = after action...but it's still broken 🙁

brokenshadows

I figured it out...I had 'type' and 'name' swapped in my form page. everything works just fine now. :p