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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Language" content="ar-kw">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256" />
</head>
<body>
$mot = $_POST['mot'] ;
$sens = $_POST['sens'] ;
$link = mysql_connect("localhost", "user", "pwd");
mysql_query("SET CHARACTER SET 'cp1256';", $link)
or die("<br>Impossible de se connecter : " . mysql_error());
mysql_query('SET NAMES `cp1256`');
$db = mysql_select_db("database");
if (!$db)
{
die ('<br>Impossible d\'utiliser la base : ' . mysql_error());
}
if ($sens=="arabe")
{
echo '<table BORDER=1> <tr> <font size=3 color="Blue" > <th> Catégorie </th> <th> Sous-catégorie </th> <th> Arabe </th> <th> Français </th> <th> Genre </th> <th> Note Explicative </th>';
echo '</font> </tr>';
$q=0;
mysql_query('SET NAMES `cp1256`');
$reqs="select * from lexique where arabe like '%$mot%'";
$rese=mysql_query($reqs);
while($zeqs=mysql_fetch_row($rese))
{
list($cat[$q],$souscat[$q],$arabe[$q],$franc[$q],$genre[$q],$note[$q])=$zeqs;
echo '<font size=1 color="black" >';
echo '<tr> <td>';
echo "$cat[$q] ";
echo '</td> <td>';
echo "$souscat[$q] ";
echo '</td> <td>';
echo "$arabe[$q] ";
echo '</td> <td>';
echo "$franc[$q] ";
echo '</td> <td>';
echo "$genre[$q] ";
echo '</td> <td>';
echo "$note[$q] ";
$q++;
}
echo '</td></tr> </table>';
}
if ($sens=="francais")
{
echo '<table BORDER=1> <tr> <font size=3 color="Blue" > <th> Catégorie </th> <th> Sous-catégorie </th> <th> Arabe </th> <th> Français </th> <th> Genre </th> <th> Note Explicative </th>';
echo '</font> </tr>';
$q=0;
mysql_query('SET NAMES `cp1256`');
$reqs="select * from lexique where francais like '%$mot%'";
$rese=mysql_query($reqs);
while($zeqs=mysql_fetch_row($rese))
{
list($cat[$q],$souscat[$q],$arabe[$q],$franc[$q],$genre[$q],$note[$q])=$zeqs;
echo '<font size=1 color="black" >';
echo '<tr> <td>';
echo "$cat[$q] ";
echo '</td> <td>';
echo "$souscat[$q] ";
echo '</td> <td>';
echo "$arabe[$q] ";
echo '</td> <td>';
echo "$franc[$q] ";
echo '</td> <td>';
echo "$genre[$q] ";
echo '</td> <td>';
echo "$note[$q] ";
$q++;
}
echo '</td></tr> </table>';
}
mysql_close($link);
?>
</body>
</html> |
Partager