API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 29th, 2020
303
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.10 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. require_once "database.php";
  4. require_once "TCPDF-master/tcpdf_import.php";
  5. require_once "PHPMailer-6.1.4/src/PHPMailer.php";
  6. require_once "PHPMailer-6.1.4/src/SMTP.php";
  7. require_once "PHPMailer-6.1.4/src/Exception.php";
  8. require_once "PHPMailer-6.1.4/src/OAuth.php";
  9. require_once "PHPMailer-6.1.4/src/POP3.php";
  10.  
  11. chdir(dirname(__DIR__));
  12.  
  13. use PHPMailer\PHPMailer\SMTP;
  14. use PHPMailer\PHPMailer\PHPMailer;
  15.  
  16. define('id_wlasciciela', 'id_wlasciciela');
  17. define('imie', 'imie');
  18. define('nazwisko', 'nazwisko');
  19. define('id_samochodu', 'id_samochodu');
  20. define('marka', 'marka');
  21. define('model', 'model');
  22. define('rocznik', 'rocznik');
  23. define('nr_rejestracyjny', 'nr_rejestracyjny');
  24. define('wlasciciel', 'wlasciciel');
  25.  
  26. $email=$_POST['email'];
  27.  
  28. $q = $db->query("SELECT * FROM wlasciciel ORDER BY id_wlasciciela");
  29.  
  30. $html = '<table>
  31. <h2>Spis naszych klientów:</h2>
  32. <tr>
  33. <th><b>Id właściciela</b></th>
  34. <th><b>Imie</b></th>
  35. <th><b>Nazwisko</b></th><hr>
  36. </tr>';
  37. while ($f = $q->fetch(PDO::FETCH_ASSOC)) {
  38. $imie = $f['imie'];
  39. $nazwisko = $f['nazwisko'];
  40. $id_wlasciciela = $f['id_wlasciciela'];
  41.  
  42. $html = $html. '<tr>
  43. <td>'.$id_wlasciciela.'</td>
  44. <td>'.$imie.'</td>
  45. <td>'.$nazwisko.'</td>
  46. </tr>';
  47. }
  48. $html = $html . '</table>';
  49.  
  50.  
  51. $q = $db->query("SELECT * FROM samochod");
  52.  
  53. $html = $html . ' <table> <h2>Spis samochodów w bazie:</h2>
  54. <tr><th><b>ID samochodu</b></th><th><b>Marka</b></th><th><b>Model</b></th><th><b>Rocznik</b></th><th><b>Nr rejestr.</b></th><th><b>Właściciel</b></th></tr><hr>
  55. ';
  56.  
  57. while ($f = $q->fetch(PDO::FETCH_ASSOC)) {
  58.  
  59. $id_wlasciciela = $f[wlasciciel.".".id_wlasciciela];
  60. $s = $db-> query("SELECT * FROM wlasciciel where id_wlasciciela=".$id_wlasciciela);
  61. while($ss = $s->fetch(PDO::FETCH_ASSOC)){
  62. $rocznik = $f[rocznik];
  63. $nr_rejestracyjny= $f[nr_rejestracyjny];
  64.  
  65. $html = $html . '<tr>
  66. <td>'.$f[id_samochodu].'</td>
  67. <td>'.$f[marka].'</td>
  68. <td>'.$f[model].'</td>
  69. <td>'.$rocznik.'</td>
  70. <td>'.$nr_rejestracyjny.'</td>
  71. <td>'.$ss[imie].' '.$ss[nazwisko].'</td></tr>';
  72.  
  73. }}
  74.  
  75. $html = $html . '</table>';
  76.  
  77.  
  78. $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
  79. $pdf->SetMargins(10, 8, 10);
  80. $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
  81.  
  82. if (@file_exists(dirname(__FILE__).'/lang/pol.php')) {
  83. require_once (dirname(__FILE__).'/lang/pol.php');
  84. }
  85.  
  86. $pdf->setPrintHeader(false);
  87. $pdf->setPrintFooter(false);
  88. $pdf->SetFont('dejavusans','',8);
  89. $pdf->AddPage();
  90.  
  91. $pdf->writeHTML($html, true, false, true, false, '');
  92.  
  93. $pdf->Output(__DIR__ . '/raport.pdf', "F"); //save the pdf to a folder setting `F`
  94. ob_start();
  95. $mail = new PHPMailer();
  96. $mail->CharSet = "UTF-8";
  97.  
  98. $mail->IsSMTP();
  99. $mail->SMTPDebug = 0;
  100. $mail->SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS;
  101. $mail->Host = 'smtp.gmail.com:587';
  102. $mail->Port = 587;
  103. $mail->SMTPOptions = array(
  104. 'ssl' => array(
  105. 'verify_peer' => false,
  106. 'verify_peer_name' => false,
  107. 'allow_self_signed' => true
  108. )
  109. );
  110.  
  111. $mail->SMTPAuth = true;
  112. $mail->Username = "aleksandra.k376@gmail.com";
  113. $mail->Password = "*******";
  114. $mail->SMTPSecure = 'tls';
  115.  
  116. $mail->From = "aleksandra.k376@gmail.com"; # REM: Gmail put Your e-mail here
  117. $mail->FromName = 'localhost/root'; # Sender name
  118. $mail->AddAddress($email); # # Recipient (e-mail address + name) / Odbiorca (adres e-mail i nazwa)
  119.  
  120. $mail->IsHTML(true); # Email @ HTML
  121.  
  122. $mail->Subject = 'Raport';
  123. $mail->Body = 'W załączniku znajduje się raport wygenerowany z bazy';
  124. $mail->AltBody = 'W załączniku znajduje się raport wygenerowany z bazy';
  125. $mail->addAttachment(__DIR__ . '/raport.pdf');
  126.  
  127. if(!$mail->Send()) {
  128. @ob_get_clean();
  129. echo 'Some error... / Jakiś błąd...';
  130. echo 'Mailer Error: ' . $mail->ErrorInfo;
  131. exit;
  132. }
  133.  
  134. echo '
  135. <div class="container">
  136. <div class="jumbotron">
  137. <h2 class="display-4">Wiadomość wysłana!</h2>
  138. <p class="lead">Zestawienie bazy danych zostało wysłane na adres '.$email.'</p>
  139. <a href="index.php" class="btn btn-primary">Powrót</a>
  140. </div>
  141. </div>
  142. ';
  143.  
  144. ?>
  145. <html>
  146. <head>
  147. <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0">
  148. <meta http-equiv="X-UA-Compatible" content="ie=edge">
  149. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
  150. <title>Wysłano wiadomość!</title>
  151.  
  152. </head>
  153. <body>
  154.  
  155. <script src="https://cdnjs.cloudflare.com/ajax/libs/jscolor/2.0.4/jscolor.min.js" integrity="sha256-CJWfUCeP3jLdUMVNUll6yQx37gh9AKmXTRxvRf7jzro=" crossorigin="anonymous"></script>
  156. <script src="https://code.jquery.com/jquery-3.4.1.slim.min.js" integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n" crossorigin="anonymous"></script>
  157. <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
  158. <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script
  159.  
  160. </body>
  161. </html>
  162.  
  163.  
  164. **************************************************************************************************************************************
  165.  
  166. <?php
  167. session_start();
  168. require_once "database.php";
  169. ?>
  170. <html>
  171. <head>
  172. <meta charset="UTF-8">
  173. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  174. <meta http-equiv="X-UA-Compatible" content="ie=edge">
  175. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
  176. <title>Wyślij zestawienie</title>
  177. </head>
  178. <body>
  179. <form method="post" action="wyslano_zestawienie.php">
  180. <div class="container">
  181. <div class="jumbotron">
  182. <h2 class="display-4">Wyślij zestawienie na e-mail</h2>
  183. <p class="lead">Podaj adres e-mail i kliknij "Wyślij!"</p>
  184. <div class="row">
  185. <div class="col-md-4">
  186. <label> E-mail
  187. <input type="email" name="email">
  188. </label>
  189. </div>
  190. </div>
  191. <br>
  192. <div class="row">
  193. <div class="col-md-2">
  194. <a class="btn btn-primary" href="index.php">Powrót</a>
  195. </div>
  196. <div class="col-md-2">
  197. <input class="btn btn-primary " type="submit" value="Wyślij!">
  198. </div>
  199. </div>
  200. </div>
  201. </div>
  202. </form>
  203. <script src="https://cdnjs.cloudflare.com/ajax/libs/jscolor/2.0.4/jscolor.min.js" integrity="sha256-CJWfUCeP3jLdUMVNUll6yQx37gh9AKmXTRxvRf7jzro=" crossorigin="anonymous"></script>
  204. <script src="https://code.jquery.com/jquery-3.4.1.slim.min.js" integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n" crossorigin="anonymous"></script>
  205. <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
  206. <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script
  207.  
  208. </body>
  209. </html>
  210.  
  211. *********************************************************************************************************************************
  212. <?php
  213. session_start();
  214. require_once "database.php";
  215. require_once "TCPDF-master/tcpdf_import.php";
  216.  
  217. define('id_wlasciciela', 'id_wlasciciela');
  218. define('imie', 'imie');
  219. define('nazwisko', 'nazwisko');
  220. define('id_samochodu', 'id_samochodu');
  221. define('marka', 'marka');
  222. define('model', 'model');
  223. define('rocznik', 'rocznik');
  224. define('nr_rejestracyjny', 'nr_rejestracyjny');
  225. define('wlasciciel', 'wlasciciel');
  226.  
  227. $q = $db->query("SELECT * FROM wlasciciel ORDER BY id_wlasciciela");
  228.  
  229. $html = '<table>
  230. <h2>Spis naszych klientów:</h2>
  231. <tr>
  232. <th><b>Id właściciela</b></th>
  233. <th><b>Imie</b></th>
  234. <th><b>Nazwisko</b></th><hr>
  235. </tr>';
  236. while ($f = $q->fetch(PDO::FETCH_ASSOC)) {
  237. $imie = $f['imie'];
  238. $nazwisko = $f['nazwisko'];
  239. $id_wlasciciela = $f['id_wlasciciela'];
  240.  
  241. $html = $html. '<tr>
  242. <td>'.$id_wlasciciela.'</td>
  243. <td>'.$imie.'</td>
  244. <td>'.$nazwisko.'</td>
  245. </tr>';
  246. }
  247. $html = $html . '</table>';
  248.  
  249.  
  250. $q = $db->query("SELECT * FROM samochod");
  251.  
  252. $html = $html . ' <table> <h2>Spis samochodów w bazie:</h2>
  253. <tr><th><b>ID samochodu</b></th><th><b>Marka</b></th><th><b>Model</b></th><th><b>Rocznik</b></th><th><b>Nr rejestr.</b></th><th><b>Właściciel</b></th></tr><hr>
  254. ';
  255.  
  256. while ($f = $q->fetch(PDO::FETCH_ASSOC)) {
  257.  
  258. $id_wlasciciela = $f[wlasciciel.".".id_wlasciciela];
  259. $s = $db-> query("SELECT * FROM wlasciciel where id_wlasciciela=".$id_wlasciciela);
  260. while($ss = $s->fetch(PDO::FETCH_ASSOC)){
  261. $rocznik = $f[rocznik];
  262. $nr_rejestracyjny= $f[nr_rejestracyjny];
  263.  
  264. $html = $html . '<tr>
  265. <td>'.$f[id_samochodu].'</td>
  266. <td>'.$f[marka].'</td>
  267. <td>'.$f[model].'</td>
  268. <td>'.$rocznik.'</td>
  269. <td>'.$nr_rejestracyjny.'</td>
  270. <td>'.$ss[imie].' '.$ss[nazwisko].'</td></tr>';
  271.  
  272. }}
  273.  
  274. $html = $html . '</table>';
  275.  
  276.  
  277. $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
  278. $pdf->SetMargins(10, 8, 10);
  279. $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
  280.  
  281. if (@file_exists(dirname(__FILE__).'/lang/pol.php')) {
  282. require_once (dirname(__FILE__).'/lang/pol.php');
  283. }
  284.  
  285. $pdf->setPrintHeader(false);
  286. $pdf->setPrintFooter(false);
  287. $pdf->SetFont('dejavusans','',8);
  288. $pdf->AddPage();
  289.  
  290. $pdf->writeHTML($html, true, false, true, false, '');
  291. $pdf->Output('przyklad.pdf', 'I');
  292.  
  293.  
  294.  
  295. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!