$place = $row['place'];
$ts = $row['ts'];
echo "<p class=\"color_value\"></p>";
echo "<p class=\"tags_display\">";
$query = "SELECT name FROM Tags, PhotosTags WHERE PhotosTags.photo_id = {$photo_id} AND Tags.tag_id = PhotosTags.tag_id";
if ($result = mysql_query($query, $link)) {
while ($row = mysql_fetch_array($result)) {
echo "<span>#" . $row['name'] . "</span>";
}
} else {
session_start();
$_SESSION['error'] = mysql_error($link);
header('location:error.php');
}
echo "</p>";
if (!IsNullOrEmpty($place)) {
echo "<p>@ {$place}</p>";
}
echo "<abbr class=\"ts\" title=\"{$ts}\"></abbr>";
?>
<br>
<a onClick="FBshare();" href="#">Share to Facebook</a><br>
<p class="filename"></p>
<div data-role="popup" id="color_popup">
<a href="#" data-rel="back" data-role="button" data-theme="a" data-icon="delete" data-iconpos="notext" class="ui-btn-left">Close</a>
<ul>
</ul>
</div>
</div>
} else {
$photo_query = "INSERT INTO Photos (save_path, palette_id, category, user_id, geolat, geolng, place, is_fav, frequency) VALUES ('{$save_path}', {$palette_id}, {$category}, {$user_id}, NULL, NULL, NULL, 0, 0)";
}
if (mysql_query($photo_query, $link)) {
$photo_query = "SELECT * FROM Photos where save_path = '{$save_path}' and user_id = {$user_id}";
$result = mysql_query($photo_query);
$array = mysql_fetch_array($result);
$photo_id = $array['photo_id'];
//process the tags
if (!IsNullOrEmpty($tag_string)) {
$tags = explode(",", $tag_string);
$tag_query = "";
for ($i = 0; $i < count($tags); $i++) {
$tag = trim($tags[$i]);
//remove spaces
if (IsNullOrEmpty($tag)) {
continue;
}
$tag_query = "SELECT * FROM Tags WHERE name = '{$tag}'";
$result = mysql_query($tag_query);
//if tag exists
if (mysql_num_rows($result) != 0) {
$array = mysql_fetch_array($result);
$tag_id = $array['tag_id'];
$tag_query = "INSERT INTO PhotosTags VALUES ({$photo_id}, {$tag_id})";
if (!mysql_query($tag_query, $link)) {
echo mysql_error($link);
}
} else {
$tag_query = "INSERT INTO Tags (name) VALUES ('{$tag}')";
if (!mysql_query($tag_query, $link)) {
<?php
include "config.php";
include "helper.php";
$email = $_POST["new_email"];
$password = $_POST["new_password"];
if (checkEmail($email) && !IsNullOrEmpty($password)) {
//see whether the email has already registered
$query = "SELECT * from Users WHERE email = '{$email}'";
$result = mysql_query($query);
//if not, register new user
if (mysql_num_rows($result) == 0) {
$query = "INSERT into Users (email, password) VALUES ('{$email}', '{$password}');";
if (mysql_query($query, $link)) {
$query = "select * from Users where email = '{$email}' and password = '******'";
$result = mysql_query($query);
$array = mysql_fetch_array($result);
//set the max life time of session to 8 hours
ini_set(’session . gc_maxlifetime’, 8 * 60 * 60);
session_start();
$_SESSION['user_id'] = $array['user_id'];
header('location:my_b.php');
} else {
session_start();
$_SESSION['error'] = mysql_error($link);
header('location:error.php');
}
} else {
session_start();
$_SESSION['account_error'] = "Oops, looks like the email has already been registered.";
header('location:new.php');
