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