error on insertion variable data in oracle database using php code

Question

i am trying to run this php code to insert values in oracle database but error showing when run it. my code is:

<?php 
$c = oci_connect('system', 'passward', 'dbname');
$sql = "INSERT INTO EMPLOYEES(EMP_ID,JOB_ID) VALUES (:emp_id, ".'{$nw}'.")";
$compiled = oci_parse($c, $sql);
oci_bind_by_name($compiled, ':emp_id', $eid);
oci_bind_by_name($compiled, '.$nw.', $nw);
oci_execute($compiled);
?>

and i get the folloing errors

Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number in C:\xampp\htdocs\folder\add_emp.php on line 16

Warning: oci_execute(): ORA-00911: invalid character in C:\xampp\htdocs\folder\add_emp.php on line 17

Ι know the problem is where Ι write $nw, but just don't know the right syntax or way.

CodeBird · Accepted Answer · 2014-02-13 08:32:45Z

1

Try

$sql = "INSERT INTO EMPLOYEES(EMP_ID,JOB_ID) VALUES (:emp_id, :nw)";

the problem in your query is that you're closing the " then concatenating {$nw} exactly this string as you've put it between single quotes, php understands that it shouldn't replace this by a variable it is just a string. so your query is arriving to oracle like this:

INSERT INTO EMPLOYEES (EMP_ID,JOB_ID) VALUES (whatever_int_in_eid, {$nw});

edited Feb 13, 2014 at 8:32

answered Feb 13, 2014 at 8:27

CodeBird

3,8132 gold badges22 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rikesh · Accepted Answer · 2014-02-13 08:28:51Z

0

You doing it incorrectly,

$sql = "INSERT INTO EMPLOYEES(EMP_ID,JOB_ID) VALUES (:emp_id, :nw)";
$compiled = oci_parse($c, $sql);
oci_bind_by_name($compiled, ':emp_id', $eid);
oci_bind_by_name($compiled, ':nw', $nw);

answered Feb 13, 2014 at 8:28

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

3 Comments

user3305088 Over a year ago

Thank you very mush Rikesh,,, i did it and it worked.

Rikesh Over a year ago

Glad to help you kindly accept it if it helps you in solving your problem.

user3305088 Over a year ago

i did it, tick marj is now green, is this what you was trying to convey??

Collectives™ on Stack Overflow

error on insertion variable data in oracle database using php code

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related