Veilige login functie?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<?php
function login() {
$sql = "SELECT name, username
FROM user
WHERE username= ? AND password = ?";
$query = $this->db->query($sql, array($this->gebruikersnaam, $this->wachtwoord));
if($query->num_rows() == 1) {
$data = array(
'logged_in' => true,
'result' => $query->result_array()
);
} else {
$data = array(
'logged_in' => false
);
}
return $data;
}
?>
function login() {
$sql = "SELECT name, username
FROM user
WHERE username= ? AND password = ?";
$query = $this->db->query($sql, array($this->gebruikersnaam, $this->wachtwoord));
if($query->num_rows() == 1) {
$data = array(
'logged_in' => true,
'result' => $query->result_array()
);
} else {
$data = array(
'logged_in' => false
);
}
return $data;
}
?>
Edit:
Code (php)
1
2
3
4
5
6
2
3
4
5
6
<?php
$sql = "SELECT name, username, password
FROM user
WHERE username= ? AND password = ?";
?>
$sql = "SELECT name, username, password
FROM user
WHERE username= ? AND password = ?";
?>
veranderd naar:
Code (php)
1
2
3
4
5
2
3
4
5
<?php
$sql = "SELECT name, username
FROM user
WHERE username= ? AND password = ?";
?>
$sql = "SELECT name, username
FROM user
WHERE username= ? AND password = ?";
?>
Gewijzigd op 28/01/2012 14:12:17 door Jack Sierkstra
Gesponsorde koppelingen:
Er zijn nog geen reacties op dit bericht.
