function showProfile($conn, $user)
{
if (file_exists($user . ".jpg")) {
echo "<img src= {$user}.jpg id='profile'/> <br/>";
}
$result = queryMySql($conn, "SELECT * FROM `profiles` WHERE `user`='{$user}'");
if ($result->num_rows) {
$row = mysqli_fetch_row($result);
echo "<span id='blue' > " . $user . "</span> <br/>";
echo "<span id='pink'>" . stripslashes($row[2]) . "</span><br/>";
}
}
\t\t</div>
\t\t<div>
\t\t<h2>Completed</h2>
\t\t<form method='POST' action='index.php' name="gamma">
_END;
// Displays the list of Completed items
$query = "SELECT * FROM todo WHERE status='yes'";
$result = queryMySql($query);
$num = mysql_num_rows($result);
for ($i = 0; $i < $num; $i++) {
$row = mysql_fetch_row($result);
echo <<<_END
\t\t\t\t<br /><input type='checkbox' value=row[0] checked='checked'/>
\t\t\t\t<label class="strike">{$row['1']}</label>
_END;
}
echo <<<_END
\t\t</form>
\t\t</div>
\t\t<script type="text/javascript" src="script.js"></script>
\t</body>
</html>
_END;
//Adds fields to completed Status
if (isset($_POST['list'])) {
$sel = $_POST['list'];
foreach ($sel as $item) {
$query = "UPDATE todo SET status='yes' WHERE id={$item}";
queryMySql($query);
}
}
function tableExists($name)
{
$result = queryMySql("SHOW TABLEs LIKE '{$name}'");
return mysql_num_rows($result);
}
<?php
include_once 'functions.php';
if (isset($_POST['user'])) {
$user = sanitizeString($conn, $_POST['user']);
if (mysql_num_rows(queryMySql("SELECT * FROM `members` WHERE `user`='{$user}'"))) {
echo "<span class='taken'> ✘ Sorry this username is taken</span>";
} else {
echo "<span class='available'> ✔ This username is available/span>";
}
}
