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.
SHAWTY721 0 Newbie Poster
almostbob 866 Retired: passive income ROCKS
<?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 --> wickedsunny 0 Junior Poster in Training
if u can post ur forum's html i can post back the whole php code for it :)
ccube921 2 Junior Poster in Training
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.
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.