Merged branch 'no-javascript' with notes
[dylansserver.git] / index.php
index c0971b1..dbff9a5 100644 (file)
--- a/index.php
+++ b/index.php
 
     <div id="content">
       <div id="exhibit">
-        <div class="exhibit" id="repthis_">
-          <span id="reprap_entry">3D printing is a form of additive
-          manufacturing technology where a three dimensional object
-          is created by successive layers of material. [1]:<a href=
-          "http://repthis.info/">http://en.wikipedia.org/wiki/3D_printing</a><br>
-
-          <br>
-          <a href="http://reprap.org">reprap</a> is a <a href=
-          "http://en.wikipedia.org/wiki/Free_software">free</a>
-          desktop 3D printer capable of printing plastic
-          objects.<br>
-          <br>
-          <a href="http://repthis.info">repthis.info</a> is the
-          account of a friend and I learning to build our own.<br>
-          <br></span>
-        </div>
-
-        <div class="exhibit" id="youtube_backup_">
-          <h1 id="youtube_backup_title"><a href=
-          "https://github.com/nospampleasemam/youtube_backup">youtube_backup</a></h1><span id="youtube_backup_entry">backs
-          up all the <a href="http://youtube.com">youtube</a>
-          videos in a users favorites list.<br>
-          <br>
-          this is my fork of the <a href=
-          "https://github.com/hagnas/youtube_backup">original
-          youtube_backup</a> which adds asynchronous alerts after
-          successful downloads.<br>
-          <br>
-          it's written in <a href=
-          "http://www.python.org/">python</a>.</span>
-        </div>
-
-        <div class="exhibit" id="i_like_pandora_">
-          <h1 id="i_like_pandora_title"><a href=
-          "https://github.com/nospampleasemam/i_like_pandora">i_like_pandora</a></h1><span id="i_like_pandora_entry">searches
-          <a href="http://youtube.com">youtube</a> for what you
-          like on <a href="http://pandora.com">pandora</a>.<br>
-          <br>
-          then it downloads the first video.<br>
-          <br>
-          it's working, but i'm still making it better.<br>
-          <br>
-          <br>
-          the code is free (as in freedom), <a href=
-          "http://github.com/nospampleasemam/i_like_pandora">here</a>.<br>
-          </span>
-        </div>
-
-        <div class="exhibit" id="peepshow_">
-          <h3 id="peepshow_title_1"><a href=
-          "foxy-addons/peepshow/peepshow.xpi">foxy-addons/</a></h3>
-
-          <h1 id="peepshow_title_2"><a href=
-          "foxy-addons/peepshow/peepshow.xpi">peepshow</a></h1><span id="peepshow_entry">a
-          <a href=
-          "http://www.mozilla.com/en-US/products/download.html">firefox</a>
-          addon, to load linked images inline (like on <a href=
-          "http://reddit.com/r/pics">reddit</a>).<br>
-          <br>
-          here's the <a href=
-          "http://github.com/nospampleasemam/peepshow/">repo</a>
-          for the source code.</span>
-        </div>
-
-        <div class="exhibit" id="drawcss_">
-          <h1 id="drawcss_title"><a href=
-          "drawcss">drawcss</a></h1><span id=
-          "drawcss_entry">writing markup for website wireframes
-          always seemed silly.<br>
-          <br>
-          this is a tool to draw them (it's not done).<br>
-          <br>
-          <a href="#show" id="showdivs" name="showdivs">check
-          out</a> the invisible divs this page is built on.<br>
-          <br>
-          then get <a href=
-          "http://github.com/nospampleasemam/drawcss">the
-          code</a>.</span>
-        </div>
-
-        <div class="exhibit" id="readoo_">
-          <h1 id="readoo_title"><a href=
-          "http://github.com/nospampleasemam/readoo">readoo</a></h1><span id="readoo_entry">helps
-          you find search keywords to target.<br>
-          <br>
-          it reads your IIS logs, and finds successful keywords
-          worth focusing on.<br>
-          <br>
-          it's not done yet! here's the <a href=
-          "http://github.com/nospampleasemam/readoo">source
-          code</a>.</span>
-        </div>
-      </div>
+           <?php
+                 $config = parse_ini_file('/etc/dylanstestserver.ini');
+          mysql_connect($config['domain'], $config['user'], $config['password']) or die(mysql_error());
+          mysql_select_db($config['database']) or die(mysql_error());
+                 if (isset($_GET['project'])) {
+                   $page_type = 'project';
+                       $project = mysql_real_escape_string($_GET['project']);
+                   $sql = "SELECT text FROM projects WHERE title='$project'";
+                 } else {
+                   $sql = "SELECT text FROM projects";
+                 }
+          $result = mysql_query($sql) or die (mysql_error());
+          while($project = mysql_fetch_array($result)) {
+                       $text = $project['text'];
+                       if (isset($page_type)) {
+                         $text = str_replace("<div class=\"exhibit\"", "<div class=\"exhibit\" style=\"display:block;\"", $text);
+                       }
+                       echo $text;
+          }
+           ?>
+         </div>
 
       <ul id="portfolio" style="text-align:right">
         <li>
           <h3>my projects:</h3>
         </li>
 
-        <li><a class="tab" href="#repthis">repthis.info</a></li>
+        <li><a class="tab" href="repthis">repthis.info</a></li>
 
         <li><a class="tab" href=
-        "#youtube_backup">youtube_backup</a></li>
+        "youtube_backup">youtube_backup</a></li>
 
         <li><a class="tab" href=
-        "#i_like_pandora">i_like_pandora</a></li>
+        "i_like_pandora">i_like_pandora</a></li>
 
         <li><a class="tab" href=
-        "#peepshow">foxy-addons/peepshow</a></li>
+        "peepshow">foxy-addons/peepshow</a></li>
 
-        <li><a class="tab" href="#drawcss">drawcss</a></li>
+        <li><a class="tab" href="drawcss">drawcss</a></li>
 
-        <li><a class="tab" href="#readoo">readoo</a></li>
+        <li><a class="tab" href="readoo">readoo</a></li>
 
         <li>
           <h3>things i've done for others:</h3>
         </li>
 
         <li><a href=
-        "notes">here</a></li>
+        "/dylanstestserver/notes">here</a></li>
 
         <li>
           <h1 id="contact_me"><a href=