Php / Mysql Form Help

[Anon]

This is probably all too easy, but hey, I\'m not gonna learn if I don\'t ask.

I have some teachers that want to put their lesson plans online and an idea I had was to do it through a form/database. Where the form presents, they insert their information like with text value 1 they can insert the title, and text value 2 they can have the lesson, etc, etc, and then they click submit to post it to the database. Now when they submit, I want the information to go into their db records (entitled title and lesson) and then show up under their lesson plans (I can do that part). I just need to know what to post to in the form (page.php?) to get it to post into the database records.

Would it go something like this:
<form action=\"page.php\" method=\"post\">
<input type=\"text\" name=\"title\" value=\"<?php echo $title ?>\">
<input type=\"text\" name=\"lessonplan\" value=\"<?php echo $lessonplan ?>\">
<input type=\"Submit\" name=\"submit\" value=\"Submit\">
</form>

[Anon]

You can put it all into one page. Something like this maybe ...

if ($insert == "yes") {
... make DB connection

mysql_query("insert into table (title, lessonplan) values ($title, $lessonplan)");
}

<form action=\"<?=$PHP_SELF; ?>\" method=\"post\">
<input type=hidden name=\"insert\" value=\"yes\">
<input type=\"text\" name=\"title\" value=\"<?php echo $title ?>\">
<input type=\"text\" name=\"lessonplan\" value=\"<?php echo $lessonplan ?>\">
<input type=\"Submit\" name=\"submit\" value=\"Submit\">
</form>

[Anon]

Well all of that made sense to me, but I just couldn't get it to work. However, I did find an alternative (thank goodness PHP is so flexible!); I thank you for your assistance and I'm going to try to see what I'm doing wrong with the code you gave me. Thank you again and have a nice day!!

[Anon]

Did you notice the hidden form field i added to your form ?

That will keep the insert from happening unless the form is submitted.