function display_blogpost($title, $date, $body, $indent_sofar)
{
$indent = str_repeat(" ", $indent_sofar);
$final_indent = str_repeat(" ", $indent_sofar - 1);
$readable_date = process_date($date);
$indented_body = str_replace("\n", "\n" . $indent, $body);
echo <<<END
<div class='blogpost'>
{$indent}<div class='title'>{$title}</div>
{$indent}<div class='date'>{$readable_date}</div>
{$indent}{$indented_body}
{$final_indent}</div>
END;
}
case "12":
$month = "December";
break;
}
return $month . " " . $date_elements[2] . ", " . $date_elements[0];
}
$code = $_GET['code'];
$SQL = "SELECT * FROM classes WHERE code= '{$code}'";
$result = mysql_query($SQL);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
//get project info
$courseID = $row['id'];
$code = $row['code'];
$desc = $row['description'];
$creator = $row['creator'];
$date = process_date($row['date']);
$invite = $row['invite'];
//get creator info
$SQL = "SELECT * FROM users WHERE email = '{$creator}'";
$result = mysql_query($SQL);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$creatorname = $row['name'];
$creatorId = $row['userid'];
?>
<!-- Page Content -->
<br>
<br>
<br>
<div class="container">
</head>
<body>
<?php
require $root . "/includes/header.html";
?>
<?php
require $root . "/includes/nav.html";
?>
<main>
<?php
require $root . "/params.php";
require $root . "/functions.php";
$connection = mysql_connect($hostname, $username, $password);
mysql_select_db($database);
$url = mysql_real_escape_string($_GET['id']);
$result = mysql_query("SELECT * FROM articles WHERE url='{$url}';");
echo "\t\t<h1>" . mysql_result($result, 0, "title") . "</h1>";
echo "\t\t<div class=\"date\">" . process_date(mysql_result($result, 0, "date")) . "</div>";
echo mysql_result($result, 0, "body");
mysql_close();
?>
</main>
<?php
require $root . "/includes/footer.html";
?>
</body>
</html>
/*connect to database */
$user_name = "root";
$pass_word = "csc309";
$database = "startit";
$server = "104.236.231.174:3306";
$db_handle = mysql_connect($server, $user_name, $pass_word);
$db_found = mysql_select_db($database, $db_handle);
$SQL = "SELECT * FROM users WHERE email = {$email}";
$result = mysql_query($SQL);
//retrieve user data from sql server and web server.
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$name = $row['name'];
$email = $row['email'];
$user_id = $row['userid'];
$raw_date = $row['date'];
$date = process_date($raw_date);
//Find projects initiated by the current user.
$SQL2 = "SELECT * FROM projects WHERE creator = '{$email}'";
$result2 = mysql_query($SQL2);
?>
<section id="profile">
<div class="container">
<br>
<br>
<br>
<div class= 'text-center'>
<h2 class="title text-center profile_headings">Welcome to your profile <?php
echo $name;
?>
!</h2>
function html($content)
{
preg_match("/<body>.*<p>(.*)<\\/p>.*<time>(.*)<\\/time>.*<\\/body>/msU", $content, $matches);
return array("status" => "ok", "date" => time(), "content" => array("date" => process_date($matches[2]), "message" => $matches[1]));
}
function get_open_house()
{
global $useradmin, $current_YVR_date;
$selectSQL = "SELECT sysid, open_house, last_trans_date, public_remarks, public_remarks_2 FROM listings WHERE (LOWER(public_remarks) LIKE '%open house%' OR LOWER(public_remarks_2) LIKE '%open house%') AND status='A' AND !ISNULL(listings.album_id) AND listings.property_type!='Land Only' AND area_desc!='VOT' AND area_desc!='FOT' AND DATE(last_trans_date)='" . $current_YVR_date . "'";
$get_listing = mysql_query_or_die($selectSQL, $useradmin);
//$string_array=array();
while ($row_get_listing = mysql_fetch_assoc($get_listing)) {
//echo "<br/><h1>".$row_get_listing[sysid]."</h1><br/>";
$description = $row_get_listing['public_remarks'] . $row_get_listing['public_remarks_2'];
$pattern = '/(?i)open house(.+)/';
preg_match($pattern, $description, $matches);
$date_string = process_date($matches[1]);
$last_trans_year = date('Y', strtotime($row_get_listing['last_trans_date']));
if (!empty($date_string)) {
$open_house_date = $last_trans_year . '-' . $date_string;
}
$temp_array = array("original" => $matches[1], "date" => $open_house_date);
if (!empty($open_house_date)) {
if (!empty($row_get_listing['open_house'])) {
if ($open_house_date != $row_get_listing['open_house']) {
echo '<br/>' . $row_get_listing['sysid'] . ' already has an open house date but a new open house date is set.Updating...<br/>';
$updateSQL = sprintf("UPDATE listings SET open_house=%s WHERE sysid=%s", GetSQLValueString($open_house_date, "date"), GetSQLValueString($row_get_listing['sysid'], "int"));
$result = mysql_query_or_die($updateSQL, $useradmin);
} else {
echo '<br/>' . $row_get_listing['sysid'] . ' already has an open house date, and it is the most updated version...<br/>';
}
} else {
echo '<br/>' . $row_get_listing['sysid'] . ' does not have an open house date.<br/>';
$updateSQL = sprintf("UPDATE listings SET open_house=%s WHERE sysid=%s", GetSQLValueString($open_house_date, "date"), GetSQLValueString($row_get_listing['sysid'], "int"));
$result = mysql_query_or_die($updateSQL, $useradmin);
}
}
unset($open_house_date);
//array_push($string_array, $temp_array);
}
//echo json_encode($string_array);
}
