<?
	function det_l($ch)
	{
	
		$rus_c = array("а","б","в","г","д","е","ё","ж","з","и","й","к","л","м",  "н","о","п","р","с","т","у","ф","х","ц","ч","ш","щ","ъ","  ы","ь","э","ю","я","А","Б","В","Г","Д","Е","Ё","Ж","З","И","Й","К","Л","М","Н","О","П","Р","С","Т","У","Ф","Х","Ц","Ч","Ш","Щ","Ъ","Ы","Ь","Э","Ю  ","Я");
		$eng_c = array("a","b","c","d","e","f","h","i","j","k","l","m","n",  "o","p","q","r","s","t","u","v","w","x","y","z","A","B","  C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z");
		$eng_len=count($eng_c);
		$rus_len=count($rus_c);
		
		for($i=0;$i<$eng_len;$i++)
			if($eng_c[$i]==$ch)
				$lang = 1;
			
		for($i=0;$i<$rus_len;$i++)
			if($rus_c[$i]==$ch)
				$lang = 2;
				
		if ($lang == 1)
			return 1;
		else
			return 2;
		
	}
	
	function in_arr($ch)
	{
		
		$rus_c = array("а","б","в","г","д","е","ё","ж","з","и","й","к","л","м","н","о","п","р","с","т","у","ф","х","ц","ч","ш","щ","ъ","  ы","ь","э","ю","я","А","Б","В","Г","Д","Е","Ё","Ж","З","И","Й","К","Л","М","Н","О","П","Р","С","Т","У","Ф","Х","Ц",& ;quo t;Ч","Ш","Щ","Ъ","Ы","Ь","Э","Ю  ","Я");
		$eng_c = array("a","b","c","d","e","f",","h","i","j","k","l","m","n",  "o","p","q","r","s","t","u","v","w","x","y","z","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q" ,"R","S","T","U","V","W","X","Y","Z");
		$eng_len=count($eng_c);
		$rus_len=count($rus_c);
		
		for($i=0;$i<$eng_len;$i++)
			if($eng_c[$i]==$ch)
				$yn = 1;
			
		for($i=0;$i<$rus_len;$i++)
			if($rus_c[$i]==$ch)
				$yn = 1;
				
		if ($yn == 1)
			return 1;
		else
			return 0;
		
	}
	
	$db_host = 'localhost';
	$db_user = 'root';
	$db_pass = '1';
	$db_database = 'word'; 
	$link = mysql_connect($db_host,$db_user,$db_pass);
	mysql_select_db($db_database,$link);
	
	$max_theme = 0;
	$max_word = 0;
	
	$query = ("SELECT * FROM themes");
	$result = mysql_query($query);
	while($res = mysql_fetch_row($result))
		{
			if($max_theme<$res[0])
				$max_theme=$res[0];
		}
			
	$query = ("SELECT * FROM words");
	$result = mysql_query($query);
	while($res = mysql_fetch_row($result))
		{
			if($max_word<$res[0])
				$max_word=$res[0];
		}
	
	$max_word++;
	$max_theme++;
	$num_insert = 0;
	$less_num = 1;	
	
	$f = fopen("base.txt","r");
	while(!feof($f))
	{
		$str = fgets($f);
		$str_len = strlen($str);
		
		unset($e_f);
		unset($e_l);
		unset($r_f);
		unset($r_l);
		$e_w="";
		$r_w="";		
		
		for($i=0;$i<$str_len;$i++)
		{
			if(in_arr($str[$i])==1)
			{
				if(det_l($str[$i])==1)
					if(isset($e_f)==false)
					{
						$e_f = $i;
						$e_l = $i;
					}
					else
						$e_l = $i;
					
				if(det_l($str[$i])==2)
					if(isset($r_f)==false)
					{
						$r_f = $i;
						$r_l = $i;
					}
					else
						$r_l = $i;
			}
			
		}
		
		for($i=$e_f;$i<=$e_l;$i++)
			$e_w = $e_w.$str[$i];
		
		for($i=$r_f;$i<=$r_l;$i++)
			$r_w = $r_w.$str[$i];
		
		[color=red]mysql_query("insert into words values($max_word,'$e_w','$r_w',$max_theme)");[/color]
		$max_word++;
		
	}
	
?>

mysql_query("insert into words values($max_word,".'$e_w'.",".'$r_w'.",$max_theme)");

mysql_query("insert into words values(".$max_word.",'".$e_w."','".$r_w."',".$max_theme.")");

mysql_query("
INSERT INTO `words` SET
`text` = '".$text."'
");

mysql_query("insert into `words` SET
                     `word_code` = '".$max_word."',
                     `e_word` = '".$e_w."',
                     `r_word` = '".$r_w."',
                     `theme_code` = '".$max_theme."'");

mysql_query("insert into `words` SET
                     `word_code` = '".$max_word."',
                     `e_word` = '".$e_w."',
                     `r_word` = '".$r_w."',
                     `theme_code` = '".$max_theme."'") or die(mysql_error());

Спустя 11 минут, 7 секунд (23.01.2011 - 19:47) mixer написал(а):

Выдает следующее:

Incorrect string value: '\xE3\xEB\xE0\xE2\xED\xFB...' for column 'r_word' at row 1

Ничего не пойму, там буквы должны быть

mysql_query("insert into words values($max_word,'".$e_w."','f',$max_theme)");

$r_w='gffd';
		
mysql_query("insert into words values($max_word,'".$e_w."','".$r_w."',$max_theme)");

$r_w='авы';

mysql_query("insert into words values($max_word,'".$e_w."','".$r_w."',$max_theme)");

mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");

show variables like ‘char%’

mysql_query ("SET CHARACTER SET 'utf8'", $link); 
mysql_query ("set character_set_client='utf8'"); 
mysql_query ("set character_set_results='utf8'"); 
mysql_query ("set collation_connection='utf8_general_ci'"); 
mysql_query ("SET NAMES utf8");

setlocale (LC_CTYPE, 'ru_RU.utf8');