aboutsummaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
authorMateja <mail@matejamaric.com>2020-10-01 15:50:36 +0200
committerMateja <mail@matejamaric.com>2020-10-01 15:50:36 +0200
commit83ee4c20beabfc33a0572a053404d6c34319ade9 (patch)
treeb114e652a4ae4021f884f460583ca197ed423af2 /test
parent16939b4344b67ac8146015231af4d2fe691e90ce (diff)
downloadold-php-yota-83ee4c20beabfc33a0572a053404d6c34319ade9.tar.gz
old-php-yota-83ee4c20beabfc33a0572a053404d6c34319ade9.zip
DateTime PHP to DB work
Diffstat (limited to 'test')
-rw-r--r--test/index.php23
1 files changed, 19 insertions, 4 deletions
diff --git a/test/index.php b/test/index.php
index b0cb731..3b1d7c0 100644
--- a/test/index.php
+++ b/test/index.php
@@ -1,7 +1,21 @@
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["name"]) && isset($_POST["date"]) && isset($_POST["time"])) {
# values will always be set, check if they are empty...
- echo "<strong>You gay!</strong><br>";
+ echo "<strong>Information submitted!</strong><br>";
+ echo "<strong>Date: " . date('Y-m-d H:i:s') . "</strong><br>";
+ try {
+ $conn = new PDO("mysql:host=localhost;dbname=testdb", "testuser", "testpass");
+ $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+ $stmt = $conn->prepare("INSERT INTO tbl1 (`name`, `from`, `to`) VALUES (:name, :from, :to)");
+ $stmt->bindParam(':name', $_POST['name']);
+ $stmt->bindParam(':from', date('Y-m-d H:i:s'));
+ $toDT='2020-10-10 12:00:00';
+ $stmt->bindParam(':to', $toDT);
+ $stmt->execute();
+ }
+ catch (PDOException $e) {
+ echo $e->getMessage();
+ }
}
?>
<!DOCTYPE html>
@@ -15,7 +29,7 @@ if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["name"]) && isset($_POS
}
th, td {
border: 1px solid black;
- padding: 0.2rem;
+ padding: 0.3rem;
}
</style>
<script>
@@ -53,11 +67,12 @@ function subAction(action) {
</form>
<?php
try {
- $conn = new PDO("mysql:host=localhost;dbname=testdb", "testuser", "testpass");
echo "<table>\n";
- echo "<thead><tr><th>ID</th><th>Name</th><th>Actions</th></tr></thead><tbody>\n";
+ echo "<thead><tr><th>ID</th><th>From</th><th>To</th><th>Name</th><th>Actions</th></tr></thead><tbody>\n";
foreach ($conn->query("SELECT * FROM tbl1") as $row) {
echo "<tr><td>" . $row['id'] . "</td>";
+ echo "<td>" . $row['from'] . "</td>";
+ echo "<td>" . $row['to'] . "</td>";
echo "<td contenteditable=\"true\">" . $row['name'] . "</td>";
echo "<td>";
echo "<button onclick=\"subAction('save')\">Save</button>";