Ad:

HTML and CSS Discussion Thread
Unsolved
Views: 971

Jan 13th, 2009

Sending Form Fields to Database

Expand Post »

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.

Similar Threads

storing the selected value of a drop-down list in PHP
Submit two values from a form at once using $_GET and javascript in JavaScript / DHTML / AJAX
How the process of sending message of confirmation will be done ? in Java
Syntax Error - Missing Operator in ASP

SHAWTY721

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Jan 2008

Permalink

Jan 14th, 2009

Re: Sending Form Fields to Database

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.

almostbob

Reputation Points: 562

Solved Threads: 368

Posting Maven

Offline

2,970 posts
since Jan 2009

Permalink

Jan 16th, 2009

Re: Sending Form Fields to Database

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

wickedsunny

Reputation Points: 10

Solved Threads: 5

Junior Poster in Training

Offline

96 posts
since Oct 2008

Permalink

Jan 21st, 2009

Re: Sending Form Fields to Database

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.

ccube921

Reputation Points: 13

Solved Threads: 6

Junior Poster in Training

Offline

93 posts
since Oct 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in HTML and CSS Forum Timeline: static css footer at the bottom of windows

Next Thread in HTML and CSS Forum Timeline: css question

DaniWeb Message

Cancel Changes

User Name
Password