Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using bootstrap with oracle php output

user5716448Apr 20 2017 — edited Apr 28 2017

Hi,

Am able to use php to get content back from oracle database and can separately use boostrap framework css  to format the tables which we get back from oracle.

However, encountering an issue when try and mix the two

some of content from file below.

<head>

<meta charset="utf-8">

  <meta name="viewport" content="width=device-width, initial-scale=1">

  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.0/jquery.min.js"></script>

  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>

</head>

<?php

///////////////////////////////////////////////////////////////

include 'db_conn.php'; //include db connection string

////////////////////////////////////////////////////////

$query = "select col1,col2,col3

                 from table";

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

  

$q = oci_execute($stid);

/////////////////////////////////////////////////////////////////

print "MAIN LOADS";

echo "<div class="container"">;

echo "<table class="table table-striped" ";

  $ncols = oci_num_fields($stid);

for ($i = 1; $i <= $ncols; $i++) {

    $column_name  = oci_field_name($stid, $i);

    echo "<th>$column_name</th>";    

}

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

print "<tr>";

foreach ($row as $item)

print "<td align=center>".htmlentities($item)."</td>";

print "</tr>";

}

print "</table>";

print "</div>";

unset($sq_var);

?>

Getting error

PHP Parse error: syntax error, unexpected 'container' (T_STRING), expecting ',' or ';'

Getting above error on this line echo "<div class="container"">;

Any ideas?

Also

Anyone know of  working examples/templates of formatting table output from oracle into tables with alternating colour on each line  producing output in paginated format.  Ideally we could look to use such a template just adjusting the query as many pages would be similar.

Thanks

Comments

rickepm

index position 0 of the array is not used..

Cindy_Paul

thanks Rick, but how to fix that.

Cindy

rickepm
Answer

class Testarray

{

String name;

public static void main (String [] args)

{

Testarray[] h= new Testarray[3];

int z= -1;

while (z<2)

{

z=z+1;

h[z] = new Testarray();

h[z].name="abc";

if (z==1) {

h[z].name="def";

}

if (z==2){

h[z].name="xyz";

}

System.out.println(h[z].name + " is a");

System.out.println("good Testarray name");

}

}

}

Marked as Answer by Cindy_Paul · Sep 27 2020
Cindy_Paul

worked .. thanks...

unknown-7404

I am practicing this program and its giving me error:

Then I suggest you download and use a GUI development system that has a debugger so you can learn how to step thru the code one line at a time and find errors.

https://netbeans.org/downloads/

Until you learn how to debug your own code you will continue to have problems.

TPD-Opitz

Cindy_Paul wrote:

worked .. thanks...

Did you learn why ?

bye

TPD

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 26 2017
Added on Apr 20 2017
2 comments
1,899 views