Forum d'entraide PHPFrance

Bonjour,

Voici mon soucis, j'aimerais exporter les informations fournies sur cette page par la base de donnée en .csv . Je fais ce travail pour un phpbook de l'asbl pour lakelle je travaille, et etant donné que mes connaissances en php sont très limittée je sollicite donc votre aide afin de fermer la boucle et enfin mettre ce phpbook en ligne.

Voici le code

Code : Tout sélectionner

<?php
// ** GET CONFIGURATION DATA **
	require_once('constants.inc');
	require_once(FILE_FUNCTIONS);
	require_once(FILE_CLASS_OPTIONS);
	require_once(FILE_CLASS_CONTACTLIST);
	require_once(FILE_CLASSES);
	session_start();

 

// ** OPEN CONNECTION TO THE DATABASE **
	$db_link = openDatabase($db_hostname, $db_username, $db_password, $db_name);

// ** CHECK FOR LOGIN **
	checkForLogin();

// ** RETRIEVE OPTIONS THAT PERTAIN TO THIS PAGE **
	$options = new Options();
	
// ** END INITIALIZATION *******************************************************

	// CREATE THE LIST.	
	$list = &new ContactList();
	
	// THIS PAGE TAKES SEVERAL GET VARIABLES
	// ie. list.php?group_id=6&page=2&letter=c&limit=20
	if ($_GET['groupid'])         $list->group_id = $_GET['groupid'];
	if ($_GET['page'])            $list->current_page = $_GET['page'];
	if (isset($_GET['letter']))   $list->current_letter = $_GET['letter'];	
	if (isset($_GET['limit']))    $list->max_entries = $_GET['limit'];	

	// Set group name (group_id defaults to 0 if not provided)
	$list->group_name();

	// ** RETRIEVE CONTACT LIST BY GROUP **
	$r_contact = $list->retrieve();
?>
<HTML>
<HEAD>
	<TITLE><?php echo "$lang[TITLE_TAB] - $lang[TITLE_LIST]"?></TITLE>
	<LINK REL="stylesheet" HREF="styles.css" TYPE="text/css">
	<META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE">
	<META HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE">
	<META HTTP-EQUIV="EXPIRES" CONTENT="-1">
	<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $lang['CHARSET']?>">
</HEAD>

<BODY onLoad="document.goToEntry.goTo.focus();">
<p>&nbsp;</p>
<p>&nbsp;</p>
<p><A NAME="top"></A> </p>
<P>
<P>
<P> 
<CENTER>
  <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=570>
    <TR> 
      <TD CLASS="navMenu"><?php echo $list->create_nav(); ?></TD>
    </TR>
    <TR> 
      <TD> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=570>
          <TR VALIGN="bottom"> 
            <TD CLASS="headTitle"><?php echo $list->title();  ?></TD>
            <TD CLASS="headText" ALIGN=right> <FORM NAME="selectGroup" METHOD="get" ACTION="<?php echo(FILE_PUBLI); ?>">
                <?php echo $lang[GROUP_SELECT] ?> 
                <SELECT NAME="groupid" CLASS="formSelect" onChange="document.selectGroup.submit();">
                  <?php
    // -- GENERATE GROUP SELECTION LIST --
	// Only admins can view hidden entries.
	if ($_SESSION['usertype'] == "admin") {
		$groupsql = "SELECT groupid, groupname FROM " . TABLE_GROUPLIST . " AS grouplist WHERE groupid >= 0 ORDER BY groupname";
	}
	else {
		$groupsql = "SELECT groupid, groupname FROM " . TABLE_GROUPLIST . " AS grouplist WHERE groupid >= 0 AND groupid != 2 ORDER BY groupname";
	}
    $r_grouplist = mysql_query($groupsql, $db_link);
    while ($tbl_grouplist = mysql_fetch_array($r_grouplist)) {
        $selectGroupID = $tbl_grouplist['groupid'];
        $selectGroupName = $tbl_grouplist['groupname'];
        echo("                       <OPTION VALUE=$selectGroupID");
        if ($selectGroupID == $list->group_id) {
            echo(" SELECTED");
        }
        if($selectGroupName=="(all entries)" )$selectGroupName =  $lang[GROUP_ALL_SELECT];
        if($selectGroupName=="(ungrouped entries)" )$selectGroupName =  $lang[GROUP_UNGROUPED_SELECT];
        if($selectGroupName=="(hidden entries)" )$selectGroupName =   $lang[GROUP_HIDDEN_SELECT];
        echo(">$selectGroupName</OPTION>\n");
    }
?>
                </SELECT>
              </FORM></TD>
          </TR>
        </TABLE></TD>
    </TR>
    <TR> 
      <TD CLASS="infoBox"> <BR> <CENTER>
          <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=570>
            <?php

	// DISPLAY IF NO ENTRIES UNDER GROUP
	if (mysql_num_rows($r_contact)<1) {
        echo("                 <TR VALIGN=\"top\">\n");
        echo("                   <TD WIDTH=560 COLSPAN=4 CLASS=\"listEntry\">$lang[NO_ENTRIES]</TD>\n");

        echo("                 </TR>\n");
	}
	// DISPLAY ENTRIES
    while ($tbl_contact = mysql_fetch_array($r_contact)) {

        $contact_fullname = stripslashes( $tbl_contact['fullname'] );
        $contact_lastname = stripslashes( $tbl_contact['lastname'] );
        $contact_firstname = stripslashes( $tbl_contact['firstname'] );
        $contact_id = $tbl_contact['id'];
        $contact_line1 = stripslashes( $tbl_contact['line1'] );
        $contact_line2 = stripslashes( $tbl_contact['line2'] );
        $contact_city = stripslashes( $tbl_contact['city'] );
        $contact_state = stripslashes( $tbl_contact['state'] );
        $contact_zip = stripslashes( $tbl_contact['zip'] );
        $contact_phone1 = stripslashes( $tbl_contact['phone1'] );
        $contact_phone2 = stripslashes( $tbl_contact['phone2'] );
        $contact_country = $tbl_contact['country'];
        $contact_whoAdded = $tbl_contact['whoAdded'];
		if ($contact_whoAdded == $_SESSION['username'] && $_SESSION['usertype'] == 'user' ) {
			$thecolor = ' STYLE="background-color: #EEEEEE;"';
		}      

        $list_NewLetter = strtoupper(substr($contact_fullname, 0, 1));
        if ($list_NewLetter != $list_LastLetter) {
            echo("                 <TR VALIGN=\"top\">\n");
            echo("                   <TD WIDTH=410 COLSPAN=3 CLASS=\"listHeader\">$list_NewLetter<A NAME=\"$list_NewLetter\"></A></TD>\n");
            echo("                   <TD WIDTH=150 COLSPAN=1 CLASS=\"listHeader\" ALIGN=\"right\" VALIGN=\"bottom\"><A HREF=\"#top\"><IMG SRC=\"images/uparrow.gif\" WIDTH=10 HEIGHT=10 BORDER=0 ALT=\"[top]\"></A></TD>\n");
            echo("                 </TR>\n");
        }

        echo("                 <TR".$thecolor." VALIGN=\"top\">\n");
        // DISPLAY NAME -- links are shown either as regular link or popup window
        if ($options->displayAsPopup == 1) {
            $popupLink = " onClick=\"window.open('" . FILE_ADDRESS . "?id=$contact_id','addressWindow','width=600,height=450,scrollbars,resizable,menubar,status'); return false;\"";
        }
		if (!$contact_firstname) {
			echo("<TD WIDTH=150 CLASS=\"listEntry\"><B><A HREF=\"" . FILE_ADDRESS . "?id=$contact_id\"$popupLink>$contact_lastname</A></B></TD>\n");
		}
        else {
			echo("<TD WIDTH=150 CLASS=\"listEntry\"><B><A HREF=\"" . FILE_ADDRESS . "?id=$contact_id\"$popupLink>$contact_fullname</A></B></TD>\n");
		}
        // DISPLAY PHONE NUMBER OF PRIMARY ADDRESS
        echo("<TD WIDTH=100 CLASS=\"listEntry\">");
        if ($contact_phone1) { echo("$contact_phone1"); }

        if ($contact_phone1 AND $contact_phone2) { echo("<BR>"); }
        if ($contact_phone2) { echo("$contact_phone2"); }
        echo("&nbsp;</TD>\n");
        // DISPLAY ADDRESS - shown only if the first line of the address exists.
        echo("                   <TD WIDTH=160 CLASS=\"listEntry\">");
        if ($contact_line1) { 
            echo("$contact_line1<BR>");
            if ($contact_line2) { echo("$contact_line2<BR>"); }
            if ($contact_city) { echo("$contact_city"); }
            if ($contact_city AND $contact_state) { echo (", "); }
            if ($contact_state) { echo("$contact_state"); }
            if ($contact_zip) { echo(" $contact_zip"); }
			// COUNTRY
        	if ($contact_country) { 
				echo("\n<br>$country[$contact_country]");
			}
        }
        echo("&nbsp;</TD>\n");
		// DISPLAY E-MAILS
        echo("<TD WIDTH=150 CLASS=\"listEntry\">");
        $r_email = mysql_query("SELECT id, email FROM " . TABLE_EMAIL . " AS email WHERE id=$contact_id", $db_link);
        $tbl_email = mysql_fetch_array($r_email);
        $email_address = $tbl_email['email'];
		if ($options->useMailScript == 1) {
			echo("<A HREF=\"" .FILE_MAILTO. "?to=$email_address\">$email_address</A>");
		}
		else {
			echo("<A HREF=\"mailto:$email_address\">$email_address</A>");
		}
        while ($tbl_email = mysql_fetch_array($r_email)) {
            $email_address = $tbl_email['email'];
			if ($options->useMailScript == 1) {
				echo("<BR><A HREF=\"" .FILE_MAILTO. "?to=$email_address\">$email_address</A>");
			}
			else {
				echo("<BR><A HREF=\"mailto:$email_address\">$email_address</A>");
			}       
		}
        echo("&nbsp;</TD>\n");
        echo("</TR>\n");
		
        $list_LastLetter = strtoupper(substr($contact_fullname, 0, 1));

		//reset background color
		$thecolor = "";

    // END WHILE
    }

?>
          </TABLE>
        </CENTER>
        <BR>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=570>
    <tr>
            <td><div align="center"></div></td>
          </tr>
        </table> </TD>
    </TR>
  </TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=570>
    <tr>
      <td width="163"><div align="left"><A HREF="javascript:history.go(-1)"><?php echo $lang['BTN_PREVIOUS'] ?></A></div></td>
      <td width="206"><div align="center"><A HREF="list.php"><?php echo $lang['BTN_RETURN'] ?></A></div></td>
      <td width="191"><div align="right"><A HREF="javascript:history.go(+1)"><?php echo $lang['BTN_NEXT'] ?></A></div></td>
    </tr>
  </table>
  <br>
  
  
  
  
  

 
  



</CENTER>

</BODY>
</HTML>

Merci d'avance pour votre aide[/code]

Forum d'entraide PHPFrance

Extraction de donnée affichée en csv

Extraction de donnée affichée en csv