fonction php "cochez tout"

<?php

...

?>

<form method="post">

<a name="haut"></a>

<?php



echo "<table border=1>"; 

echo'<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">

 			 <tr bgcolor="#18447F"> 

    			<td colspan="5"><div align="center"><font color="#FFFFFF" size="5px"></td>

				</tr>

			<tr bgcolor="#B8C8FE"> 

    			<td width="20%" align="center"><font face=\"arial\" size=\"5\">Selection</font></td>

				<td width="20%" align="center"><font face=\"arial\" size=\"5\">Enregistrement</font></td>

				<td align="center"><font face=\"arial\" size=\"5\">Nom </font></td>

				<td width="20%" align="center"><font face=\"arial\" size=\"5\">Ville</font></td>

				<td width="20%" align="center"><font face=\"arial\" size=\"5\">Code postal</font></td>

			</tr>

			<table/>'; 







include('../../connectBDD.php');



$table= 'champs';

$champs= array('date','nom','cp','ville');

$select= 'id,'.'nom, '.'ville, '.'cp ';

$order= 'nom';

$sens= 'ASC';

$limit_start= '0';

$limit_nb= '250';

$count= '';



 function requete($table, $champs, $select, $order, $sens, $limit_start, $limit_nb, $count = '')

 {

 // option de recherche

 $option = $_POST['option'];

 // texte de recherche

 $search = $_POST['search'];



 // si c'est le premier appel de la fonction

 if(!isset($fonction_requete))

 {

 static $fonction_requete = 1;



 // si "Rechercher tous les mots" ou "Rechercher un de ces mots"

 if($option == 'all' || $option == 'one')

 {

 // liste des mots

 $mots = explode(' ', $search);



 // sépararateur

 if($option == 'all')

 $sep = ' AND ';

 else

 $sep = ' OR ';

 } // if($option == 'all' || $option == 'one')

 // "Rechercher l'expression exacte"

 else

 {

 $mots = $search;

 $sep = '';

 }

 } // if(!isset($fonction_requete))



 if(!is_array($champs))

 $champs = array($champs);



 if($option == 'all' || $option == 'one')

 {

 // pour savoir si on en est à la première itération ou non

 $i = 0;



 // pour tous les mots

 foreach($mots as $mot)

 {

 if(!$i)

 {

 $search = '~#^!|!^#~ LIKE \'%' . $mot . '%\'';

 $i = 1;

 }

 else

 $search .= $sep . '~#^!|!^#~ LIKE \'%' . $mot . '%\'';

 } // foreach($mots as $mot)

 } // if($option == 'all' || $option == 'one')

 else if($option == 'sentence')

 $search = '~#^!|!^#~ LIKE \'%' . $mots . '%\'';



 $i = 0;



 // début de requête

 if(empty($count))

 $req_search = 'SELECT ' . $select . ' FROM ' . $table . ' WHERE ';

 else

 $req_search = 'SELECT count(' . $count . ') FROM ' . $table . ' WHERE ';



 // ajout des champs

 foreach($champs as $champ)

 {

 if(!$i)

 {

 $req_search .= '( ' . str_replace('~#^!|!^#~', $champ, $search) .' ) ';

 $i = 1;

 }

 else

 $req_search .= 'OR ( ' . str_replace('~#^!|!^#~', $champ, $search) .' ) ';

 }



 if(empty($count))

 {

 $req_search .= "ORDER BY $order $sens LIMIT $limit_start, $limit_nb";



 return $req_search;



 } }



$req_search = requete( $table, $champs, $select, $order, $sens, $limit_start, $limit_nb );

$result = mysql_query( $req_search ) or die('Erreur MySQL');

while ($row = mysql_fetch_assoc($result)) {

$_SESSION['nb_enregistrement']=mysql_num_rows($result);

$_SESSION['id'.$i]=$row['id'];

 

?>

//Table qui affiche les résultats avec des cases à cocher

<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr bgcolor="#B8C8FE"> 

    <td width="20%" align="center"><?php echo "<input type=\"checkbox\" name=\"data[]\" value=\"".$row['id']."\">"; ?></td>

    <td width="20%" colspan="2" bgcolor="#B8C8FE" align="center"> <?php echo "<font face=\"arial\" size=\"3\">", $row['id'],"</font>"; ?> </td>

	<td width="20%" colspan="2" bgcolor="#B8C8FE" align="center"> <?php echo "<font face=\"arial\" size=\"3\">", $row['nom'],"</font>"; ?> </td>

	<td width="20%"align="center"><?php echo "<font face=\"arial\" size=\"3\">", $row['ville'],"</font>"; ?> </td>

  <td width="20%" colspan="2" bgcolor="#B8C8FE" align="center"> <?php echo "<font face=\"arial\" size=\"3\">", $row['cp'],"</font>"; ?> </td>

  </tr>

  <tr> 

    <td height="3"></td>

    <td></td>

    <td></td>

  </tr><br>

  <?php

echo "</table>"; 

}

?>

<p align="center"><a href="#haut" class="lien2">Haut de page - </a></p>

  <p><form name="export_resultat">

  <p align="center"><input type="button" value="Exporter la fiche au format PDF" name="envoi" onClick="form.action='fiche.php';form.submit()"></p>

  <div align="center">

    <input type="button" name="exporter" value="Exporter l'ensemble des r&eacute;sultats au format Excel" onClick="form.action='export.php';form.submit()">

  </div>

  </form>  

</form>

<?php

}

?>

<SCRIPT LANGUAGE="JavaScript">

function checkAll(field)

{

for (i = 0; i < field.length; i++)

	field[i].checked = true ;

}



function uncheckAll(field)

{

for (i = 0; i < field.length; i++)

	field[i].checked = false ;

}

</script>

<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr bgcolor="#B8C8FE"> 

    <td width="20%" align="center"><?php echo "<input type=\"checkbox\" name=\"data[]\" value=\"".$row['id_societe']."\">"; ?></td>

    <td width="20%" colspan="2" bgcolor="#B8C8FE" align="center"> <?php echo "<font face=\"arial\" size=\"3\">", $row['id_societe'],"</font>"; ?> </td>

	<td width="20%" colspan="2" bgcolor="#B8C8FE" align="center"> <?php echo "<font face=\"arial\" size=\"3\">", $row['nom_societe'],"</font>"; ?> </td>

	<td width="20%"align="center"><?php echo "<font face=\"arial\" size=\"3\">", $row['ville'],"</font>"; ?> </td>

  <td width="20%" colspan="2" bgcolor="#B8C8FE" align="center"> <?php echo "<font face=\"arial\" size=\"3\">", $row['cp'],"</font>"; ?> </td>

  </tr>

  <tr> 

    <td height="3"></td>

    <td></td>

    <td></td>

  </tr><br>

  <?php

echo "</table>"; 

}

?>

<p align="center"><a href="#haut" class="lien2">Haut de page - </a>

<a href="../index.php">Retour à l'interface d'administration</a></p>

<input type="button" name="CheckAll" value="Check All" onClick="checkAll(document.myform.data[])">

<input type="button" name="UnCheckAll" value="Uncheck All" onClick="uncheckAll(document.myform.data[])">

function forcerTelechargement($nom, $situation, $poids)

{

header('Content-Type: application/octet-stream');

header('Content-Length: '. $poids);

header('Content-disposition: attachment; filename='. $nom);

header('Pragma: no-cache');

header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');

header('Expires: 0');

readfile($situation);

exit();

}

forcerTelechargement('nom-fichier.xls', './nom-fichier.xls', 1000000);