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

Processing
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,896 views