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