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 115
|
require_once('../connections/connect.php');
require_once($_SERVER['DOCUMENT_ROOT']."/inc/utilitairesDB.php");
?>
<?php
mysql_select_db($database_adh, $connect);
$query_adh = "SELECT * FROM adherents a left outer join contacts c on a.Adh_id=c.Cnt_id_Adh ORDER BY Adh_id ASC";
$adh = mysql_query($query_adh, $connect) or die(mysql_error());
$row_adh = mysql_fetch_assoc($adh);
$totalRows_adh = mysql_num_rows($adh);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="../Templates/main.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Coopsoc Industrie : liste des Adhérents</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
<link href="../css/coopsoc.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td align="center" class="fond" style="color:#00746B;font-size:12px;font-weight:bold" height="120">
<img src="../images/display/bandeau-superieur.jpg" width="760" height="100" />
<div align="left"><?php if(isset($_SESSION["login"])) printf("Bienvenu : %s</ br>",$_SESSION["login"]); else echo ""; ?></div>
</td>
</tr>
<tr>
<td><div id="navigation"><a class="boutonNav" href="../pages/acceuil.php">Présentation...</a><a class="boutonNav" href="<?php if (isset($_SESSION["groupe"])) printf("../%s/liste_offres.php",$_SESSION["groupe"]); else echo "../admin/erreur_coopsoc.php"; ?>">Liste des offres</a><a class="boutonNav" href="<?php if (isset($_SESSION["groupe"])) printf("../%s/liste_adherents.php",$_SESSION["groupe"]); else echo "../admin/erreur_coopsoc.php"; ?>">Liste des adhérents</a><a class="boutonNav" href="../pages/contact.php">Contact</a><a class="boutonNav" href="<?php if (isset($_SESSION["groupe"])) printf("../%s/id.php",$_SESSION["groupe"]); else echo "../admin/erreur_coopsoc.php"; ?>">S'identifier</a></div></td>
</tr>
<tr>
<td class="fond"><!-- InstanceBeginEditable name="affichage principal" -->
<br />
<form action="../user/liste_adherents.php" method="get" enctype="multipart/form-data" name="form_triAdherent" id="form_triAdherent">
<table width="100%" border="1" bordercolor="#C4DF9B" align="center" cellpadding="5" cellspacing="0" bgcolor="#FFFFCC">
<tr>
<td align="center"><font color="#00746B"><strong>Nom </strong></font>
<?php
mysql_select_db($database_adh, $connect);
$query_adh = "SELECT * FROM adherents a left outer join contacts c on a.Adh_id=c.Cnt_id_Adh ORDER BY Adh_nom DESC";
$adh = mysql_query($query_adh, $connect) or die(mysql_error());
$row_adh = mysql_fetch_assoc($adh);
$totalRows_adh = mysql_num_rows($adh);
?>
<input type="image" src="../images/display/tri_up.jpg" />
<?php
mysql_select_db($database_adh, $connect);
$query_adh = "SELECT * FROM adherents a left outer join contacts c on a.Adh_id=c.Cnt_id_Adh ORDER BY Adh_nom ASC";
$adh = mysql_query($query_adh, $connect) or die(mysql_error());
$row_adh = mysql_fetch_assoc($adh);
$totalRows_adh = mysql_num_rows($adh);
?>
<input type="image" src="../images/display/tri_down.jpg" />
</td>
<td align="center"><font color="#00746B"><strong>Ville</strong></font></td>
<td align="center"><font color="#00746B"><strong>Nom Contact</strong></font></td>
<td align="center"><font color="#00746B"><strong>Prénom Contact</strong></font></td>
<td align="center"><font color="#00746B"><strong>Téléphone</strong></font></td>
<td align="center"><font color="#00746B"><strong>Site web</strong></font></td>
<td align="center"><font color="#00746B"><strong>Détail</strong></font></td>
</tr>
</table>
</form>
<form action="../user/detail_adherents.php" method="post" enctype="multipart/form-data" name="form_listeAdherent" id="form_listeAdherent">
<table width="73%" border="1" bordercolor="#C4DF9B" align="center" cellpadding="5" cellspacing="0" bgcolor="#FFFFCC">
<tr>
<td align="center"><font color="#00746B"><strong>Nom </strong></font></td>
<td align="center"><font color="#00746B"><strong>Ville</strong></font></td>
<td align="center"><font color="#00746B"><strong>Nom Contact</strong></font></td>
<td align="center"><font color="#00746B"><strong>Prénom Contact</strong></font></td>
<td align="center"><font color="#00746B"><strong>Téléphone</strong></font></td>
<td align="center"><font color="#00746B"><strong>Site web</strong></font></td>
<td align="center"><font color="#00746B"><strong>Détail</strong></font></td>
</tr>
<?php do { ?>
<tr>
<td>
<input name="idAdh" type="hidden" id="idAdh" size="8" maxlength="8" value="<?php print(stripslashes($row_adh["Adh_id"])); ?>">
<input name="nomAdh" style="color:#00746B" disabled="disabled" type="text" id="nomAdh" size="30" maxlength="30" value="<?php print(stripslashes($row_adh["Adh_nom"])); ?>">
</td>
<td><input name="villeAdh" style="color:#00746B" disabled="disabled" type="text" id="villeAdh" size="32" value="<?php print(stripslashes($row_adh["Adh_ville"])); ?>">
</td>
<td><input name="nomCnt" style="color:#00746B" disabled="disabled" type="text" id="nomCnt" size="32" value="<?php print(stripslashes($row_adh["Cnt_nom"])); ?>">
</td>
<td><input name="prenomCnt" style="color:#00746B" disabled="disabled" type="text" id="prenomCnt" size="32" value="<?php print(stripslashes($row_adh["Cnt_prenom"])); ?>">
</td>
<td><input name="telCnt" style="color:#00746B" disabled="disabled" type="text" id="telCnt" size="32" value="<?php print(stripslashes($row_adh["Cnt_tel"])); ?>">
</td>
<td><a href="http://<?php print(stripslashes($row_adh["Adh_siteWeb"])); ?>">
<input type="image" src="../images/www.png">
</a>
</td>
<td><?php printf("<a href=\"detail_adherents.php?idAdh=%d\">",$row_adh["Adh_id"]); ?>
<input type="image" src="../images/detail.png">
</td>
</tr>
<?php } while ($row_adh=mysql_fetch_assoc($adh)); ?>
</table>
</form>
<!-- InstanceEndEditable --></td>
</tr>
<tr>
<td align="right" class="fond"><a href="mailto:a@a.fr"><img src="../images/display/bandeau-inferieur.gif" width="563" height="49" border="0" /></a></td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($adh);
?> |