Nazdar hoši ,
obraciam sa k vam znovu s mojim problemom ktory sa vyskitol pri vkladani udajov do databazy .
Problem je to v databaze mam nastavene kodovanie jazyka na latin2_czech_cz to je v pohode ked nieco napisem v databaze po cesky alebo slovensky s diakritikami tak v pohode to ukaze tak ako ma . ale ak to posielam so stranky tam mi uz neukazuje diakritika iba otazniky. hodim vám sem aj kod ktory pouzivam na odosielanie clankov do DB .
Citácia:
<?php
$hostname = "xxxx";
$db_user = "xxxx";
$db_password = "xxxx";
$database = "xxxx";
$db_table = "posts";
$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<?php
if (isset($_REQUEST['Submit'])) {
$sql = "INSERT INTO $db_table(Title,Author,Content,Category,added) values ('".mysql_real_escape_string(stripslashes($_REQUEST['Title']))."','".
mysql_real_escape_string(stripslashes($_REQUEST['Author']))."','".
mysql_real_escape_string(stripslashes($_REQUEST['Content']))."','".
mysql_real_escape_string(stripslashes($_REQUEST['Category']))."','".
mysql_real_escape_string(stripslashes($_REQUEST['added']))."')";
if($result = mysql_query($sql ,$db)) {
echo 'článok bol úspešne pridaný';
} else {
echo "ERROR: ".mysql_error();
}
} else {
?>
<form method="post" action="">
Názov:<br>
<input type="text" name="Title">
<br>
Autor: <br>
<input type="text" name="Author">
<br><br>
Obsah: <br>
<textarea type="text" name="Content" > </textarea>
<br><br>
Categória: <br>
<select name="Category">
<option>html</option>
<option>php</option>
<option>photoshop</option>
<option>dreamweaver</option>
<option>flash</option>
<option>aftereffect</option>
<option>flashbuilder</option>
<option>flashcatalyst</option>
<option>iphone</option>
<option>ipad</option>
<option>osx</option>
<option>windows</option>
</select>
<br><br>
Pridané: <br>
<input type="text" name="added" value="<?php
$datum = StrFTime("%d-%m-%Y %H:%M:%S", Time());
echo($datum);
?>">
<br><br>
<input type="submit" name="Submit" value="Poslať">
</form>
<?php
}
?>
</body>
</html>
