MySql ÅÄÖ fungerar ej
Hej jag har gjort en php-fil där man uppdaterar information i en databas men när man skriver in Å, Ä eller Ö så läggs ej detta till.
PHP-kod
<?php
include 'config.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset="UTF-8" />
<link href="<?php echo $design; ?>/style.css" rel="stylesheet" title="Style" />
<title>Redigera Elevinformation</title>
</head>
<body>
<div class="header">
<?php include 'default/header.php'; ?>
</div>
<div class="content">
<?php
if(isset($_SESSION['username']))
{
$dn = $connect->query('select username, admin from teachers where username="'.$_SESSION['username'].'"');
$dnn = mysqli_fetch_array($dn);
if($dnn['admin']="yes")
{
?>
<?php
if(isset($_POST['first_name'], $_POST['last_name'], $_POST['parents']))
{
if(get_magic_quotes_gpc())
{
$_POST['first_name'] = stripslashes($_POST['first_name']);
$_POST['last_name'] = stripslashes($_POST['last_name']);
$_POST['parents'] = stripslashes($_POST['username']);
$_POST['adress'] = stripslashes($_POST['password']);
$_POST['parents_number'] = stripslashes($_POST['passverif']);
$_POST['parents_email'] = stripslashes($_POST['email']);
$_POST['pers_nr'] = stripslashes($_POST['avatar']);
}
$first_name = $connect->real_escape_string($_POST['first_name']);
$last_name = $connect->real_escape_string($_POST['last_name']);
$pers_nr = $connect->real_escape_string($_POST['pers_nr']);
$class = $connect->real_escape_string($_POST['class']);
$adress = $connect->real_escape_string($_POST['adress']);
$parents = $connect->real_escape_string($_POST['parents']);
$parents_number = $connect->real_escape_string($_POST['parents-number']);
$parents_email = $connect->real_escape_string($_POST['parents-email']);
$parent2 = $connect->real_escape_string($_POST['parent2']);
$parent2_number = $connect->real_escape_string($_POST['parent2-number']);
$parent2_email = $connect->real_escape_string($_POST['parent2-email']);
$annan = $connect->real_escape_string($_POST['annan']);
$annan_number = $connect->real_escape_string($_POST['annan-number']);
$hamtning = $connect->real_escape_string($_POST['hamtning']);
$allergy = $connect->real_escape_string($_POST['allergy']);
$about = $connect->real_escape_string($_POST['about']);
$id = $_GET['id'];
if($connect->query('update students set first_name="'.$first_name.'", last_name="'.$last_name.'", pers_nr="'.$pers_nr.'", class="'.$class.'", adress="'.$adress.'", parents="'.$parents.'", parents_number="'.$parents_number.'", parents_email="'.$parents_email.'", parent2="'.$parent2.'", parent2_number="'.$parent2_number.'", parent2_email="'.$parent2_email.'", annan="'.$annan.'", annan_number="'.$annan_number.'", hamtning="'.$hamtning.'", allergy="'.$allergy.'", about="'.$about.'" where id="'.$id.'"'))
{
$form = false;
?>
<div class="message">Informationen har uppdaterats.<br />
<a href="student.php?id=<?php echo $_GET['id']; ?>">Visa elevsida</a></div>
<?php
}
else
{
$form = true;
$message = 'Ett fel inträffade, kontakta systemansvarig.';
}
}
else
{
$form = true;
}
if($form)
{
if(isset($message))
{
echo '<div class="message">'.$message.'</div>';
}
?>
<?php
}
}
else
{
header("Location: home.php");
}
}
else
{
header("Location: login.php");
}
?>
</div>
<div class="foot"><font color="#FFF">© FOOTER</font></div>
</body>
</html>
Tacksam för svar