Untitled Document

<?
include("users.inc");
connect_to_users_db();

if ($_CURRENT_USER->is_anonymous) {
show_error("You must be logged in to view this dream journal.",
$PHP_USERS_HEADER_FILE,
$PHP_USERS_FOOTER_FILE);
}

$loggedin_user_id = $_CURRENT_USER->id;

$PAGE_TITLE = "dream journal";
include $PHP_USERS_HEADER_FILE;

if ($_POST["submit"]) {

// here if no ID then adding else we're editing

if ($_POST["id"]) {

$sql = "UPDATE Journals SET dream='".addslashes($_POST["dream"])."', month=".$_POST["month"].", day=".$_POST["day"].", year=".$_POST["year"].", time=".$_POST["time"]." WHERE dreamId=".$_POST["id"];
} else {

$sql = "INSERT INTO Journals (userId, dream, month, day, year, time) VALUES (".$loggedin_user_id.", '".addslashes($_POST["dream"])."', ".$_POST["month"].", ".$_POST["day"].", ".$_POST["year"].", ".$_POST["time"].")";

}

// run SQL against the DB
//echo $sql;
$result = mysql_query($sql);

echo "Record updated/edited!<p>";

} elseif ($_REQUEST["delete"]) {

// delete a record

$sql = "DELETE FROM Journals WHERE dreamId=".$_REQUEST["id"];

$result = mysql_query($sql);

echo "Record deleted!<p>";

} else {

// this part happens if we don't press submit

if (!$_REQUEST["id"]) {
$sql = "SELECT * FROM Journals WHERE userId = $loggedin_user_id";

$result = mysql_query($sql);

#echo "<p><a href="#add"><b>Add a New Dream</b></a>";
echo "<p><font color='red'><i>Click on any of your links to see similiar themes in other users' dreams *</p></i></font>";
while ($myrow = mysql_fetch_array($result)) {
echo "<hr size=\"1\">";
switch ($myrow["month"]) {
case 1:
$displayMonth = "January";
break;
case 2:
$displayMonth = "February";
break;
case 3:
$displayMonth = "March";
break;
case 4:
$displayMonth = "April";
break;
case 5:
$displayMonth = "May";
break;
case 6:
$displayMonth = "June";
break;
case 7:
$displayMonth = "July";
break;
case 8:
$displayMonth = "August";
break;
case 9:
$displayMonth = "September";
break;
case 10:
$displayMonth = "October";
break;
case 11:
$displayMonth = "November";
break;
case 12:
$displayMonth = "December";
break;
}

printf("<b><font size=\"4\">%s %s, %s</font></b><br>\n", $displayMonth, $myrow["day"], $myrow["year"]);

$dreamText = $myrow["dream"];
$sqlTags = "SELECT * FROM Tags";
$resultTags = mysql_query($sqlTags);

$tagListing = "";

while ($rsTags = mysql_fetch_array($resultTags)) {
#$pos = strpos($mystring, $rsTags["tag"]);

$findTag = " ".$rsTags["tag"]." ";
$replaceTag = " <a href='tags.php?tag=".$rsTags["tag"]."'>".$rsTags["tag"]."</a> ";

$dreamText = str_replace($findTag, $replaceTag, $dreamText, $count);

if ($count > 0) {
#$sqlTagInsert = "INSERT INTO TagsJournals (dreamId, tagID) VALUES (".$myrow["dreamId"].", ".$rsTags["tag_id"].")";
#$resultTagInsert = mysql_query($sqlTagInsert);
#echo $sql."<br>";
$tagListing = $tagListing." <a href='tags.php?tag=".$rsTags["tag"]."'>".$rsTags["tag"]."</a>";

}
}

echo nl2br($dreamText);
echo "<p><B><font size='3'>dream themes:</font> </B> ".$tagListing."</p>";

#printf("%s<P>\n", $myrow["dream"]);

printf("<a href=\"%s?id=%s\">EDIT</a>  |  ", $PHP_SELF, $myrow["dreamId"]);

printf("<a href=\"%s?id=%s&delete=yes\">DELETE</a><br>", $PHP_SELF, $myrow["dreamId"]);

}

<!--P>

<a href="<?php echo $PHP_SELF?>">ADD A RECORD</a-->

<?php

if ($_REQUEST["id"]) {

// editing so select a record

$sql = "SELECT * FROM Journals WHERE dreamId=".$_REQUEST['id'];
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);

$id = $myrow["dreamId"];
$dream = $myrow["dream"];
$dreamMonth = $myrow["month"];
$dreamDay = $myrow["day"];
$dreamYear = $myrow["year"];
$dreamTime = $myrow["time"];

// print the id for editing

<?php

}

<a name="add"></a><font size="5" color="#ffffff">enter your dream</font>
<BR>
<textarea name="dream" cols="70" rows="10"><?php echo $dream ?></textarea><br>

</td></tr>
</table>
</form>

<?php

}

include $PHP_USERS_FOOTER_FILE;
?>