I have been looking for a mistake in my php and mysql for the past 5 hours. I have no clue what I have done wrong or if there is just a problem with my mamp. I think it may be a problem with my mamp. This is where I believe the problem would be taking place. But the problem is that now every page comes up blank. Thanks.
site/core/init.php
<?php
session_start();
error_reporting(0);
require 'database/connect.php';
require 'database/general.php';
require 'functions/users.php';
$errors = array();
?>
site/core/functions/users.php
<?php
function user_exists($username) {
$username = sanitize($username);
$query = mysql_query("SELECT COUNT('user_id') FROM 'users' WHERE 'username' = '$username'");
return (mysql_result($query, 0) == 1 ) ? true : false;
}
?>
site/includes/widgets/logins
<aside>
<div class = "rightsidebar">
<h2>Log in/Register</h2>
<form action = "login.php" method = "post">
<ul id = ".login">
<li>
Username:<br>
<input type = "text" name = "username">
</li>
<li>
Password:<br>
<input type = "password" name = "password">
</li>
<li>
<input type = "submit" value = "Log In">
</li>
<li>
<a href = "register.php"><p>Register</p></a>
</li>
</ul>
</form>
</div>
</aside>
site/core/database/connect.php
<?php
mysql_connect('localhost', 'root', 'root');
mysql_select_db('lr');
?>
site/core/functions/general.php
<?php
function sanitize($data) {
return mysql_real_escape_string($data);
}
?>
site/login.php
<?php
include 'core/init.php';
if (user_exists('ben') === true) {
echo 'exists';
}
die();
if(empty($_POST) === false) {
$username = $_POST['username'];
$password = $_POST['password'];
if(empty($username) === true | | empty($password) === true) {
$errors[] = 'You need to enter a username and password';
} else if (user_exists($username) === false) {
$errors[] = 'We ca\'nt find that username. Have you registered?';
}
}
?>
