2 Replies Latest reply on Apr 28, 2017 8:11 AM by user5716448

    using bootstrap with oracle php output

    user5716448

      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