Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set("display_errors", 1);
- $host = "localhost";
- $db = "study";
- $user = "root";
- $pass = "";
- $charset = "utf8";
- $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
- $opt = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- ];
- $pdo = new PDO($dsn, $user, $pass, $opt);
- $myQuery = 'SELECT * FROM workers';
- function displayTable($myQuery, $pdo) {
- $stmt = $pdo->query($myQuery);
- $colCount = $pdo->query($myQuery)->columnCount();
- $table = "<table><tr>";
- for ($i=0;$i<$colCount;$i++) {
- $metaArray = $pdo->query($myQuery)->getColumnMeta($i);
- $table .= "<td>".$metaArray["name"]."</td>";
- }
- $table .= "<td>edit</td>";
- $table .= "<td>delete</td></tr>";
- $table .="<tr>";
- while ($row = $stmt->fetch())
- {
- $table .= "<tr><td>";
- $table .= $row["id"];
- $table .= "</td><td>";
- $table .= $row["name"];
- $table .= "</td><td>";
- $table .= $row["age"];
- $table .= "</td><td>";
- $table .= $row["salary"];
- $table .= "</td><td><a href="."edit.php?id=".$row["id"].">Редактировать</a></td>";
- $table .= "<td><a href="."delete.php".">Удалить</a></td></tr>";
- }
- return $table;
- }
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <title>Document</title>
- <style type="text/css">
- td {
- text-align: center;
- border: 1px solid black;
- padding: 10px 20px;
- }
- table {
- border: 1px solid black;
- border-collapse: collapse;
- }
- body {
- font-size: 16px;
- }
- </style>
- </head>
- <body>
- <?php
- echo displayTable($myQuery,$pdo);
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement