Untitled

<?php
/*
echo "<center>";
echo "<h1>Contacts:</h1>";
echo "<style>";
echo 'table {';
echo 'font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;';
echo 'width:100%;';
echo 'border-collapse:collapse;';
echo 'font-size: 1.2em;';
echo 'border: 1px solid white;';
echo 'padding: 3px 7px 2px 7px;';
echo 'font-size: 1.4em;';
echo 'text-align: left;';
echo 'padding-top: 5px;';
echo 'padding-bottom: 4px;';
echo 'background-color: grey;';
echo 'color: black;';
echo '}';
echo "</style>";
$db_hostname = "127.0.0.1";
$db_username = "cgscompu_deana1";
$db_password = "040497";
$db_database = "cgscompu_deana1";
$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if(!$db_server) {
    die("Unable to connect to MySQL: " . mysql_error());
}
mysql_select_db($db_database, $db_server) or die("Unable to select database: " . mysql_error());
if($_GET['order'] == 1){
$query = "SELECT * FROM todo_list ORDER BY person_id ASC";
}elseif($_GET['order'] == 2)
{
$query = "SELECT * FROM todo_list ORDER BY name ASC";
}elseif($_GET['order'] == 3)
{
$query = "SELECT * FROM todo_list ORDER BY age ASC";
}elseif($_GET['order'] == 4)
{
$query = "SELECT * FROM todo_list ORDER BY email_address ASC";
}elseif($_GET['order'] == 5)
{
$query = "SELECT * FROM todo_list ORDER BY phone_number ASC";
}elseif($_GET['order'] == 6)
{
$query = "SELECT * FROM todo_list ORDER BY postcode ASC";
}else{
$query = "SELECT * FROM todo_list";
}

$result = mysql_query($query);
if(!$result) die ("Database access failed: " . mysql_error());
$rows = mysql_num_rows($result);
echo "<table border=\"1\" id=\"table\">";
echo "<tr>";
echo "<th><a href=\"my_contacts.php?order=2\">Name</a></th>";
echo "<th><a href=\"my_contacts.php?order=3\">Age</a></th>";
echo "<th><a href=\"my_contacts.php?order=4\">Email Address</a></th>";
echo "</tr>";
for ($j = 0;$j < $rows; $j++) {
    echo "<tr>";
    echo "<td>" . mysql_result($result,$j,'complete') . "</td>";
    echo "<td>" . mysql_result($result,$j,'title') . "</td>";
    echo "<td>" . mysql_result($result,$j,'created_timestamp') . "</td>";
    echo "</tr>";
}
echo "</table>";
mysql_close($db_server);
echo "</center>";
*/
?>
<html>
<head>
    <title>To-Do List</title>
    <style>
        html {
            font-family: sans-serif;
        }
        table {
            border-collapse:collapse;
            margin-bottom: 20px;
        }
        table, th, td {
            border: 1px solid black;
        }
        th, td {
            padding: 5px;
        }
        th {
            background-color: green;
            color: white;
        }
        td.done-column, td.delete-column {
            text-align: center;
        }
        td.done-column a, td.delete-column a {
            text-decoration: none;
            font-weight: bold;
        }
        td.done-column a:hover, td.delete-column a:hover {
            text-decoration: underline;
        }
        tr.item-complete, tr.item-complete a {
            color: green;
        }
        tr.item-incomplete, tr.item-incomplete a {
            color: red;
        }
    </style>
</head>
<body>
<h2>Online To-Do List</h2>
<table>
<tr>
<th>Done</th>
<th>Title</th>
<th>Created</th>
<th></th>
</tr>
<?php
$db_hostname = "127.0.0.1";
$db_username = "cgscompu_deana1";
$db_password = "040497";
$db_database = "cgscompu_deana1";
$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if(!$db_server) {
    die("Unable to connect to MySQL: " . mysql_error());
}
mysql_select_db($db_database, $db_server) or die("Unable to select database: " . mysql_error());
$result = mysql_query("SELECT * FROM todo_list");
$rows = mysql_num_rows($result);

if(isset($_GET["done"])){
mysql_query("UPDATE todo_list SET complete=" . $_GET["done"] . " WHERE todo_id=" . $_GET["todo_id"]);
}

// Render table

for ($j = 0;$j < $rows; $j++) {
    switch (mysql_result($result,$j,'complete'))
{
case 0:
  echo '<tr class="item-incomplete">';
  echo '<td class="done-column"><a href="ToDo.php?todo_id=' . mysql_result($result,$j,'todo_id') . '&done=1' . '">NO</a></td>';
  echo '<td class="title-column">' . mysql_result($result,$j,'title') . '</td>';
  echo '<td class="created-column">4 days ago</td>';
  echo '<td class="delete-column"><a href="ToDo.php?delete_todo_id=' . mysql_result($result,$j,'todo_id') . '">[X]</a></td>';
  break;
case 1:
  echo '<tr class="item-complete">';
    echo '<td class="done-column"><a href="ToDo.php?todo_id=' . mysql_result($result,$j,'todo_id') . '&done=0' . '">YES</a></td>';
      echo '<td class="title-column">' . mysql_result($result,$j,'title') . '</td>';
        echo '<td class="created-column">4 days ago</td>';
  echo '<td class="delete-column"><a href="ToDo.php?delete_todo_id=' . mysql_result($result,$j,'todo_id') . '">[X]</a></td>';
  break;
}
//  echo <td class="done-column"><a href="ToDo.php?todo_id=1&done=1">NO</a></td>
//  echo "<td>" . mysql_result($result,$j,'created_timestamp') . "</td>";
    echo "</tr>";
}
/*
echo '<tr class="item-complete">';
echo '<td class="done-column"><a href="ToDo.php?todo_id=5&done=0">YES</a></td>';
echo '<td class="title-column">Weekend soccer game</td>';
echo '<td class="created-column">4 days ago</td>';
echo '<td class="delete-column"><a href="ToDo.php?delete_todo_id=5">[X]</a></td>';
echo '</tr>';
*/
echo '</table>';
?>
<form method="post" action="ToDo.php">
New To-Do Item: <input type="text" name="todo-title" size=40/><input type="submit" value="Add" />
</form>
<hr />
<p><strong>You do not need to implement anything below this line.</strong></p>
<p>The Reset button will simply reset the database back to it's original state - this is because this sample program is shared (i.e. anyone can access it and modify it, and potentially mess it up) so the Reset will put it back to it's original state for your testing.</p>
<form method="post" action="ToDo.php">
<input type="submit" name="reset" value="Reset" />
</form>
</body>
</html>