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
| <HTML>
<?php
try
{
$bdd = new PDO('mysql:host=localhost;dbname=drow;charset=utf8', 'root', '');
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
?>
<table border="1px" style="border-color: #c1c1c1" >
<tr>
<td style="background-color: lightgrey">ID</td>
<td>Entreprise</td>
<td>Nom</td>
<td>Code Postal</td>
</tr>
<form id="bouton" name="bouton" method="post">
<p><input type="submit" name="bouton" value ="VERS WORD"></p>
</form>
<?php
$reponse = $bdd->prepare('SELECT * FROM btob WHERE Entreprise = ?');
$reponse->execute(array($_GET['Entreprise']));
// On affiche chaque entrée une à une
while ($donnees = $reponse->fetch())
{
?>
<tr>
<td style="background-color: lightgrey"><?php echo $donnees['id']; ?></td>
<td><?php echo $donnees['Entreprise']; ?></td>
<td><?php echo $donnees['Nom']; ?></td>
<td><?php echo $donnees['CP']; ?></td>
</tr>
<?php
}
?>
</table>
<?php
$reponse->closeCursor(); // Termine le traitement de la requête
if(isset($_POST['bouton'])) {
$todayfichier = date("d.m.y_H-i");
$today = date("d.m.y");
$nom_fichier = 'devis.'.$todayfichier.'.docx';
$file = dirname(__FILE__) . DIRECTORY_SEPARATOR . 'Facture.docx';
$myContent = file_get_contents($file);
$myContent = str_replace("@Date@",$today,$myContent);
$myContent = str_replace("@CP@",$donnees['CP'],$myContent);
$myContent = str_replace("@Nom@",$donnees['Nom'],$myContent);
$myContent = str_replace("@Entreprise@",$donnees['Entreprise'],$myContent);
$newFile = fopen("$nom_fichier", "a");
fwrite($newFile,$myContent);
fclose($newFile);
}
?>
</HTML> |
Partager