courses/2011/fall/BIO-101.html
courses/2011/fall/BIO-120.html
courses/2011/fall/BIO-210.html
courses/2011/fall/BIO-319.html
courses/2011/spring/BIO-102.html
courses/2011/spring/BIO-220.html
courses/2012/fall/BIO-101.html
courses/2012/fall/BIO-150.html
courses/2012/spring/BIO-102.html
courses/2012/spring/BIO-314.htmlcourses.html
courses.csvyear,semester,code,professor,day,time,description
2011,fall,BIO-101,Jones,MWF,2:00,How Life Works
2011,fall,BIO-120,Baker,TTh,11:00,Single-Cell Organisms
2011,fall,BIO-210,Schnider,MWF,10:00,Mitosis
2011,fall,BIO-319,Yun,MTh,9:00,The Golgi Apparatus
2011,spring,BIO-102,Jones,MWF,2:00,How Life Works
2011,spring,BIO-220,Schnider,MWF,10:00,Protein
2012,fall,BIO-101,Jones,MWF,2:00,How Life Works
2012,fall,BIO-150,Yun,MThF,12:00,Pathogens
2012,spring,BIO-102,Baker,TTh,3:30,Stem Cells
2012,spring/BIO-314,Merriman,MWF,6:00,Advanced Labratory TechniqueSimilar to HTML but very strict syntax and semantic elements and attributes
<course>
<code>BIO-101</code>
<semester>fall</semester>
<year>2011</year>
<professor>Jones</professor>
<day>MWF</day>
<time>2:00</time>
<description>How Life Works</description>
</course>{
"code": "BIO-101",
"day": "MWF",
"description": "How Life Works",
"professor": "Jones",
"semester": "fall",
"time": "2:00",
"year": 2011
}SELECT isbn, title, price, price * 0.06 AS sales_tax
FROM Book
WHERE price > 100.00
ORDER BY title;Browser ↔ Web Server ↔ Application Server ↔ Database Server
<?php
// Connects to your Database
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
$data = mysql_query("SELECT * FROM friends WHERE pet='Cat'")
or die(mysql_error());
Print "<table border cellpadding=3>";
while($info = mysql_fetch_array( $data ))
{
Print "<tr>";
Print "<th>Name:</th> <td>".$info['name'] . "</td> ";
Print "<th>Color:</th> <td>".$info['fav_color'] . "</td> ";
Print "<th>Food:</th> <td>".$info['fav_food'] . "</td> ";
Print "<th>Pet:</th> <td>".$info['pet'] . " </td></tr>";
}
Print "</table>";
?> <h1>Listing Books</h1>
<table>
<tr>
<th>Title</th>
<th>Summary</th>
<th></th>
<th></th>
<th></th>
</tr>
<% @books.each do |book| %>
<tr>
<td><%= book.title %></td>
<td><%= book.content %></td>
<td><%= link_to \'Show\', book %></td>
<td><%= link_to \'Edit\', edit_book_path(book) %></td>
<td><%= link_to \'Remove\', book, :confirm => \'Are you sure?\', :method => :delete %></td>
</tr>
<% end %>
</table>
<br />
<%= link_to \'New book\', new_book_path %>