Assign value from Oracle SQL statement to PHP variable

Question

I am trying to create a PHP page that will run a SQL select statement that returns 1 row and take the values in two of the columns to PHP variables but I am getting the error:

PHP Notice: Undefined index: firstname

Here is what the important part of my code looks like:

$sql = " select * from employee e where e.emp_id = 123";

echo $sql;

$stid = oci_parse($Conn, $sql);
oci_execute($stid);
oci_fetch_all($stid, $res, null, null, OCI_FETCHSTATEMENT_BY_ROW);

var_dump($res);

$firstname = $res['firstname'];

Any idea what can be causing this?

This doesn't look like it would return just one row. What does the var_dump($res); give you? — Digital Chris
– Digital Chris, Commented Jun 23, 2016 at 18:52
Hi @digitalChris - this will return just one row, I forgot the where clause in the original post — AAA
– AAA, Commented Jun 23, 2016 at 18:53
I suspect Oracle would return column names in uppercase. Try $res['FIRSTNAME'] — mustaccio
– mustaccio, Commented Jun 23, 2016 at 18:55
Look at the syntax for oci_fetch_all What happens when you var_dump($res)? — Jay Blanchard
– Jay Blanchard, Commented Jun 23, 2016 at 18:56

josdev · Accepted Answer · 2016-06-24 09:30:17Z

1

Check by this code

$firstname = $res[0]['firstname'];

answered Jun 24, 2016 at 9:30

josdev

791 silver badge11 bronze badges

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

1 Comment

AAA Over a year ago

Thank you - this was VERY close

AAA · Accepted Answer · 2016-06-24 13:33:11Z

0

Resolved: I had to add [0] after the column:

$firstname = $res['firstname'][0];

answered Jun 24, 2016 at 13:33

AAA

2,45810 gold badges38 silver badges50 bronze badges

Collectives™ on Stack Overflow

Assign value from Oracle SQL statement to PHP variable

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related