function checklogin($name, $passwd)
{
$dbc = connectToDB("jed");
$encodepw = sha1($passwd);
$result = performQuery($dbc, "select * FROM pwdemo where name='{$name}' and pass='******'");
$matches = mysqli_num_rows($result);
mysqli_free_result($result);
disconnectFromDB($dbc);
return $matches == 1;
}
function checkFirstTime($username, $passwd)
{
$dbc = connectToDB("leeawg");
$encodepw = sha1($passwd);
$query = "select * FROM account where user_id='{$username}' and password='******'";
$result = performQuery($dbc, $query);
$extractedSQL = mysqli_fetch_assoc($result);
$firstTimeStatus = $extractedSQL['first_time'];
disconnectFromDB($dbc, $result);
if ($firstTimeStatus == 1) {
return true;
} else {
return false;
}
}
function createContinentMenu($menuname)
{
echo "<select name=\"{$menuname}\">\n";
$dbc = connectToDB();
$query = "select Continent from countries group by Continent";
$result = performQuery($dbc, $query);
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$continent = $row['Continent'];
if (isset($_GET[$menuname]) && $_GET[$menuname] == $continent) {
echo "<option value = \"{$continent}\" selected> {$continent} </option>\n";
} else {
echo "<option value = \"{$continent}\"> {$continent} </option>\n";
}
}
echo "</select>";
disconnectFromDB($dbc, $result);
}
$query = sprintf("SELECT * FROM {$table} WHERE (\n\t\t \t\t\t\t(category IN (%s)) AND\n\t\t \t\t\t\t(size IN (%s)) AND\n\t\t \t\t\t\t(msrp <= %s ) AND\n\t\t \t\t\t\t(mpg >= %s ) AND\n\t\t \t\t\t\t(stars >= %s ) AND\n\t\t \t\t\t\t(fuel IN (%s)) )\n\t\t \t\t\tORDER BY %s;", implode(", ", $_GET["categories"]), implode(", ", $_GET["sizes"]), $_GET["msrp"], $_GET["mpg"], $_GET["stars"], implode(", ", $_GET["fuel"]), $_GET["sortBy"]);
$result = $db_connection->query($query);
if ($result) {
$numberOfRows = mysqli_num_rows($result);
while ($recordArray = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$year = $recordArray['year'];
$manufacturer = $recordArray['manufacturer'];
$model = $recordArray['model'];
$image = $recordArray['image'];
//echo $year, $manufacturer, $model;
//echo '<img src="data:image/jpeg;base64,'.base64_encode($image);' />';
//TODO
}
mysqli_free_result($result);
}
disconnectFromDB($db_connection);
}
?>
<p class = "right">
<?php
session_start();
if (isset($_SESSION['username']) && $_SESSION['username'] != "") {
echo "Welcome, " . $_SESSION['username'] . "! ";
echo "<a class=\"right\" href=\"logout.php\" alt=\"Log Out\">Log Out </a>";
} else {
echo " ";
echo "<a class=\"right\" href=\"signup.html\" alt=\"Sign Up\">Sign Up</a> ";
echo "<a class=\"right\" href=\"login.html\" alt=\"Log In\">Log In</a>";
}
?>
