I have a login function, but there is one problem, before redirecting to the next page I have to check if $user_data['isikukood'] is in $tootaja_data Maybe i'm doing something wrong? It doesen't works.
PhP
db_connect();
if (isset($_POST['login']) ) {
$kasutajanimi = $_POST['kasutajanimi'];
$password = $_POST['pass'];
$query = mysql_query("SELECT * FROM isik WHERE nimi='$kasutajanimi'");
$query_tootaja = mysql_query("SELECT isikukood FROM tootaja");
$user_data = mysql_fetch_array($query);
$count = 0;
$tootaja_data = array();
while($row = mysql_fetch_assoc($query_tootaja))
{
$tootaja_data[$count] = $row;
$count++;
}
if($user_data['parool'] == $password){
foreach($tootaja_data as $value){
if($user_data['isikukood'] == $value){
header('Location: ../main.php/?view=tootaja');
}else{
header('Location: ../main.php/?view=klient');
}
}
// print_arr($tootaja_data);
}else{
header('Location: ../index.php');
}
}