Forum Stats

  • 3,826,050 Users
  • 2,260,591 Discussions
  • 7,896,781 Comments

Discussions

using bootstrap with oracle php output

user5716448
user5716448 Member Posts: 1,748 Silver Badge
edited Apr 28, 2017 4:11AM in PHP

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

Answers

This discussion has been closed.