Data query working in oracle sqlplus but not in PHP

Question

I have connected a oracle database with PHP. When I try to query a data in sqlplus it works. But when I try to query in PHP, it doesn't work(It doesn't show any error or nothing). My emp_id is number.

        <p> $query = "select order_id from ordered_by where order_emp_id =".$emp_id."and order_done='N'";

        $stid = oci_parse($conn, $query);

        $r = oci_execute($stid, OCI_DEFAULT);

        $value="";

        while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) 

        {

            foreach ($row as $item) 

            {

                $item!== null ? htmlentities($item) :'NULL';

                $value =$item;



            }

What does the meaning of "it does not work ?" An error appear ? — Debflav
– Debflav, Commented Apr 1, 2014 at 8:55
try attaching the schema name to the where clause like schema_name.ordered_by — iamsleepy
– iamsleepy, Commented Apr 1, 2014 at 8:57

hkutluay · Accepted Answer · 2014-04-01 08:56:19Z

2

Put a space after =".$emp_id."

$query = "select order_id from ordered_by where order_emp_id =".$emp_id." and order_done='N'";

answered Apr 1, 2014 at 8:56

hkutluay

6,9742 gold badges37 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Data query working in oracle sqlplus but not in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related