Bonjour,
j'ai besoin de votre aideeee !!!! et c'est urgent !!!
j'essai d'exporter un résultat vers excel , mais je comprends pas l'erreur ,
le script de l'export fonctionne parfaitement ailleurs , mais lorsque je le mets dans mon script , ça ne
marche pas et je comprends pas la cause ,
il me faut un génie pour comprendre le script , le voilà en tout cas :
<?php
require_once('../../../includes/connect.inc.php');
require_once('../../includes/logged.php');
$id = "";
if (isset($_POST["ID"])) $id = $_POST["ID"];
$submit = false;
if (isset($_POST["submitbutton"])) $submit = true;
$makestatus = false;
if (isset($_POST["submitstatus"])) $makestatus = true;
if ($submit) {
DeleteContent($id,'lead'); // permet la suppression d'un ligne de données
$contentupdated='Enregistrement supprimé avec succès';
}
if ($makestatus) {
ChangeStatusContent($id,'lead'); // permet la suppression d'un ligne de données
$contentupdated='Enregistrement Status avec succès';
}
if ($submit || $makestatus) {
header('Content-Type: text/xml');
print '<?xml version="1.0" encoding="UTF-8"?>';
print '<EditContent>';
print '<Response>Success</Response>';
print '<Details><![CDATA[' . $contentupdated . ']]></Details>';
print '</EditContent>';
exit;
}
if ( isset ($_POST['exporterbutton']) )
{
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=nom_fichier.xls");
// selectionner la base de données
if (isset ($_GET['ID']) )
{
$query_rs = "SELECT * FROM ".PREFIXE_DB."lead where id in (SELECT id_lead from ".PREFIXE_DB."lead_mailing where id_ML=".$_GET['ID'].") ";
}
else
{
$query_rs ="SELECT * FROM ".PREFIXE_DB."lead where 1=1 ";
}
$query=$db->dbquery($query_rs);
$tbl= " <table border='0' cellpadding='0' cellspacing='0'>
<tr bgcolor='#CCCCCC' height='40px'>
<td>Prénom</td>
<td>Nom</td>
<td>Fonction</td>
<td>Société</td>
<td>Ville</td>
<td>Email</td>
</tr>";
while ($data = $db->dbarray($query))
{
$tbl = $tbl . "<tr>";
$tbl = $tbl . "<td>" . $data['firstname'] . "</td>";
$tbl = $tbl . "<td>" . $data['name'] . "</td>";
$tbl = $tbl . "<td>" . $data['fonction'] . "</td>";
$tbl = $tbl . "<td>" . $data['societe'] . "</td>";
$tbl = $tbl . "<td>" . $data['ville'] . "</td>";
$tbl = $tbl . "<td>" . $data['mail'] . "</td>";
$tbl = $tbl . "</tr>";
}
$tbl = $tbl . "</table>";
print $tbl ;
}
?>
<!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">
<head>
<title><?php echo SITE_NAME?> : Leads</title>
<?php require_once('../../includes/metahead.inc.php'); ?>
<script type="text/javascript" src="../../../libs/js/prototype.js"></script>
<script type="text/javascript" src="../../../libs/js/effects.js"></script>
<script type="text/javascript">
// <![CDATA[
window.Change_Content = function(button,id)
{
$('Del_Content_Result').innerHTML = '';
if ($('displaymsgInserted')) $('displaymsgInserted').style.display = 'none';
//button.disabled = 'disabled';
var data = new Array();
if (button.value=='Submit'){
data.push('submitbutton=1');
}else{
data.push('submitstatus=1');
}
data.push('ID='+id);
var qnom=document.adminForm.qnom.value;
var elements = Form.getElements($('adminForm'));
for (var cnt = 0; cnt < elements.length; cnt++)
{
var elem = elements[cnt];
if (elem.type == 'image')
{
continue;
}
var query = Form.Element.serialize(elem);
data.push(query);
}
new Ajax.Request(
'<?php echo $_SERVER['REQUEST_URI'];?>'
, {
method: 'post'
, parameters: data.join('&')
, onSuccess: function(t)
{
//button.removeAttribute('disabled');
var xml = t.responseXML;
var response = xml.documentElement.childNodes[0];
var details = xml.documentElement.childNodes[1];
if (response.textContent) { response = response.textContent; } else { response = response.text; }
if (details.textContent) { details = details.textContent; } else { details = details.text; }
var htmlShow = '';
if (response == 'Success')
{
htmlShow = '<div class="pagemcontainer"><p class="pagemessage">' + details + '<\/p><\/div>';
$('Del_Content_Result').innerHTML = htmlShow;
new Effect.Pulsate(document.getElementById('Del_Content_Result'));
window.setTimeout('sendData("declarevar=OK&qnom='+qnom+'<?php if (isset($_GET['pageNum_rs']) && $_GET['pageNum_rs']!="") echo "&pageNum_rs=".$_GET['pageNum_rs']; ?>", "<?php echo $monConfig_url_site;?>/admin/Modules/Users/mailList.php", "navigation")', 1000);
}
// else
// {
// htmlShow = '<div class="pageerrorcontainer"><ul class="pageerror">' + details + '<\/ul><\/div>';
// }
}
, onFailure: function(t)
{
alert('Could not delete: ' + t.status + ' -- ' + t.statusText);
}
}
);
return false;
}
// ]]>
</script>
<script type="text/javascript">
// <![CDATA[
window.Edit_Content_Apply = function(button)
{
//button.disabled = 'disabled';
var data = new Array();
//data.push('ajax=1');
data.push('exporterbutton=1');
var elements = Form.getElements($('adminForm'));
for (var cnt = 0; cnt < elements.length; cnt++)
{
var elem = elements[cnt];
if (elem.type == 'image')
{
continue;
}
var query = Form.Element.serialize(elem);
data.push(query);
}
new Ajax.Request(
'<?php echo $_SERVER['REQUEST_URI'];?>'
, {
method: 'post'
, parameters: data.join('&')
, onSuccess: function(t)
{
//button.removeAttribute('disabled');
var xml = t.responseXML;
var response = xml.documentElement.childNodes[0];
var details = xml.documentElement.childNodes[1];
if (response.textContent) { response = response.textContent; } else { response = response.text; }
if (details.textContent) { details = details.textContent; } else { details = details.text; }
}
, onFailure: function(t)
{
alert('Could not save: ' + t.status + ' -- ' + t.statusText);
}
}
);
return false;
}
// ]]>
</script>
</head>
<body>
<?php require_once('../../includes/header.php'); ?>
<div id="content-box">
<div class="padding">
<?php require_once('../../includes/nav.php'); ?>
<table width="100%" class="menubar" cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="92%" height="60" align="center" class="menudottedline"><?php
if(isset($_GET['message'])){
displayMsg($_GET['message'],'Le lead');
}
?><div id="Del_Content_Result"> </div></td>
<td width="8%" align="right" class="menudottedline"><table cellpadding="0" cellspacing="0" border="0" id="toolbar">
<tr valign="middle" align="center" >
<td> <a class="toolbar" href="DB_m.php?action=Ajout&ID="<?php echo $_GET['ID'] ?>" "> <img src="../../img/addusers.png" title="Ajouter un utilisateur" alt="Ajouter un utilisateur" align="middle" name="Ajouter" border="0" /> <br />
Ajouter</a> </td>
<td> <a class="toolbar" href="#"> <img src="../../img/50px-Gnome-edit-undo.svg.png" onclick="return window.Edit_Content_Apply(this);" value="exporter" title="Exporter le résultat vers excel" alt="Exporter le résultat vers excel" align="middle" name="exporterbutton" border="0" /> <br />
Exporter</a> </td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="10" cellpadding="0">
<tr>
<td colspan="2"> <table width="100%" align="center">
<tr>
<td width="60%" valign="top"><form action="<?php echo $currentPage ?><?php if (isset($_GET['pageNum_rs']) && $_GET['pageNum_rs']!="") echo "?pageNum_rs=".$_GET['pageNum_rs']; ?>" enctype="multipart/form-data" method="post" name="adminForm" id="adminForm"> <input name="ID" type="hidden" id="ID" />
<table cellpadding="0" cellspacing="0" border="0" id="toolbar">
<tr>
<td>
<?php
$cur= $db->dbquery('SELECT * FROM '.PREFIXE_DB.'categories ORDER BY title');
echo "<select name=\"catid\" id=\"catid\" size=\"1\">
<option value=\"\" selected=\"selected\">Catégorie</option>";
while ( $item = $db->dbarray($cur) ) {
echo "<option value='".$item['id']."' >".$item['title']."</option>";
}
echo '</select>';
?>
<?php
$cur= $db->dbquery('SELECT * FROM '.PREFIXE_DB.'mailing_list ORDER BY title');
echo "<select name=\"ML\" id=\"ML\" size=\"1\">
<option value=\"\" selected=\"selected\">Mailing list</option>";
while ( $item = $db->dbarray($cur) ) {
echo "<option value='".$item['id']."' >".$item['title']."</option>";
}
echo '</select>';
?>
<?php
$cur= $db->dbquery('SELECT ville FROM '.PREFIXE_DB.'lead ORDER BY ville');
echo "<select name=\"ville\" id=\"ville\" size=\"1\">
<option value=\"\" selected=\"selected\">Ville</option>";
while ( $item = $db->dbarray($cur) ) {
echo "<option value='".$item['id']."' >".$item['ville']."</option>";
}
echo '</select>';
?>
<?php
$cur= $db->dbquery('SELECT cp FROM '.PREFIXE_DB.'lead ORDER BY cp');
echo "<select name=\"ML\" id=\"ML\" size=\"1\">
<option value=\"\" selected=\"selected\">Code postal</option>";
while ( $item = $db->dbarray($cur) ) {
echo "<option value='".$item['id']."' >".$item['cp']."</option>";
}
echo '</select>';
?>
<input type="checkbox" name="mon_champ[]" value="Opt1"/>Abonné
<input type="checkbox" name="mon_champ[]" value="Opt2"/>Désabonné
<input type="button" name="ordre" value="Ordre alphabétique">
<a href="DB_m.php?action=Ajout&ID="<?php echo $_GET['ID'] ?>" "> <img src="../../img/search.png" title="Afficher" alt="Afficher" align="middle" name="afficher" border="0" onclick="return window.Edit_Content_Apply2(this);"/></a>
</td>
</tr>
</table>
<?php
if (isset ($_POST['valider']) )
{
echo "jjjjjjjjjjjj";
}
?>
<table border="0" cellpadding="0" cellspacing="0" class="adminheading">
<tr>
<th width="72%" class="user">Leads</th>
<td width="12%" align="right">Mots clés : </td>
<td><input name="qnom" type="text" class="inputbox" id="qnom" value="<?php if (isset($_REQUEST['qnom']) && $_REQUEST['qnom']!="") echo htmlspecialchars($_REQUEST['qnom']); ?>" /></td>
<td align="right"><input type="button" onClick="document.adminForm.submit();" value="Rechercher" /></td>
</tr>
</table>
<table class="adminlist">
<tr>
<th width="96%" colspan="3"> </th>
</tr>
</table>
<div id="loading" style="display: none; padding:5px;" align="center">Chargement en cours...<br /><img src="../../img/loader.gif" /></div>
<div id="navigation">
<?php include('DBList.php');?>
</div>
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</div>
</div>
<!--Footer-->
<div id="footer"><?php require_once("../../includes/footer.php");?></div>
</body>
</html>
Toute idée sera la bienvenue !!!!
Afficher la suite