File manager - Edit - /home/kridsana/webapp.cm.in.th/663012801/u66301280010/P003/Index.php
Back
<!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Provinces</title> <style> body { font-family: Arial, sans-serif; background-color: #f4f4f9; margin: 0; padding: 20px; display: flex; justify-content: center; align-items: flex-start; height: 100vh; } .container { background-color: #fff; padding: 20px; border-radius: 8px; box-shadow: 0 0 10px rgba(0,0,0,0.1); } table { width: 100%; border-collapse: collapse; } table, th, td { border: 1px solid #ddd; } th, td { padding: 8px; text-align: left; } th { background-color: #007bff; color: white; } .button { background-color: #007bff; color: #fff; border: none; padding: 5px 10px; border-radius: 5px; cursor: pointer; } .button:hover { background-color: #0056b3; } .back-button { background-color: #28a745; color: #fff; border: none; padding: 5px 10px; border-radius: 5px; cursor: pointer; margin-bottom: 20px; } .back-button:hover { background-color: #218838; } </style> </head> <body> <div class="container"> <table> <tr> <th>ID</th> <th>Thai Name</th> <th>English Name</th> <th>Action</th> </tr> <?php $servername = "localhost"; $username = "u66301280010"; $password = "@2566"; $dbname = "u66301280010"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Modify SQL query to order by id $sql = "SELECT id, name_in_thai, name_in_english FROM provinces ORDER BY id ASC"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { echo "<tr>"; echo "<td>" . $row["id"] . "</td>"; echo "<td>" . $row["name_in_thai"] . "</td>"; echo "<td>" . $row["name_in_english"] . "</td>"; echo "<td><form action='districts.php' method='POST' style='display:inline;'>"; echo "<input type='hidden' name='province_id' value='" . $row['id'] . "'>"; echo "<button type='submit' class='button'>เลือก</button>"; echo "</form></td>"; echo "</tr>"; } } else { echo "<tr><td colspan='4'>0 results</td></tr>"; } $conn->close(); ?> </table> </div> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 1.01 |
proxy
|
phpinfo
|
Settings