Advertisement
Guest User

Untitled

a guest
Aug 11th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.55 KB | None | 0 0
  1. <?php
  2. ini_set("display_errors", 1);
  3.  
  4. $host = "localhost";
  5. $db = "study";
  6. $user = "root";
  7. $pass = "";
  8. $charset = "utf8";
  9. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  10. $opt = [
  11. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  12. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  13. ];
  14.  
  15. $pdo = new PDO($dsn, $user, $pass, $opt);
  16. $myQuery = 'SELECT * FROM workers';
  17.  
  18. function displayTable($myQuery, $pdo) {
  19. $stmt = $pdo->query($myQuery);
  20. $colCount = $pdo->query($myQuery)->columnCount();
  21. $table = "<table><tr>";
  22. for ($i=0;$i<$colCount;$i++) {
  23. $metaArray = $pdo->query($myQuery)->getColumnMeta($i);
  24. $table .= "<td>".$metaArray["name"]."</td>";
  25. }
  26. $table .= "<td>edit</td>";
  27. $table .= "<td>delete</td></tr>";
  28. $table .="<tr>";
  29. while ($row = $stmt->fetch())
  30. {
  31. $table .= "<tr><td>";
  32. $table .= $row["id"];
  33. $table .= "</td><td>";
  34. $table .= $row["name"];
  35. $table .= "</td><td>";
  36. $table .= $row["age"];
  37. $table .= "</td><td>";
  38. $table .= $row["salary"];
  39. $table .= "</td><td><a href="."edit.php?id=".$row["id"].">Редактировать</a></td>";
  40. $table .= "<td><a href="."delete.php".">Удалить</a></td></tr>";
  41. }
  42. return $table;
  43. }
  44. ?>
  45. <!DOCTYPE html>
  46. <html lang="en">
  47. <head>
  48. <meta charset="UTF-8">
  49. <title>Document</title>
  50. <style type="text/css">
  51. td {
  52. text-align: center;
  53. border: 1px solid black;
  54. padding: 10px 20px;
  55. }
  56. table {
  57. border: 1px solid black;
  58. border-collapse: collapse;
  59.  
  60. }
  61. body {
  62. font-size: 16px;
  63. }
  64. </style>
  65. </head>
  66. <body>
  67. <?php
  68. echo displayTable($myQuery,$pdo);
  69. ?>
  70. </body>
  71. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement