" . $search . "", $res); } function clean_and_transliterate($s) { $clean_from = array( 'c', 'f', 'j', 'q', 'v', 'w', 'x', 'y', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'в', 'й', 'ф', 'ч', 'щ', 'ъ', 'ѣ', 'ь', 'ю', 'я', 'ѝ', 'ѫ', 'ѧ', '-', ' ', '/', '(', ')', "'", '"', ',', '.', ';', ''); $s = str_ireplace($clean_from, '', $s); $cyr_from = array('а', 'б', 'д', 'е', 'г', 'ж', 'з', 'х', 'и', 'к', 'л', 'м', 'н', 'о', 'п', 'р', 'с', 'ш', 'т', 'у', 'ц', '*', 'o'); $cyr_to = array('a', 'b', 'd', 'e', 'g', 'ĝ', 'z', 'h', 'i', 'k', 'l', 'm', 'n', 'u', 'p', 'r', 's', 'š', 't', 'u', 'z', '%', 'u'); $s = str_ireplace($cyr_from, $cyr_to, $s); return $s; } function format_root($root) { $replacement = '${1}'; $pattern = '/(\(\d([,\/ ]\d)*\))/'; $root = preg_replace($pattern, $replacement, $root); $pattern = '/(\d([,\/ ]\d)*)/'; $root = preg_replace($pattern, $replacement, $root); return $root; } $mysqli = new mysqli("localhost", "grazhdan_sumer", "q1w2e3r4", "grazhdan_sumer"); // prod // $mysqli = new mysqli("localhost", "sumer", null, "sumer"); // local /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $mysqli->set_charset("utf8mb4"); $s_english = false; $s_submitted = @boolval($_POST["sforms"]); $s_type = @intval($_POST["s_type"]); $s_search = @trim($_POST["ss"]); if ($s_search == "") { $s_search = @trim($_GET["ss"]); } else if ($s_type != 2) { $s_search = clean_and_transliterate($s_search); } $s_search = strtolower($s_search); $num_rows = 0; $result = null; $random_search = false; if ($s_search) { if ($s_type == 2) { $s_english = true; if (strlen($s_search) >= 4) { // fulltext seatch wors for 4 or more chars $query = "SELECT *, LOCATE('$s_search', `meaning`) AS pos FROM `sumlex` WHERE MATCH(`meaning`) AGAINST('$s_search') ORDER BY pos LIMIT 100"; } else { $q_like = " '%$s_search%'"; // $query = "SELECT * FROM `sumlex` WHERE `meaning` LIKE $q_like LIMIT 100"; $query = "SELECT *, LOCATE('$s_search', `meaning`) AS pos FROM `sumlex` WHERE `meaning` LIKE $q_like ORDER BY pos LIMIT 100"; } } else { $q_like = $s_type == 1 ? " '%$s_search%'" : " '$s_search'"; $query = "SELECT *, LENGTH(`simple`) AS le FROM `sumlex` WHERE (`clean` LIKE $q_like OR `simple` LIKE $q_like) ORDER BY le LIMIT 50"; } } else { $random_search = true; // do random word $query = "SELECT * FROM `sumlex` WHERE `cuneiform` != '' GROUP BY cuneiform ORDER BY RAND() LIMIT 3"; } $result = $mysqli->query($query); if (!$result) { printf("Errormessage: %s\n", $mysqli->error); } $num_rows = $result->num_rows; $results_found_str = $num_rows . " results found"; if ($random_search) { $results_found_str = "Showing random words. Use the box above to refine search."; } ?> Sumerian lexicon search

Sumerian lexicon search

/> /> />


0) { ?>
0) { ?>
Cuneiform
Sumerian word
English description
" . $row["cuneiform"] . "" ; } else { echo "" . format_root($row["linguistic"]) . "" ; } ?>
">
External links
©2016 SUMER.GRAZHDANI.EU
close(); ?>