daily pastebin goal
62%
SHARE
TWEET

Untitled

a guest Oct 17th, 2017 83 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php include('header.php'); ?>
  2. <?php
  3.     $host = "localhost";
  4.     $user = "root";
  5.     $pass = "";
  6.  
  7.     mysql_connect ($host, $user, $pass);
  8.     mysql_select_db ("lorenzo");
  9.  
  10.     // =========================================
  11.  
  12.     $sql_category = "SELECT * FROM cv_category ORDER BY category_order ASC";
  13.     $result_category = mysql_query ($sql_category) or die (mysql_error());
  14.    
  15.     echo    '<div id="about_text">
  16.         <div id="h3_title"><h3>Curriculum Vitae</h3><h4>2007-Present</h4></div>
  17.     </div>';
  18.     while ($row_category = mysql_fetch_assoc ($result_category))
  19.     {
  20.         echo '<ul class="ul_cv">';
  21.         echo "<li class='li_headline'>$row_category[category_label]</li><br />";
  22.             // sub category output
  23.             $sql_subcategory = "SELECT * FROM cv_subcategories WHERE fk_category = $row_category[category_id]";
  24.             $result_subcategory = mysql_query ($sql_subcategory) or die (mysql_error());
  25.                
  26.             while ($row_subcategory = mysql_fetch_assoc ($result_subcategory))
  27.             {
  28.             echo "<li class='dot'>$row_subcategory[label]</li><br />";
  29.                 // entries output
  30.                 $sql_entries = "SELECT * FROM cv_entries WHERE fk_subcategory = $row_subcategory[id]";
  31.                 $result_entries = mysql_query ($sql_entries) or die (mysql_error());
  32.                            
  33.                 while ($row_entries = mysql_fetch_assoc ($result_entries))
  34.                 {
  35.                     echo "<li class='cv_text'>$row_entries[entry_body]</li><br />";
  36.                 }
  37.         }
  38.     echo '</ul>';  
  39.         }
  40.     ?>
  41. <?php include('footer.php'); ?>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top