public static function login($connection, $email, $password, $ip)
{
$data = "id, name, lastname, landline_number, mobile_number, home_number, \n\t\t\t\t\thome_address, birth_date, twitter, facebook, employee_type";
$table = "employees";
$where = "email = '" . $email . "' and password = '******'";
$others = "limit 1";
if ($result = $connection->select($data, $table, $where, $others)) {
$num_rows = $result->num_rows;
if ($num_rows > 0) {
$row = $result->fetch_array();
$id = md5($row['id']);
$name = $row['name'];
$lastname = $row['lastname'];
$landline = $row['landline_number'];
$mobile = $row['mobile_number'];
$homeline = $row['home_number'];
$address = $row['home_address'];
$birth = $row['birth_date'];
$twitter = $row['twitter'];
$facebook = $row['facebook'];
$type = $row['employee_type'];
$instance = new employee($name, $lastname, $landline, $mobile, $homeline, $address, $birth, $twitter, $facebook, $email, $password, $type, $id);
if ($instance->updateLastLogin($connection, $ip)) {
return $instance;
//User object with info
} else {
return -1;
//Data Base Connection Error
}
} else {
$result->close();
return 0;
//Incorrect Login
}
$result->close();
}
return -1;
//Data Base Connection Error
}
