form to MySQL

blckspder

I am trying to set up a simple form just to learn how to insert data into my database.. however I can't seem to get it to work. Can someone please help??

<?php
$dbhost = '**';
$dbuser = '**';
$dbpass = '**';
$dbname = '**';

$conn = mysql_connect($dbhost, $dbuser, $dbpass);

if (!$conn) {
	die('Could not connect: ' . mysql_error());
} 

//echo 'connected successfully';

if(isset($_POST['submit'])) {

$name = $_POST['name'];
$comments = $_POST['comments'];

$query = "INSERT INTO `testtable` ( `name`,`comments` ) 
     VALUES ( '$name','$comments' )"; 
mysql_query($query) or die('Error, insert query failed');

}
mysql_close($conn);

//mysql_select_db($dbname);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<form method="post" action="test.php">
	name: <input type="text" name="name" />
	Comment: <input type="text" name="comments" />
	<input type="submit" name="submit" value="submit" />
</form>
</body>
</html>

kona72

You just need a basic html form like so...

<body>
<form method="post" action="add_info.php">
  <p>
    <input type="text" name="textfield"> 
  name</p>
  <p>
    <textarea name="textarea"></textarea>
Comments</p>
  <p>
    <input type="submit" name="Submit" value="Send Info">
</p>
</form>
</body>

and when you submit have it go to this another page such as add_info.php with this code...

$name = $_POST['name'];
$comments = $_POST['comments'];
mysql_connect("example.com","username","password")or die(mysql_error());
mysql_select_db("flyerforce")or die(mysql_error());
mysql_query("INSERT INTO your_table_name VALUES('$name','comments')");
// optional  header to take you to thank you page...//
header("Location: http://www.example.com/thanks.htm");
mysql_close();

Hope this helps!!

blckspder

awesome I got it to work Thanks!!