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
|
<html>
<head>
<title>CONVPHPJS</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<script LANGUAGE="Javascript" type="text/javascript">
function Affiche(Index) {
alert(Tab_js[Index] + " - " + Tab_js2[Index]);
}
</script>
<body>
<?
/************** Connection ****************/
$host="localhost";
$nom="root";
$pass="";
$link=mysql_connect($host,$nom,$pass) or die ("Connexion impossible");
mysql_select_db("tronsport",$link);
/************** Fonction pour la convérsion du tableau de PHP au Javascript ****************/
function TabPHP_to_JS($tableauPHP, $tableauJS) {
echo $tableauJS . " = new Array();";
for($i = 0; $i < count($tableauPHP); $i++) {
if (!is_array($tableauPHP[$i])) {
echo $tableauJS . "[" . $i . "] = '" . $tableauPHP[$i] . "';";
}
else {
TabPHP_to_JS($tableauPHP[$i], $tableauJS . "[" . $i . "]");
}
}
return;
}
$Tab_php = array(100);
$Tab_php2 = array(100);
$Tab_php3 = array(100);
$i = 0;
$selec = mysql_query("select * FROM autocar,billet_voyageur,voyage");
while ($datamenu = mysql_fetch_array($selec)) {
$Tab_php[$i] = $datamenu["voyage.VoyageId"];
$Tab_php2[$i] = $datamenu["autocar.AutocarId"];
$Tab_php3[$i] = $datamenu["Billet_voyageur.VoyageurId"];
echo "<a href=\"#\" onClick=\"Affiche(" . $i . ");\">" . $datamenu["voyage.VoyageId"] . "</a><br>";
$i++;
}
echo "<script type='text/javascript'>";
TabPHP_to_JS($Tab_php, "Tab_js");
TabPHP_to_JS($Tab_php2, "Tab_js2");
TabPHP_to_JS($Tab_php3, "Tab_js3");
//echo "document.write(monTableauJS.toSource());";
echo "</script> ";
?>
</body>
</html> |
Partager