Insert

[dute105]

Hi everyone

Am new to the php and oracle technology, my problem is that i want to insert data to the database from an HTML form but when i run the script it will insert NULL to the database. On that note i like to request for help from anyone. This is my code


<?php

include "connect.php"

$sql = "insert into TEST values(:name)";

// Parse SQL
$stmt = OCIParse($conn,$sql);

// Bind php variables to Oracle columns
OCIBindByName($stmt,"NAME",$name);
// Oracle converts all column names into UPPERCASE

// Run SQL
OCIExecute($stmt);

?>