1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
|
<?php
function suppr_accents($chaine) {
$accents = array('À','Á','Â','Ã','Ä','Å','Ç','È','É','Ê','Ë','Ì','Í','Î','Ï','Ò','Ó','Ô','Õ','Ö','Ù','Ú','Û','Ü','Ý','à','á','â','ã','ä','å','ç','è','é','ê','ë','ì','í','î','ï','ð','ò','ó','ô','õ','ö','ù','ú','û','ü','ý','ÿ');
$sans = array('A','A','A','A','A','A','C','E','E','E','E','I','I','I','I','O','O','O','O','O','U','U','U','U','Y','a','a','a','a','a','a','c','e','e','e','e','i','i','i','i','o','o','o','o','o','o','u','u','u','u','y','y');
return str_replace($accents, $sans, $chaine);
}
function is_anagram($string_1, $string_2)
{
if (count_chars($string_1, 1) == count_chars($string_2, 1))
return $string_1;
else
return ;
}
$mot="avarièrent";
$mot= suppr_accents($mot);
$mot=strtolower($mot);
$nbr=strlen($mot);
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "Mots";
$lettre="dictionnaire";
echo $mot."<br/>.....<br/>";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM $lettre WHERE scrabble_nbr = $nbr";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$row["scrabble_name"]=suppr_accents(strtolower($row["scrabble_name"]));
if ($row["scrabble_name"]==suppr_accents($mot)){echo "oui,";$id=$row["scrabble_id"];}
if (is_anagram(suppr_accents($row["scrabble_name"]), $mot)==""){}else{
$mem.= is_anagram(suppr_accents($row["scrabble_name"]), $mot).",";
}
}//if
}//while
$mem=substr($mem,0,-1);
echo "<b>".$mot."</b> <br/>";
echo $mem. " id= ".$id;
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$sql = "UPDATE dictionnaire set scrabble_anagramme='$mem' where scrabble_id=$id";
if ($conn->query($sql) === TRUE) {
} else {
echo "Error updating record: " . $conn->error;
}//if
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$conn->close();
?> |
Partager