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

问题描述：

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()); 
} }

我正在尝试将表单值数据插入Oracle数据库但是我收到此错误...请帮忙.. 。 p>

  if（isset（$ _ POST ['submit']））{
 
 $ id = $ _POST ['id']; 
 $ username =  $ _POST ['username']; 
 $ password = $ _POST ['password']; 
 $ nameen = $ _POST ['nameen']; 
 $ namear = $ _POST ['namear']; 
 \  n 
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（））;  
}} 
  code>  pre> 
  div>

答

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 ...

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

相关推荐