Trying to create a form which posts to oracle

[freqout]

Hi, I have installed php, apache and oracle. I have tested the connectivity and php can connect to the db instance but I cant get it to do an insert query based on a form. Wondering if anyone here can help?

 

Form:

<form method="post" action="sendmail.php">

  Email: <input name="email" type="text" /><br />

  Message:<br />

  <textarea name="message" rows="15" cols="40">

  </textarea><br />

  <input type="submit" />

</form>

 

PHP:

<?

  $email = $_REQUEST['email'] ;

  $message = $_REQUEST['message'] ;

  $c=OCILogon("portal", "portal", "scdb");

  if ( ! $c ) {

    echo "Unable to connect: " . var_dump( OCIError() );

    die();

  }

  $s = OCIParse($c, "insert into users values (:bind1, :bind2)");

  OCIBindByName($s, ":bind1", $email);

  OCIBindByName($s, ":bind2", $message);

  OCIExecute($s, OCI_DEFAULT);

  OCICommit($c);

 

?>

[simcoweb]

There's a forum specifically for Oracle and PHP. The Mods will probably move this over there