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); }