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>"; } ?>