Passy

function username_exists($username){ global $db; $sql = "SELECT 'username' FROM users WHERE 'username' = '$username'"; $result = mysqli_query($db, $sql); confirmquery( $result ); if (mysqli_num_rows($result) > 0) { return true; }else { return false; } } if(username_exists($username)){ $error['username'] = 'Username already exists'; }

**my functions.php file** <?php function confirmquery( $result ){ global $db; if(!$result){ die("OUERY FAILED .".mysqli_error($db)); } } function redirect($location){ return header("Location:". $location); } function is_admin($username = ''){ global $db; $sql = "SELECT user_role FROM users WHERE username = '$username'"; $result = mysqli_query($db, $sql); confirmquery( $result ); $row = mysqli_fetch_array($result); if ($row['user_role'] …

function username_exists($username){ global $db; $sql = "SELECT 'username' FROM users WHERE 'username' = '$username'"; $result = mysqli_query($db, $sql); confirmquery( $result ); if (mysqli_num_rows($result) > 0) { return true; }else { return false; } } if(username_exists($username)){ $error['username'] = 'Username already exists'; }

<?php $sql =" SELECT * FROM `comments` "; $result = mysqli_query($db, $sql); while($row = mysqli_fetch_assoc($result)){ $comment_id = $row['comment_id']; $comment_company_id = $row['comment_company_id']; $comment_name = $row['comment_name']; $comment_content = $row['comment_content']; $comment_email = $row['comment_email']; $comment_status = $row['comment_status']; $comment_date = $row['comment_date']; echo "<tr>"; echo "<td>$comment_id </td>"; echo "<td>$comment_name </td>"; echo "<td>$comment_content</td>"; echo "<td>$comment_email</td>"; echo "<td>$comment_status …

<?php if(!empty($_POST['submit'])){ if(empty($_POST['user_name'])|| empty($_POST['phone_number'])|| empty($_POST['email'])|| empty($_POST['password'])|| empty($_POST['confirm_password'])) { exit("please fill in all the fields. <a href = './register.php'>return</a>"); } if($_POST['password']!==$_POST['confirm_password']) { exit("passwords must match. <a href = './register.php'>return</a>"); } /*$pattern = "^([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})$"; if(!pregmatch($pattern,$POST['email'])) { exit("please enter a valid email address. <a href = './register.php'>return</a>"); }*/ $regex = '/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/'; if (!preg_match($regex, …

<?php if(isset($_COOKIE['id'])&&isset($_COOKIE['security'])){ $id = addslashes($_COOKIE['id']); //just in case $sql ="SELECT * FROM `customer_information_table` WHERE `customer_id` = '$id'" ; require_once("./connect.php"); $result = mysqli_query($db, $sql); if($db->error){ exit("SQL ERROR"); } IF(mysqli_num_rows($result) === 0 ){ exit("illegal operation.<a href = './login.php'>login</a>"); } //id is real $array = $result->fetch_array(); $result->free(); $shell = md5($_COOKIE['id'].$array['password']."one_plus_one_is_three"); $db->close(); if($shell === …

$sql="SELECT * FROM `customer_information_table` WHERE `email`='{email}'"; $result = $db->query($sql); if($db->error) { exit("SQL error. <a href = './register.php'>return</a>"); } if($result->num_rows!==0) { exit("email address already exists. <a href = './register.php'>return</a>"); }

<?php if(!empty($_POST[`submit`])){ if(empty($_POST[`user_name`])|| empty($_POST[`phone_number`])|| empty($_POST[`email`])|| empty($_POST[`password`])|| empty($_POST[`confirm_password`])) { exit("please fill in all the fields. <a href = './register.php'>return</a>") } if($_POST[`password`]!==$_POST[`confirm_password`]) { exit("passwords must match. <a href = './register.php'>return</a>"); } $pattern = "/^([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})$/"; if(!pregmatch($pattern,$POST[`email`])) { exit("please enter a valid email address. <a href = './register.php'>return</a>"); } /* $pwd = $_POST['password ']; …

<?php if(!empty($_POST[`submit`])){ if(empty($_POST[`user_name`])|| if(empty($_POST[`phone_number`])|| if(empty($_POST[`email`])|| if(empty($_POST[`password`])|| if(empty($_POST[`confirm_password`])) { exit("please fill in all the fields. <a href = './register.php'>return</a>"); } if(empty($_POST[`password`]!==$_POST[`confirm_password`]) { exit("passwords must match. <a href = './register.php'>return</a>"); } $pattern="/^([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})$/"; if(!pregmatch($pattern,$POST[`email`])) { exit("please enter a valid email address. <a href = './register.php'>return</a>"); } $pwd = $_POST['password ']; if( strlen($password ) …