Return Json from Oracle database

Question

How can I return Json format from Oracle using php? I did this and debugged with firebug, there were no error and it did not return anything...but it printed done!

<?php

$user = "username";
$pass = "password";
$host = "myhost/myservicename";

$conn = oci_connect($user, $pass, $host);
$sql  = oci_parse($conn, "SELECT * FROM emp WHERE rownum <100");

oci_execute($sql);

$rows = array();
while($r = oci_fetch_assoc($sql)) {
$rows[] = $r;
 }
$locations =(json_encode($rows));
echo 'done!';
?>

You could var_dump($locations) to see the content of your encoding... — legrandviking
– legrandviking, Commented Aug 19, 2013 at 14:19

Schleis · Accepted Answer · 2013-08-19 14:19:37Z

3

The response is what ever that you have the page print.

So change 'done!' to $locations

answered Aug 19, 2013 at 14:19

Schleis

44.2k8 gold badges73 silver badges90 bronze badges

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

Collectives™ on Stack Overflow

Return Json from Oracle database

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