Code source du fichier arborescence.php

Code source du fichier arborescence.php :

(c) John Bonobo - Bonobo Future Systems Inc. - Nancy, Berlin, 2000-2003.


<?php

// /////////////////////////////////////////////////////////////////////// //
//
// Author: John Bonobo (Bonobo Future Systems)
// Copyright (C) 2000-2003, John Bonobo
// john.bonobo@free.fr
// http://john.bonobo.free.fr
//
// /////////////////////////////////////////////////////////////////////// //
//
// This program is free software; you can redistribute it and/or modify it
// under the terms of the GNU General Public License as published by the
// Free Software Foundation; either version 2 of the License, or (at your
// option) any later version.
//
// This program is distributed in the hope that it will be useful, but
// WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
// See the GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License along
// with this program; if not, write to the Free Software Foundation, Inc.,
// 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
//
// GNU General Public License : http://www.gnu.org/licenses/gpl.html
// Free Software Foundation : http://www.gnu.org/fsf/fsf.html
//
// /////////////////////////////////////////////////////////////////////// //

?>


<center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><!DOCTYPE HTML SYSTEM "http://bonobo.jones.free.fr/bonobo/HTML4-bonobo.dtd">

<!--  the HTML4-bonobo.dtd is just a very very slight modification of
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
            "http://www.w3.org/TR/html4/loose.dtd">  
-->




<html>
<head>
 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
    <meta name="Author" content="Sebastien Chaumont">
    <meta name="description" content="Affichage du contenu de la table arborescence ">
    <meta name="reply-to" content="john.bonobo@free.fr">
    <meta name="owner" content="john.bonobo@free.fr">
    <meta name="copyright" content="bonobo universal pictures 2000-2003">
    <link rel="SHORTCUT ICON" href="http://bonobo.jones.free.fr/favicon.ico">
<title>Le site officiel de John Bonobo : Affichage de la table arborescence</title>
<link rel="stylesheet" type="text/css" href="bonobo0.css" title="Style sobre (par défaut)">

</head>
<body>
<h1>Contenu des tables</h1>
<h2>(c) <a href="mailto:john.bonobo@free.fr">John Bonobo</a> - Bonobo Future Systems Inc. - Nancy, Berlin, 2000-2003.</h2>
<?php
 
include("motdepasse.php"); 

@
mysql_connect("$serveur","$base","$passe");
$select_base=@mysql_selectdb("$base"); 
 if (!
$select_base
{echo 
"<font color=\"#CC0000\"><b>Mauvaise configuration!!! </b></font><br> 
Problème de connexion à la base <b>$base</b><br>"
; }


echo
"<br /><hr /><h2>Table : arborescence (correspondances lexico-motcl&eacute;iques)</h2>
"
;
echo
"<table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
"
;
echo
"<tr>";
echo
"<td width=\"5%\">&nbsp;&nbsp;<b>Niv. 1</b></td>";
echo
"<td width=\"5%\">&nbsp;&nbsp;<b>Niv. 2</b></td>";
echo
"<td width=\"5%\">&nbsp;&nbsp;<b>Niv. 3</b></td>";
echo
"<td width=\"5%\">&nbsp;&nbsp;<b>Niv. 4</b></td>";
echo
"<td width=\"5%\">&nbsp;&nbsp;<b>Niv. 5</b></td>";
echo
"<td width=\"5%\">&nbsp;</td>";
echo
"<td width=\"5%\">&nbsp;<b>X1</b></td>";
echo
"<td width=\"5%\">&nbsp;<b>X2</b></td>";
echo
"<td width=\"5%\">&nbsp;<b>X3</b></td>";
echo
"<td width=\"5%\">&nbsp;<b>X4</b></td>";
echo
"<td width=\"5%\">&nbsp;</td>";
echo
"<td width=\"45%\"><b>Titre</b></td>";
echo
"</tr>
"
;
    
$sql "SELECT pos1,pos2,pos3,pos4,niv1,niv2,niv3,niv4,niv5,titre,lien FROM arborescence";
    
$req mysql_query($sql) or die("Erreur SQL !<br>".$sql."<br>".mysql_error());
    while(
$data mysql_fetch_array($req))
        {
echo
"<tr>";
echo
"<td width=\"5%\">".$data["niv1"]."</td>";
echo
"<td width=\"5%\">".$data["niv2"]."</td>";
echo
"<td width=\"5%\">".$data["niv3"]."</td>";
echo
"<td width=\"5%\">".$data["niv4"]."</td>";
echo
"<td width=\"5%\">".$data["niv5"]."</td>";
echo
"<td width=\"5%\"></td>";
echo
"<td width=\"5%\">".$data["pos1"]."</td>";
echo
"<td width=\"5%\">".$data["pos2"]."</td>";
echo
"<td width=\"5%\">".$data["pos3"]."</td>";
echo
"<td width=\"5%\">".$data["pos4"]."</td>";
echo
"<td width=\"5%\"></td>";
$title=$data["titre"];
$long=strlen($title);
if (
$long>25)
{
$title=substr($title,0,17)."...".substr($title,$long-5,$long);}
echo
"<td width=\"45%\">".$title."</td>";


echo
"</tr>
"
;
}


echo
"</table>
"
;
echo
"<br /><hr /><h2>Table : Mots-clé</h2>";
echo
"<table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
"
;
echo
"<tr>";

echo
"<td width=\"10%\">&nbsp;&nbsp;<b>X1</b></td>";
echo
"<td width=\"10%\">&nbsp;&nbsp;<b>X2</b></td>";
echo
"<td width=\"10%\">&nbsp;&nbsp;<b>X3</b></td>";
echo
"<td width=\"10%\">&nbsp;&nbsp;<b>X4</b></td>";
echo
"<td width=\"10%\">&nbsp;&nbsp;</td>";
echo
"<td width=\"50%\">&nbsp;<b>Mot-clé</b></td>";
echo
"</tr>
"
;
$sql "SELECT x1,x2,x3,x4,nom FROM motsclefs";

    
$req mysql_query($sql) or die("Erreur SQL !<br>".$sql."<br>".mysql_error());
    while(
$data mysql_fetch_array($req))
        {
echo
"<tr>";
echo
"<td>&nbsp;&nbsp;".$data["x1"]."</td>";
echo
"<td>&nbsp;&nbsp;".$data["x2"]."</td>";
echo
"<td>&nbsp;&nbsp;".$data["x3"]."</td>";
echo
"<td>&nbsp;&nbsp;".$data["x4"]."</td>";
echo
"<td>&nbsp;&nbsp;</td>";
echo
"<td>&nbsp;".$data["nom"]."</td>";

echo
"</tr>
"
;
}

echo
"</table><br /><hr />
"
;


// /////////////////////////////
//
// FERMETURE CONNECTION MySQL
//
// /////////////////////////////

mysql_close();

?>



<h2>Cette page <a href="http://validator.w3.org/check/referer">respecte</a> les standards d&eacute;finis par le <a href="http://www.w3.org">W3C</a>.</h2>
</body>
</html><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><center><script type="text/javascript"><!--
google_ad_client = "pub-9072325218963400";
/* 728x90, date de création 24/04/11 */
google_ad_slot = "1201648247";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center>

Sources PHP du site officiel de John Bonobo

(c) John Bonobo - Bonobo Future Systems Inc. - Nancy, Berlin, 2000-2003.




Cette page respecte les standards définis par le W3C.