54 lines
1.6 KiB
PHP
54 lines
1.6 KiB
PHP
<?php
|
|
//work1
|
|
include_once 'config/pdo_connect.php';
|
|
/** @var PDO $pdo */
|
|
try {
|
|
$statement = $pdo->prepare('select * from tb_pdo_mysql');
|
|
$statement->execute();
|
|
echo '<table style="border: 1px solid black">';
|
|
echo '<tr>';
|
|
echo '<th>id</th>';
|
|
echo '<th>pdo</th>';
|
|
echo '<th>dbname</th>';
|
|
echo '<th>time</th>';
|
|
echo '<th>delete</th>';
|
|
echo '</tr>';
|
|
|
|
while ($row = $statement->fetch(PDO::FETCH_ASSOC)) {
|
|
echo '<tr>';
|
|
echo '<td>' . $row['id'] . '</td>';
|
|
echo '<td>' . $row['pdo'] . '</td>';
|
|
echo '<td>' . $row['dbname'] . '</td>';
|
|
echo '<td>' . $row['time'] . '</td>';
|
|
echo '<td><a href="19.test1.back.php?id=' . $row['id'] . '">delete</a></td>';
|
|
echo '</tr>';
|
|
}
|
|
//
|
|
// $all = $statement->fetchAll(PDO::FETCH_ASSOC);
|
|
// foreach ($all as $row) {
|
|
// echo '<tr>';
|
|
// echo '<td>' . $row['id'] . '</td>';
|
|
// echo '<td>' . $row['pdo'] . '</td>';
|
|
// echo '<td>' . $row['dbname'] . '</td>';
|
|
// echo '<td>' . $row['time'] . '</td>';
|
|
// echo '</tr>';
|
|
// }
|
|
// echo '</table>';
|
|
|
|
// $statement1 = $pdo->prepare('SELECT COUNT(*) FROM tb_pdo_mysql');
|
|
// $statement1->execute();
|
|
// $rowCount = $statement1->fetchColumn();
|
|
// echo '<table style="border: 1px solid black">';
|
|
// echo '<tr>';
|
|
// echo '<th>ID</th>';
|
|
// echo '</tr>';
|
|
// for ($i = 0; $i < $rowCount; $i++) {
|
|
// echo '<tr>';
|
|
// echo '<td>' . $statement->fetchColumn(0) . '</td>';
|
|
// echo '</tr>';
|
|
// }
|
|
// echo '</table>';
|
|
} catch (PDOException $e) {
|
|
echo 'Error: ' . $e->getMessage();
|
|
}
|