<?php
class user {
public function isValidEmail($email) {
return mysql_num_rows(mysql_query('SELECT `email` FROM `users` WHERE `email` = "'.$email.'"'));
}
public function isValidLogin($email, $password) {
return mysql_num_rows(mysql_query('SELECT `email`, `password` FROM `users` WHERE `email` = "'.$email.'" AND `password` = "'.$password.'"'));
}
public function fetch($query) {
return mysql_fetch_array(mysql_query($query));
}
public function getPasswordById($id) {
$result = $this->fetch('SELECT `id`, `password` FROM `users` WHERE `id` = "'.$id.'"');
return $result['password'];
}
public function getUsernameById($id) {
$result = $this->fetch('SELECT `id`, `username` FROM `users` WHERE `id` = "'.$id.'"');
return $result['username'];
}
public function getMembers() {
$query = mysql_query("SELECT * FROM `users`");
$i = 0;
while($show = mysql_fetch_array($query)){
$i++;
echo '
<tr align="center">
<td class="m">'.$i.'.</td>
<td class="m">'.$show['username'].'</td>
<td class="m">'.$show['joined'].'</td>
<td class="m">'.($show['activated'] < 2 ? "<font color='green'>Activated</font>" : "<font color='red'>Inactivated</font>").'</td>
</tr>
';
}
}
public function countMembers() {
return mysql_num_rows(mysql_query("SELECT `email` FROM `users`"));
}
}
?>