Looking for code to create a questionnaire form?

[emanage]

If someone could help me or point me in the right direction I would be most appreciative.

I need to find some code that and I modify some that will allow us to integrate a php form into our website. What we want to do is make a contact/questionnaire form and then have it submitted via email or sent to a MySQL database. I've been learning more and more PHP but time is running out and I can't write something from scratch.

Any help on this would be great...

[campsoup1988]

ok, try the following base:

questioniere.php :

<?

$db=mysql_connect("localhost","root","password") or die("Server could not be connected");
$mydb=mysql_select_db("questioniere") or die("Database could not be connected");

echo"<form method=post action=submit.php>";

echo"<b>Question 1</b>";
echo"<br>";
echo"<input type=text name=quest1>";
echo"<br>";
echo"<br>";
echo"<b>Question 2</b>";
echo"<br>";
echo"<input type=text name=quest2>";
echo"<br>";
echo"<br>";
echo"<b>Question 3</b>";
echo"<br>";
echo"<input type=text name=quest3>";
echo"<br>";
echo"<input type=submit name=options value='Submit'>";
echo"<input type=hidden name=quest1 value='$quest1'>";
echo"<input type=hidden name=quest2 value='$quest2'>";
echo"<input type=hidden name=quest3 value='$quest3'>";
echo"</form>";
?>

submit.php :

<?

$db=mysql_connect("localhost","root","password") or die("Server could not be connected");
$mydb=mysql_select_db("questioniere") or die("Database could not be connected");

echo"<form method=post action=questioniere.php>";

echo"<b>Thanks for the feedback</b>";
echo"<br>";
echo"<input type=submit name=options value='Submit'>";

$sql="insert into questions_table (quest1,quest2,quest3) values('$quest1','$quest2','$quest3');";
$insert=mysql_query($sql);

echo"</form>";

?>

hope that helps!
campsoup1988

[emanage]

Yes it does but how would I create the corresponding tables in MySQL?

[emanage]

Also is it possible to do this same form and send it via email?

[campsoup1988]

ok I dont know how to email, sorry

you know how to create a database and connect to it right?

well, to create the table, in mysql command prompt, type the following:

create table questions_table(
quest1 varchar(40),
quest2 varchar(40),
quest3 varchar(40));

I hope that helps!
campsoup1988

[emanage]

yeah I can create a database and connect, I'm not familiar with command line but I can find my way around phpMyAdmin. I saved the table above to a text file and imported it into myadmin and it seems to have created the table ok.

However when I run the code with test data in the three fields it doesn't appear to post it into mySQL?

[campsoup1988]

hmmm... I am not familuar with that method of submitting information. but then I dont know everything, or it could be a differnt progam then I use.

back to topic. to view the information, try:

select * from questions_table;

hope that helps!

[emanage]

ok ran that at the command prompt and still no test data, not sure if it is making it from the .php file into the db

[emanage]

upon further review it does appear to be putting records in SQL but they do not contain any data. I have six records and all of them are null

[emanage]

here is the dump I get from mySQL, it looks like a record is created but no info is carrying into them

--

-- Table structure for table questions_table

CREATE TABLE questions_table (
quest1 varchar(40) default '',
quest2 varchar(40) default '',
quest3 varchar(40) default '',
KEY quest1 (quest1)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--

-- Dumping data for table questions_table

INSERT INTO questions_table VALUES ('', '', '');

[campsoup1988]

hmmm not sure about, probly because it is a different program then me

ENGINE=InnoDB DEFAULT CHARSET=latin1;

I also tend not use key, but it is not nessary
my guess it is that in your insert into command, I think, it is wrong. I think it should be:

insert into questions_table (quest1,quest2,quest3) values('$quest1','$quest2','$quest3');

I hope that helps!

PS: what program are you using? I am using Apache/2.2.0 (Win32) PHP/5.1.2