2.x/spg/bible3.php

<?php   
//$Id: bible3.php,v 1.1 2007-07-30 15:38:48 fraynaud1 Exp $
include ("../dyn/session.inc");
// classe(s) utilisée(s)
require_once "DB.php";
// variables
//$idx=$_GET['idx'];
$DEBUG=0;
$evenement=$_GET['ev'];
//$types=$_GET['vu'];
 include("../dyn/fenetre.css");
include("../dyn/var.inc");
echo "<html>";
echo"<head>";
echo "</head>";
echo "<body>";
//
// dsn
   include ("../dyn/connexion.php");
   $db=& DB :: connect($dsn, $db_option);
   if (DB :: isError($db)) {
    die($db->getMessage());
    }
    else{
        if($DEBUG==1)
        echo "La base ".$dsn['database']." est connectée.<br>";
    }
    $sql="select * from bible where evenement =".$evenement.
    " and complement=3";
    if ($DEBUG==1)
       echo $sql."<br>";
    $res = $db->query($sql);
    $nbligne=$res->numrows();
    if (DB :: isError($res))
           die($res->getDebugInfo()." ".$sql);
    else{
      if ($DEBUG == 1)
             echo "La requête ".$sql." est exécutée";
      if($nbligne>0){
      echo "<form name='f2'>";
      echo  "<select size=\"1\" name=\"bible\" class=\"champFormulaire\">";
      while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){
              $temp=$row['contenu'];
              $opt= "<option value=\"".$temp."\">".$row['libelle']."</option>";
              echo $opt;
      }
      echo "</select>";
      echo "<br><br><br><br><input type='submit' tabindex=70 value='V a l i d e r' onclick='javascript:recup();'  style='".$styleBouton."'></center>";
      echo "</form>";
      }else{
      echo "aucun element dans la bible pour l'evenement = ".$evenement;
      echo "<br><center><a href=# onclick='window.close();'>";
      echo "<img src='..\img\fermer.png' border='0'  alt='Fermer cette fenêtre' align='middle'>";
      echo "</a></center>";
      }
    }


?>
<script language="javascript">
function recup()
{
opener.document.f1.complement3.value = opener.document.f1.complement3.value+document.f2.bible.value+"\r";
this.close();
}
</script>
</body>
</html>
1	<?php
2	//$Id: bible3.php,v 1.1 2007-07-30 15:38:48 fraynaud1 Exp $
3	include ("../dyn/session.inc");
4	// classe(s) utilisée(s)
5	require_once "DB.php";
6	// variables
7	//$idx=$_GET['idx'];
8	$DEBUG=0;
9	$evenement=$_GET['ev'];
10	//$types=$_GET['vu'];
11	include("../dyn/fenetre.css");
12	include("../dyn/var.inc");
13	echo "<html>";
14	echo"<head>";
15	echo "</head>";
16	echo "<body>";
17	//
18	// dsn
19	include ("../dyn/connexion.php");
20	$db=& DB :: connect($dsn, $db_option);
21	if (DB :: isError($db)) {
22	die($db->getMessage());
23	}
24	else{
25	if($DEBUG==1)
26	echo "La base ".$dsn['database']." est connectée.<br>";
27	}
28	$sql="select * from bible where evenement =".$evenement.
29	" and complement=3";
30	if ($DEBUG==1)
31	echo $sql."<br>";
32	$res = $db->query($sql);
33	$nbligne=$res->numrows();
34	if (DB :: isError($res))
35	die($res->getDebugInfo()." ".$sql);
36	else{
37	if ($DEBUG == 1)
38	echo "La requête ".$sql." est exécutée";
39	if($nbligne>0){
40	echo "<form name='f2'>";
41	echo "<select size=\"1\" name=\"bible\" class=\"champFormulaire\">";
42	while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){
43	$temp=$row['contenu'];
44	$opt= "<option value=\"".$temp."\">".$row['libelle']."</option>";
45	echo $opt;
46	}
47	echo "</select>";
48	echo "<br><br><br><br><input type='submit' tabindex=70 value='V a l i d e r' onclick='javascript:recup();' style='".$styleBouton."'></center>";
49	echo "</form>";
50	}else{
51	echo "aucun element dans la bible pour l'evenement = ".$evenement;
52	echo "<br><center><a href=# onclick='window.close();'>";
53	echo "<img src='..\img\fermer.png' border='0' alt='Fermer cette fenêtre' align='middle'>";
54	echo "</a></center>";
55	}
56	}
57
58
59	?>
60	<script language="javascript">
61	function recup()
62	{
63	opener.document.f1.complement3.value = opener.document.f1.complement3.value+document.f2.bible.value+"\r";
64	this.close();
65	}
66	</script>
67	</body>
68	</html>