Team:TU-Delft/SynBioData

From 2013.igem.org

(Difference between revisions)
Line 5: Line 5:
<html>
<html>
-
 
+
<?php
-
<head>
+
     $db = mysqli_connect('jdbc:mysql://localhost:3306/syntheticbiology','dimitra','dimitra','syntheticbiology');
-
 
+
?>
-
<!--
+
<html>
-
     <link rel="exhibit-data" href="data.js" />
+
    <body>
-
-->
+
           <?php
-
    <link rel="exhibit/data"
+
                 $query = "SELECT * FROM 'interviews';";
-
      type="application/jsonp"
+
                $result = mysqli_query($db, $query);
-
      href="https://spreadsheets.google.com/feeds/list/0AkuvTGMlkqD1dE9YNXJaX3JNWHA5RV9YQUw3anpaZ1E/od4/public/basic?alt=json-in-script"
+
                while($row = mysqli_fetch_assoc($result)) {
-
      ex:converter="googleSpreadsheets" />
+
                      // Display your datas on the page
-
 
+
                }
-
    <script src="http://api.simile-widgets.org/exhibit/3.0.0rc1/exhibit-api.js" type="text/javascript"></script>
+
           ?>
-
<!--
+
     </body>
-
    <script src="exhibit3/scripted/dist/exhibit-api.js" type="text/javascript"></script>
+
-
-->
+
-
 
+
-
 
+
-
<!-- Google -->
+
-
<!--
+
-
<meta name="description" content="Complete collection of iGEM software projects 2007-2011" />
+
-
-->
+
-
<!--<meta property="fb:admins" content="100003985967089" />-->
+
-
<!-- FB like -->
+
-
<div id="fb-root"></div>
+
-
<script>(function(d, s, id) {
+
-
  var js, fjs = d.getElementsByTagName(s)[0];
+
-
  if (d.getElementById(id)) return;
+
-
  js = d.createElement(s); js.id = id;
+
-
  js.src = "//connect.facebook.net/en_US/all.js#xfbml=1";
+
-
  fjs.parentNode.insertBefore(js, fjs);
+
-
}(document, 'script', 'facebook-jssdk'));</script>
+
-
 
+
-
 
+
-
<script type="text/javascript" src="analyze.js" ></script>
+
-
</head>
+
-
<body>
+
-
 
+
-
    <div id="content">
+
-
 
+
-
   
+
-
    <table cellspacing="0" cellpadding="0" border="0" width="100%">
+
-
      <tr>
+
-
        <td width="350px" style="padding-right: 20px;">
+
-
        <div ex:role="facet"
+
-
              ex:expression=".team"
+
-
              ex:sortMode="count"
+
-
              ex:height="40em"
+
-
              ex:facetLabel="iGEM Team"></div>
+
-
        <!-- Place this tag where you want the +1 button to render -->
+
-
        <div>
+
-
        <g:plusone size="medium"></g:plusone>
+
-
       
+
-
        </div>
+
-
       
+
-
        </td>
+
-
        <td>
+
-
           <div ex:role="view"
+
-
      ex:orders=".label"
+
-
      ex:direction="ascending"
+
-
      ex:grouped="false"
+
-
      ex:showAll="false"
+
-
      ex:abbreviatedCount="10">
+
-
 
+
-
    <div ex:role="lens" >
+
-
              <table cellpadding="0" cellspacing="0">
+
-
                 <tr class="details">
+
-
              <td>
+
-
                    <div class="title"><span ex:content=".label"></span> - <span ex:content=".team"></span></div>
+
-
    <div class="inclusion"><span class="property">Year:</span><span ex:content=".year"></span></div>
+
-
<!--
+
-
-->
+
-
                    <div class="definition" ex:content=".description"></div>
+
-
<!--
+
-
-->
+
-
                    <div class="property" ex:content=".dependency"></div>
+
-
 
+
-
    <div class="exclusion"><span class="property">URL:</span>
+
-
                        <a ex:href-content=".url"><span ex:content=".url"></a></span></div>
+
-
    <div class="exclusion"><span class="property">
+
-
                        Development:</span> <span ex:content=".status"></span>
+
-
                        Was last updated: <span ex:content=".update"></span>
+
-
                        Contact: <span ex:content=".contact"></span>
+
-
                        Free: <span ex:content=".free"></span> </div>
+
-
                    <div class="exclusion">Source: <a ex:href-content=".source"><span ex:content=".source"></a></span></div>
+
-
                    <div class="identifier"><span class="property">Category:</span><span ex:content=".category"></span></div>
+
-
                  </td>
+
-
</tr>
+
-
              </table>
+
-
            </div>
+
-
 
+
-
          </div>
+
-
        </td>
+
-
 
+
-
<td width="200px" style="padding-left: 20px;">
+
-
 
+
-
  <b>Search</b><br />
+
-
          <div ex:role="facet"
+
-
              ex:facetClass="TextSearch"
+
-
              ex:expressions=".label, .description, .team, .contact" ></div>
+
-
          </br>
+
-
 
+
-
          <div ex:role="facet"
+
-
              ex:expression=".category"
+
-
      ex:facetLabel="Category"
+
-
              ex:showMissing="false"
+
-
              ex:sortMode="count"
+
-
              ></div>
+
-
 
+
-
          <div ex:role="facet"
+
-
              ex:expression=".year"
+
-
      ex:facetLabel="Year"
+
-
              ></div>
+
-
          <div ex:role="facet"
+
-
              ex:expression=".dependency"
+
-
              ex:facetLabel="Depends On:"
+
-
              ></div>
+
-
           <div ex:role="facet"
+
-
              ex:expression=".free"
+
-
              ex:facetLabel="Free?:"
+
-
              ></div>
+
-
 
+
-
</td>
+
-
      </tr>
+
-
     </table>
+
-
    </div>
+
-
 
+
-
</body>
+
</html>
</html>

Revision as of 08:52, 2 September 2013