PHP5 and Access 2003

GoodCoffee

I'm new to PHP. I can't seem to get my page to insert values into a table. I seem to connect to the database, and if I manually edit the tables, I can see the data on the webpage. Anyone have any ideas?? No point going on with the language unless I can insert into a table!!

esukf

Please copy and paste your code here.

GoodCoffee

<?
$connect = odbc_connect("forum", "root", "");
if(isset($submit)) // check if submitted button is clicked
{
// insert the record in the database
$resultupdate=odbc_exec($connect,"insert into forum
(parentcode,title,description,uname,email) VALUES
($node,'$title','$description','$postname','$email')");
header("location:forum.php"); // open forum.php file to display the thread
exit;
}
?>
<CENTER>Post to Discussion Forum</CENTER>
<?
if ( $_REQUEST['node'] != 0 )
{
// Displaying the details of the thread
echo "<HR>";
$noderesult = odbc_exec($connect,"select * from forum where code = $node");
$noderow=odbc_fetch_row($noderesult);
$title = odbc_result($noderesult,"title");
$description = odbc_result($noderesult,"description");
$uname = odbc_result($noderesult,"uname");
$email = odbc_result($noderesult,"email");
echo "$title by ($uname) $email<BR>";
echo "$description <BR><HR>";
}
?>

<FORM method='post'>
Name : <INPUT TYPE=TEXT NAME=postname> <BR>
E-Mail : <INPUT TYPE=TEXT NAME=email> <BR>
Title : <INPUT TYPE=TEXT NAME=title VALUE = '' size=50> <BR>
Description : <BR> <TEXTAREA name=description rows=10 cols=45></TEXTAREA>

<INPUT TYPE=hidden NAME=node value='<? echo $node;?>'> <BR>
<INPUT type=submit name=submit value='Post Message'>
</FORM>

esukf

Not sure if you pasted all the code in your script but i notice that you didn't assign anything to the variables $submit, $node, $title, $description, $postname, $email

<?
$connect = odbc_connect("forum", "root", "");
if(isset($submit)) // check if submitted button is clicked
{
// insert the record in the database
$resultupdate=odbc_exec($connect,"insert into forum
(parentcode,title,description,uname,email) VALUES
($node,'$title','$description','$postname','$email')");
header("location:forum.php"); // open forum.php file to display the thread
exit;
}
?>

In the above code $submit will always not be set so the code in the if statement won't even run.

Try assigning the $_POST values to the variables ie

$submit = $_POST['submit'];
$node = $_POST['node'];
$title = $_POST['title'];

etc

or use $_POST directly

if(isset($_POST['submit'])){
//........
}

esukf

Also action is missing in the form

<FORM method='post'>

replace with

<FORM method='post' action="<?php echo $_SERVER['PHP_SELF']?>">

GoodCoffee

Thanks for the tips...

is the reason $submit is empty is that it doesn't get a value until later in the code (where the form is)? should the form and the PHP that processes it be on seperate pages?