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 }