如何修复oci_execute（）：ORA-00957：重复列名...？ [关闭]

Question

I'm trying to insert form value data to Oracle database But I get this error ... please help ... ?

if(isset($_POST['submit'])){

  $id = $_POST['id'];
  $username = $_POST['username'];
  $password = $_POST['password'];
  $nameen = $_POST['nameen'];
  $namear = $_POST['namear'];


echo $sql = "INSERT INTO TESTTABLE (ID,USERNAME,PASSWORD,NAMEEN,NAMEEN) VALUES (:id,:username,:password,:nameen,:namear)";
  $compiled = oci_parse($conn, $sql);

  oci_bind_by_name($compiled, ':id', $id);
  oci_bind_by_name($compiled, ':username', $username);
  oci_bind_by_name($compiled, ':password', $password);
  oci_bind_by_name($compiled, ':nameen', $nameen);
  oci_bind_by_name($compiled, ':namear', $namear);

  oci_execute($compiled);

  if (! oci_execute($compiled)) {
    var_dump(oci_error()); 
} }

Answer 1

You have twice the same field, called « NAMEEN », in your INSERT statement :

INSERT INTO TESTTABLE
(ID,USERNAME,PASSWORD,NAMEEN,NAMEEN) VALUES ...

You want :

INSERT INTO TESTTABLE
(ID,USERNAME,PASSWORD,NAMEEN,NAMEAR) VALUES ...