HTML and CSS

Sending Form Fields to Database

Please support our HTML and CSS advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jan 2008

Posts: 16

Reputation: SHAWTY721 is an unknown quantity at this point

Solved Threads: 0

SHAWTY721

Offline

Newbie Poster

Sending Form Fields to Database

Jan 13th, 2009

I created a form using Dreamweaver and am trying to figure out how to get the form contents saved to a database. Does anyone know of a way to to do this.

•

Join Date: Jan 2009

Posts: 1,332

Reputation: almostbob has a spectacular aura about

Solved Threads: 163

almostbob

Offline

Nearly a Posting Virtuoso

Re: Sending Form Fields to Database

Jan 14th, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php if isset() //validate data entered howver you require
 { { define ('MYSQL_SERVER', 'MYSQLHOST');
 define ('MYSQL_PASSWORD', 'MYSQLPASS' );
 define ('MYSQL_USERNAME', 'MYSQLUSER');
 define ('MYSQL_DB', 'MYSQLDB');
 if (!(@mysql_pconnect(MYSQL_SERVER, MYSQL_USERNAME, MYSQL_PASSWORD) and @mysql_select_db(MYSQL_DB)))
 die(sprintf("Cannot connect to database, error: %s", mysql_error()));
}
if (!mysql_query(sprintf("insert into MYSQLDB_table
		(data1, data2, data3, data4, data5, ) values ('%s', '%s', '%s', '%s', '%s', '%s');", $data1, $data2,
$data3, $data4, $data5,)))
	{ echo "error adding your geoip entry to database!<br>";
	echo mysql_errno().": ".mysql_error()."<BR>";
	return false;
	}
return true; }
?>
<form action='<?php echo $_server['PHP_SELF']; ?>'>
<!-- input form -->
<?php if isset() //validate data entered howver you require
 { { define ('MYSQL_SERVER', 'MYSQLHOST');
 define ('MYSQL_PASSWORD', 'MYSQLPASS' );
 define ('MYSQL_USERNAME', 'MYSQLUSER');
 define ('MYSQL_DB', 'MYSQLDB');
 if (!(@mysql_pconnect(MYSQL_SERVER, MYSQL_USERNAME, MYSQL_PASSWORD) and @mysql_select_db(MYSQL_DB)))
 die(sprintf("Cannot connect to database, error: %s", mysql_error()));
}
if (!mysql_query(sprintf("insert into MYSQLDB_table
		(data1, data2, data3, data4, data5, ) values ('%s', '%s', '%s', '%s', '%s', '%s');", $data1, $data2,
$data3, $data4, $data5,)))
	{ echo "error adding your geoip entry to database!<br>";
	echo mysql_errno().": ".mysql_error()."<BR>";
	return false;
	}
return true; }
?>
<form action='<?php echo $_server['PHP_SELF']; ?>'>
<!-- input form -->

Last edited by almostbob; Jan 14th, 2009 at 5:18 pm.

Failure is not an option It's included free
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it

Please mark solved problems, solved

•

Join Date: Oct 2008

Posts: 89

Reputation: wickedsunny is an unknown quantity at this point

Solved Threads: 4

wickedsunny wickedsunny is offline

Offline

Junior Poster in Training

Re: Sending Form Fields to Database

Jan 16th, 2009

if u can post ur forum's html i can post back the whole php code for it

Ayaz Malik
Free online Photoshop/Drawing | Art Community

•

Join Date: Oct 2008

Posts: 76

Reputation: ccube921 is an unknown quantity at this point

Solved Threads: 6

ccube921

Offline

Junior Poster in Training

Re: Sending Form Fields to Database

Jan 21st, 2009

This, by the way is called php, if your interested in this, you might want to check these two links:
http://w3schools.com/php/default.asp
http://hudzilla.org/phpwiki/index.php?title=Main_Page

The first one is universal, a goiod site for web tutorials of any kind.
The second is a great tutorial (which I am in the middle of myself)
you should look at both really.

If I have been helpful add to my reputation!